Skip to main content

Toward Propagating the Evolution of Data Warehouse on Data Marts

  • Conference paper
Model and Data Engineering (MEDI 2012)

Part of the book series: Lecture Notes in Computer Science ((LNPSE,volume 7602))

Included in the following conference series:

Abstract

Modern Decision Support Systems (DSS) are composed of a Data Warehouse (DW) which stores all data necessary for decisional purposes, and a several Data Marts (DMs). A DM is a subject oriented extract of the DW data; it facilitates evaluating the performances of a business process. However, in practice, business processes may evolve as well as new ones may be created, consequently the DW model evolves in order to capture the changes. The maintenance of DMs due to the evolution of their DW is time-consuming, expensive and error-prone process. This paper studies the evolution of DM schemas in the case of a new table is added to the DW.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 54.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 72.00
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. Banerjee, J., Kim, W., Kim, H.J., Korth, H.: Semantics and implementation of schema evolution in object-oriented databases. In: ACM SIGMOD International Conference on Management of Data (SIGMOD), pp. 311–322. ACM, NewYork (1987)

    Google Scholar 

  2. Aboulsamh, M.A., Davies, J.: Specification and Verification of Model-Driven Data Migration. In: Bellatreche, L., Mota Pinto, F. (eds.) MEDI 2011. LNCS, vol. 6918, pp. 214–225. Springer, Heidelberg (2011)

    Chapter  Google Scholar 

  3. Hurtado, C.A., Mendelzon, A.O., Vaisman, A.A.: Maintaining Data Cubes underDimension Updates. In: XVth International Conference on Data Engineering (ICDE 1999), pp. 346–355. IEEE Computer Society, Sydney (1999)

    Google Scholar 

  4. Blaschka, M., Sapia, C., Höfling, G.: On Schema Evolution in Multidimensional Databases. In: Mohania, M., Tjoa, A.M. (eds.) DaWaK 1999. LNCS, vol. 1676, pp. 153–164. Springer, Heidelberg (1999)

    Google Scholar 

  5. Golfarelli, M., Lechtenborger, J., Rizzi, S., Vossen, G.: Schema versioning in datawarehouses: enabling cross-version querying via schema augmentation. Data and Knowledge Engineering 59(2), 435–459 (2006)

    Article  Google Scholar 

  6. Bellahsene, Z.: Schema Evolution in Data Warehouses. Knowledge and Information Systems 4(3), 283–304 (2002)

    Article  Google Scholar 

  7. Benitez-Guerrero, E.I., Collet, C., Adiba, M.: The Whes Approach To Data Warehouse Evolution.e-Gnosis (online), 2, Art. 11 (2004)

    Google Scholar 

  8. Favre, C., Bentayeb, F., Boussaïd, O.: Dimension Hierarchies Updates in Data Warehouses: a User-driven Approach. In: IXth International Conference on Enterprise Information Systems (ICEIS 2007), Funchal, Madeira, Portugal (2007)

    Google Scholar 

  9. Papastefanatos, G., Vassiliadis, P., Simitsis, A., Sellis, T., Vassiliou, Y.: Rulebased Management of Schema Changes at ETL Sources. In: The International Workshop on Managing Evolution of Data Warehouses (MEDWa 2009), Riga, Latvia (2009)

    Google Scholar 

Download references

Author information

Authors and Affiliations

Authors

Editor information

Editors and Affiliations

Rights and permissions

Reprints and permissions

Copyright information

© 2012 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Taktak, S., Feki, J. (2012). Toward Propagating the Evolution of Data Warehouse on Data Marts. In: Abelló, A., Bellatreche, L., Benatallah, B. (eds) Model and Data Engineering. MEDI 2012. Lecture Notes in Computer Science, vol 7602. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-33609-6_18

Download citation

  • DOI: https://doi.org/10.1007/978-3-642-33609-6_18

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-642-33608-9

  • Online ISBN: 978-3-642-33609-6

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics