Logo image
Designing data warehouses with OO conceptual models
Journal article   Open access

Designing data warehouses with OO conceptual models

J Trujillo, M Palomar, J Gomez and Il-Yeol Il-Yeol Song
Computer (Long Beach, Calif.), v 34(12)
Dec 2001
url
https://doi.org/10.1109/2.970579View
Published, Version of Record (VoR) Open

Abstract

Multidimensional systems Data analysis Object oriented databases Unified modeling language Buildings Data warehouses Data structures Marketing and sales Proposals Power system modeling
The authors propose an approach that provides a theoretical foundation for the use of object-oriented databases and object-relational databases in data warehouse, multidimensional database, and online analytical processing applications. This approach introduces a set of minimal constraints and extensions to the Unified Modeling Language for representing multidimensional modeling properties for these applications. Multidimensional modeling offers two benefits. First, the model closely parallels how data analyzers think and, therefore, helps users understand data. Second, multidimensional modeling helps predict what final users want to do, thereby facilitating performance improvements. The authors are using their approach to create an automatic implementation of a multidimensional model. They plan to integrate commercial online-analytical-processing tool facilities within their GOLD model case tool as well, a task that involves data warehouse prototyping and sample data generation issues.

Metrics

7 Record Views
144 citations in Scopus

Details

InCites Highlights

Data related to this publication, from InCites Benchmarking & Analytics tool:

Web of Science research areas
Computer Science, Hardware & Architecture
Computer Science, Software Engineering
Logo image