Slowly Changing Dimension Handling in Data Warehouses Using Temporal Database Features

  • Thanapol Phungtua-Eng
  • Suphamit ChittayasothornEmail author
Conference paper
Part of the Lecture Notes in Computer Science book series (LNCS, volume 11431)


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.


Slowly Changing Dimension Temporal data warehouse Temporal SQL 


  1. 1.
    Kimbal, R., Ross, M.: The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling, 3rd edn. Wiley, Indianapolis (2013)Google Scholar
  2. 2.
    Jensen, C., Pederson, T.B., Thomsen, C.: Multidimensional Databases and Data Warehousing. Lexington, Morgan Claypool (2010)CrossRefGoogle Scholar
  3. 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)CrossRefGoogle Scholar
  4. 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. 5.
    Faisal, S., Sarwar, M.: Handling slowly changing dimensions in data warehouses. J. Syst. Softw. 94, 151–160 (2014)CrossRefGoogle Scholar
  6. 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). Scholar
  7. 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). Scholar
  8. 8.
    Workspace Manager Valid Time Support.
  9. 9.
    Snodgrass, R.T.: Managing temporal data – a five part series, Database programming and design, TimeCenter technical report (1998)Google Scholar
  10. 10.
    Allen, J.F.: Maintaining knowledge about temporal intervals. Commun. ACM 26, 832–843 (1983)CrossRefGoogle Scholar

Copyright information

© Springer Nature Switzerland AG 2019

Authors and Affiliations

  • Thanapol Phungtua-Eng
    • 1
  • Suphamit Chittayasothorn
    • 2
    Email author
  1. 1.Faculty of Business Administration and Information TechnologyRajamangala University of Technology Tawan-OkBangkokThailand
  2. 2.Faculty of EngineeringKing Mongkut’s Institute of Technology LadkrabangBangkokThailand

Personalised recommendations