Data Warehousing and OLAP: Improving Query Performance Using Distributed Computing

Authors

Abstract

Data warehouses are used to store large amounts of data. This
data is often used for On-Line Analytical Processing (OLAP)
where short response times are essential for on-line decision
support. One of the most important requirements of a data
warehouse server is the query performance. The principal aspect
from the user perspective is how quickly the server processes a
given query: 'the data warehouse must be fastâ?.
The main focus of our research is finding adequate solutions to
improve query response time of typical OLAP queries and
improve scalability using a distributed computation environment
that takes advantage of characteristics specific to the OLAP
context. Our proposal provides very good performance and
scalability even on huge data warehouses.

Subject

Data Warehousing

Conference

12th Conference on Advanced Information Systems Engineering, June 2000

Cited by

Year 2013 : 26 citations

1 "Data Warehousing and OLAP: Improving Query Performance Using Distributed Computing

" 2517340332268281606 Distributed Spatial Data Warehouse Indexed with Virtual Memory Aggregation Tree. http://www.engr.sjsu.edu/fayad/current.courses/cmpe226-fall07/docs/lecture8/STDBM04-ProceedingsL08fn.pdf#page=30 M Gorawski, R Malczok STDBM 2004 engr.sjsu.edu
2 "Data Warehousing and OLAP: Improving Query Performance Using Distributed Computing

" 2517340332268281606 Materialized aR-tree in distributed spatial data warehouse http://iospress.metapress.com/index/0XPB4Q8LEFTN7E4W.pdf M Gorawski, R Malczok Intelligent Data Analysis 2006 IOS Press
3 "Data Warehousing and OLAP: Improving Query Performance Using Distributed Computing

" 2517340332268281606 Accelerating foreign-key joins using asymmetric memory channels http://planet-data.eu/sites/default/files/publications/CWI_ADMS2011.pdf H Pirk, S Manegold, M Kersten VLDB-Workshop on Accelerating … 2011 planet-data.eu
4 "Data Warehousing and OLAP: Improving Query Performance Using Distributed Computing

" 2517340332268281606 Architecture of Parallel Spatial Data Warehouse: Balancing Algorithm and Resumption of Data Extraction http://books.google.com/books?hl=en&lr;=&id=sArznQV2GcIC&oi=fnd&pg=PA49&ots=Vv5CL0QQ1O&sig=V1h7OLGwANsdzi167-vyOrRyCys K Zieliriski, T Szmuc Software Engineering: Evolution And … 2005 books.google.com
5 "Data Warehousing and OLAP: Improving Query Performance Using Distributed Computing

" 2517340332268281606 Strategic Alignment in Data Warehouses Two Case Studies http://researchbank.rmit.edu.au/view/rmit:6307 N Bhansali Publication/NA 2007 researchbank.rmit.edu.au
6 "Data Warehousing and OLAP: Improving Query Performance Using Distributed Computing

" 2517340332268281606 Distributed spatial data warehouse http://link.springer.com/chapter/10.1007/978-3-540-24669-5_88 M Gorawski, R Malczok Parallel Processing and Applied Mathematics 2004 Springer
7 "Data Warehousing and OLAP: Improving Query Performance Using Distributed Computing

" 2517340332268281606 Spatial Telemetric Data Warehouse Balancing Algorithm in Oracle9i/Java Environment http://link.springer.com/chapter/10.1007/3-540-32392-9_37 M Gorawski, R Chechelski Intelligent Information Processing and Web … 2005 Springer
8 "Data Warehousing and OLAP: Improving Query Performance Using Distributed Computing

" 2517340332268281606 Strategic data warehousing: achieving alignment with business http://books.google.com/books?hl=en&lr;=&id=7dp-XRmkD1UC&oi=fnd&pg=PP1&ots=C0RztH3U1z&sig=eEvVSYigAyPFI27WjJpxWUWbQzg N Bhansali Publication/NA 2009 books.google.com
9 "Data Warehousing and OLAP: Improving Query Performance Using Distributed Computing

" 2517340332268281606 Parallel telemetric data warehouse balancing algorithm http://ieeexplore.ieee.org/xpls/abs_all.jsp?arnumber=1578816 M Gorawski, R Chechelski Intelligent Systems Design and … 2005 ieeexplore.ieee.org
10 "Data Warehousing and OLAP: Improving Query Performance Using Distributed Computing

" 2517340332268281606 Updating aggregation tree in distributed spatial telemetric data warehouse http://ieeexplore.ieee.org/xpls/abs_all.jsp?arnumber=1386076 M Gorawski, R Malczok Parallel, Distributed and Network- … 2005 ieeexplore.ieee.org
11 "Data Warehousing and OLAP: Improving Query Performance Using Distributed Computing

" 2517340332268281606 Selection of structures with grid optimization, in multiagent data warehouse http://link.springer.com/chapter/10.1007/978-3-642-15381-5_36 M Gorawski, S Ba?kowski, M Gorawski Intelligent Data Engineering and … 2010 Springer
12 "Data Warehousing and OLAP: Improving Query Performance Using Distributed Computing

" 2517340332268281606 Systemy rozproszone http://zti.polsl.pl/zbdihd/ZBDiHD - Systemy rozproszone.pdf M Gorawski, R Malczok Laboratorium hurtowni danych, Gliwice 2004 zti.polsl.pl
13 "Data Warehousing and OLAP: Improving Query Performance Using Distributed Computing

" 2517340332268281606 ????????? OLAP ?? http://d.wanfangdata.com.cn/periodical_hkjmzzjs200302005.aspx ??? ??? ???????? 2003 ????????
14 "Data Warehousing and OLAP: Improving Query Performance Using Distributed Computing

" 2517340332268281606 Data warehouse access using multi-agent system http://link.springer.com/article/10.1007/s10619-009-7036-9 N Kolsi, A Abdellatif, K Ghedira Distributed and Parallel Databases 2009 Springer
15 "Data Warehousing and OLAP: Improving Query Performance Using Distributed Computing

" 2517340332268281606 Version-Manager: For vital simulating advantages in data warehouse http://cis.uws.ac.uk/research/journal/V11n2/VersionManager.doc MK Shahzad COMPUTING AND INFORMATION SYSTEMS 2007 cis.uws.ac.uk
16 "Data Warehousing and OLAP: Improving Query Performance Using Distributed Computing

" 2517340332268281606 Multi agent systems in distributed datawarehousing http://ieeexplore.ieee.org/xpls/abs_all.jsp?arnumber=5640491 TP Latchoumi, R Sunitha Computer and Communication … 2010 ieeexplore.ieee.org
17 "Data Warehousing and OLAP: Improving Query Performance Using Distributed Computing

" 2517340332268281606 Architecture for virtualization in data warehouse http://link.springer.com/chapter/10.1007/978-1-4020-6268-1_44 JA Nasir, MK Shahzad … and advanced techniques in computer and … 2007 Springer
18 "Data Warehousing and OLAP: Improving Query Performance Using Distributed Computing

" 2517340332268281606 Spatial Telemetric Data Warehouse and Software Agents as Environment to Distributed Execute SQL Queries http://www.proceedings2006.imcsit.org/pliks/122.pdf M Gorawski, E P?uciennik Proceedings of the … 2006 proceedings2006.imcsit.org
19 "Data Warehousing and OLAP: Improving Query Performance Using Distributed Computing

" 2517340332268281606 Online balancing of ar-tree indexed distributed spatial data warehouse http://link.springer.com/chapter/10.1007/11752578_57 M Gorawski, R Chechelski Parallel Processing and Applied Mathematics 2006 Springer
20 "Data Warehousing and OLAP: Improving Query Performance Using Distributed Computing

" 2517340332268281606 Cloud Computing: Data-intensive Computing and Scheduling http://books.google.com/books?hl=en&lr;=&id=06c4jn6kV7AC&oi=fnd&pg=PP1&ots=LhXdt-_YMi&sig=unyAUdGSgF5xmWWLDbUW2fPwoIA F Magoulès, J Pan, F Teng Publication/NA 2012 books.google.com
21 "Data Warehousing and OLAP: Improving Query Performance Using Distributed Computing

" 2517340332268281606 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
22 "Data Warehousing and OLAP: Improving Query Performance Using Distributed Computing

" 2517340332268281606 Version Manager: A step towards Synthetic-Warehouse-Builder extension http://link.springer.com/chapter/10.1007/978-1-4020-6268-1_52 MK Shahzad Innovations and advanced techniques in computer and … 2007 Springer
23 "Data Warehousing and OLAP: Improving Query Performance Using Distributed Computing

" 2517340332268281606 Pembangunan Aplikasi Pelaporan Perijinan dengan Online Analytical Processing (OLAP)(Development of License Report Application with Online Analytical … http://jurnal.ump.ac.id/index.php/juita/article/view/92 DK Hakim JUITA 2011 jurnal.ump.ac.id
24 "Data Warehousing and OLAP: Improving Query Performance Using Distributed Computing

" 2517340332268281606 ?? Tree-lib ?????????? http://d.wanfangdata.com.cn/periodical_jsjkx201306041.aspx ???? ?? ????? 2013 ????????
25 "Data Warehousing and OLAP: Improving Query Performance Using Distributed Computing

" 2517340332268281606 Analityczne rozszerzenia SQL w rozproszonej, homogenicznej strukturze danych http://www.cs.put.poznan.pl/kkntpd/tpd_pliki/publikacja/pub/45.pdf M Gorawski, E P?uciennik Publication/NA Year/NA cs.put.poznan.pl

Year 2009 : 1 citations

Nader Kolsi, Abdelaziz Abdellatif, and Khaled Ghedira, "Data warehouse access using multi-agent system?, Journal of Distributed and Parallel Databases, Volume 25, Numbers 1-2 / April, 2009

Year 2006 : 3 citations

Marcin Gorawski, Ewa Płuciennik, "Spatial Telemetric Data Warehouse and Software Agents as Environment to Distributed Execute SQL Queries?, proceedings of the International Multiconference on Computer Science and Information Technology, pp. 243 " 252, 2006

Marcin Gorawski, Ewa Płuciennik, "Materialized aR-Tree in Distributed Spatial Data Warehouse?, Intelligent Data Analysis Journal, Volume 10, Number 4, 2006.

M Gorawski, R Chechelski, "Online Balancing of aR-Tree Indexed Distributed Spatial Data Warehouse?, - Lecture Notes in Computer Science, 2006 " Springer, Parallel Processing and Applied Mathematics, Volume 3911, 2006.

Year 2005 : 2 citations

Marcin Gorawski and Rafal Malczok, "Updating Aggregation Tree in Distributed Spatial Telemetric DataWarehouse", Proceedings of the IEEE 13th Euromicro Conference on Parallel, Distributed and Network-Based Processing (Euromicro-PDP"05), 2005.

Marcin Gorawski and Rafal Malczok, "Parallel Telemetric Data Warehouse Balancing Algorithm?, Proceedings. 5th International Conference on Intelligent Systems Design and Applications, ISDA '05, 2005

Year 2004 : 1 citations

Marcin Gorawski and Rafal Malczok, "Distributed Spatial Data Warehouse Indexed with Virtual Memory Aggregation Tree?, Proceedings of the Second Workshop on Spatio-Temporal Database Management (STDBM"04), Toronto, Canada, August 30th, 2004.

Year 2003 : 1 citations

Marcin Gorawski and Rafal Malczok, "Distributed Spatial Data Warehouse", Parallel Processing and Applied Mathematics: 5th International Conference, PPAM 2003, Lecture Notes in Computer Science, Springer-Verlag Czestochowa, Poland, September 7-10, 2003