Understanding Cryptic Schemata in Large Extract-transform-load Systems

Released on by Alexander Albrecht
preview-18

  • Understanding Cryptic Schemata in Large Extract-transform-load Systems Book Detail

  • Author : Alexander Albrecht
  • Release Date : 2013
  • Publisher : Universitätsverlag Potsdam
  • Genre : Computers
  • Pages : 28
  • ISBN 13 : 3869562013
  • File Size : 69,69 MB
DOWNLOAD BOOK

Understanding Cryptic Schemata in Large Extract-transform-load Systems by Alexander Albrecht PDF Summary

Book Description: Extract-Transform-Load (ETL) tools are used for the creation, maintenance, and evolution of data warehouses, data marts, and operational data stores. ETL workflows populate those systems with data from various data sources by specifying and executing a DAG of transformations. Over time, hundreds of individual workflows evolve as new sources and new requirements are integrated into the system. The maintenance and evolution of large-scale ETL systems requires much time and manual effort. A key problem is to understand the meaning of unfamiliar attribute labels in source and target databases and ETL transformations. Hard-to-understand attribute labels lead to frustration and time spent to develop and understand ETL workflows. We present a schema decryption technique to support ETL developers in understanding cryptic schemata of sources, targets, and ETL transformations. For a given ETL system, our recommender-like approach leverages the large number of mapped attribute labels in existing ETL workflows to produce good and meaningful decryptions. In this way we are able to decrypt attribute labels consisting of a number of unfamiliar few-letter abbreviations, such as UNP_PEN_INT, which we can decrypt to UNPAID_PENALTY_INTEREST. We evaluate our schema decryption approach on three real-world repositories of ETL workflows and show that our approach is able to suggest high-quality decryptions for cryptic attribute labels in a given schema.

Disclaimer: www.yourbookbest.com does not own Understanding Cryptic Schemata in Large Extract-transform-load Systems books pdf, neither created or scanned. We just provide the link that is already available on the internet, public domain and in Google Drive. If any way it violates the law or has any issues, then kindly mail us via contact us page to request the removal of the link.

Conceptual Modeling

Conceptual Modeling

File Size : 22,22 MB
Total View : 9020 Views
DOWNLOAD

This book constitutes the refereed proceedings of the 31st International Conference on Conceptual Modeling, ER 2012, held in Florence, Italy, in October 2012. T