Design and Implementation of a Data Warehouse ETL Tray Program

Zhi Gang Yang; Li Sun; Xiao Yang Yu

doi:10.4028/www.scientific.net/AMM.385-386.1684

Paper Titles

Research on the Method of Text Information Hiding Based on XML
p.1665

Research on Entity Resolution Algorithm Based on Domain Ontology Using MapReduce
p.1669

An Improved Estimation of Distribution Algorithm Based on the Entropy Increment Theorem
p.1675

Web Service QoS Matching Research Based on Ontology
p.1679

Design and Implementation of a Data Warehouse ETL Tray Program
p.1684

Reachability Analysis of Perception Layer Scheduling for IoT
p.1689

Research on Customizable Modeling Workflow Engine in Information System
p.1693

A Novel Learning Evaluation Method Based on RBF Neural Network
p.1697

CMM Based Requirement Engineering Model in Software Development
p.1701

HomeApplied Mechanics and MaterialsApplied Mechanics and Materials Vols. 385-386Design and Implementation of a Data Warehouse ETL...

Design and Implementation of a Data Warehouse ETL Tray Program

Abstract:

This paper presents an ETL system for a data warehouse designed for a PVC profile manufacturing enterprise. The system implements the data extraction, data transformation and load from the data sources of ERP system, CRM system and production line operation data collection system. The ETL requirements are discussed. The system design and implementation methods, including system structure, functions, data processing methods as well as tray program implementation are addressed.

You might also be interested in these eBooks

Applied Scientific Research and Engineering Developments for Industry

View Preview

Info:

Periodical:

Applied Mechanics and Materials (Volumes 385-386)

Pages:

1684-1688

DOI:

https://doi.org/10.4028/www.scientific.net/AMM.385-386.1684

Citation:

Cite this paper

Online since:

August 2013

Authors:

Zhi Gang Yang, Li Sun, Xiao Yang Yu

Keywords:

Data Warehouse, ETL, Tray Program

Export:

RIS, BibTeX

Price:

Permissions CCC:

Request Permissions

Permissions PLS:

Request Permissions

Сopyright:

Citation:

References

[1] Lin Jiqanguang, Wu Yijie: The Research of Decision Support System in Commercial Marketing Based on Data Warehouse (In Chinese), Computer Applications and Software, Vol. 22, pp.39-40, (2004).

Google Scholar

[2] Jeffrey L. Whitten, Lonnie D. Bentley, Kevin C. Dittman, in: System Analysis and Design Methods, 5th Edition. Higher Education Press/McGraw-Hill Companies, Beijing(2001), pp.437-443.

Google Scholar

[3] Kevin Loney, George Koch and the Experts at TUSC, in: Oracle 9i Complete Reference, McGraw-Hill/Osborne, Berkeley (2002), pp.777-778.

Google Scholar

[4] Kevin Loney, George Koch and the Experts at TUSC, in: Oracle 9i Complete Reference, McGraw-Hill/Osborne, Berkeley (2002), pp.294-296.

Google Scholar

[5] Jiawei Han, Micheline Kambr. In: Data Mining: Concepts and Techniques, Higher Education Press/Morgan Kaufmann Publishers, Beijing(2001), pp.105-140.

Google Scholar