By cspr , java , odbc and ibm db2 , the author carries out the pivotal technology and major element . at last , this paper makes an experimental system for sowntown cluster and multidimensional analysis of yuzhong tobacco company . this corp 在lcc基础上利用cspr ,采用java 、 odbc接口, ibmdb2语言及相关技术,实现了商业智能挖掘( businessintelligentminer ,简称biminer )系统商圈聚类的主要功能模块。
The article studies how to dynamically create multi - cube structure using sql language and rolap engine and to realize multidimensional calculation combined with olap engine and to satisfy the report form and multidimensional analysis requirement of consumer by drive of user ' s analysis 本文研究如何由用户分析驱动,利用sql语句和rolap引擎动态生成多立方结构,并且结合olap引擎实现多维计算,以满足用户报表及多维分析需求。
So the concepts of multidimensional database and multidimensional analysis are put forward , viz . on - line analytical process , it gives analyst , manager , or executor the ability of information access which is rapid , accordant and interactive from multi point of view . the information comes from original data , and can be catch on by consumer and really reflects the character of enterprise dimension 因此提出了多维数据库和多维分析的概念,即联机分析处理( on - lineanalyticaiprocess ) ,它是使分析人员、管理人员或执行人员能够从多种角度,对从原始数据中转化出来的、能够真正为用户所理解的并真实反映企业维特性的信息进行快速、一致、交互地存取,从而获得对数据的更深入了解的一类软件技术。
The requirement of multidimensional analysis of terminal consumers will be dynamically translated to sql requirement by rolap engine , then relational database will handle the sql requirement . in the end the requesting result which is handled by rolap engine will be sent to consumer as multidimensional cube 最终用户的多维分析请求通过rolap引擎被动态地翻译为sql请求,然后由关系数据库来处理sql请求,最后查询结果经rolap引擎处理后生成多维数据立方体返回给用户。