Abstract
Data 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.
Talk to us
Join us for a 30 min session where you can share your feedback and ask us any queries you have
Disclaimer: All third-party content on this website/platform is and will remain the property of their respective owners and is provided on "as is" basis without any warranties, express or implied. Use of third-party content does not indicate any affiliation, sponsorship with or endorsement by them. Any references to third-party content is to identify the corresponding services and shall be considered fair use under The CopyrightLaw.