Data Warehouse Technology In Foreign Trade And Realization

In the last few years, the market economy obtains to quickly develop in the domestic, the economic combination trend turn obvious in world. The local business enterprise will face to add more the vigorous market competes, a business enterprise want that obtain to exist with develop in market obtain competitive advantage must every moment full with confidencely market direction, understanding oneself, understood customer, understood opponent, only attain on time availably respond to market, Enterprise like live and develop in the vigorous market compete.Shanghai Lansheng Group Corporation is the model business enterprise in International trade, International trade is the core business which conforms a number of professional old-line foreign trade companies, such as Shanghai Lansheng Corporation - the first publicly listed foreign trade company. The last years, Lansheng Group implemented sucessly intermational trade ERP system in members' enterprise. but face the huge data that the system of ERP, howing to dig out the data gold from those huge data, how the decision analysis and provide science for our decision, The demand establishes a decision and support flat, that can convert the data of the long-term into useful, dependable information and knowledge.This paper first introduce Lansheng Group Corporation information system circus now. Then to did the introduction with related knowledge in warehouse and ETL technique. Finally the paper detailed analyze the design thought of Lansheng data warehouse, the data warehouse core module an inside topic, erp system in a specific way the ETL data take out takes of realize. Introducing the Lansheng the data warehouse project management.This paper is begin from the foreign trade of large business enterprise that Shanghai Lansheng Group Corporation, detailed design and realizes method for the data warehouse, the lansheng is the first company in ERP system platform, success put from into practice according to the system of ERP several database long range data extract translate load for Chinese outside the profession of trade. Data warehouse technique is in the extensive expansion of the foreign trade realm build firm foundation, promote information technique position and function at lent support to business enterprise strategy target.