Advertisement

Modeling of census data in a multidimensional environment

  • Holger Günzel
  • Wolfgang Lehner
  • Stein Eriksen
  • Jon Folkedal
Regular Papers Industrial Track
Part of the Lecture Notes in Computer Science book series (LNCS, volume 1475)

Abstract

The general aim of the KOSTRA project, initiated by Statistics Norway, is to set up a data reporting chain from the norwegian municipalities to a central database at Statistics Norway. In this paper, we present an innovative data model for supporting a data analysis process consisting of two sequential data production phases using two conceptional database schemes. A first data schema must provide a sound basis for an efficient analysis reflecting a multidimensional view on data. Another schema must cover all structural information, which is essential for supporting the generation of electronic forms as well as for performing consistency checks of the gathered in-formation. The resulting modeling approach provides a seamless solution for both proposed challenges. Based on the relational model, both schemes are powerful to cover the heterogeneity of the data source, handle complex structural information, and to provide a versioning mechanism for long term analysis.

Keywords

Data analysis metadata multidimensional model census data 

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. 1.
    Codd, E.F.; Codd, S.B.; Salley, C.T.: Providing OLAP (On-line Analytical Processing) to User Analysts: An IT Mandate, White Paper, Arbor Software Corporation, 1993Google Scholar
  2. 2.
    Dayal U.; Hsu, M.; Ladin, R.: Organizing Long-Running Activities with Triggers and Transactions, SIGMOD Conference 1990, pp. 204–214Google Scholar
  3. 3.
    Eriksen, S.: Data Warehousing in Statistics Norway — The RD application, Statistics Norway, internal report, Oslo, 1997Google Scholar
  4. 4.
    Kimball, R.: The Data Warehouse Toolkit, John Wiley & Sons, Inc., New York, 1996Google Scholar
  5. 5.
    Smith, J.M.; Smith, D.C.P.: Database Abstractions: Aggregation and Generalization, ACM Transactions on Database Systems 2(1977)2, pp. 105–133CrossRefGoogle Scholar
  6. 6.
    Titlestad, G.: KOSTRA — Model and solutions for a management for information ressources (in norwegian: KOSTRA — Modell og lØsninger for informasjonsressursforvaltning), Statistics Norway, internal report, Oslo, 1996Google Scholar
  7. 7.
    Wedekind, H.: Database Systems I (in german: Datenbanksysteme I), Mannheim, BI Wissenschaftsverlag, 1981Google Scholar
  8. 8.
    Yang, J.J.: Overall user requirements to Metadata Management Systems, Statistics Norway, KITH, internal report, Trondheim, 1997Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 1998

Authors and Affiliations

  • Holger Günzel
    • 1
  • Wolfgang Lehner
    • 1
  • Stein Eriksen
    • 2
  • Jon Folkedal
    • 2
  1. 1.Department of Database SystemsUniversity of Erlangen-NurembergErlangenGermany
  2. 2.KOSTRA Development TeamStatistics NorwayOsloNorway

Personalised recommendations