| Warehousing and logistics is an important link in the goods production and marketing.In order to improve the efficiency of warehouse management,find more goods suppliers,allocate resources rationally and reduce operating costs,operators need to analyze data of the whole process of warehousing and logistics process in making business decisions,but data in the business system which is organized according to the business process is not suitable for data statistics and analysis,data of different system is in the isolated state.In order to integrate business data in the WMS system,the logistics enterprise establish data warehouse for decision analysis in accordance with the theme to reorganize the data in different systems to provide effective data source for data analysis and data mining.In this paper data warehouse is designed according to the business needs of the logistics data analysis in the actual operation of a city logistics industry.Based on a clear theme of data warehouse to design concept model and based on the star scheme to design logic model.Granularity analysis and slow change dimension is completed according to the different logical model,establishing the data warehouse through physical table and index designing.Using kettle tools to complete the ETL process which extract transform and load data into the data warehouse.In the process of extraction,the change data capture mechanism is designed according to the characteristics of the dimension table.The data is cleaned and the field conversion is completed in the staging area.At the end of this paper,the application of data warehouse is introduced.At present warehousing and logistics data warehouse designed and implemented in this paper began to use in warehouse operation process,providing statistical data for decision analysis.It helps logistics enterprise achieve reasonable allocation of resources,efficient management of warehouse goods and reduce operating costs greatly. |
PDF Full Text Request