So what’s so cool under the hood? Vizubi uses a column oriented database management system. In a traditional row based system (like sql server and oracle), data is organized by field with each field containing a specific information like a person’s name or a postal code. If we’re talking about clients for example, all the information about any single client is contained in a row of data which has different values for each of these fields. This means that if there are multiple clients for a specific city (Barcelona for instance), then Barcelona will be repeated for every client from Barcelona. Clearly this means that a row based system takes up lots of space with redundant data and in today’s world, where we want to store all the data we can, this is a problem.
With our columnar system, each column is stored as a single table, so even if there are thousands of clients in Barcelona, the city table will only list Barcelona once. Barcelona is then associated with the appropriate tables. This means that when you run a query, the database only searches through the data you are interested in blazing fast queries.
In Vizubi, even the data which is stored in RAM is stored the same way. This means you spend more time on analysis and less time staring at the hourglass.
Pretty cool huh?
For a more techincal explanation check out this Wiki:
http://en.wikipedia.org/wiki/Column-oriented_DBMS
Vizubi – You are the killer app.
Stay in Touch