• Home
  • Search
  • Design and Implementation of an Improved Data Warehouse on Clinical Data
  • Cite Icon1
  • https://doi.org/10.1007/978-981-13-8581-0_23Copy DOI Icon

Design and Implementation of an Improved Data Warehouse on Clinical Data

  • Jan 1, 2019
  • Nilkantha Garain +4 more
Show More
  • Abstract
  • Literature Map
  • References
  • Citations
  • Similar Papers
Abstract

Data Warehouse is a repository to store huge detailed and summaries data for historical data analysis. In a decision support system which stores data from remote, complex and heterogeneous operational data sources . A clinical data warehouse contains complex, heterogeneous data from different data sources. In literature, there are different data warehouse architectures are present with there own design issues, which are relevant to different application areas. In this paper, we proposed a conceptual and logical view of data warehouse architecture along with physical implementation of the data warehouse. Our main focus in this paper is to efficiently handle the complex heterogeneous medical data stored into the warehouse and improve the performance of data warehouse for data analysis. Here, we proposed a partitioning concept of the dimension tables and fact tables for optimizing the response time, minimizing the disk IO, along with reducing the joining cost of the data warehouse. To show the effectiveness of our system, we, compare with different joining techniques of the dimension and fact tables of fact-consolidated data warehouse schema. A mathematical cost model of disk IO optimization is being calculated. SQL window partitioning techniques are being used for data analysis of the proposed data warehouse. After storing complex heterogeneous data in well organized and efficient way in a data warehouse, efficient searching techniques need to be incorporated. Here, bitmap indexing technique is used for the purpose.

Similar Papers
  • Research Article

Taxonomy of Different Data Warehouse Architectures & Need for Optimized Data Warehouse

  • May 31, 2015
  • International Journal of u- and e-Service, Science and Technology
  • Muhammad Arif +1
  • Conference Article
  • Citations4

Proposed Techniques to Design Speed Efficient Data Warehouse Architecture for Fastening Knowledge Discovery Process

  • Dec 01, 2020
  • Abhishek Gupta +2
  • Book Chapter
  • Citations11

On Handling the Evolution of External Data Sources in a Data Warehouse Architecture

  • May 25, 2011
  • Robert Wrembel
  • Research Article
  • Citations11

Multiversion join index for multiversion data warehouse

  • Jan 26, 2008
  • Information and Software Technology
  • Jan Chmiel +2
  • Book Chapter
  • Citations3

Proposal of a New Data Warehouse Architecture Reference Model

  • Jan 01, 2015
  • Dariusz Dymek +2
  • Research Article

Data warehouse model for population registration in Kerambitan village Tabanan Regency

  • Jan 25, 2020
  • JELIKU (Jurnal Elektronik Ilmu Komputer Udayana)
  • Fathiyarizq Mahendra Putra +1
  • Conference Article
  • Citations12

Analysis of Data Warehouse Architectures: Modeling and Classification

  • Jan 01, 2019
  • Qishan Yang +2
  • Research Article
  • Citations39

Biomedical informatics and outcomes research: enabling knowledge-driven health care.

  • Dec 07, 2009
  • Circulation
  • Peter J Embi +2
  • Research Article
  • Citations1

Model data warehouse untuk Operasional petugas pemadam kebakaran Pada dinas pemadam kebakaran provinsi DKI Jakarta

  • Apr 09, 2019
  • Jurnal Ilmu Komputer
  • Kharis Munawar +1
  • Research Article

A New Architecture for Large Data Warehouse

  • May 03, 2011
  • Applied Mechanics and Materials
  • Gang Li +2
  • Research Article
  • Citations45

Automatic quality control of brain T1-weighted magnetic resonance images for a clinical data warehouse.

  • Jan 01, 2022
  • Medical Image Analysis
  • Simona Bottani +6
  • Book Chapter
  • Citations7

Dimension Table Selection Strategies to Referential Partition a Fact Table of Relational Data Warehouses

  • Aug 20, 2011
  • Ladjel Bellatreche
  • Research Article
  • Citations33

Referential Horizontal Partitioning Selection Problem in Data Warehouses

  • Oct 01, 2009
  • International Journal of Data Warehousing and Mining
  • Ladjel Bellatreche +3
  • PDF
  • Research Article
  • Citations18

Lake Data Warehouse Architecture for Big Data Solutions

  • Jan 01, 2020
  • International Journal of Advanced Computer Science and Applications
  • Emad Saddad +3
  • Research Article
  • Citations5

Mechanism for securing cloud based data warehouse schema

  • Oct 19, 2020
  • International Journal of Information Technology
  • Amar Arora +1
Cactus Communications logo

Copyright 2026 Cactus Communications. All rights reserved.