Dimensional modeling of medical data warehouse based on ontology

Author(s):  
Shuxia Ren ◽  
Teng Wang ◽  
Xu Lu
2017 ◽  
Vol 10 (04) ◽  
pp. 745-754
Author(s):  
Mudasir M Kirmani

Data Warehouse design requires a radical rebuilding of tremendous measures of information, frequently of questionable or conflicting quality, drawn from various heterogeneous sources. Data Warehouse configuration assimilates business learning and innovation know-how. The outline of theData Warehouse requires a profound comprehension of the business forms in detail. The principle point of this exploration paper is to contemplate and investigate the transformation model to change over the E-R outlines to Star Schema for developing Data Warehouses. The Dimensional modelling is a logical design technique used for data warehouses. This research paper addresses various potential differences between the two techniques and highlights the advantages of using dimensional modelling along with disadvantages as well. Dimensional Modelling is one of the popular techniques for databases that are designed keeping in mind the queries from end-user in a data warehouse. In this paper the focus has been on Star Schema, which basically comprises of Fact table and Dimension tables. Each fact table further comprises of foreign keys of various dimensions and measures and degenerate dimensions if any. We also discuss the possibilities of deployment and acceptance of Conversion Model (CM) to provide the details of fact table and dimension tables according to the local needs. It will also highlight to why dimensional modelling is preferred over E-R modelling when creating data warehouse.


2013 ◽  
Vol 717 ◽  
pp. 816-819
Author(s):  
Yu Ke Chen ◽  
Tai Xiang Zhao

We propose an easy method for data collection and central data warehouse design. This method can be used with or without other software development frameworks.We explain thoroughly those aspects that influenced the methodology building.The methodology is defined by four steps, which can be aligned with various iterative development frameworks. We describe here the alignment of our methodology with the RUP(rational unified process) framework.


Author(s):  
Khoirudin Eko Nurcahyo ◽  
Sucipto Sucipto ◽  
Arie Nugroho

<em>The purpose of this study is provide data warehouse modeling which make executive of school can analyze data easily, the problem is executive of school are analysis list registrant list difficulty, what the most and least registrant junior high school come from and the major which most and least registrant. This study do is because how important data management on education organization and how the data can be managed better. The study use descriptive quantitative method research and use 4 step data warehouse dimensional modeling by Kimball. On building data warehouse used ETL, data be extracted and transformed into data warehouse as dimension and fact. For next data be imported and be showed by web base business intelligence app. The result of this study is an web base business intelligence app which can show sum of registrant on gender, majors, junior high school graduate come from, recommendation and register year. Data warehouse is good at data analyzing for decision making, because data warehouse can show information quickly and accurate.</em>


Author(s):  
Arvind Singh

Health care is one of the speedy growing areas. The Health care system contains large amount of medical data which should be mined from data warehouse. The mined data from data warehouse helps in finding the important information. Comprehensive amount of data in health care database need the growth of tools which can be used to access the data, analyze and analysis the data, discovery of knowledge, and versed use of the stored knowledge. The health care system has lot of data about the patient’s details, medications etc. In this paper we have studied different data mining and warehousing techniques used in healthcare areas.


2018 ◽  
Vol 143 (4) ◽  
pp. 518-524 ◽  
Author(s):  
Marsha A. Raebel ◽  
LeeAnn M. Quintana ◽  
Emily B. Schroeder ◽  
Susan M. Shetterly ◽  
Lisa E. Pieper ◽  
...  

Context.— The laboratory total testing process includes preanalytic, analytic, and postanalytic phases, but most laboratory quality improvement efforts address the analytic phase. Expanding quality improvement to preanalytic and postanalytic phases via use of medical data warehouses, repositories that include clinical, utilization, and administrative data, can improve patient care by ensuring appropriate test utilization. Cross-department, multidisciplinary collaboration to address gaps and improve patient and system outcomes is beneficial. Objective.— To demonstrate medical data warehouse utility for characterizing laboratory-associated quality gaps amenable to preanalytic or postanalytic interventions. Design.— A multidisciplinary team identified quality gaps. Medical data warehouse data were queried to characterize gaps. Organizational leaders were interviewed about quality improvement priorities. A decision aid with elements including national guidelines, local and national importance, and measurable outcomes was completed for each gap. Results.— Gaps identified included (1) test ordering; (2) diagnosis, detection, and documentation, and (3) high-risk medication monitoring. After examination of medical data warehouse data including enrollment, diagnoses, laboratory, pharmacy, and procedures for baseline performance, high-risk medication monitoring was selected, specifically alanine aminotransferase, aspartate aminotransferase, complete blood count, and creatinine testing among patients receiving disease-modifying antirheumatic drugs. The test utilization gap was in monitoring timeliness (eg, &gt;60% of patients had a monitoring gap exceeding the guideline recommended frequency). Other contributors to selecting this gap were organizational enthusiasm, regulatory labeling, and feasibility of a significant laboratory role in addressing the gap. Conclusions.— A multidisciplinary process facilitated identification and selection of a laboratory medicine quality gap. Medical data warehouse data were instrumental in characterizing gaps.


2020 ◽  
Vol 309 ◽  
pp. 05010
Author(s):  
Songhe Mu ◽  
Qing Zhu ◽  
Yue Zhang ◽  
Yeteng An

The daily traffic volume of the State Grid 95598 Customer Service Center exceeds 800,000. In order to manage and store these massive data, we must carefully handle it. The call from electric customers implement the business philosophy of “Quality service is the lifeline of electric power enterprise”, and carry out related data aggregation, processing, statistics, conversion and analysis based on data warehouse, and fully explore and analyze these with big data analysis technology. The potential value in the data guides the optimization of business processes and improves the service quality and efficiency of the business center.


Author(s):  
Guntis Bārzdiņš ◽  
Sergejs Rikačovs ◽  
Marta Veilande ◽  
Mārtiņš Zviedris

Ontological Re-engineering of Medical Databases This paper describes data export from multiple medical databases (relational databases) into a single shared Medical Data Warehouse (RDF database structured according to an integrated OWL ontology). The exported data is conveniently accessible via SPARQL or via graphical query language ViziQuer based on UML profile for OWL. The approach is illustrated on one of Latvian Medical databases - Injury Register.


Sign in / Sign up

Export Citation Format

Share Document