A Unified Conceptual Model for Data Warehouses

Abstract

These days, NoSQL (Not only SQL) databases are being used as a deployment tool for Data Warehouses (DW) due to its support for dynamic and scalable data modeling capabilities. Yet, decision-makers have faced several challenges to accept it as a major choice for implementation of their DW. The most significant one among those challenges is a lack of common conceptual model and a systematic design methodology for different NoSQL databases. The objective of this paper is to resolve these challenges by proposing an ontology based formal conceptual model for NoSQL based DWs. These proposed concepts are capable of realizing the cube concepts for visualization of multi-dimensional data in NoSQL based DW solutions. In this context, two strategies are specified, implemented and illustrated using a case study for devising of the proposed conceptual model.

A Novel Unified Data Modeling Method for Equipment Lifecycle Integrated Logistics Support

“…To completely express the different dimensional information of the data model, many researchers have studied the multidimensional data modeling method. Multidimensional data modeling is mainly applied to the research of the data warehouse, such as the analysis of heterogeneous data [46][47][48]. In the data warehouse, the multidimensional data model is designed to describe the facts of the data warehouse and the different analysis dimensions [49].…”