Improving clinical data warehouse performance via a windowing data structure architecture

Proceedings of the 2009 International Conference on Computational Science and Its Applications, ICCSA 2009

Volumn , Issue , 2009, Pages 243-253

  Nealon, Joshua ^a   Rahayu, Wenny ^a   Pardede, Eric ^a  

^a LA TROBE UNIVERSITY   (Australia)

Author keywords

[No Author keywords available]

Indexed keywords

CLINICAL DATA WAREHOUSE; DATA WAREHOUSING; DECISION SUPPORTS; ESSENTIAL ELEMENTS; HASH JOIN; INDIVIDUAL PERFORMANCE; OLAP QUERIES; ON-LINE ANALYTICAL PROCESSING; OPTIMAL CONFIGURATIONS; QUERY PROCESSING TECHNIQUES; QUERY RESULTS;

DATA STRUCTURES; DECISION SUPPORT SYSTEMS;

DATA WAREHOUSES;

EID: 70449652890     PISSN: None     EISSN: None     Source Type: Conference Proceeding    
DOI: 10.1109/ICCSA.2009.23     Document Type: Conference Paper

References (19)

1. N. Pendse, "What is OLAP? An analysis of what the often misused OLAP term is supposed to mean," The OLAP Report. Available: http://www.olapreport.com/fasmi.htm. Accessed April 21, 2008.
2. Sun Microsystems, "Worldś largest data warehouse: sunTM data warehouse reference architecture -scalability over 1 PB," Sun Microsystems. Available: http://www.sun.com/servers/sparcenterprise/ datawarehousesolutionbrief.pdf. Accessed July 25, 2008.
3. Health Informatics - Deployment of a clinical data warehouse, ISO/PDTS Technical Specification 29585, 2008.
4. IBM Corp., "DB2 Database for Linux, Unix, and Windows," IBM Corp. Available: http://publib.boulder.ibm.com/infocenter/db2luw/v9/index.jsp. Accessed April 21, 2008.
5. P. Lane, et al., Oracle 10g data warehousing guide, Release 1, Redwood City: Oracle Corp., 2007.
6. D. J. Abadi, A. Marcus, S. Madden and K. J. Hollen-bach, "Scalable semantic web data management using vertical partitioning," in Proceedings of International Conference on Very Large Databases (VLDB), 2007, pp 411-412.
7. L. Bellatreche, K. Boukhalfa and H. I. Abdalla, "SAGA: A combination of genetic and simulated annealing algorithms for physical data warehouse design," in Proceedings of British National Conference on Databases (BNCOD), 2006, pp 212-219.
8. T. S. Jung, M. S. Ahn and W. S. Cho, "An efficient OLAP query processing technique using measure attribute indexes," in Proceedings of International Conference on Web Information Systems Engineering (WISE), 2004, pp 218-228.
9. R. Elmasri, S. B. Navathe, Fundamentals of database systems (5th Edition). Boston: Addison-Wesley Longman Publishing Co., Inc., 2006.
10. P. E. O'Neil, "Model 204 Architecture and Performance," in Proceedings of International Workshop on High Performance Transaction Systems, 1987, pp 40-59.
11. C. Park, M. Kim, Y. Lee, "Rewriting OLAP queries using materialized views and dimension hierarchies in data warehouses," in Proceedings of International Conference on Data Engineering (ICDE), 2001, pp 515-523.
12. D. Theodoratos and A. Tsois, "Heuristic Optimization of OLAP Queries in Multidimensionally Hierarchically Clustered Databases," in Proceedings of International Workshop of. Data warehousing and OLAP, 2001, pp 48-55.
13. F. Akal, K. Boḧm and H. Schek, "OLAP query evaluation in a database cluster: A performance study on intra-query parallelism," in Proceedings of East-European Conference Advances in Databases and Information Systems (ADBIS), 2002, pp 181-184.
14. A. A. B. Lima, M. Mattoso and P. Valduriez, "OLAP query processing in a database cluster," in Proceedings of European Conference on Parallel Processing (Euro-Par), 2004, pp 355-362.
15. L. Bellatreche, M. Schneider, H. Lorinquer and M. K. Mohania, "Bringing together partitioning, materialized views and indexes to optimize performance of relational data warehouses," in Proceedings of International Conference on Data Warehousing and Knowledge Discovery (DAWAK), 2004, pp 15-25.
16. A. H. Landberg, H. Grain, J. W. Rahayu, and E. Pard-ede, "Incorporating Privacy Support into Clinical Data Warehouse", electronic Journal of Health Informatics, Accepted 22 November 2008.
17. Victorian Government Health Information, "Informa-tion about health data standards and systems (hdss) used in victoria's hospitals 2008," Victorian Government Health. Available: http://www.health.vic.gov.au/hdss/index. htm. Accessed May 1, 2008.
18. I. Botan, P. M. Fischer, D. Florescu, D. Kossmann, T. Kraska and R. Tamosevicius, "Extending XQuery with window functions," in Proceedings of International Conference on Very Large Databases (VLDB), 2007, pp 75-86.
19. D. Taniar, C. H. C. Leung, W. Rahayu and S. Goel, High Performance Parallel Database Processing and Grid Databases, John Wiley & Sons, 2008.