Institutional Repository
| 商业智能中的多维分析和报表查询的研究 | |
| 刘庆伟 | |
| 2007-06-01 | |
| Degree Grantor | 中国科学院软件研究所 |
| Degree Level | 博士 |
| Place of Degree Grantor | 软件研究所 |
| Keyword | 商业智能 前端展现 多维分析 报表 查询 |
| English Abstract | 大量面向事务处理的应用系统的开发使企业逐渐积累了丰富的数据资源，为了充分利用这些数据资源来辅助企业进行有效的商业决策，迫切需要一种切合企业实际需求的面向分析和查询的解决方案。商业智能正是为满足企业的这种需求而提出的一个系统的解决方案，它综合了多种信息技术，为分析企业中积累的数据和信息提供了一套有效的方法和工具。商业智能中的前端展现部分是直接面向用户的，也是目前商业智能所研究的重点和难点，针对国内用户对这方面的实际需求，本论文把如何基于关系数据库和B/S模式实现商业智能中的前端展现部分作为研究的主要方向，目的是为关系数据库中的业务数据提供一种多维分析的方法并在多维模型定义的基础上提供自定义报表和即席查询的功能。 本论文主要研究了基于关系数据库和B/S开发模式的商业智能前端展现，包括多维分析、报表和即席查询三部分内容。在多维分析的研究中通过建立多维模型定义使数据具有多维的概念，并在此基础上提供了一种多维数据展现的方法，同时可实现多维数据的钻取、旋转、切片等操作，并提供了一种多维数据图形展现的功能，实现了多种统计分析模型；在多维模型定义的基础上提供了一种自定义报表的实现，可完成报表的定制、分发、打印、导出等功能；在即席查询部分的研究中，通过定义查询列、排序列以及查询条件可实现任意组合的查询。 在对多维分析、报表和查询研究的基础上实现了一种B/S模式的商业智能前端展现综合工具，该工具基于SQL SERVER2005关系数据库和JAVA语言实现，利用AJAX和JAVASCRIPT增强前端的交互和展现效果。 |
| Abstract | Because many transaction oriented application systems are developed, enterprises gradually accumulate plenty of data resources. In order to assist enterprises making effective business decision by make the best of these data resources. There is a need of analysis and query oriented solution which is suit of enterprise’s requirements. Business intelligence is just a system solution which is put forward to satisfy this demand of enterprises. Business intelligence integrates many information technologies. It provides a suit of effective methods and tools for analyzing data and information that enterprises produce. Data presentation in business intelligence is faced directly to end users. It is also the most important and the most implicated part of business intelligence. Aiming at the requirements of domestic users, the main research purpose of this paper is how to implement data presentation of business intelligence on relational database and B/S mode. The purpose is providing a multidimensional analysis method for business data in relational database and based on the multidimensional model definition providing the function of self-defined reporting and ad-hoc query. This paper mainly researches data presentation in business intelligence in relational database and B/C mode. It includes three parts: multidimensional analysis, reporting and ad-hoc query. In research of multidimensional analysis, make data having the multidimensional concept by creating multidimensional model definition. Based on the multidimensional model definition provides a method of multidimensional data presentation. The method cans implement operations of pivoting, roll up, drill down, dice and slice. Provide a method of graphical presentation and analysis. Implement many analysis models. Based on the multidimensional model definition provide a self-defined reporting implementation. Includes report definition, report handing out, report printing, report exporting. In the research of ad-hoc query, by defining query fields, order fields and query conditions implements the self-defined data queries. Based on the researches of multidimensional analysis, reporting and ad-hoc query, implements an integrated tool of data presentation in B/S mode. The tool is developed on SQL SERVER 2005 and in JAVA language. Using AJAX and JAVASCRIPT technologies enhances the effect of interaction and presentation. |
| Pages | 76 |
| Language | 中文 |
| Content Type | 学位论文 |
| URI | http://ir.iscas.ac.cn/handle/311060/5618 |
| Collection | 中科院软件所_中科院软件所 |
| Recommended Citation GB/T 7714 | 刘庆伟. 商业智能中的多维分析和报表查询的研究[D]. 软件研究所. 中国科学院软件研究所,2007. |
| Files in This Item: | ||||||
| File Name/Size | DocType | Version | Access | License | ||
| 10001_20042801502910（1582KB） | 限制开放 | -- | Application Full Text | |||
Items in the repository are protected by copyright, with all rights reserved, unless otherwise indicated.
Edit Comment