Data Warehouses is a concept that includes a consolidated database. Company wide data is stored in this database system to enable sophisticated data analysis. With large scale companies the amount of data stored within a Data Warehouse rises accordingly. Sophisticated database management systems are needed to manage this large amount of data. While the implemented algorithms within a database system are a major driver of performance hardware aspects must also be considered as drivers for slow query speed. CPU and I/O throughput are the major hardware aspects that impact query performance. While newest CPU generations provide an exponential growth of performance over time I/O has always lagged behind this trend.

The DDE-DWH is a storage engine similar to DDE-GAN. A cluster storage engine enabling unique distribution of the data on the nodes. While the DDE-GAN engine distributes the data according to predictive methods ensuring a high locality of the data DDE-DWH distributed the data according to the I/O performance of the underlying hardware. Also the redundant options available in the DDE-GAN engine are modified since a complete distribution across multiple locations is not required. With the horizontal partitioning of the data in the engine we enable a fast query answering time with only very little overhead.

For more information please read the White Paper or contact us at: This e-mail address is being protected from spambots. You need JavaScript enabled to view it

Download Whitepaper