数据仓库及OLAP技术的应用研究
|
摘要
随着信息产业的飞速发展，数据仓库及其相关技术的研究和应用已经成为数据库领域的一大热点。本文在深入探讨了数据仓库、数据集市和OLAP技术的基本概念和开发方法的基础上，建立了辽宁省纺织品进出口公司出口销售数据集市，利用OLAP工具实现了对销售数据的多维查看，并采用MDX、ADOMD和ASP.net技术开发了纺织品出口销售数据查询分析系统，满足了移动办公的需求。
本文共分六章。第一章介绍了数据仓库的发展现状。第二章、第三章、第四章详细阐述了数据仓库、数据集市和OLAP技术的概念及开发、构建方法。第五章说明了纺织品出口销售查询系统的实现过程。第六章对全文做出结论并提出下一步的研究方向。
With the rapid improving of information industry, the research and application of data warehouse and its related technology have become a hotspot in the database field. Based on the discussing of the basic conception and development methods of data warehouse, data market and OLAP, the author built the export sales data market of Liaoning textile import&export company, then realized the multidimensional inquire of sales data by OLAP tools, and developed the textile export sales data inquire/analysis system by MDX, ADOMD and ASP.net, which met the users' requirements.
This thesis consists of six chapters. The first chapter introduces the present developments of data warehouse. The second chapter, the third chapter and the fourth chapter discuss the conception and development methods of data warehouse, data market and OLAP on details. The fifth chapter introduces the developing course of textile export sales inquire system. The last chapter draws a conclusion of this thesis and plans the future researching works.
本文共分六章。第一章介绍了数据仓库的发展现状。第二章、第三章、第四章详细阐述了数据仓库、数据集市和OLAP技术的概念及开发、构建方法。第五章说明了纺织品出口销售查询系统的实现过程。第六章对全文做出结论并提出下一步的研究方向。
With the rapid improving of information industry, the research and application of data warehouse and its related technology have become a hotspot in the database field. Based on the discussing of the basic conception and development methods of data warehouse, data market and OLAP, the author built the export sales data market of Liaoning textile import&export company, then realized the multidimensional inquire of sales data by OLAP tools, and developed the textile export sales data inquire/analysis system by MDX, ADOMD and ASP.net, which met the users' requirements.
This thesis consists of six chapters. The first chapter introduces the present developments of data warehouse. The second chapter, the third chapter and the fourth chapter discuss the conception and development methods of data warehouse, data market and OLAP on details. The fifth chapter introduces the developing course of textile export sales inquire system. The last chapter draws a conclusion of this thesis and plans the future researching works.
引文
1 [美]Tony Bain等著，邵勇译．SQL Server 2000数据仓库与Analysis Services．中国电力出版社，2003．3
2 沈兆阳编著．SQL Server 2000 OLAP解决方案—数据仓库与Analysis Services．清华大学出版社，2001．9
3 [美]Ralph Kimball，Margy Ross著，谭明金译．数据仓库工具箱：维度建模的完全指南(第二版)．电子工业出版社，2003．10
4 夏火松主编．数据仓库与数据挖掘技术．科学出版社，2004．3
5 陈京民等著．数据仓库与数据挖掘技术．电子工业出版社，2002．8
6 [美]Ralph Kimball，Laura Reeves，Margy Ross等著，肖明，王永红等译．数据仓库生命周期工具箱—设计、开发和部署数据仓库的专家方法．电子工业出版社．2004．1
7 [美]W．H．Inmon著，王志海，林友芳等译．数据仓库(原书第三版)．机械工业出版社．2003．3
8 陈京民著．数据仓库原理、设计与应用．中国水利电力出版社．2004．4
9 王珊等著．数据仓库技术与联机分析处理．科学出版社．1998．6
10 [美]Efrem Mallach著，李昭智等译．决策支持与数据仓库系统．电子工业出版社．2001．4
11 林杰斌，刘明德，陈湘著．数据挖掘与OLAP理论与实务．清华大学出版社．2003．1
12 林宏渝著．SQL 2000决策分析—OLAP建置与应用．中国铁道出版社．2001．8
13 陈德军，盛翊智，陈绵云．基于数据仓库的OLAP在DSS中的应用研究．计算机工程与应用，2003．01：30-31
14 高凯，朱金钧．浅谈数据仓库的在线分析方法．计算机工程与应用，2003，12：202-205
15 李静，陆菊康，汤艳艳等．基于数据仓库的销售分析系统的设计与实现．计算机工程，May 2003 Vol．29 No7：173-175
17 林萍，蒋波．关于数据仓库中联机分析处理的几点研究．Computer era，No．1 2002：6-8
18 张艳肖，周大镯．联机分析处理在商业企业应用的探讨．商业研究，2003／09：151-152
19 何玉琳，骆斌，张延成等．一种有效的3OLAP多维视图查询算法．计算机工程与应用，2003．3：101103
20 Weifa Liang,Maria E.Orlowska,Jeffrey X.Yu.Optimizing multiple dimensional queries simultaneously in muldimensional databases. The VLDB Journal(2000)8:319-338
21 J W Buzydlowski,I Y Song,L Hassell.A framework for object-oriented on-line analytic processing[C].In:DOLAP'98 workshop, 1998
22 J Trujillo,M Palomar.An object oriented approach to multidimensional database conceptual modeling (OOMD)[C].In:DOLAP'98 workshop, 1998
23 Luo Bin,Zhao Zhi-hong,Chen Shi-fu.An Information System Construction Method Based on ORDB and Software Component[C],In:ISFST-99,Nanjing,China, 1999-10
24 Department of the Air Force.Software Technology Support Center:Guidelines for Successful Acquisition and Management of Software-Intensive Systems(Version 3.0).2000-05
25 O'Malley C L,Scanlon E.Computer-supported collaborative learning:problem solving and distance education[J].Computers Education, 1999-15:127-136
26 Ayala G, Yano Y.A collaborative learning environment based on intelligent agents[J].Expert Systems with Application, 1998-14:129-137
27 Helen Hsan,Peter Hyland.Using OLAP and multidimensional data for decision making[J].IT professional,2001;3(5):44-50
28 Usama Fayyad,Paul Stolorz.Data mining and KDD:promise and challenges[J].Future Generation Computer Systems, 1999; 13(2):99-115
29 Michael Blaha.Data warehouses and decision support systems Blaha[J].M Computer,2001;34(12):38-39
30 Steven Geffner, Divyakant Agrawal,Amr EL Abbadi.The Dynamic Data Cube. InProceedings of the 7th International Conference on Extending Database. Technology, Konstanz,Germany, March 2000
31 Efrem G.Mallach.Decision Support and data Warehouse Systems.McGraw-Hill Higher Education,January 2000
32 Elaheh Pourabbas,Maurizio Rafanelli.Hierarchies and Relative Operators in the OLAP Environment.SIGMOD Record,2000,Vol.29,No. 1:32-37
33 Thomas,Vetterli,Anca, Vaduva, Staudt.Metadata Standards for Data Warehousing:Open Information Model vs Common Warehouse Metamodel.ACM SIGMOD
Record,2000,Vol.29,No.3:68-75
34 Guozhu Dong,Jianwen Su.Incremental Maintenace of Recursive Views Using Relational Calculus.ACM SIGMOD Record,2000,Vol.29,No. 1:44-51
35 Ashish Gupta, Inderpal S.Mumick,Jun Rao,Kenneth A.Ross.Adapting materialized views after redefinitions:Techniques and a performance Study.Information Systems.2001.1, Vol.26,No.25:45-52
2 沈兆阳编著．SQL Server 2000 OLAP解决方案—数据仓库与Analysis Services．清华大学出版社，2001．9
3 [美]Ralph Kimball，Margy Ross著，谭明金译．数据仓库工具箱：维度建模的完全指南(第二版)．电子工业出版社，2003．10
4 夏火松主编．数据仓库与数据挖掘技术．科学出版社，2004．3
5 陈京民等著．数据仓库与数据挖掘技术．电子工业出版社，2002．8
6 [美]Ralph Kimball，Laura Reeves，Margy Ross等著，肖明，王永红等译．数据仓库生命周期工具箱—设计、开发和部署数据仓库的专家方法．电子工业出版社．2004．1
7 [美]W．H．Inmon著，王志海，林友芳等译．数据仓库(原书第三版)．机械工业出版社．2003．3
8 陈京民著．数据仓库原理、设计与应用．中国水利电力出版社．2004．4
9 王珊等著．数据仓库技术与联机分析处理．科学出版社．1998．6
10 [美]Efrem Mallach著，李昭智等译．决策支持与数据仓库系统．电子工业出版社．2001．4
11 林杰斌，刘明德，陈湘著．数据挖掘与OLAP理论与实务．清华大学出版社．2003．1
12 林宏渝著．SQL 2000决策分析—OLAP建置与应用．中国铁道出版社．2001．8
13 陈德军，盛翊智，陈绵云．基于数据仓库的OLAP在DSS中的应用研究．计算机工程与应用，2003．01：30-31
14 高凯，朱金钧．浅谈数据仓库的在线分析方法．计算机工程与应用，2003，12：202-205
15 李静，陆菊康，汤艳艳等．基于数据仓库的销售分析系统的设计与实现．计算机工程，May 2003 Vol．29 No7：173-175
17 林萍，蒋波．关于数据仓库中联机分析处理的几点研究．Computer era，No．1 2002：6-8
18 张艳肖，周大镯．联机分析处理在商业企业应用的探讨．商业研究，2003／09：151-152
19 何玉琳，骆斌，张延成等．一种有效的3OLAP多维视图查询算法．计算机工程与应用，2003．3：101103
20 Weifa Liang,Maria E.Orlowska,Jeffrey X.Yu.Optimizing multiple dimensional queries simultaneously in muldimensional databases. The VLDB Journal(2000)8:319-338
21 J W Buzydlowski,I Y Song,L Hassell.A framework for object-oriented on-line analytic processing[C].In:DOLAP'98 workshop, 1998
22 J Trujillo,M Palomar.An object oriented approach to multidimensional database conceptual modeling (OOMD)[C].In:DOLAP'98 workshop, 1998
23 Luo Bin,Zhao Zhi-hong,Chen Shi-fu.An Information System Construction Method Based on ORDB and Software Component[C],In:ISFST-99,Nanjing,China, 1999-10
24 Department of the Air Force.Software Technology Support Center:Guidelines for Successful Acquisition and Management of Software-Intensive Systems(Version 3.0).2000-05
25 O'Malley C L,Scanlon E.Computer-supported collaborative learning:problem solving and distance education[J].Computers Education, 1999-15:127-136
26 Ayala G, Yano Y.A collaborative learning environment based on intelligent agents[J].Expert Systems with Application, 1998-14:129-137
27 Helen Hsan,Peter Hyland.Using OLAP and multidimensional data for decision making[J].IT professional,2001;3(5):44-50
28 Usama Fayyad,Paul Stolorz.Data mining and KDD:promise and challenges[J].Future Generation Computer Systems, 1999; 13(2):99-115
29 Michael Blaha.Data warehouses and decision support systems Blaha[J].M Computer,2001;34(12):38-39
30 Steven Geffner, Divyakant Agrawal,Amr EL Abbadi.The Dynamic Data Cube. InProceedings of the 7th International Conference on Extending Database. Technology, Konstanz,Germany, March 2000
31 Efrem G.Mallach.Decision Support and data Warehouse Systems.McGraw-Hill Higher Education,January 2000
32 Elaheh Pourabbas,Maurizio Rafanelli.Hierarchies and Relative Operators in the OLAP Environment.SIGMOD Record,2000,Vol.29,No. 1:32-37
33 Thomas,Vetterli,Anca, Vaduva, Staudt.Metadata Standards for Data Warehousing:Open Information Model vs Common Warehouse Metamodel.ACM SIGMOD
Record,2000,Vol.29,No.3:68-75
34 Guozhu Dong,Jianwen Su.Incremental Maintenace of Recursive Views Using Relational Calculus.ACM SIGMOD Record,2000,Vol.29,No. 1:44-51
35 Ashish Gupta, Inderpal S.Mumick,Jun Rao,Kenneth A.Ross.Adapting materialized views after redefinitions:Techniques and a performance Study.Information Systems.2001.1, Vol.26,No.25:45-52