基于Internet的数据仓库解决方案的研究
摘要
近十几年来，很多基于各种关系型数据库的企业管理系统，已经在企业用户中得到了广泛的应用。这些系统为企业的决策提供了大量的数据。如何有效的利用这些数据，为企业的经营决策提供依据成为急需解决的问题。数据仓库技术就是在这种背景下提出，目标是在大量数据的基础上进行及时、准确、智能化的分析、决策支持的解决方案。数据仓库技术中融合了OLAP和数据挖掘技术。关于数据仓库与数据挖掘方面的研究国内外有相当多的理论成果与论文,但是能够成功地把这些成果应用到实际的系统中不多,随着网络的迅速发展,现在更多的系统是基于INTERNET下的B/S系统,因为B/S系统有很多相对C/S系统的优势所在,而基于B/S系统能够成功应用数据仓库与数据挖掘技术的案例就更少了。如何在基于INTERNET系统中数据仓库的解决方案的研究,也就更具有现实意义了。
本课题完全基于实践工程与理论探索的基础,在整个研究方法上我们采用实际项目为工程实践背景,数据仓库研究成果为理论指导。在其中寻求良好的结合点,最终形成可行的应用于实际的解决方案。
该课题研究的目标是探索出一条比较实用而且可行的解决方案,成功的实现基于B/S模式的数据仓库及OLAP系统，实现呈现端与数据仓库的动态连接，并实现针对元数据的管理。
In recently ten years, many enterprises management systems based on various kinds of relationship database have been widely used in enterprises. These systems supply large quantities data for the decision of enterprises. It is urgent solution to use these data effectively providing basis for management decision. Data warehouse is posed under this background and aims at providing prompt, exact and intellectual analysis and decision support solution on the basis of large quantities data. Data warehouse is the combination of OLAP and Data Mining. There are some theoretical achievements and papers about Data warehouse and Data Mining at home and abroad, but only a few can be successfully used in realistic system. With the rapid development of Internet, now more and more systems are based on B/C system of Internet. Compared with C/S system, B/C system has more advantage. But there are only a few cases successfully used Data warehouse and Data Mining based on B/S. It becomes more realistic to research Data warehouse solution based on Internet system.
This project entirely based on the foundation engineering and theoretical exploring. In the whole researching methods, we used realistic program as the background of practical engineer and the researching achievement of data base as theoretical direction to seek for the better combination and eventually formed realistic solution for using.
This project aims at exploring practicable solution and successfully implementing Data warehouse and OLAP on the basis of B/S system, meanwhile it implements dynamic connection between UI and DW and manage metadata.
本课题完全基于实践工程与理论探索的基础,在整个研究方法上我们采用实际项目为工程实践背景,数据仓库研究成果为理论指导。在其中寻求良好的结合点,最终形成可行的应用于实际的解决方案。
该课题研究的目标是探索出一条比较实用而且可行的解决方案,成功的实现基于B/S模式的数据仓库及OLAP系统，实现呈现端与数据仓库的动态连接，并实现针对元数据的管理。
In recently ten years, many enterprises management systems based on various kinds of relationship database have been widely used in enterprises. These systems supply large quantities data for the decision of enterprises. It is urgent solution to use these data effectively providing basis for management decision. Data warehouse is posed under this background and aims at providing prompt, exact and intellectual analysis and decision support solution on the basis of large quantities data. Data warehouse is the combination of OLAP and Data Mining. There are some theoretical achievements and papers about Data warehouse and Data Mining at home and abroad, but only a few can be successfully used in realistic system. With the rapid development of Internet, now more and more systems are based on B/C system of Internet. Compared with C/S system, B/C system has more advantage. But there are only a few cases successfully used Data warehouse and Data Mining based on B/S. It becomes more realistic to research Data warehouse solution based on Internet system.
This project entirely based on the foundation engineering and theoretical exploring. In the whole researching methods, we used realistic program as the background of practical engineer and the researching achievement of data base as theoretical direction to seek for the better combination and eventually formed realistic solution for using.
This project aims at exploring practicable solution and successfully implementing Data warehouse and OLAP on the basis of B/S system, meanwhile it implements dynamic connection between UI and DW and manage metadata.
引文
[1]Mark Sweiger，Mark R.Madsen JimmyLangstan,Howard Lombard,Clickstream Data Warehousing,电子工业出版社，2004.1
[2]Tom Soukup,Lan Davjdson,Visual DataMining Techniques and Tools for Data Visualizaion and Mining, 电子工业出版社，2004
[3]Ralph Kimball,Margy Ross,The Data Warehouse Toolkit the Complete Guide to Dimemsional Modling, 电子工业出版社，2003.1
[4]Tony Bain,SQL Server2000 数据仓库与 Analysis Services,中国电力出版社，2003.3
[5] 林宇，数据仓库原理与实践，人民邮电出版社，2003.1
[6]章立民，用实例学ASP.NET—使用C#与ADO.NET,华中科技大学出版社，2003
[7]Microsoft Corporation, Microsoft SQL Server 2000 Analysis Services, Microsoft Press,2001
[8] Microsoft Corporation, Microsoft SQL Server 2000 安装与使用指南, Microsoft Press,2001
[9]www.csdn.net
[10] http://www.ourfly.com/forum/List.aspx?fbId=12&Page=2
[11] http://www.billinmon.com/
[12] http://www.datawarehouse.com
[13]http://www.dmgroup.org.cn/
[14]http://www.dmreview.com
[15]http://www.dwinforcenter.org
[16]http://www.dwway.com/
[17]http://www.skyec.com/cpxz.asp
[18]http://www.excelhome.net/
[19]http://www.officefans.net
[20]http://xml.sz.luohuedu.net
[21]http://www.uncj.net
[22]http://www.spss.com
[23]http://www.sasor.com
[2]Tom Soukup,Lan Davjdson,Visual DataMining Techniques and Tools for Data Visualizaion and Mining, 电子工业出版社，2004
[3]Ralph Kimball,Margy Ross,The Data Warehouse Toolkit the Complete Guide to Dimemsional Modling, 电子工业出版社，2003.1
[4]Tony Bain,SQL Server2000 数据仓库与 Analysis Services,中国电力出版社，2003.3
[5] 林宇，数据仓库原理与实践，人民邮电出版社，2003.1
[6]章立民，用实例学ASP.NET—使用C#与ADO.NET,华中科技大学出版社，2003
[7]Microsoft Corporation, Microsoft SQL Server 2000 Analysis Services, Microsoft Press,2001
[8] Microsoft Corporation, Microsoft SQL Server 2000 安装与使用指南, Microsoft Press,2001
[9]www.csdn.net
[10] http://www.ourfly.com/forum/List.aspx?fbId=12&Page=2
[11] http://www.billinmon.com/
[12] http://www.datawarehouse.com
[13]http://www.dmgroup.org.cn/
[14]http://www.dmreview.com
[15]http://www.dwinforcenter.org
[16]http://www.dwway.com/
[17]http://www.skyec.com/cpxz.asp
[18]http://www.excelhome.net/
[19]http://www.officefans.net
[20]http://xml.sz.luohuedu.net
[21]http://www.uncj.net
[22]http://www.spss.com
[23]http://www.sasor.com