發(fā)布時間：2018-03-22 12:28

  本文選題：數(shù)據(jù)倉庫　切入點：維度建模　出處：《首都師范大學》2013年碩士論文　論文類型：學位論文

【摘要】：財務管理作為國內首先實現(xiàn)計算管理的領域,積累了大量數(shù)據(jù),是管理的財富,對這些數(shù)據(jù)的分析有重要的意義。傳統(tǒng)的基于數(shù)據(jù)庫技術的決策支持系統(tǒng)由于其技術弱且缺少統(tǒng)一性,無法處理大量的數(shù)據(jù)且應用復雜,已無法滿足用戶的需要。數(shù)據(jù)倉庫技術和聯(lián)機分析處理(OLAP)技術的出現(xiàn)為大數(shù)據(jù)的處理帶來了希望,也解決了傳統(tǒng)的決策支持系統(tǒng)的問題。 數(shù)據(jù)倉庫技術為決策支持系統(tǒng)的數(shù)據(jù)存儲和管理提供了解決方法,但數(shù)據(jù)的原始記錄一般存儲在不同的數(shù)據(jù)庫和源文件中,這也使得原始數(shù)據(jù)直接導入到數(shù)據(jù)倉庫是不切實際的。因此,首先我們要為數(shù)據(jù)倉庫的構建建立模型,然后在設置的模型的基礎上設計抽取工具,通過數(shù)據(jù)抽取、轉換和加載(ETL)這一過程將源數(shù)據(jù)庫中的數(shù)據(jù)裝載到目標數(shù)據(jù)庫中。ETL是構建數(shù)據(jù)倉庫的重要組成部分。ETL這一過程需要解決如主題的分散、數(shù)據(jù)重復、同一對象的命名方式或表達方式不一致的現(xiàn)象等問題。 隨著計算機技術的快速發(fā)展,數(shù)據(jù)倉庫技術也得以快速發(fā)展以及廣泛的應用。本文基于某機關單位的總賬信息管理系統(tǒng)和非稅信息管理系統(tǒng),詳述了數(shù)據(jù)倉庫的維度建模和ETL工具的設計。 本文采用維度建模作為其建模策略,結合總賬和非稅管理項目,主要探討了維度建模設計問題,其中包括事實表和維度表的設計,通過星型模型來進行維度建模。首先介紹了維度建模的理論基礎,結合具體的項目來進行維度模型的設計。 ETL是構建數(shù)據(jù)倉庫這一過程最重要的設計。首先介紹了ETL的結構及這一過程元數(shù)據(jù)的重要性。然后具體結合總賬抽取工具和報表抽取工具,詳述了基于元數(shù)據(jù)的ETL過程的設計。
[Abstract]:Financial management, as the first field to realize calculation management in China, has accumulated a lot of data and is the wealth of management. The analysis of these data is of great significance. Because of its weak technology and lack of unity, traditional decision support system based on database technology is unable to deal with a large number of data and its application is complex. The emergence of data warehouse technology and on-line analytical processing (OLAP) technology brings hope to big data's processing and solves the problem of traditional decision support system. Data warehouse technology provides a solution for data storage and management in decision support systems, but the original records of data are generally stored in different databases and source files. This also makes it impractical to import raw data directly into the data warehouse. So, first of all, we have to model the construction of the data warehouse, and then we design the extraction tool based on the set model. The process of loading data from the source database into the target database. ETL is an important component of building a data warehouse. Problems such as inconsistent naming or expression of the same object. With the rapid development of computer technology, data warehouse technology has been rapidly developed and widely used. This paper is based on the general ledger information management system and non-tax information management system. The dimension modeling of data warehouse and the design of ETL tool are described in detail. In this paper, dimension modeling is used as its modeling strategy, and combined with general ledger and non-tax management project, dimension modeling design is mainly discussed, including fact table and dimension table design. Firstly, the theoretical basis of dimension modeling is introduced, and the design of dimension model is carried out with specific items. ETL is the most important design in the process of building data warehouse. Firstly, the structure of ETL and the importance of metadata are introduced. Then, the design of ETL process based on metadata is described in detail by combining general ledger extraction tool and report extraction tool.
【學位授予單位】：首都師范大學
【學位級別】：碩士
【學位授予年份】：2013
【分類號】：TP311.13;F233

【參考文獻】

相關期刊論文 前10條

1 陳峰;數(shù)據(jù)倉庫技術綜述[J];重慶工學院學報;2002年02期

2 劉繼永;楊前進;韓新民;金風明;;工程機械出口行業(yè)客戶關系管理數(shù)據(jù)倉庫建模研究[J];成組技術與生產(chǎn)現(xiàn)代化;2012年01期

3 張葉娥;數(shù)據(jù)倉庫建模技術之比較[J];福建電腦;2004年05期

4 白果;賈玉文;;數(shù)據(jù)倉庫中ETL技術的研究與改進[J];甘肅科技;2012年19期

5 張勇;楊昆錦;王文杰;;移動經(jīng)營分析系統(tǒng)中ETL的分析和設計[J];計算機工程與應用;2006年03期

6 徐俊剛;裴瑩;;數(shù)據(jù)ETL研究綜述[J];計算機科學;2011年04期

7 柴巧葉;;企業(yè)管理決策中數(shù)據(jù)倉庫的設計與實現(xiàn)[J];計算機教育;2007年24期

8 侯偉;數(shù)據(jù)倉庫建模技術[J];科技廣場;2005年02期

9 孫浩;楊軼群;;數(shù)據(jù)倉庫元數(shù)據(jù)的集成及管理[J];科技信息;2010年31期

10 吳隆基;采用Oracle數(shù)據(jù)倉庫解決方案構建圖書館數(shù)據(jù)倉庫[J];情報科學;2005年01期

相關博士學位論文 前1條

1 於永和;BOT項目投標決策模型及其應用研究[D];湖南大學;2006年

相關碩士學位論文 前3條

1 曲斌;數(shù)據(jù)挖掘技術在零售業(yè)CRM中的應用研究[D];浙江大學;2004年

2 張肖霞;數(shù)據(jù)倉庫系統(tǒng)中元數(shù)據(jù)的研究與應用[D];中南大學;2005年

3 丁左明;ETL工作流的建模及優(yōu)化[D];上海師范大學;2007年

，

本文編號：1648672