CISUC

A middle layer for distributed data warehouses using the DWS-AQA technique

Authors

Abstract

The DWS (Data Warehouse Striping) technique is a round-robin data partitioning approach especially designed for distributed data warehouse envi-ronments. In DWS the fact tables are distributed by an arbitrary number of computers and the queries are executed in parallel by all the computers, guaran-tying a nearly optimal speed up and scale up. This technique is combined with an approximate query answering (AQA) strategy to deal with fails in one or more nodes. This paper presents a middle layer software and administration tools allowing the transparent implementation of DWS-AQA in commercial da-tabases and OLAP (On-line Analytical Processing) tools.

Keywords

Data Warehousing, Distributed Query Execution

Subject

Data Warehousing

Related Project

DWS Data Warehouse Striping

Conference

VIII Jornadas de Ingenieria del Software y Bases de Datos, November 2003

PDF File


Cited by

Year 2013 : 6 citations

 1 "A middle layer for distributed data warehouses using the DWS-AQA technique

 " 579784189063319719 Handling big dimensions in distributed data warehouses using the DWS technique http://dl.acm.org/citation.cfm?id=1031770 M Costa, H Madeira Proceedings of the 7th ACM international … 2004 dl.acm.org
2 "A middle layer for distributed data warehouses using the DWS-AQA technique

 " 579784189063319719 Model and procedure for performance and availability-wise parallel warehouses http://link.springer.com/article/10.1007/s10619-009-7038-7 P Furtado Distributed and Parallel Databases 2009 Springer
3 "A middle layer for distributed data warehouses using the DWS-AQA technique

 " 579784189063319719 Efficient compression of text attributes of data warehouse dimensions http://link.springer.com/chapter/10.1007/11546849_35 J Vieira, J Bernardino, H Madeira Data Warehousing and Knowledge … 2005 Springer
4 "A middle layer for distributed data warehouses using the DWS-AQA technique

 " 579784189063319719 AGENT BASED DATA STORAGE AND DISTRIBUTION IN DATA WAREHOUSES http://www.worldscientific.com/doi/abs/10.1142/S0218194008003842 N Kolsi, A Abdellatif, K Ghedira International Journal of Software … 2008 World Scientific
5 "A middle layer for distributed data warehouses using the DWS-AQA technique

 " 579784189063319719 Optimizer and Scheduling for the Community Data Warehouse Architecture http://link.springer.com/chapter/10.1007/978-3-642-02196-1_2 RL de Carvalho Costa, R Antunes… Methods and Supporting … 2009 Springer