中国科学院软件研究所机构知识库
Advanced  
ISCAS OpenIR  > 中科院软件所  > 中科院软件所
题名:
商业智能中的多维分析和报表查询的研究
作者: 刘庆伟
答辩日期: 2007-06-01
授予单位: 中国科学院软件研究所
授予地点: 软件研究所
学位: 博士
关键词: 商业智能 ; 前端展现 ; 多维分析 ; 报表 ; 查询
摘要: 大量面向事务处理的应用系统的开发使企业逐渐积累了丰富的数据资源,为了充分利用这些数据资源来辅助企业进行有效的商业决策,迫切需要一种切合企业实际需求的面向分析和查询的解决方案。商业智能正是为满足企业的这种需求而提出的一个系统的解决方案,它综合了多种信息技术,为分析企业中积累的数据和信息提供了一套有效的方法和工具。商业智能中的前端展现部分是直接面向用户的,也是目前商业智能所研究的重点和难点,针对国内用户对这方面的实际需求,本论文把如何基于关系数据库和B/S模式实现商业智能中的前端展现部分作为研究的主要方向,目的是为关系数据库中的业务数据提供一种多维分析的方法并在多维模型定义的基础上提供自定义报表和即席查询的功能。 本论文主要研究了基于关系数据库和B/S开发模式的商业智能前端展现,包括多维分析、报表和即席查询三部分内容。在多维分析的研究中通过建立多维模型定义使数据具有多维的概念,并在此基础上提供了一种多维数据展现的方法,同时可实现多维数据的钻取、旋转、切片等操作,并提供了一种多维数据图形展现的功能,实现了多种统计分析模型;在多维模型定义的基础上提供了一种自定义报表的实现,可完成报表的定制、分发、打印、导出等功能;在即席查询部分的研究中,通过定义查询列、排序列以及查询条件可实现任意组合的查询。 在对多维分析、报表和查询研究的基础上实现了一种B/S模式的商业智能前端展现综合工具,该工具基于SQL SERVER2005关系数据库和JAVA语言实现,利用AJAX和JAVASCRIPT增强前端的交互和展现效果。
英文摘要: 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.
语种: 中文
内容类型: 学位论文
URI标识: http://ir.iscas.ac.cn/handle/311060/5618
Appears in Collections:中科院软件所

Files in This Item:
File Name/ File Size Content Type Version Access License
10001_200428015029105刘庆伟_paper.doc(1582KB)----限制开放-- 联系获取全文

Recommended Citation:
刘庆伟. 商业智能中的多维分析和报表查询的研究[D]. 软件研究所. 中国科学院软件研究所. 2007-06-01.
Service
Recommend this item
Sava as my favorate item
Show this item's statistics
Export Endnote File
Google Scholar
Similar articles in Google Scholar
[刘庆伟]'s Articles
CSDL cross search
Similar articles in CSDL Cross Search
[刘庆伟]‘s Articles
Related Copyright Policies
Null
Social Bookmarking
Add to CiteULike Add to Connotea Add to Del.icio.us Add to Digg Add to Reddit
所有评论 (0)
暂无评论
 
评注功能仅针对注册用户开放,请您登录
您对该条目有什么异议,请填写以下表单,管理员会尽快联系您。
内 容:
Email:  *
单位:
验证码:   刷新
您在IR的使用过程中有什么好的想法或者建议可以反馈给我们。
标 题:
 *
内 容:
Email:  *
验证码:   刷新

Items in IR are protected by copyright, with all rights reserved, unless otherwise indicated.

 

 

Valid XHTML 1.0!
Copyright © 2007-2017  中国科学院软件研究所 - Feedback
Powered by CSpace