Skip to Main content Skip to Navigation
Theses

Entrepôts de données pour l'aide à la décision médicale: conception et expérimentation

Abstract : Data warehouses integrate information coming from different data sources which are often heterogeneous and distributed. Their main goal is to provide a global view for analysts and managers to make decisions based on data sets and historical logs. The design and construction of a data warehouse are composed by three phases: extraction-integration, organisation and interrogation. In this thesis, we are interested in the latter two. For us, the organisation is a complex and delicate task. Hence, we divide it into two parts: data structuring and data managing. For structuring we propose a multidimensional model which is composed by three classes: Cube, Dimension and Hierarchy. We propose also an algorithm for selecting the optimal set of materialized views. We consider that data management should include warehouse evolution. The concept of schema evolution was adapted here and we propose to use bitemporal schema versions for the management, storage and visualization of current and historical data (intentional and extensional). Finally, we have implemented a graphic interface that allows semi-automatic query generation (indicators). These queries (for example, 'number of patients by hospitals and diseases') are determined by the application domain. We had the opportunity to work in a medical project; it allowed us to verify and to validate our proposition using real data.
Complete list of metadatas

https://tel.archives-ouvertes.fr/tel-00184256
Contributor : Serna Encinas María Trinidad <>
Submitted on : Tuesday, October 30, 2007 - 6:58:57 PM
Last modification on : Friday, October 23, 2020 - 4:52:17 PM
Long-term archiving on: : Monday, September 24, 2012 - 2:47:01 PM

Identifiers

  • HAL Id : tel-00184256, version 1

Collections

UJF

Citation

Serna Encinas María Trinidad. Entrepôts de données pour l'aide à la décision médicale: conception et expérimentation. Réseaux et télécommunications [cs.NI]. Université Joseph-Fourier - Grenoble I, 2005. Français. ⟨tel-00184256⟩

Share

Metrics

Record views

586

Files downloads

18572