An ETL Framework Based on Data Reorganization for the Chinese Style Cross-Tab

Shu Dong Zhang; Qiu Hui Zhang; Jing Bing Yang

doi:10.4028/www.scientific.net/AMR.267.377

Paper Titles

Application of UKF Algorithm in Airborne Single Observer Passive Location
p.356

Study on the Virtual Signal Production Based on the PCI
p.363

Improved Subdivision Based Halftoning Algorithm
p.368

Dynamic Modeling and Simulation on Ordering Strategy of Five-Stage Supply Chain
p.372

An ETL Framework Based on Data Reorganization for the Chinese Style Cross-Tab
p.377

Slip Pridiction Based Path Planning for Planetary Rovers
p.382

A Document Feature Extraction Method Based on Concept-Word List
p.386

An Overview of P2P Search Algorithms
p.393

Application and Research of Data Acquisition Based on Database Technology of LabVIEW
p.398

HomeAdvanced Materials ResearchAdvanced Materials Research Vol. 267An ETL Framework Based on Data Reorganization for...

An ETL Framework Based on Data Reorganization for the Chinese Style Cross-Tab

Abstract:

This paper proposes a framework for the extract-transform-load (ETL) of the Chinese style cross-tab. It makes a reverse engineering process for the Chinese style report. That is to say, converting the report to its original scheme of relational database table, and then making an ETL processing on the two-dimensional table. And ultimately load the data into the fact tables. Finally, we discuss implementation issues and we present the design and experiment of the system based on our framework.

You might also be interested in these eBooks

Manufacturing Systems and Industry Application

View Preview

Info:

Periodical:

Advanced Materials Research (Volume 267)

Pages:

377-381

DOI:

https://doi.org/10.4028/www.scientific.net/AMR.267.377

Citation:

Cite this paper

Online since:

June 2011

Authors:

Shu Dong Zhang, Qiu Hui Zhang, Jing Bing Yang

Keywords:

Atomic Data, Chinese Style Cross-Tab, Data Warehouse (DW), Reorganization

Export:

RIS, BibTeX

Price:

Permissions CCC:

Request Permissions

Permissions PLS:

Request Permissions

Сopyright:

Citation:

References

[1] Jiawei Han, Micheline Kamber: Data Mining: Concepts and Techniques. Morgan Kaufmann (2001).

Google Scholar

[2] W.H. Inmon: Building the Data Warehouse, John Wiley and Sons, (2002).

Google Scholar

[3] Guangting Liu, Hong He: Analysis and Design of Data Gathering for Crosstab, Modern Computer. Vol. 12 (2007), pp.139-140.

Google Scholar

[4] Hongyan Liu, Jun He: The Design and Implementation of Database Application System about Chinese Style, Management Information System. Vol. 12 (1997), pp.25-29.

Google Scholar

[5] Guangting Liu, Hong He, Wanming Cai, and Zhengdong Yang: The research of Input method for common sheet, Networks and Information. Vol. 11 (2007), p.73.

Google Scholar