Advertisement

Metadata and Data Warehouse Quality

  • Matthias Jarke
  • Maurizio Lenzerini
  • Yannis Vassiliou
  • Panos Vassiliadis
Chapter

Abstract

In the traditional view, data warehouses provide large-scale caches of historic data. They sit between (a) information sources gained externally or through online transaction processing systems (OLTP) and (b) decision support or data mining queries following the vision of online analytic processing (OLAP). Three main arguments have been put forward in favor of this caching approach:
  1. 1.

    Performance and safety considerations. The concurrency control methods of most DBMS do not react well to a mix of short update transactions (as in OLTP) and OLAP queries that typically search a large portion of the database. Moreover, the OLTP systems are often critical for the operation of the organization and must not be in danger of corruption by other applications.

     
  2. 2.

    Logical interpretability problems. Inspired by the success of spreadsheet techniques, OLAP users tend to think in terms of highly structured multidimensional data models, whereas information sources offer at best relational, often just semistructured data models or even flat files.

     
  3. 3.

    Temporal and granularity mismatch. OLTP systems focus on current operational support in great detail, whereas OLAP often considers historical developments in a somewhat lesser detail.

     

Keywords

Unify Modeling Language Data Warehouse Quality Function Deployment Enterprise Model Quality Goal 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Springer-Verlag Berlin Heidelberg 2003

Authors and Affiliations

  • Matthias Jarke
    • 1
  • Maurizio Lenzerini
    • 2
  • Yannis Vassiliou
    • 3
  • Panos Vassiliadis
    • 3
  1. 1.Dept. of Computer Science VRWTH AachenAachenGermany
  2. 2.Dipartimento di Informatica e SistemisticaUniversità di Roma “La Sapienza”RomeItaly
  3. 3.Dept. of Electrical and Computer Engineering, Computer Science DivisionNational Technical University of AthensZographou, AthensGreece

Personalised recommendations