Skip to main content
SpringerLink
Log in

Slowly Changing Dimension Handling in Data Warehouses Using Temporal Database Features

  • Conference paper
  • First Online:
Intelligent Information and Database Systems (ACIIDS 2019)

Part of the book series: Lecture Notes in Computer Science ((LNAI,volume 11431))

Included in the following conference series:

Abstract

This paper presents the use of temporal database features to solve the Slowly Changing Dimension (SCD) problem of data warehouses. The SCD problem is presented and existing solutions, together with their limitations are shown. Temporal database features of SQL are described. Temporal data retrieval and temporal data manipulations, together with illustrated examples are demonstrated. The solution to the SCD problem is shown with illustrated examples. The data warehouse whose dimension tables are validtime state tables, but the fact table is a conventional fact table without any timestamp or validtime period, is proposed. The identifier integrity of dimension instances is preserved. The sample fact table, dimension tables, and the SQL codes which perform temporal operations to solve the problem are presented. The proposed solution gives correct results regardless of the number of changes made to the attribute of the dimension table, thus completely solves the Slowly Changing Dimension problem.

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 39.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 54.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. Kimbal, R., Ross, M.: The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling, 3rd edn. Wiley, Indianapolis (2013)

    Google Scholar 

  2. Jensen, C., Pederson, T.B., Thomsen, C.: Multidimensional Databases and Data Warehousing. Lexington, Morgan Claypool (2010)

    Book  Google Scholar 

  3. Nguyen, T.M., Tjoa, A.M., Nemec, J., Windisch, M.: An approach towards an event-fed solution for slowly changing dimensions in data warehouses with a detailed case study. Data Knowl. Eng. 63(1), 26–43 (2007)

    Article  Google Scholar 

  4. Santos, V., Belo, O.: No need to type slowly changing dimensions. In: Proceedings of IADIS International Conference Information Systems 2011, Avila, Spain, pp. 11–13 (2011)

    Google Scholar 

  5. Faisal, S., Sarwar, M.: Handling slowly changing dimensions in data warehouses. J. Syst. Softw. 94, 151–160 (2014)

    Article  Google Scholar 

  6. Ravat, F., Teste, O., Zurfluh, G.: A multiversion-based multidimensional model. In: Tjoa, A.M., Trujillo, J. (eds.) DaWaK 2006. LNCS, vol. 4081, pp. 65–74. Springer, Heidelberg (2006). https://doi.org/10.1007/11823728_7

    Chapter  Google Scholar 

  7. Golfarelli, M., Lechtenbörger, J., Rizzi, S., Vossen, G.: Schema versioning in data warehouses. In: Wang, S., et al. (eds.) ER 2004. LNCS, vol. 3289, pp. 415–428. Springer, Heidelberg (2004). https://doi.org/10.1007/978-3-540-30466-1_38

    Chapter  Google Scholar 

  8. Workspace Manager Valid Time Support. https://docs.oracle.com/database/121/ADWSM/long_vt.htm

  9. Snodgrass, R.T.: Managing temporal data – a five part series, Database programming and design, TimeCenter technical report (1998)

    Google Scholar 

  10. Allen, J.F.: Maintaining knowledge about temporal intervals. Commun. ACM 26, 832–843 (1983)

    Article  Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Faculty of Business Administration and Information Technology, Rajamangala University of Technology Tawan-Ok, Chakrabongse Bhuvanarth Campus, Bangkok, 10400, Thailand

    Thanapol Phungtua-Eng

  2. Faculty of Engineering, King Mongkut’s Institute of Technology Ladkrabang, Bangkok, 10520, Thailand

    Suphamit Chittayasothorn

Authors
  1. Thanapol Phungtua-Eng
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Suphamit Chittayasothorn
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Suphamit Chittayasothorn .

Editor information

Editors and Affiliations

  1. Ton Duc Thang University, Ho Chi Minh City, Vietnam

    Ngoc Thanh Nguyen

  2. Bina Nusantara University, Jakarta, Indonesia

    Ford Lumban Gaol

  3. National University of Kaohsiung, Kaohsiung, Taiwan

    Tzung-Pei Hong

  4. Wrocław University of Science and Technology, Wrocław, Poland

    Bogdan Trawiński

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

Phungtua-Eng, T., Chittayasothorn, S. (2019). Slowly Changing Dimension Handling in Data Warehouses Using Temporal Database Features. In: Nguyen, N., Gaol, F., Hong, TP., Trawiński, B. (eds) Intelligent Information and Database Systems. ACIIDS 2019. Lecture Notes in Computer Science(), vol 11431. Springer, Cham. https://doi.org/10.1007/978-3-030-14799-0_58

Download citation

  • DOI: https://doi.org/10.1007/978-3-030-14799-0_58

  • Published:

  • Publisher Name: Springer, Cham

  • Print ISBN: 978-3-030-14798-3

  • Online ISBN: 978-3-030-14799-0

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics

Search

Navigation