Data Warehouse Design Methodology

2009 ◽  
pp. 658-658
Keyword(s):  
Data Warehouse ◽  
Design Methodology ◽  
Warehouse Design

scholarly journals Conceptual Modeling Solutions for the Data Warehouse

2009 ◽  
pp. 86-104 ◽  
Author(s):  
Stefano Rizzi
Keyword(s):  
Conceptual Model ◽  
Data Warehouse ◽  
Design Methodology ◽  
Conceptual Modeling ◽  
The Other ◽  
Level Of Abstraction ◽  
Practical Guide ◽  
Multidimensional Modeling ◽  
Basic Concepts ◽  
Warehouse Design

In the context of data warehouse design, a basic role is played by conceptual modeling, that provides a higher level of abstraction in describing the warehousing process and architecture in all its aspects, aimed at achieving independence of implementation issues. This chapter focuses on a conceptual model called the DFM that suits the variety of modeling situations that may be encountered in real projects of small to large complexity. The aim of the chapter is to propose a comprehensive set of solutions for conceptual modeling according to the DFM and to give the designer a practical guide for applying them in the context of a design methodology. Besides the basic concepts of multidimensional modeling, the other issues discussed are descriptive and cross-dimension attributes; convergences; shared, incomplete, recursive, and dynamic hierarchies; multiple and optional arcs; and additivity.

scholarly journals Conceptual Modeling Solutions for the Data Warehouse

2011 ◽  
pp. 24-42
Author(s):  
Stefano Rizzi
Keyword(s):  
Conceptual Model ◽  
Data Warehouse ◽  
Design Methodology ◽  
Conceptual Modeling ◽  
The Other ◽  
Level Of Abstraction ◽  
Practical Guide ◽  
Multidimensional Modeling ◽  
Basic Concepts ◽  
Warehouse Design

In the context of data warehouse design, a basic role is played by conceptual modeling, that provides a higher level of abstraction in describing the warehousing process and architecture in all its aspects, aimed at achieving independence of implementation issues. This chapter focuses on a conceptual model called the DFM that suits the variety of modeling situations that may be encountered in real projects of small to large complexity. The aim of the chapter is to propose a comprehensive set of solutions for conceptual modeling according to the DFM and to give the designer a practical guide for applying them in the context of a design methodology. Besides the basic concepts of multidimensional modeling, the other issues discussed are descriptive and cross-dimension attributes; convergences; shared, incomplete, recursive, and dynamic hierarchies; multiple and optional arcs; and additivity.

scholarly journals Conceptual Modeling Solutions for the Data Warehouse

2011 ◽  
pp. 44-64
Author(s):  
Stefano Rizzi
Keyword(s):  
Conceptual Model ◽  
Data Warehouse ◽  
Design Methodology ◽  
Conceptual Modeling ◽  
The Other ◽  
Level Of Abstraction ◽  
Practical Guide ◽  
Multidimensional Modeling ◽  
Basic Concepts ◽  
Warehouse Design

In the context of data warehouse design, a basic role is played by conceptual modeling, that provides a higher level of abstraction in describing the warehousing process and architecture in all its aspects, aimed at achieving independence of implementation issues. This chapter focuses on a conceptual model called the DFM that suits the variety of modeling situations that may be encountered in real projects of small to large complexity. The aim of the chapter is to propose a comprehensive set of solutions for conceptual modeling according to the DFM and to give the designer a practical guide for applying them in the context of a design methodology. Besides the basic concepts of multidimensional modeling, the other issues discussed are descriptive and cross-dimension attributes; convergences; shared, incomplete, recursive, and dynamic hierarchies; multiple and optional arcs; and additivity.

scholarly journals Conceptual Modeling Solutions for the Data Warehouse

2011 ◽  
pp. 1-26 ◽  
Author(s):  
Stefano Rizzi
Keyword(s):  
Conceptual Model ◽  
Data Warehouse ◽  
Design Methodology ◽  
Conceptual Modeling ◽  
The Other ◽  
Level Of Abstraction ◽  
Practical Guide ◽  
Multidimensional Modeling ◽  
Basic Concepts ◽  
Warehouse Design

In the context of data warehouse design, a basic role is played by conceptual modeling, that provides a higher level of abstraction in describing the warehousing process and architecture in all its aspects, aimed at achieving independence of implementation issues. This chapter focuses on a conceptual model called the DFM, that suits the variety of modeling situations that may be encountered in real projects of small to large complexity. The aim of the chapter is to propose a comprehensive set of solutions for conceptual modeling according to the DFM and to give the designer a practical guide for applying them in the context of a design methodology. Besides the basic concepts of multidimensional modeling, the other issues discussed are descriptive and cross-dimension attributes; convergences; shared, incomplete, recursive, and dynamic hierarchies; multiple and optional arcs; additivity.

scholarly journals Conceptual Modeling Solutions for the Data Warehouse

2008 ◽  
pp. 208-227 ◽  
Author(s):  
Stefano Rizzi
Keyword(s):  
Conceptual Model ◽  
Data Warehouse ◽  
Design Methodology ◽  
Conceptual Modeling ◽  
The Other ◽  
Level Of Abstraction ◽  
Practical Guide ◽  
Multidimensional Modeling ◽  
Basic Concepts ◽  
Warehouse Design

In the context of data warehouse design, a basic role is played by conceptual modeling, that provides a higher level of abstraction in describing the warehousing process and architecture in all its aspects, aimed at achieving independence of implementation issues. This chapter focuses on a conceptual model called the DFM, that suits the variety of modeling situations that may be encountered in real projects of small to large complexity. The aim of the chapter is to propose a comprehensive set of solutions for conceptual modeling according to the DFM and to give the designer a practical guide for applying them in the context of a design methodology. Besides the basic concepts of multidimensional modeling, the other issues discussed are descriptive and cross-dimension attributes; convergences; shared, incomplete, recursive, and dynamic hierarchies; multiple and optional arcs; additivity.

Physical Data Warehouse Design

2014 ◽  
pp. 233-284
Author(s):  
Alejandro Vaisman ◽  
Esteban Zimányi
Keyword(s):  
Data Warehouse ◽  
Physical Data ◽  
Warehouse Design

scholarly journals Perancangan Data Warehouse Rumah Sakit Berbasis Online Analytical Processing (OLAP)

2021 ◽  
Vol 8 (5) ◽  
pp. 1077
Author(s):  
Joko Purwanto ◽  
Renny Renny
Keyword(s):  
Information Technology ◽  
Health Services ◽  
Data Warehouse ◽  
Data Extraction ◽  
Online Analytical Processing ◽  
Data Source ◽  
Analytical Processing ◽  
Quality Of Health Services ◽  
Warehouse Design

<p class="BodyCxSpFirst">Pemanfaatan teknologi informasi sangat penting bagi rumah sakit, karena berpengaruh pula terhadap kualitas pelayanan kesehatan yang secara manual diubah menjadi digital dengan menggunakan teknologi informasi.Dalam penelitian ini penulis menggunakan metodologi <em>Nine step</em> sebagai acuan dalam merancang suatu <em>data warehouse</em><em>,</em> untuk pemodelan menggunakan skema konstelasi fakta dengan 3 tabel fakta dan 11 tabel dimensi. Perbedaan penelitian ini dengan penelitian sebelumnya terletak pada sumber data yang diekstrak langsung dari <em>database</em> SIMRS yang digunakan rumah sakit, sehingga tidak ada ekstraksi data secara manual.Penelitian ini bertujuan untuk menghasilkan desain data warehouse berbasis Online Analytical Processing (OLAP) sebagai sarana penunjang kualitas pelayanan kesehatan rumah sakit. OLAP yang dihasilkan akan berupa desain data warehouse dengan berbagai dimensi yang akan menghasilkan tampilan informasi berupa Chart maupun Grafik sehingga informasinya mudah dibaca dan dipahami oleh berbagai pihak.</p><p class="BodyCxSpFirst"> </p><p class="BodyCxSpFirst"><em><strong>Abtract</strong></em></p><p class="BodyCxSpFirst"><em>The use of information technology is very important for hospitals, because it also affects the quality of health services, which manualy changed to digital using information technology. In this study, the authors used the Nine step methodology as a reference in designing a data warehouse for modeling using a fact constellation schema with 3 fact tables and 11 dimension tables. the different in this study from previous research is that the data source was taken directly from the SIMRS database used by the hospital, so there is no manual data extraction.</em><em>The aim of this research is to be able to produce a Data Warehouse design based on Online Analytical Processing (OLAP) as a means of supporting the quality of hospital health services. The resulting OLAP will be a data warehouse design with various dimensions will produce the displays information in the form of a graph or chart so that the information is easy to read and understand by various parties.</em></p><p class="BodyCxSpLast"><em> </em></p><p class="BodyCxSpFirst"><em><strong><br /></strong></em></p>

Sign in / Sign up

Export Citation Format

Share Document