Access More Data
How we store data makes a big difference on how easy it is to access it. Imagine how you keep your addresses – you could either keep them in a tabbed address book, or you could write them all on index cards and stuff them randomly into a bag. When it comes to sending a friend’s birthday card, which is the easier from which to find their address?
Of course in today’s challenging business environment we are never talking about a problem as simple as a personal address list where the only use is to look up a name. A modern database contains millions, may be billions of rows of data, and complicated lookup criteria. However, the basic principle remains the same: how you store data has a big impact on the speed and ease of access.
Unfortunately, designing the way data is to be stored in a database (the “data model”) is often done with little thought as to how well it will scale to more and more data or with a view to the flexibility required to respond to new business requirements.
Here at Catalyst Computing Services we are practised in both designing and modifying data models to meet both stringent performance requirements and giving businesses the flexibility to use their data in new and inventive ways. We seek first to understand the situation (after all, it is the business requirements, not technical requirements, that are king) and then to produce a design which satisfies both the immediate need and gives the flexibility for future development.
Start-up With Big Data Requirements
A start-up technology company without database experience had a requirement for sub-two second response time access to (projected) over a billion rows.
We created a database design that partitioned the data in such a way that the required response time could be achieved. We also created an infrastructure design that allowed them to deploy initially on limited and low-cost infrastructure, and scale up and out as their customer base grew.
The design was sufficiently transparent to be usable by their own engineers whilst still satisfying the stringent performance requirements.
Whatever your business, we can help you store and access today’s high-volume complex data required by your business.