Refine
Has Fulltext
- yes (9)
Year of publication
- 2012 (9) (remove)
Document Type
- Monograph/Edited Volume (9) (remove)
Language
- English (9) (remove)
Is part of the Bibliography
- yes (9)
Keywords
- AUTOSAR (2)
- Data Integration (2)
- Datenintegration (2)
- Model Synchronisation (2)
- Model Transformation (2)
- SysML (2)
- Tripel-Graph-Grammatik (2)
- Aspect-oriented Programming (1)
- Association Rule Mining (1)
- Assoziationsregeln (1)
- Bedingte Inklusionsabhängigkeiten (1)
- Conditional Inclusion Dependency (1)
- Context-oriented Programming (1)
- Cyber-Physical-Systeme (1)
- Cyber-physical-systems (1)
- Data Dependency (1)
- Data Quality (1)
- Data Warehouse (1)
- Datenabhängigkeiten (1)
- Datenqualität (1)
- Duplicate Detection (1)
- Duplikaterkennung (1)
- Echtzeitsysteme (1)
- Erkennen von Meta-Daten (1)
- Extract-Transform-Load (ETL) (1)
- Formale Verifikation (1)
- Information Systems (1)
- Informationssysteme (1)
- JCop (1)
- Java (1)
- Link Discovery (1)
- Link-Entdeckung (1)
- Linked Open Data (1)
- Mehrkernsysteme (1)
- Metadata Discovery (1)
- Model Synchronization (1)
- Modellierung (1)
- Programming Languages (1)
- Prozessoren (1)
- Quantitative Analysen (1)
- Service-orientierte Systme (1)
- Triple Graph Grammar (1)
- Verbindungsnetzwerke (1)
- Verifikation (1)
- Virtualisierung (1)
- beschreibende Feldstudie (1)
- formal verification methods (1)
- hybrid graph-transformation-systems (1)
- hybride Graph-Transformations-Systeme (1)
- interconnect (1)
- many-core (1)
- modeling (1)
- modellgetriebene Entwicklung (1)
- multi-core (1)
- parallel computing (1)
- paralleles Rechnen (1)
- processor hardware (1)
- quantitative analysis (1)
- real-time systems (1)
- runtime adaptations (1)
- service-oriented systems (1)
- verification (1)
- virtualization (1)
Institute
- Hasso-Plattner-Institut für Digital Engineering gGmbH (9) (remove)
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.