IDEAS home Printed from https://ideas.repec.org/a/igg/jiit00/v6y2010i3p1-16.html
   My bibliography  Save this article

Incremental Load in a Data Warehousing Environment

Author

Listed:
  • Nayem Rahman

    (Intel Corporation, USA)

Abstract

Incremental load is an important factor for successful data warehousing. Lack of standardized incremental refresh methodologies can lead to poor analytical results, which can be unacceptable to an organization’s analytical community. Successful data warehouse implementation depends on consistent metadata as well as incremental data load techniques. If consistent load timestamps are maintained and efficient transformation algorithms are used, it is possible to refresh databases with complete accuracy and with little or no manual checking. This paper proposes an Extract-Transform-Load (ETL) metadata model that archives load observation timestamps and other useful load parameters. The author also recommends algorithms and techniques for incremental refreshes that enable table loading while ensuring data consistency, integrity, and improving load performance. In addition to significantly improving quality in incremental load techniques, these methods will save a substantial amount of data warehouse systems resources.

Suggested Citation

  • Nayem Rahman, 2010. "Incremental Load in a Data Warehousing Environment," International Journal of Intelligent Information Technologies (IJIIT), IGI Global, vol. 6(3), pages 1-16, July.
  • Handle: RePEc:igg:jiit00:v:6:y:2010:i:3:p:1-16
    as

    Download full text from publisher

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

    Citations

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


    Cited by:

    1. Yujong Hwang, 2014. "Understanding the Electronic Recruiting Marketplace Strategy: The Case of JobKorea," Information Technology for Development, Taylor & Francis Journals, vol. 20(4), pages 353-361, October.
    2. Francis Kofi Andoh-Baidoo, 2016. "Organizational Information and Communication Technologies for Development," Information Technology for Development, Taylor & Francis Journals, vol. 22(2), pages 193-204, April.

    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:jiit00:v:6:y:2010:i:3:p:1-16. 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.