title: Solutions for medical databases optimal exploitation.
abstract: The paper discusses the methods to apply OLAP techniques for multidimensional databases that leverage the existing, performance-enhancing technique, known as practical pre-aggregation, by making this technique relevant to a much wider range of medical applications, as a logistic support to the data warehousing techniques. The transformations have practically low computational complexity and they may be implemented using standard relational database technology. The paper also describes how to integrate the transformed hierarchies in current OLAP systems, transparently to the user and proposes a flexible, "multimodel" federated system for extending OLAP querying to external object databases.
authors.affiliation: Faculty of Automatic Control and Computers, Polytechnic University of Bucharest.
authors.forename: I
authors.initials: I
authors.lastname: Branescu
authors.affiliation: Department of Healthcare Marketing, Technology and Medical Devices, Medical Informatics and Biostatistics, "Carol Davila" University of Medicine and Pharmacy, Bucharest.
authors.forename: V L
authors.initials: VL
authors.lastname: Purcarea
authors.affiliation: Faculty of Automatic Control and Computers, Polytechnic University of Bucharest.
authors.forename: R
authors.initials: R
authors.lastname: Dobrescu
mesh_terms: D035843:Biomedical Research / Q000379:methods*; D003219:Confidentiality / Q000592:standards; D019992:Databases as Topic; D057286:Electronic Health Records / Q000639:trends*; D016247:Information Storage and Retrieval / Q000379:methods*; D008490:Medical Informatics / Q000379:methods* / Q000639:trends; D009862:Online Systems
keywords: EPR; OLAP technique; data warehousing; medical database; pre-aggregation