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.
Preview
Unable to display preview. Download preview PDF.
References
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, 1993
Dayal U.; Hsu, M.; Ladin, R.: Organizing Long-Running Activities with Triggers and Transactions, SIGMOD Conference 1990, pp. 204–214
Eriksen, S.: Data Warehousing in Statistics Norway — The RD application, Statistics Norway, internal report, Oslo, 1997
Kimball, R.: The Data Warehouse Toolkit, John Wiley & Sons, Inc., New York, 1996
Smith, J.M.; Smith, D.C.P.: Database Abstractions: Aggregation and Generalization, ACM Transactions on Database Systems 2(1977)2, pp. 105–133
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, 1996
Wedekind, H.: Database Systems I (in german: Datenbanksysteme I), Mannheim, BI Wissenschaftsverlag, 1981
Yang, J.J.: Overall user requirements to Metadata Management Systems, Statistics Norway, KITH, internal report, Trondheim, 1997
Author information
Authors and Affiliations
Editor information
Rights and permissions
Copyright information
© 1998 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Günzel, H., Lehner, W., Eriksen, S., Folkedal, J. (1998). Modeling of census data in a multidimensional environment. In: Litwin, W., Morzy, T., Vossen, G. (eds) Advances in Databases and Information Systems. ADBIS 1998. Lecture Notes in Computer Science, vol 1475. Springer, Berlin, Heidelberg. https://doi.org/10.1007/BFb0057748
Download citation
DOI: https://doi.org/10.1007/BFb0057748
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-64924-3
Online ISBN: 978-3-540-68309-4
eBook Packages: Springer Book Archive