IDEAS home Printed from https://ideas.repec.org/a/igg/jswis0/v3y2007i4p1-24.html
   My bibliography  Save this article

Ontology-Based Conceptual Design of ETL Processes for Both Structured and Semi-Structured Data

Author

Listed:
  • Dimitrios Skoutas

    (National Technical University of Athens, Greece)

  • Alkis Simitsis

    (National Technical University of Athens, Greece)

Abstract

One of the main tasks in the early stages of a data warehouse project is the identification of the appropriate transformations and the specification of inter-schema mappings from the data sources to the data warehouse. In this article, we propose an ontology-based approach to facilitate the conceptual design of the back stage of a data warehouse. A graph-based representation is used as a conceptual model for the datastores, so that both structured and semi-structured data are supported and handled in a uniform way. The proposed approach is based on the use of Semantic Web technologies to semantically annotate the data sources and the data warehouse, so that mappings between them can be inferred, thereby resolving the issue of heterogeneity. Specifically, a suitable application ontology is created and used to annotate the datastores. The language used for describing the ontology is OWL-DL. Based on the provided annotations, a DL reasoner is employed to infer semantic correspondences and conflicts among the datastores, and to propose a set of conceptual operations for transforming data from the source datastores to the data warehouse.

Suggested Citation

  • Dimitrios Skoutas & Alkis Simitsis, 2007. "Ontology-Based Conceptual Design of ETL Processes for Both Structured and Semi-Structured Data," International Journal on Semantic Web and Information Systems (IJSWIS), IGI Global, vol. 3(4), pages 1-24, October.
    • Handle: RePEc:igg:jswis0:v:3:y:2007:i:4:p:1-24
    as

    Download full text from publisher

    File URL: http://services.igi-global.com/resolvedoi/resolve.aspx?doi=10.4018/jswis.2007100101
    Download Restriction: no
    ---><---

    Citations

    Citations are extracted by the CitEc Project, subscribe to its RSS feed for this item.
    as


    Cited by:

    1. Asma Dhaouadi & Khadija Bousselmi & Mohamed Mohsen Gammoudi & Sébastien Monnet & Slimane Hammoudi, 2022. "Data Warehousing Process Modeling from Classical Approaches to New Trends: Main Features and Comparisons," Data, MDPI, vol. 7(8), pages 1-38, August.
    2. Petar Jovanovic & Sergi Nadal & Oscar Romero & Alberto Abelló & Besim Bilalli, 0. "Quarry: A User-centered Big Data Integration Platform," Information Systems Frontiers, Springer, vol. 0, pages 1-25.
    3. Petar Jovanovic & Sergi Nadal & Oscar Romero & Alberto Abelló & Besim Bilalli, 2021. "Quarry: A User-centered Big Data Integration Platform," Information Systems Frontiers, Springer, vol. 23(1), pages 9-33, February.
    4. Jianhui Chen & Ning Zhong & Jianhua Feng, 2017. "Developing a Provenance Warehouse for the Systematic Brain Informatics Study," International Journal of Information Technology & Decision Making (IJITDM), World Scientific Publishing Co. Pte. Ltd., vol. 16(06), pages 1581-1609, November.

    More about this item

    Statistics

    Access and download statistics

    Corrections

    All material on this site has been provided by the respective publishers and authors. You can help correct errors and omissions. When requesting a correction, please mention this item's handle: RePEc:igg:jswis0:v:3:y:2007:i:4:p:1-24. See general information about how to correct material in RePEc.

    If you have authored this item and are not yet registered with RePEc, we encourage you to do it here. This allows to link your profile to this item. It also allows you to accept potential citations to this item that we are uncertain about.

    We have no bibliographic references for this item. You can help adding them by using this form .

    If you know of missing items citing this one, you can help us creating those links by adding the relevant references in the same way as above, for each refering item. If you are a registered author of this item, you may also want to check the "citations" tab in your RePEc Author Service profile, as there may be some citations waiting for confirmation.

    For technical questions regarding this item, or to correct its authors, title, abstract, bibliographic or download information, contact: Journal Editor (email available below). General contact details of provider: https://www.igi-global.com .

    Please note that corrections may take a couple of weeks to filter through the various RePEc services.

    IDEAS is a RePEc service. RePEc uses bibliographic data supplied by the respective publishers.