Integrating different grain levels in a medical data warehouse federation

Authors:
Marko Banek;A Min Tjoa;Nevena Stolba
Affiliations:
FER, University of Zagreb, Zagreb, Croatia;Institute of Software Technology and Interactive Systems (ISIS), Vienna University of Technology, Wien, Austria;Women’s Postgraduate College for Internet Technologies (WIT), Vienna University of Technology, Wien, Austria
Venue:
DaWaK'06 Proceedings of the 8th international conference on Data Warehousing and Knowledge Discovery
Year:
2006

Citing 9
Cited 3

Federated database systems for managing distributed, heterogeneous, and autonomous databases

ACM Computing Surveys (CSUR) - Special issue on heterogeneous databases
Data warehousing in an integrated health system: building the business case

Proceedings of the 1st ACM international workshop on Data warehousing and OLAP
The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling

The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling
A powerful and SQL-compatible data model and query language for OLAP

ADC '02 Proceedings of the 13th Australasian database conference - Volume 5
Research Issues in Clinical Data Warehousing

SSDBM '98 Proceedings of the 10th International Conference on Scientific and Statistical Database Management
XML-Extended OLAP Querying

SSDBM '02 Proceedings of the 14th International Conference on Scientific and Statistical Database Management
Ontology-based Integration of OLAP and Information Retrieval

DEXA '03 Proceedings of the 14th International Workshop on Database and Expert Systems Applications
Ontology Interaction with a Patient Electronic Health Record

CBMS '05 Proceedings of the 18th IEEE Symposium on Computer-Based Medical Systems
Mining Associations over Human Sleep Time Series

CBMS '05 Proceedings of the 18th IEEE Symposium on Computer-Based Medical Systems

Development of traditional Chinese medicine clinical data warehouse for medical knowledge discovery and decision support

Artificial Intelligence in Medicine
A framework for building logical schema and query decomposition in data warehouse federations

ICCCI'11 Proceedings of the Third international conference on Computational collective intelligence: technologies and applications - Volume Part I
Automating the schema matching process for heterogeneous data warehouses

DaWaK'07 Proceedings of the 9th international conference on Data Warehousing and Knowledge Discovery

Quantified Score

Hi-index	0.00

Visualization

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.