Skip to main content
SpringerLink
Log in

A Temporal Data Warehouse Conceptual Modelling and Its Transformation into Temporal Object Relational Model

  • Conference paper
  • First Online:
Advanced Intelligent Systems for Sustainable Development (AI2SD’2018) (AI2SD 2018)

Part of the book series: Advances in Intelligent Systems and Computing ((AISC,volume 915))

Abstract

The Conventional data warehouses (DWs) are information repositories specialized in supporting decision making. Since the decisional process requires an analyzing of historical data, DWs systems have been increasingly feeling the need to collect temporal data for accountability and traceability reasons. On the other hand, the temporal object relational Model has been successfully used to handle and maintain past, present and future information. In this paper, we propose a Novel conceptual design for temporal data warehouse (TDW) including bitemporal data. Our solution provides a transformation method into temporal star and snowflake schemas, which incorporate features of object relational data warehouse and integrate Bitemporal data, to meet the requirement of integrating heterogeneous types of data to support decision making with an efficient manner. We have focused on the creation of a conceptual model for designing a temporal object-relational data warehouse based on UML technology and EER (Enhanced entity-relationship) model. The proposed method comprises a Meta Model using UML mechanism to express the varying time data in data warehousing applications that allow easily realizing and transforming the conceptual model into a logical design schema.

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

Access this chapter

Log in via an institution
Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 129.00
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 169.99
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

References

  1. Garani, G., Atay, C.E.: Comparison of different temporal data warehouses approaches. The Online J. Sci. Technol. 7(2) (2017)

    Google Scholar 

  2. Malinowski, E., Zimanyi, E.: Logical representation of a conceptual model for spatial data warehouses. GeoInformatica 11(4), 431–457 (2007)

    Article  Google Scholar 

  3. Kaufmann, M., Fischer, P.M., May, N., Kossmann, D.: Benchmarking bitemporal database systems: ready for the future or stuck in the past? In: Proceedings of the: EDBT, pp. 738–749 (2014)

    Google Scholar 

  4. Ain El Hayat, S. Bahaj, M.: Converting UML class diagrams into temporal object relational databases. IJECE J. 7(5) (2017)

    Google Scholar 

  5. Loyola, R., Sepulveda, A., Hernandez, M.: Optimization slowly changing dimensions of a data warehouse using object-relational. In: Conference: 24th International Conference of the Chilean Computer Science Society (SCCC) (2015)

    Google Scholar 

  6. Gosain, A., Saroha, K.: Bitemporal versioning of schema in temporal data warehouses. Data Eng. Intell. Comput. 542, 357–367 (2017)

    Google Scholar 

  7. Malinowski, E., Zimanyi, E.: A conceptual model for temporal data warehouses and its transformation to the ER and the object-relational models. Data Knowl. Eng. 64(1), 101–133 (2008)

    Article  Google Scholar 

  8. Yu-Chih Liu, J., Ya Lai, S.: Constructing an object-relational data warehouse using semi-automated methods. J. Inf. Manag. 205–225 (2008)

    Google Scholar 

  9. Saxena, G., Agarwa, B.B.: Data warehouse desining: dimensional modelling and E-R modelling. Int. J. Eng. Invent. 3, 28–34 (2014)

    Google Scholar 

  10. Garani, G., Helmer, S.: Integrating star and snowflake schemas in data warehouses. Int. J. Data Warehous. Min. 8(4), 22–40 (2012)

    Article  Google Scholar 

  11. Garani, G., Adam, G., Ventzas, D.: Temporal data warehouse logical modeling. Conf. Int. J. Data Min. Mod. Manag. 8(2) (2016)

    Google Scholar 

  12. Lin, W.Y., Wu, C.A., Wu, C.C.: An object-relational datawarehouse modeling for complex data. In: Conference: 9th International Conference in Information Sciences (JCI) (2006)

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Faculty of Science and Technologies, Hassan 1st University, Settat, Morocco

    Soumiya Ain El Hayat & Mohamed Bahaj

Authors
  1. Soumiya Ain El Hayat
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Mohamed Bahaj
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Soumiya Ain El Hayat .

Editor information

Editors and Affiliations

  1. Faculty of Sciences and Techniques, Abdelmalek Essaâdi University, Tangier, Morocco

    Mostafa Ezziyyani

Rights and permissions

Reprints and permissions

Copyright information

© 2019 Springer Nature Switzerland AG

About this paper

Check for updates. Verify currency and authenticity via CrossMark

Cite this paper

Ain El Hayat, S., Bahaj, M. (2019). A Temporal Data Warehouse Conceptual Modelling and Its Transformation into Temporal Object Relational Model. In: Ezziyyani, M. (eds) Advanced Intelligent Systems for Sustainable Development (AI2SD’2018). AI2SD 2018. Advances in Intelligent Systems and Computing, vol 915. Springer, Cham. https://doi.org/10.1007/978-3-030-11928-7_28

Download citation

Publish with us

Policies and ethics

Search

Navigation