DocumentCode
2068465
Title
Design of ETL Aggregation Policy in Local Tax System (LTS)
Author
Liu, Xiaoyun ; Chen, Jianhua ; Zha, Yingchun
Author_Institution
Econ. Sch., Anhui Univ., Hefei, China
fYear
2009
fDate
20-22 Sept. 2009
Firstpage
1
Lastpage
4
Abstract
The design of extract transform loading (ETL) aggregation policy for data warehouse in LTS is introduced in the paper. Firstly, we analyze the characters of data storage in LTS, and according to the subject and logic model analyzed to LTS, estimate the data scale and classify the refresh frequency, then design the ETL aggregation policy, including aggregation tables and the process of aggregation transformation. The paper proposes new and be executed rules for selecting aggregation dimension and presents the process of aggregation calculation and transformation.
Keywords
data models; data warehouses; taxation; ETL aggregation policy; aggregation tables; aggregation transformation; data storage; data warehouse; extract transform loading; local tax system; Data analysis; Data mining; Data models; Data warehouses; Electronic mail; Frequency estimation; Information analysis; Logic design; Memory; Partial response channels;
fLanguage
English
Publisher
ieee
Conference_Titel
Management and Service Science, 2009. MASS '09. International Conference on
Conference_Location
Wuhan
Print_ISBN
978-1-4244-4638-4
Electronic_ISBN
978-1-4244-4639-1
Type
conf
DOI
10.1109/ICMSS.2009.5300877
Filename
5300877
Link To Document