About CS&CE
Prospective Students
Research
Staff
Dept Comp Sci & Comp Eng
Contact Details
La Trobe University
Victoria 3086
AUSTRALIA
Tel: +61 3 9479 1107
Fax: +61 3 9479 3060
Email: info
@cs.latrobe.edu.au
|
 |
Research Publications - Abstract
Department of Computer Science & Computer Engineering
|
Rahayu, J.W., Nealon, J., and Pardede, E. |
| Publication Year: |
2009 |
| Paper Title: |
Improving Clinical Data Warehouse Performance via a Windowing Data Structure Architecture |
| Conference Name: |
The 2009 International Conference on Computational Sciences and its Applications (ICCSA 2009) |
| Venue: |
Yongin, Korea |
| Volume: |
ICCSA 2009 |
| Pages: |
243 - 253 |
| Abstract: |
Data warehousing and on-line 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 configuation. 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.
|
|
|
