基于数据仓库的外贸业务智能决策系统
|
摘要
随着计算机信息技术和互联网技术的发展，社会各行各业的分工、业务流程、管理流程在发生着重大的改变。而如何运用先进的信息技术构建电子政府，实践电子政务，以电子化、信息化手段提高政府的行政职能、行政管理水平和决策准确性，从而更科学、更有效地为社会、企业和公众服务，已成为我国政府越来越紧迫的一项工作。
本文以中国出口综合评价体系的建立和研究为基础，首先介绍了与此项目相关的技术背景和实施必要基础；然后介绍了基于CTPI的外贸业务分析决策系统的研制开发，给出基于数据仓库的外贸业务分析决策系统的体系结构，并介绍了系统各部分功能；讨论了在电子政务的建设中如何利用数据仓库来实施决策支持系统，详细介绍了本系统在实施决策支持过程中遇到了问题及所采用的相应的技术手段，研究了数据仓库、联机分析处理在对外贸业务分析决策系统中的应用；最后介绍了Web Service技术背景的各个方面，以及该技术在本系统的数据转移和客户端模块中的应用，并分析了Web Service技术在本系统实现过程的利弊。
在结论与展望部分，介绍了在出口综合评价系统实施过程中个人的一些认识和体会：决策支持目前在中国电子政务中应用的较低水平及其原因，论述了如何发展决策支持系统，更好地为中国电子政务服务。
Along with the high development of computer information science and network technology, the function of all kinds of social industry and operation flow and management flow have changed.How do we build electronic government and improve the administration function and decision nicety by using the advanced information technology is a urgent work for our government.
Based on the building and study of the Chinese trade Performance Index . This paper first introduces some related technology backgrounds and basement of implement. Discusses the establishment of the CTPI(Chinese Trade Performance Index),particularly introduce development of the foreign trade Decision-making Support System based on CTPI,displays the architecture of the system based on data warehousing and illuminates the function of the system. it discuss how do we implement the Decision-making Support System by using Data warehouse in the electronic government and deeply introduces the problem and the related technology when build the Decision-making Support System. This paper also studies the role of Data warehouse and OLAP in the in the decision-making system. Finally it introduces that all aspects of the web service technology backgrounds and displays applications of this technology in the data-transformation and client module .then discusses the advantage and disadvantage of the web service technology in this system.
At the the end of this paper,it introduces some personal thinking about building the foreign trade Decision-making Support System based on CTPI that we consider the decision-making support poor level and the reason why do so. then it discuss how to develop the Decision-making Support System for the Chinese electronic government.
本文以中国出口综合评价体系的建立和研究为基础，首先介绍了与此项目相关的技术背景和实施必要基础；然后介绍了基于CTPI的外贸业务分析决策系统的研制开发，给出基于数据仓库的外贸业务分析决策系统的体系结构，并介绍了系统各部分功能；讨论了在电子政务的建设中如何利用数据仓库来实施决策支持系统，详细介绍了本系统在实施决策支持过程中遇到了问题及所采用的相应的技术手段，研究了数据仓库、联机分析处理在对外贸业务分析决策系统中的应用；最后介绍了Web Service技术背景的各个方面，以及该技术在本系统的数据转移和客户端模块中的应用，并分析了Web Service技术在本系统实现过程的利弊。
在结论与展望部分，介绍了在出口综合评价系统实施过程中个人的一些认识和体会：决策支持目前在中国电子政务中应用的较低水平及其原因，论述了如何发展决策支持系统，更好地为中国电子政务服务。
Along with the high development of computer information science and network technology, the function of all kinds of social industry and operation flow and management flow have changed.How do we build electronic government and improve the administration function and decision nicety by using the advanced information technology is a urgent work for our government.
Based on the building and study of the Chinese trade Performance Index . This paper first introduces some related technology backgrounds and basement of implement. Discusses the establishment of the CTPI(Chinese Trade Performance Index),particularly introduce development of the foreign trade Decision-making Support System based on CTPI,displays the architecture of the system based on data warehousing and illuminates the function of the system. it discuss how do we implement the Decision-making Support System by using Data warehouse in the electronic government and deeply introduces the problem and the related technology when build the Decision-making Support System. This paper also studies the role of Data warehouse and OLAP in the in the decision-making system. Finally it introduces that all aspects of the web service technology backgrounds and displays applications of this technology in the data-transformation and client module .then discusses the advantage and disadvantage of the web service technology in this system.
At the the end of this paper,it introduces some personal thinking about building the foreign trade Decision-making Support System based on CTPI that we consider the decision-making support poor level and the reason why do so. then it discuss how to develop the Decision-making Support System for the Chinese electronic government.
引文
1. Data warehousing, data mining, and OLAP / Berson, Alex. McGraw-Hill, TP311.13/993 1997
2. Tom Hammergren. Data Warehousing: Building the Corporate Knowledge Base 曹增强.王备战等译，中国水利水电出版社，1998
3. Mike Gunderloy、Tim Sneath. SQL2000 开发指南 张伟等译 电子工业出版社 TP.4110 2001.11
4. K.Short. Component Based Development and Object Modeling. STERLING SOFTWARE，1997
5. 林宏谕SQL2000 决策分析OLAP 建置与应用 中国铁道出版社 TP311.1323/251 2001
6. 飞思科技产品研发中心 SQL Server 2000 OLAP服务设计与应用 电子工业出版社 TP311.1323/330 2002
7. IBM developerWorks/Web Service Zone http://www-106.ibm.com/developerworks/webservice/
8. Erik Thomsen.GeorgeSpfford Dick Chase SQL Server 2000 OLAP解决方案 箫湘工作室译 人民邮电出版社 TP1695 2000.9
9. Martin Fowler.Kendall Scott UML Distilled:A Brief Guide to the Standard Object Modeling Language 徐家福 译 清华大学出版社 TP.3152 2002
10. Ingeborg Menzler-Hokkanen. Measuring change in intra_industry competitiveness Swedish School of Economics and Business Administration Working Papers1986.11
11. R.W.Brock, R.E.Johnson. A survey of current research in object-oriented design. Communications of the ACM, 1990, 33(9):104(124
12. P.Coad. Object-oriented patterns. Communications of the ACM,1992, 35(9):152(159
13. 沈兆阳 SQL Server 2000 OLAP解决方案 : 数据仓库与Analysis Services 清华大学出版社 TP311.1323/298 2001
14. J.P.Redlich. Distributed object technology for networking. IEEE Communication Magazine,1998 , 26(8):100(111
15. 斯特姆 Microsoft SQL Server 7.0 数据仓库技术指南 机械工业出版社 TP311.1323/279 2000
16. 美国微软公司 Microsoft SQL Server 7.0 数据仓库开发技术 北京大学出版社 TP311.1323/80 2000
17. H.T.Mannila. Discovery of frequent of episodes in event sequences[J]. Data Mining and Knowledge Discovery,1997, 1(3):255(289
18. 北京市外经贸委 出口综合评价体系的指标及其解释 2002.3
19. 康博创作室 SQL Server 2000数据仓库设计和使用指南 清华大学出版社 TP311.1323/296 2001
20. 罗运模 SQL Server 2000数据仓库应用与开发 人民邮电出版社 TP311.1323/265 2001
21. Boggs.W, M.Boggs. Mastering UML with Rational Rose2002. 邱仲潘等译. 电子工业出版社，tp312 2002
22. 科里 SQL Server 7 Data Warehousing 数据仓库 北京希望电子出版社 TP311.1323/127 2000
23. K.Short. Component Based Development and Object Modeling. STERLING SOFTWARE，1997
24. Robert D. Atkinson, Randolph H. Court, and Joseph M. Ward The Us new economy index Progressive Policy Institute Technology & New Economy Project July 1999
25. ITC market Analysis section The Trade Performance Index 2002.4
26. UDDI_Technical_White_Paper http://www.uddi.org
27. 冷鹏 电子政务的决策支持系统 Http://www.Dwway.Com
28. Robert Tabor .NET XML Web服务 徐继伟、英宇等译 机械工业出版社 TP.2410 2002.5
29. Simon Roinson Ollie Cornes. Professional c# 康博译 清华大学出版社 TP.2980 2002.1
30. 飞思科技产品研发中心 Java Web服务应用开发详解 电子工业出版社 TP.4250 2002
31. Mike Jasnowski.Java,XML和Web Service Bible 盖江南 王勇 等译 电子工业出版社 TP.4401 2002
32. MSDN Online Web Services Developer Resources http://msdn.microsoft.com/webservices/
33. 周存杰 Visual C#.Net网络核心编程 清华大学出版社 TP。3498 2002
34. 柴晓路 梁宇奇 Web Services技术、架构和应用 电子工业出版社 TP.4812 2003
35. Joachim Hammer 、Hector Garcia Molina 、Jennifer Widom 、Wilburt Labio Yue Zhuge The Stanford Data Warehousing Project Data Engineering 1995
36. Ralph Kimball Is Your Dimensional Data Warehouse Expressive? Http://www.Dwway.Com
37. 中国UDDI技术联盟 http://www.uddi-china.org
38. Web-Service-Architecture http://www.webservices.org
39. 朱乐骏，李明禄，盛焕烨 基于Web Service技术的商业智能决策系统模型 2002'全国软件与应用学术会议（NASAC）论文集机械工业出版社 TP.2661 2002
40. 飞思科技产品研发中心 精通.NET核心技术-高级特性 电子工业出版社 TP.4476 2002
2. Tom Hammergren. Data Warehousing: Building the Corporate Knowledge Base 曹增强.王备战等译，中国水利水电出版社，1998
3. Mike Gunderloy、Tim Sneath. SQL2000 开发指南 张伟等译 电子工业出版社 TP.4110 2001.11
4. K.Short. Component Based Development and Object Modeling. STERLING SOFTWARE，1997
5. 林宏谕SQL2000 决策分析OLAP 建置与应用 中国铁道出版社 TP311.1323/251 2001
6. 飞思科技产品研发中心 SQL Server 2000 OLAP服务设计与应用 电子工业出版社 TP311.1323/330 2002
7. IBM developerWorks/Web Service Zone http://www-106.ibm.com/developerworks/webservice/
8. Erik Thomsen.GeorgeSpfford Dick Chase SQL Server 2000 OLAP解决方案 箫湘工作室译 人民邮电出版社 TP1695 2000.9
9. Martin Fowler.Kendall Scott UML Distilled:A Brief Guide to the Standard Object Modeling Language 徐家福 译 清华大学出版社 TP.3152 2002
10. Ingeborg Menzler-Hokkanen. Measuring change in intra_industry competitiveness Swedish School of Economics and Business Administration Working Papers1986.11
11. R.W.Brock, R.E.Johnson. A survey of current research in object-oriented design. Communications of the ACM, 1990, 33(9):104(124
12. P.Coad. Object-oriented patterns. Communications of the ACM,1992, 35(9):152(159
13. 沈兆阳 SQL Server 2000 OLAP解决方案 : 数据仓库与Analysis Services 清华大学出版社 TP311.1323/298 2001
14. J.P.Redlich. Distributed object technology for networking. IEEE Communication Magazine,1998 , 26(8):100(111
15. 斯特姆 Microsoft SQL Server 7.0 数据仓库技术指南 机械工业出版社 TP311.1323/279 2000
16. 美国微软公司 Microsoft SQL Server 7.0 数据仓库开发技术 北京大学出版社 TP311.1323/80 2000
17. H.T.Mannila. Discovery of frequent of episodes in event sequences[J]. Data Mining and Knowledge Discovery,1997, 1(3):255(289
18. 北京市外经贸委 出口综合评价体系的指标及其解释 2002.3
19. 康博创作室 SQL Server 2000数据仓库设计和使用指南 清华大学出版社 TP311.1323/296 2001
20. 罗运模 SQL Server 2000数据仓库应用与开发 人民邮电出版社 TP311.1323/265 2001
21. Boggs.W, M.Boggs. Mastering UML with Rational Rose2002. 邱仲潘等译. 电子工业出版社，tp312 2002
22. 科里 SQL Server 7 Data Warehousing 数据仓库 北京希望电子出版社 TP311.1323/127 2000
23. K.Short. Component Based Development and Object Modeling. STERLING SOFTWARE，1997
24. Robert D. Atkinson, Randolph H. Court, and Joseph M. Ward The Us new economy index Progressive Policy Institute Technology & New Economy Project July 1999
25. ITC market Analysis section The Trade Performance Index 2002.4
26. UDDI_Technical_White_Paper http://www.uddi.org
27. 冷鹏 电子政务的决策支持系统 Http://www.Dwway.Com
28. Robert Tabor .NET XML Web服务 徐继伟、英宇等译 机械工业出版社 TP.2410 2002.5
29. Simon Roinson Ollie Cornes. Professional c# 康博译 清华大学出版社 TP.2980 2002.1
30. 飞思科技产品研发中心 Java Web服务应用开发详解 电子工业出版社 TP.4250 2002
31. Mike Jasnowski.Java,XML和Web Service Bible 盖江南 王勇 等译 电子工业出版社 TP.4401 2002
32. MSDN Online Web Services Developer Resources http://msdn.microsoft.com/webservices/
33. 周存杰 Visual C#.Net网络核心编程 清华大学出版社 TP。3498 2002
34. 柴晓路 梁宇奇 Web Services技术、架构和应用 电子工业出版社 TP.4812 2003
35. Joachim Hammer 、Hector Garcia Molina 、Jennifer Widom 、Wilburt Labio Yue Zhuge The Stanford Data Warehousing Project Data Engineering 1995
36. Ralph Kimball Is Your Dimensional Data Warehouse Expressive? Http://www.Dwway.Com
37. 中国UDDI技术联盟 http://www.uddi-china.org
38. Web-Service-Architecture http://www.webservices.org
39. 朱乐骏，李明禄，盛焕烨 基于Web Service技术的商业智能决策系统模型 2002'全国软件与应用学术会议（NASAC）论文集机械工业出版社 TP.2661 2002
40. 飞思科技产品研发中心 精通.NET核心技术-高级特性 电子工业出版社 TP.4476 2002