Abstract

Extraction, Transformation and Loading (ETL) is a key process of data warehouse building. It integrates data sources with diverse features and structures. Numerous approaches and implementations of ETL have been introduced. However, they still have the following disadvantages: human-dependence, information integration only in syntactic levels, incomplete the homogeneity solution, difficulty to install and configure, etc. In this paper, we propose an alternative approach to the ETL process by attacking the homogeneity in data sources with an ontology-based methodology. Our approach can overcome the drawbacks of most existing approaches; as it automates the key activities of the process, such as: extraction of metainformation, generation of logical and physical data models, and transformation of information.

Full Text
Paper version not known

Talk to us

Join us for a 30 min session where you can share your feedback and ask us any queries you have

Schedule a call

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.