Extract transfer load considerations of temporal data sources to data warehouses

Simple item page
dc.contributor.authorPhungtua-Eng, Thanapol
dc.contributor.authorChittayasothorn, Suphamit
dc.date.accessioned2026-08-06T10:23:21Z
dc.date.available2026-08-06T10:23:21Z
dc.date.issued2019-01-01
dc.description.abstractData warehouses are databases which store integrated enterprise-level information from information system data sources across the organization. These data sources may employ different database management systems, use different data formats, and use different value coding standards. Integrated data availability at the enterprise level from such diverse data sources requires transfers from transactional data sources, transforms them to the standard format, and loads them into the data warehouse. This process is known as the Extract Transform Load (ETL) process. At present, temporal databases which support validtime are available and temporal extensions to SQL are standard features since SQL 2011. The challenge is the temporal feature of temporal databases is different from the time dimension of conventional data warehouses. Thus specialized ETL procedures are required in the case that temporal databases are used as the data sources of data warehouses. In this paper, ETL process considerations for temporal databases sources are presented.
dc.identifier.citationLecture Notes in Electrical Engineering, 574, 170-176, 2019
dc.identifier.doi10.1007/978-3-030-21507-1_25
dc.identifier.issn18761100
dc.identifier.other2-s2.0-85068590991
dc.identifier.urihttps://dspace.kmitl.ac.th/handle/123456789/9537
dc.sourceLecture Notes in Electrical Engineering
dc.subjectData warehouse
dc.subjectETL
dc.subjectTemporal databases
dc.subjectValidtime period
dc.titleExtract transfer load considerations of temporal data sources to data warehouses
dc.typeConference Paper

Files

Collections

Research