At the heart of the Sensage event data warehouse is a sophisticated database that uses Massively Parallel Processing (MPP) architecture to perform all loads and query tasks fully in parallel across all systems in the cluster. The Sensage database delivers:
This architecture allows users to load and query massive data volumes in a single, logical database instance without partitioning. Using a patented method, data is loaded into columns of values, formatting each column into data stream, and transferring data stream to storage device in a continuous strip of data. This achieves high levels of compression, while still making all data fully available to query.
This data model also removes the need for the performance and storage overhead of indices on specific columns.
