仓储物流数据仓库的设计与实现

发布时间：2018-02-04 02:01

本文关键词： 仓储物流数据仓库 Kettle ETL　出处：《东华大学》2017年硕士论文　论文类型：学位论文

【摘要】：仓储物流是货物生产销售的重要环节。随着贸易自由化和电子商务的兴起,物流企业快速发展,为提高仓库管理效率,发掘更多的仓库供应商客户,合理配置资源并降低经营成本,经营者在制定经营决策时需要分析仓储物流过程的整个环节的数据,然而在业务系统中的数据是按照业务过程进行组织的,处于孤立分散的状态并不适用于数据的统计和分析。在仓储物流系统上建立数据仓库,按照用于决策分析的主题对不同系统中数据进行重新组织,为数据分析和数据挖掘提供有效的数据来源。本文根据某市物流业实际运营过程中对仓储物流数据分析的业务需求设计数据仓库。在明确数据仓库的主题领域的基础上设计数据仓库的概念模型,并使用星型架构设计逻辑模型,根据不同的逻辑模型进行粒度分析和缓慢变更维的设计,最后设计索引和数据仓库中的物理表完成数据仓库的建立。设计ETL过程首先分析不同的数据源并设计数据采集的过程。从不同的数据源中抽取数据到数据仓库中,在抽取过程中根据维度表的特点设计不同的增量抽取过程提高抽取效率。在缓冲数据域表中对数据进行清洗和表合并过程中的字段转换最后完成事实表和维度表的加载过程。在文章的最后对数据仓库的应用进行介绍。本论文设计和实现的数据仓库已在仓储物流运营中开始使用,为仓储物流的决策分析提供各种统计数据,实现资源的合理配置和仓库货物的有效管理,大大地降低企业的经营成本。
[Abstract]:Warehousing logistics is an important link of goods production and sales. With the development of trade liberalization and e-commerce, logistics enterprises develop rapidly, in order to improve the efficiency of warehouse management, to explore more warehouse supplier customers. Reasonable allocation of resources and reduce operating costs, operators in making business decisions need to analyze the whole link of the warehousing logistics process data, but the data in the business system is organized according to the business process. The isolated and decentralized state is not suitable for the statistics and analysis of the data. The data warehouse is established on the warehouse logistics system, and the data in different systems are reorganized according to the topic used for decision analysis. To provide effective data sources for data analysis and data mining. This paper designs a data warehouse according to the business requirements of warehouse logistics data analysis during the actual operation of logistics industry in a certain city. The conceptual model of data warehouse is designed based on this. And using star architecture design logic model, according to different logical models for granularity analysis and slowly changing dimension design. Finally, the index and the physical tables in the data warehouse are designed to complete the establishment of the data warehouse. The ETL process is designed to analyze different data sources and design the process of data collection. Data are extracted from different data sources to the data warehouse. In the library. In the extraction process, different incremental extraction processes are designed according to the characteristics of dimension tables to improve the extraction efficiency. In the buffer data domain tables, the data are cleaned and the field conversion in the process of table merging is completed finally, the fact table and the dimension table are completed. At the end of the article, the application of data warehouse is introduced. The data warehouse designed and implemented in this paper has been used in warehouse logistics operation. This paper provides all kinds of statistical data for the decision analysis of warehouse logistics, realizes the rational allocation of resources and the effective management of warehouse goods, and greatly reduces the operating cost of enterprises.
【学位授予单位】：东华大学
【学位级别】：硕士
【学位授予年份】：2017
【分类号】：TP311.13

【参考文献】