How Long to Read Understanding Cryptic Schemata in Large Extract-transform-load Systems

By Alexander Albrecht

How Long Does it Take to Read Understanding Cryptic Schemata in Large Extract-transform-load Systems?

It takes the average reader and 28 minutes to read Understanding Cryptic Schemata in Large Extract-transform-load Systems by Alexander Albrecht

Assuming a reading speed of 250 words per minute. Learn more

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.

How long is Understanding Cryptic Schemata in Large Extract-transform-load Systems?

Understanding Cryptic Schemata in Large Extract-transform-load Systems by Alexander Albrecht is 28 pages long, and a total of 7,224 words.

This makes it 9% the length of the average book. It also has 9% more words than the average book.

How Long Does it Take to Read Understanding Cryptic Schemata in Large Extract-transform-load Systems Aloud?

The average oral reading speed is 183 words per minute. This means it takes and 39 minutes to read Understanding Cryptic Schemata in Large Extract-transform-load Systems aloud.

What Reading Level is Understanding Cryptic Schemata in Large Extract-transform-load Systems?

Understanding Cryptic Schemata in Large Extract-transform-load Systems is suitable for students ages 8 and up.

Note that there may be other factors that effect this rating besides length that are not factored in on this page. This may include things like complex language or sensitive topics not suitable for students of certain ages.

When deciding what to show young students always use your best judgement and consult a professional.

Where Can I Buy Understanding Cryptic Schemata in Large Extract-transform-load Systems?

Understanding Cryptic Schemata in Large Extract-transform-load Systems by Alexander Albrecht is sold by several retailers and bookshops. However, Read Time works with Amazon to provide an easier way to purchase books.

To buy Understanding Cryptic Schemata in Large Extract-transform-load Systems by Alexander Albrecht on Amazon click the button below.

Buy Understanding Cryptic Schemata in Large Extract-transform-load Systems on Amazon