학술논문

A Meta-model Based Approach for Data Warehouses Design and Implementation
Document Type
Conference
Source
2015 26th International Workshop on Database and Expert Systems Applications (DEXA) Database and Expert Systems Applications (DEXA), 2015 26th International Workshop on. :212-216 Sep, 2015
Subject
Computing and Processing
Databases
Unified modeling language
Erbium
Data warehouses
Object oriented modeling
Design methodology
Numerical models
Data Warehouses (DWs)
meta-model
user requirements
operational Database
Language
ISSN
1529-4188
2378-3915
Abstract
In this paper, we present a meta-model approach for the design and implementation of Data Warehouses (DWs). The approach is made up of a set of transformation rules as a mechanism to extract multidimensional schemas from the logical description of the operational Database and a Computation Independent Model (CIM) for user requirements definition. As a result we have implemented an Eclipse based prototype that generates from the logical description of the operational Database and user requirements the multidimensional schema that best reflects users requirements. Next, for multidimensional schemas generation, we use user requirements to guide the selection that is supported by the operational Database that is most likely to satisfy users requirements. Finally, we define a tool for the data Warehouse implementation.