The Application of Data Warehouse in Enterprise Resource Planning

Abstract:

Article Preview

Through building a data warehouse which is used to support manufacturing inventory analysis, according to the analysis theme, this paper extracted, purified and integrated the historical data which is accumulated by the enterprise in a long term and distributed in the various heterogeneous systems, and store them in the data warehouse fact table; through the establishment of the data cube, it generate the aggregated data with different particle size, as well as provide on-line analytical processing technology (OLAP), to provide users data query analysis with multi-angle, multi-granularity, visualization, which can solve many problems difficult to solve in the inventory analysis in traditional enterprise information processing systems.

Info:

Periodical:

Advanced Materials Research (Volumes 179-180)

Edited by:

Garry Zhu

Pages:

973-977

DOI:

10.4028/www.scientific.net/AMR.179-180.973

Citation:

P. Yang and Z. J. Zeng, "The Application of Data Warehouse in Enterprise Resource Planning", Advanced Materials Research, Vols. 179-180, pp. 973-977, 2011

Online since:

January 2011

Export:

Price:

$35.00

In order to see related information, you need to Login.

In order to see related information, you need to Login.