Abstract
Healthcare organizations practicing evidence-based medicine strive to unite their data resources in order to achieve a wider knowledge base for sophisticated research and matured decision support service. The central point of such an integrated system is a data warehouse, to which all participants have access. In order to insure a better protection of highly sensitive healthcare data, the warehouse is not created physically, but as a federated system. The paper describes the conceptual design of a health insurance data warehouse federation (HEWAF) aimed at supporting evidence-based medicine. We address a major domain-specific conceptual design issue: the integration of low-grained, time-segmented data into the traditional warehouse, whose basic grain level is higher than that of the time-segmented data. The conceptual model is based on a widely accepted international healthcare standard. We use ontologies of the data warehouse domain, as well as of the healthcare and pharmacy domains, to provide schema matching between the federation and the component warehouses.
Preview
Unable to display preview. Download preview PDF.
Similar content being viewed by others
References
Bruckner, R.M., Tok, W.L., Mangisengi, O., Tjoa, A.M.: A Framework for a Multidimensional OLAP Model Using Topic Maps. In: Proc. Int. Conf. on Web Information Systems Engineering (WISE 2001), pp. 109–118. IEEE Computer Society, Los Alamitos (2001)
Curé, O.: Ontology Interaction with a Patient Electronic Health Record. In: Proc. Symp. Computer-Based Medical Systems (CBMS 2005), pp. 323–328. IEEE Computer Society Press, Los Alamitos (2005)
Ewen, E.F., Medsker, C., Dusterhoft, L.E., Levan-Shultz, K., Smith, J.L., Gottschall, M.A.: Data Warehousing in an Integrated Health System: Building the Business Case. In: Proc. Int. Workshop on Data Warehousing and OLAP (DOLAP 1998), pp. 47–53. ACM Press, New York (1998)
Jindal, R., Acharya, A.: Federated Data warehouse Architecture, Wipro Technologies white paper (2004) (last access April 10, 2006), http://hosteddocs.ittoolbox.com/Federated%20data%20Warehouse%20Architecture.pdf
Kimball, R., Ross, M.: The Data Warehouse Toolkit, The Complete Guide to Dimensional Modeling, 2nd edn. John Wiley & Sons, New York (2002)
Laxminarayan, P., Ruiz, C., Alvarez, S.A., Moonis, M.: Mining Associations over Human Sleep Time Series. In: Proc. Symp. Computer-Based Medical Systems (CBMS 2005), pp. 323–328. IEEE Computer Society Press, Los Alamitos (2005)
Morocho, V., Saltor, F., Pérez-Vidal, L.: Schema Integration on Federated Spatial DB across Ontologies. In: Proc. Int. Workshop on Engineering Federated Information Systems (EFIS 2003), pp. 63–72. IOS Press, Amsterdam (2003)
Nguyen, T.B., Tjoa, A.M., Mangisengi, O.: MetaCube XTM: A Multidimensional Metadata Approach for Semantic Web Warehousing Systems. In: Kambayashi, Y., Mohania, M., Wöß, W. (eds.) DaWaK 2003. LNCS, vol. 2737, pp. 76–88. Springer, Heidelberg (2003)
Pedersen, T.B., Jensen, C.S.: Research Issues in Clinical Data Warehousing. In: Proc. Int. Conf. on Scientific and Statistical Database Management (SSDBM 1998), pp. 43–52. IEEE Computer Society Press, Los Alamitos (2001)
Song, I.-Y., Rowen, W., Medsker, C., Ewen, E.F.: An Analysis of Many-to-Many Relationships between the Fact and Dimension Tables in Dimensional Modeling. In: Proc. Int. Workshop on Design Management of Data Warehouses (DMDW 2001). CEUR Workshop Proceedings, vol. 39, 6(1-13) (2001), CEUR WS-org
Priebe, T., Pernul, G.: Ontology-based Integration of OLAP and Information Retrieval. In: Int. Workshop on Database and Expert Systems Applications (DEXA 2003), pp. 610–614. IEEE Computer Society, Los Alamitos (2003)
Pedersen, D., Riis, K., Pedersen, T.B.: XML Extended OLAP Querying. In: Proc. Int. Conf. on Scientific and Statistical Database Management (SSDBM 2002), pp. 195–206. IEEE Computer Society, Los Alamitos (2002)
Pedersen, D., Riis, K., Pedersen, T.B.: A Powerful and SQL-Compatible Data Model and Query Language for OLAP. In: Database Technologies, Proc. Australasian Database Conference (ADC 2002), Australian Computer Society (2002)
Sackett, D.L., Rosenberg, W.M.C., Gray, J.A.M., Haynes, R.B., Richardson, W.S.: Evidence-Based Medicine: What It Is and What It Isn’t. British Medical J. 312(7032), 71–72 (1996)
Sheth, A.P., Larson, J.A.: Federated Database Systems for Managing Distributed, Heterogeneous, and Autonomous Databases. ACM Computing Surveys 22(3), 183–236 (1990)
World Health Organization (WHO): International Statistical Classification of Diseases and Related Health Problems, 10th Revision, Version for 2003 (last access April 10, 2006), http://www3.who.int/icd/vol1htm2003/fr-icd.htm
World Wide Web Consortium: XML Path Language (XPath) v. 1.0. W3C recommendation (November 16, 1999), http://www.w3.org/TR/1999/REC-xpath-19991116
World Wide Web Consortium: OWL Web Ontology Language. W3C Recommendation (February 10, 2004), http://www.w3.org/TR/2004/REC-owl-features-20040210/
XML Topic Maps (XTM) 1.0, TopicMaps.Org Specification (June 6, 2001), http://www.topicmaps.org/xtm/1.0/xtm1-20010806.html
Princeton University Cognitive Science Laboratory: WordNet, a lexical database for English language (last access April 10, 2006), http://wordnet.princeton.edu/
Health Level Seven (HL7) (last access April 10, 2006), www.hl7.org
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2006 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Banek, M., Tjoa, A.M., Stolba, N. (2006). Integrating Different Grain Levels in a Medical Data Warehouse Federation. In: Tjoa, A.M., Trujillo, J. (eds) Data Warehousing and Knowledge Discovery. DaWaK 2006. Lecture Notes in Computer Science, vol 4081. Springer, Berlin, Heidelberg. https://doi.org/10.1007/11823728_18
Download citation
DOI: https://doi.org/10.1007/11823728_18
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-37736-8
Online ISBN: 978-3-540-37737-5
eBook Packages: Computer ScienceComputer Science (R0)