本文關(guān)鍵詞： 倉(cāng)儲(chǔ)物流 數(shù)據(jù)倉(cāng)庫(kù) Kettle ETL　出處：《東華大學(xué)》2017年碩士論文　論文類(lèi)型：學(xué)位論文

【摘要】：倉(cāng)儲(chǔ)物流是貨物生產(chǎn)銷(xiāo)售的重要環(huán)節(jié)。隨著貿(mào)易自由化和電子商務(wù)的興起,物流企業(yè)快速發(fā)展,為提高倉(cāng)庫(kù)管理效率,發(fā)掘更多的倉(cāng)庫(kù)供應(yīng)商客戶(hù),合理配置資源并降低經(jīng)營(yíng)成本,經(jīng)營(yíng)者在制定經(jīng)營(yíng)決策時(shí)需要分析倉(cāng)儲(chǔ)物流過(guò)程的整個(gè)環(huán)節(jié)的數(shù)據(jù),然而在業(yè)務(wù)系統(tǒng)中的數(shù)據(jù)是按照業(yè)務(wù)過(guò)程進(jìn)行組織的,處于孤立分散的狀態(tài)并不適用于數(shù)據(jù)的統(tǒng)計(jì)和分析。在倉(cāng)儲(chǔ)物流系統(tǒng)上建立數(shù)據(jù)倉(cāng)庫(kù),按照用于決策分析的主題對(duì)不同系統(tǒng)中數(shù)據(jù)進(jìn)行重新組織,為數(shù)據(jù)分析和數(shù)據(jù)挖掘提供有效的數(shù)據(jù)來(lái)源。本文根據(jù)某市物流業(yè)實(shí)際運(yùn)營(yíng)過(guò)程中對(duì)倉(cāng)儲(chǔ)物流數(shù)據(jù)分析的業(yè)務(wù)需求設(shè)計(jì)數(shù)據(jù)倉(cāng)庫(kù)。在明確數(shù)據(jù)倉(cāng)庫(kù)的主題領(lǐng)域的基礎(chǔ)上設(shè)計(jì)數(shù)據(jù)倉(cāng)庫(kù)的概念模型,并使用星型架構(gòu)設(shè)計(jì)邏輯模型,根據(jù)不同的邏輯模型進(jìn)行粒度分析和緩慢變更維的設(shè)計(jì),最后設(shè)計(jì)索引和數(shù)據(jù)倉(cāng)庫(kù)中的物理表完成數(shù)據(jù)倉(cāng)庫(kù)的建立。設(shè)計(jì)ETL過(guò)程首先分析不同的數(shù)據(jù)源并設(shè)計(jì)數(shù)據(jù)采集的過(guò)程。從不同的數(shù)據(jù)源中抽取數(shù)據(jù)到數(shù)據(jù)倉(cāng)庫(kù)中,在抽取過(guò)程中根據(jù)維度表的特點(diǎn)設(shè)計(jì)不同的增量抽取過(guò)程提高抽取效率。在緩沖數(shù)據(jù)域表中對(duì)數(shù)據(jù)進(jìn)行清洗和表合并過(guò)程中的字段轉(zhuǎn)換最后完成事實(shí)表和維度表的加載過(guò)程。在文章的最后對(duì)數(shù)據(jù)倉(cāng)庫(kù)的應(yīng)用進(jìn)行介紹。本論文設(shè)計(jì)和實(shí)現(xiàn)的數(shù)據(jù)倉(cāng)庫(kù)已在倉(cāng)儲(chǔ)物流運(yùn)營(yíng)中開(kāi)始使用,為倉(cāng)儲(chǔ)物流的決策分析提供各種統(tǒng)計(jì)數(shù)據(jù),實(shí)現(xiàn)資源的合理配置和倉(cāng)庫(kù)貨物的有效管理,大大地降低企業(yè)的經(jīng)營(yíng)成本。
[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.
【學(xué)位授予單位】：東華大學(xué)
【學(xué)位級(jí)別】：碩士
【學(xué)位授予年份】：2017
【分類(lèi)號(hào)】：TP311.13

【參考文獻(xiàn)】

相關(guān)期刊論文 前7條

1 紀(jì)永軍;黃亞飛;;現(xiàn)代物流從信息化走向知識(shí)管理[J];經(jīng)營(yíng)管理者;2012年06期

2 王光輝;李慶全;盧慶齡;;論物流行業(yè)的服務(wù)創(chuàng)新[J];中國(guó)物流與采購(gòu);2009年04期

3 王海燕;;南京現(xiàn)代物流業(yè)信息化建設(shè)研究[J];科技與經(jīng)濟(jì);2008年05期

4 馮運(yùn)仿;余志毅;趙青;;商業(yè)智能在物流企業(yè)中的應(yīng)用[J];商場(chǎng)現(xiàn)代化;2008年15期

5 張軍;;異構(gòu)數(shù)據(jù)源之間的數(shù)據(jù)轉(zhuǎn)換方法[J];計(jì)算機(jī)應(yīng)用;2005年S1期

6 尤玉林,張憲民;一種可靠的數(shù)據(jù)倉(cāng)庫(kù)中ETL策略與架構(gòu)設(shè)計(jì)[J];計(jì)算機(jī)工程與應(yīng)用;2005年10期

7 陳明,吳國(guó)文,施伯樂(lè);數(shù)據(jù)倉(cāng)庫(kù)概念模型的設(shè)計(jì)[J];小型微型計(jì)算機(jī)系統(tǒng);2002年12期

相關(guān)碩士學(xué)位論文 前3條

1 魏巍;菏澤郵政物流商品庫(kù)存決策支持系統(tǒng)的設(shè)計(jì)與實(shí)現(xiàn)[D];北京郵電大學(xué);2010年

2 劉耀宗;基于數(shù)據(jù)倉(cāng)庫(kù)的物流信息系統(tǒng)[D];南京理工大學(xué);2004年

3 齊紅胤;物流企業(yè)數(shù)據(jù)倉(cāng)庫(kù)的設(shè)計(jì)與實(shí)現(xiàn)[D];清華大學(xué);2004年

，

本文編號(hào)：1488990