DocumentCode :
3464084
Title :
Improving Clinical Data Warehouse Performance via a Windowing Data Structure Architecture
Author :
Nealon, Joshua ; Rahayu, Wenny ; Pardede, Eric
Author_Institution :
Sch. of Comput. Sci. & Comput. Eng., La Trobe Univ., Bundoora, VIC, Australia
fYear :
2009
fDate :
June 29 2009-July 2 2009
Firstpage :
243
Lastpage :
253
Abstract :
Data warehousing and online analytical processing (OLAP) are essential elements of decision support and commonly require large periods of time to process query results. Given that, it is crucial to tailor individual performance solutions based on the structure and merits of the data within the data warehouse to obtain the most optimal configuration. Therefore, this paper presents an analysis of the defining features of a clinical data warehouse, where the focus of the analysis is centered on the opportunities and threats for optimization purposes, based on the types of queries that are likely to arise. From the findings, the paper introduces a windowing data structure architecture (WDSA) to increase the performance of OLAP queries on a clinical data warehouse, which manages a collection of popular windows. The cost of processing a query using a simple instance of the WDSA was compared against existing query processing techniques such as nested join and hash join, to which the technique greatly outperformed both in almost all cases.
Keywords :
data warehouses; decision support systems; medical administrative data processing; query processing; clinical data warehouse; decision support; hash join; nested join; online analytical processing; query processing; windowing data structure architecture; Aerospace industry; Application software; Computational geometry; Computer networks; Conferences; Data structures; Data warehouses; Grid computing; High performance computing; Physics computing; Data Warehouse; Query Optimization; Windowing;
fLanguage :
English
Publisher :
ieee
Conference_Titel :
Computational Science and Its Applications, 2009. ICCSA '09. International Conference on
Conference_Location :
Yongin
Print_ISBN :
978-0-7695-3701-6
Type :
conf
DOI :
10.1109/ICCSA.2009.23
Filename :
5260907
Link To Document :
بازگشت