skip to main content
10.1145/1871940.1871945acmconferencesArticle/Chapter ViewAbstractPublication PagescikmConference Proceedingsconference-collections
research-article

Multiversion data warehouse constraints

Published: 30 October 2010 Publication History

Abstract

Data warehouse (DW) schema and instances may undergo several changes coming from data sources or from user analysis requirements. In order to be able to handle these changes, we have proposed a multiversion DW (MV-DW) model, which has to manage temporal versions of DW schema components and dimension members. Since this model is based on a multidimensional structure enhanced by temporal and versioning extensions, it requires several integrity constraints to maintain the consistency of its structure and data. The present paper first describes our meta-model for MV-DW. Then, a set of multiversion DW constraints are defined under three classes: structural constraints, temporal constraints and versioning constraints. Each of these constraints is expressed under the Object Constraint Language (OCL). Finally, we show that the MV-DW consistency can be maintained by running algorithms that have to check the defined integrity constraints.

References

[1]
Abelló, A., Martin, C., 2003. A Bi-temporal Storage Structure for a Corporate Data Warehouse. In International Conference on Enterprise Information Systems, Angers, France, 177--183.
[2]
Bebel, B., Eder, J., Koncilia, C., Morzy, T., Wrembel, R., 2004. Creation and Management of Versions in Multiversion Data Warehouse. ACM Symposium on Applied Computing, Nicosia, Cyprus, 717--723.
[3]
Bliujute, R., Saltenis, S., Slivinskas, G., Jensen, C. S., 1998. Systematic Change Management in Dimensional Data Warehousing. In International Baltic Workshop on Databases and Information Systems, Riga, Latvia, 27--41.
[4]
Carpani, F., Ruggia, R., 2001. An Integrity Constraints Language for a Conceptual Multidimensional Data Model. In International Conference on Software Engineering & Knowledge Engineering, Argentina.
[5]
Eder, J., Koncilia, C., Morzy, T., 2002. The COMET Metamodel for a Temporal Data Warehouse. In International Conference on Advanced Information Systems Engineering, Toronto, Canada, 83--99.
[6]
Eder, J., Wiggiser, K., 2009. Data Warehouse Maintenance, Evolution and Versioning. Encyclopedia of Database Systems, 664--669.
[7]
Ghozzi, F., Ravat F., Teste, O., Zurfluh, G., 2003. Constraints and Multidimensional Databases. In International Conference on Enterprise Information Systems, Angers, France, 104--111.
[8]
Golfarelli, M., Rizzi, S., 2009. A Survey on Temporal Data Warehousing. Journal IJDWM, 5(1), 1--17.
[9]
Hurtado, C.A., Mendelzon, A.O., 2002. OLAP Dimension Constraints. In ACM SIGACT-SIGMOD-SIGART Symposium on Principles of Database Systems, Madison, USA, 169--179.
[10]
Kimball, R., 1996. The Data Warehouse Toolkit. J. Wiley and Sons.
[11]
Lenz, H.-J., Shoshani, A., 1997. Summarizability in OLAP and statistical data bases. In Proceedings of the 9th SSDBM Conference, Olympia, Washington, USA, 132--143.
[12]
Mazon, J.-N., Lechtenborger, J., Trujillo, J., 2009. A Survey on Summarizability Issues in Multidimensional Modelling. Journal DKE, 68 (12), 1452--1469.
[13]
OMG, 2006. Object Constraint Language. Version 2.0 http://www.omg.org/spec/OCL/2.0/PDF
[14]
Pedersen, T.B., Jensen, C.S., 2001. Multidimensional Database Technology. IEEE Computer, 34(12), 40--46.
[15]
Romero, O., Abello, A., 2010. Automatic Validation of Requirements to Support Multidimensional Design. Journal DKE, 69 (9), 917--942.
[16]
Salem, A., Ghozzi, F., Ben-Abdallah, H., 2008. Multi- Dimensional Modeling: Formal Specification and Verification of the Hierarchy Concept. In 10th International Conference on Enterprise Information Systems (ICEIS), Barcelona, Spain.
[17]
Wrembel, R., Bebel, B., 2007. Metadata Management in a Multiversion Data Warehouse. Journal JODS, 8, LNCS 4380, 118--157.
[18]
Zouari, I., Ghozzi, F., Bouaziz, R., 2008. Impact of Nomenclature Evolution on DW Versioning (in French). Journal RSTI-ISI, 13(6), 85--114.
[19]
Zouari, I., Ghozzi, F., Bouaziz, R., 2009. New Evolution Operators for Multiversion Data Warehouse. In International Conference MIPRO Business Intelligence System, 175--180.

Cited By

View all
  • (2020)A Semi-Automatic Design Methodology for (Big) Data Warehouse Transforming Facts into DimensionsIEEE Transactions on Knowledge and Data Engineering10.1109/TKDE.2019.292562133:1(28-42)Online publication date: 7-Dec-2020
  • (2016)Cohérence logique dans les systèmes OLAP spatiauxRevue Internationale de Géomatique10.3166/RIG.26.97-13126:1(97-131)Online publication date: 11-Apr-2016
  • (2016)Bi-temporal schema versioning in bi-temporal data warehouseCSI Transactions on ICT10.1007/s40012-016-0081-43:2-4(135-142)Online publication date: 4-Jul-2016
  • Show More Cited By

Index Terms

  1. Multiversion data warehouse constraints

    Recommendations

    Comments

    Information & Contributors

    Information

    Published In

    cover image ACM Conferences
    DOLAP '10: Proceedings of the ACM 13th international workshop on Data warehousing and OLAP
    October 2010
    112 pages
    ISBN:9781450303835
    DOI:10.1145/1871940
    Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

    Sponsors

    Publisher

    Association for Computing Machinery

    New York, NY, United States

    Publication History

    Published: 30 October 2010

    Permissions

    Request permissions for this article.

    Check for updates

    Author Tags

    1. data warehouse
    2. dimension member versioning
    3. schema versioning
    4. structural constraint
    5. temporal constraint

    Qualifiers

    • Research-article

    Conference

    CIKM '10

    Acceptance Rates

    Overall Acceptance Rate 29 of 79 submissions, 37%

    Upcoming Conference

    CIKM '25

    Contributors

    Other Metrics

    Bibliometrics & Citations

    Bibliometrics

    Article Metrics

    • Downloads (Last 12 months)4
    • Downloads (Last 6 weeks)0
    Reflects downloads up to 10 Feb 2025

    Other Metrics

    Citations

    Cited By

    View all
    • (2020)A Semi-Automatic Design Methodology for (Big) Data Warehouse Transforming Facts into DimensionsIEEE Transactions on Knowledge and Data Engineering10.1109/TKDE.2019.292562133:1(28-42)Online publication date: 7-Dec-2020
    • (2016)Cohérence logique dans les systèmes OLAP spatiauxRevue Internationale de Géomatique10.3166/RIG.26.97-13126:1(97-131)Online publication date: 11-Apr-2016
    • (2016)Bi-temporal schema versioning in bi-temporal data warehouseCSI Transactions on ICT10.1007/s40012-016-0081-43:2-4(135-142)Online publication date: 4-Jul-2016
    • (2010)DOLAP 2010 workshop summaryProceedings of the 19th ACM international conference on Information and knowledge management10.1145/1871437.1871792(1973-1974)Online publication date: 26-Oct-2010

    View Options

    Login options

    View options

    PDF

    View or Download as a PDF file.

    PDF

    eReader

    View online with eReader.

    eReader

    Figures

    Tables

    Media

    Share

    Share

    Share this Publication link

    Share on social media