loading
Papers Papers/2020

Research.Publish.Connect.

Paper

Paper Unlock

Authors: Christian Lettner and Michael Zwick

Affiliation: Software Competence Center Hagenberg GmbH, Austria

ISBN: 978-989-758-027-7

ISSN: 2184-4992

Keyword(s): Data Analysis, Generic Data Models, Extract Transform Load, Data Warehouse.

Related Ontology Subjects/Areas/Topics: Coupling and Integrating Heterogeneous Data Sources ; Data Warehouses and OLAP ; Databases and Information Systems Integration ; Enterprise Information Systems ; Legacy Systems

Abstract: Industrial manufacturing companies produce a variety of different products, which, despite their differences in function and application area, share common requirements regarding quality assurance and data analysis. The goal of the approach presented in this paper is to automatically generate Extract-Transform-Load (ETL) packages for semi-generic operational database schema. This process is guided by a descriptor table, which allows for identifying and filtering the required attributes and their values. Based on this description model, an ETL process is generated which first loads the data into an entity-attribute-value (EAV) model, then gets transformed into a pivoted model for analysis. The resulting analysis model can be used with standard business intelligence tools. The descriptor table used in the implementation can be substituted with any other non-relational description language, as long as it has the same descriptive capabilities.

CC BY-NC-ND 4.0

Sign In Guest: Register as new SciTePress user now for free.

Sign In SciTePress user: please login.

PDF ImageMy Papers

You are not signed in, therefore limits apply to your IP address 34.237.124.210

In the current month:
Recent papers: 100 available of 100 total
2+ years older papers: 200 available of 200 total

Paper citation in several formats:
Lettner, C. and Zwick, M. (2014). A Data Analysis Framework for High-variety Product Lines in the Industrial Manufacturing Domain.In Proceedings of the 16th International Conference on Enterprise Information Systems - Volume 3: ICEIS, ISBN 978-989-758-027-7, ISSN 2184-4992, pages 209-216. DOI: 10.5220/0004887802090216

@conference{iceis14,
author={Christian Lettner. and Michael Zwick.},
title={A Data Analysis Framework for High-variety Product Lines in the Industrial Manufacturing Domain},
booktitle={Proceedings of the 16th International Conference on Enterprise Information Systems - Volume 3: ICEIS,},
year={2014},
pages={209-216},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0004887802090216},
isbn={978-989-758-027-7},
}

TY - CONF

JO - Proceedings of the 16th International Conference on Enterprise Information Systems - Volume 3: ICEIS,
TI - A Data Analysis Framework for High-variety Product Lines in the Industrial Manufacturing Domain
SN - 978-989-758-027-7
AU - Lettner, C.
AU - Zwick, M.
PY - 2014
SP - 209
EP - 216
DO - 10.5220/0004887802090216

Login or register to post comments.

Comments on this Paper: Be the first to review this paper.