XML驱动的OLAP解决方案研究

OLAP系统应该能够集成常见的分析数据源,并提供对立方体的方便快速的建模,XML的潜在优势能很好胜任这一角色。论文首先介绍OLAP系统中XML应用角色及0LAPAPI的技术现状,在对现有OLAP产品研究的基础上提出开放OLAP系统应遵循的一般原则,最后结合Mondrian系统,给出一个基于XML的OLAP服务系统开发实例。     

一种OLAP概念建模的研究与实现

OLAP已成为决策支持的一种重要工具。鉴于对多种数据源集成和易用性的要求越来越高,文中提出了一种轻型OLAP的框架,它能利用XML在表示维度数据的优势,提供对XML数据源的集成,最终利用UML类图提供概念上的建模。从而让用户以统一、透明的方式从概念上完成建模,方便使用OLAP。     

一种OLAP概念建模的研究与实现

OLAP已成为决策支持的一种重要工具.鉴于对多种数据源集成和易用性的要求越来越高,文中提出了一种轻型OLAP的框架,它能利用XML在表示维度数据的优势,提供对XML数据源的集成,最终利用UML类图提供概念上的建模.从而让用户以统一、透明的方式从概念上完成建模,方便使用OLAP.     

基于XML的松耦合OLAP系统的研究

文章给出了松耦合OLAP应用系统的新概念。它是一个集合了XML、SOAP等技术的新型OLAP应用系统。可在交叉平台以及Internet语言独立的环境中完成客户对OLAP服务器立方体的创建和多维数据查询的操作。文中对此松耦合OLAP系统做了详尽的描述,并给出了实现房地产分析系统中数据集成管理的初步方案。     

CRM系统中基于ASP.NET的OLAP的设计与实现

介绍了客户关系管理（customer relationship management,CRM）、数据仓库和联机分析处理（on-line analytical processing,OLAP）服务,分析了基于数据仓库的CRM系统中OLAP设计的系统架构.基于ASP.NET和SQL Server2000,并综合运用OWC（office web components）、可扩展标记语言（extensible markup language,XML）等相关技术,提出了拓宽OLAP服务域,实现OLAP报表在Web上显示的一个解决方案.说明了系统的部署配置方法和应用程序的构建过程,给出了实现通过内嵌OWC的Web客户端页面,调用XML Web Service,与OLAP服务器建立连接并进行访问的具体方法.     

基于关系数据库和XML的OLAP建模方案

OLAP系统运行的基础是多维数据模型。以快速、准确、灵活地构建多维数据模型为目的,提出了一种基于关系数据库和XML的OLAP建模方案。该建模方案将OLAP的建模任务分为两个阶段:存储层建模和应用层建模。在存储层,使用关系数据库,按照"星型图"方法建立具备多维特性的关系数据模型;在应用层,设计XML Schema,描述多维数据立方体及物理映射。运用建模方案,可以有效提高OLAP多维数据建模的效率和效果。     

基于XML的OLAP信息发布技术

一种新的基于XML信息发布技术的OLAP系统体系结构,解决了系统实现中多维数据集到XML数据的映射算法和XML数据的Internet发布二个关键问题。     

基于半结构化数据的关联规则挖掘模式

针对关联规则挖掘应用所面临的困难,分析了XML语言的技术特点,提出了一种基于半结构化数据的关联规则挖掘模式。该模式充分利用了半结构化数据源的自描述性、开放性和可扩展性方面的优势。     

远程监测与故障诊断专家系统设计与实现

介绍了以太网远程监测与故障诊断系统,针对系统开放性的需求,将可扩展标记语言(XML)应用于该系统;通过分析系统数据接口中XML模型和XML文档解释方法,介绍了XML通用数据交换接口的实现方法,着重分析了在DOS操作系统下如何实现XML文档的解析;通过将该数据交换接口应用于某系统远程监测与故障诊断专家系统表明,运用XML数据交换接口进行数据通行具有较强的可靠性和灵活性,能够满足系统的开放性和跨平台要求。     

基于XML的石油勘探数据库查询应用系统的实现

通过XML技术在河南油田勘探数据库查询应用系统中的应用,提出了XML技术和数据库技术相结合的数据库快速灵活地查询浏览应用的解决方案。在该方案中,以XML为数据交换标准,采用了多级分布式三层架构,很好地实现了数据库查询应用系统的开放性和可扩充性。     

A relational–XML data warehouse for data aggregation with SQL and XQuery

Integrating information from multiple data sources is becoming increasingly important for enterprises that partner with other companies for e‐commerce. However, companies have their internal business applications deployed on diverse platforms and no standard solution for integrating information from these sources exists. To support business intelligence query activities, it is useful to build a data warehouse on top of middleware that aggregates the data obtained from various heterogeneous database systems. Online analytical processing (OLAP) can then be used to provide fast access to materialized views from the data warehouse. Since extensible markup language (XML) documents are a common data representation standard on the Internet and relational tables are commonly used for production data, OLAP must handle both relational and XML data. SQL and XQuery can be used to process the materialized relational and XML data cubes created from the aggregated data. This paper shows how to handle the two kinds of data cubes from a relational–XML data warehouse using extract, transformation and loading. Copyright © 2008 John Wiley & Sons, Ltd.     

Finding an application-appropriate model for XML data warehouses

Decision support systems help the decision making process with the use of OLAP (On-Line Analytical Processing) and data warehouses. These systems allow the analysis of corporate data. As OLAP and data warehousing evolve, more and more complex data is being used. XML (Extensible Markup Language) is a flexible text format allowing the interchange and the representation of complex data. Finding an appropriate model for an XML data warehouse tends to become complicated as more and more solutions appear. Hence, in this survey paper we present an overview of the different proposals that use XML within data warehousing technology. These proposals range from using XML data sources for regular warehouses to those using full XML warehousing solutions. Some researches merely focus on document storage facilities while others present adaptations of XML technology for OLAP. Even though there are a growing number of researches on the subject, many issues still remain unsolved.     

Specifying OLAP Cubes on XML Data

On-Line Analytical Processing (OLAP) enables analysts to gain insight about data through fast and interactive access to a variety of possible views on information, organized in a dimensional model. The demand for data integration is rapidly becoming larger as more and more information sources appear in modern enterprises. In the data warehousing approach, selected information is extracted in advance and stored in a repository, yielding good query performance. However, in many situations a logical (rather than physical) integration of data is preferable. Previous web-based data integration efforts have focused almost exclusively on the logical level of data models, creating a need for techniques focused on the conceptual level. Also, previous integration techniques for web-based data have not addressed the special needs of OLAP tools such as handling dimensions with hierarchies. Extensible Markup Language (XML) is fast becoming the new standard for data representation and exchange on the World Wide Web. The rapid emergence of XML data on the web, e.g., business-to-business (B2B) e-commerce, is making it necessary for OLAP and other data analysis tools to handle XML data as well as traditional data formats.Based on a real-world case study, this paper presents an approach to specification of OLAP DBs based on web data. Unlike previous work, this approach takes special OLAP issues such as dimension hierarchies and correct aggregation of data into account. Also, the approach works on the conceptual level, using Unified Modeling Language (UML) as a basis for so-called UML snowflake diagrams that precisely capture the multidimensional structure of the data. An integration architecture that allows the logical integration of XML and relational data sources for use by OLAP tools is also presented.     

一个开放的OLAP体系结构

一个 OL AP产品要想在多变的市场需求中站稳脚跟 ,它的体系结构必须具有足够的开放性 :首先 OL AP服务器要能够方便的与现有的大型数据仓库很好的集成 ,并且 OL AP服务器在向客户端提供的支持上应该提供对第三方软件特别是决策支持软件的友好接口 .本文将以此为依据提出一个开放的 OL AP体系 ,并着重分析 OL AP服务器的内部结构以及服务器对客户端的支持     

基于XML技术的数据仓库多维数据模型

本文介绍了一种基于关系数据库、利用 XML技术实现多维数据模型方法 .首先讨论了在关系数据库之上构建数据仓库的系统结构 ,利用面向对象的技术构建一个逻辑多维数据模型 ,通过 XML 文档保存多维数据模型的元数据 .配合数据仓库的数据抽取工具、汇总工具可以实现数据仓库的基本功能 .对于实现关系数据库之上 OL AP和数据挖掘有一定的参考价值 .     

Improving the performance and functionality of Mondrian open‐source OLAP systems

For a long time, the design of relational databases has focused on the optimization of atomic transactions (insert, select, update or delete). Currently, relational databases store tactical information of data warehouses, mainly for select‐like operations. However, the database paradigm has evolved, and nowadays on‐line analytical processing (OLAP) systems handle strategic information for further analysis. These systems enable fast, interactive and consistent information analysis of data warehouses, including shared calculations and allocations. OLAP and data warehouses jointly allow multidimensional data views, turning raw data into knowledge. OLAP allows ‘slice and dice’ navigation and a top‐down perspective of data hierarchies. In this paper, we describe our experience in the migration from a large relational database management system to an OLAP system on top of a relational layer (the data warehouse), and the resulting contributions in open‐source ROLAP optimization. Existing open‐source ROLAP technologies rely on summarized tables with materialized aggregate views to improve system performance (in terms of response time). The design and maintenance of those tables are cumbersome. Instead, we intensively exploit cache memory, where key data reside, yielding low response times. A cold start process brings summarized data from the relational database to cache memory, subsequently reducing the response time. We ensure concurrent access to the summarized data, as well as consistency when the relational database updates data. We also improve the OLAP functionality, by providing new features for automating the creation of calculated members. This makes it possible to define new measures on the fly using virtual dimensions, without re‐designing the multidimensional cube. We have chosen the XML/A de facto standard for service provision. Copyright © 2008 John Wiley & Sons, Ltd.     

一种基于B／S结构的OLAP服务体系结构的研究

论述了当前基于C／S结构的OLAP系统的不足，提出了一种基于B／S结构的OLAP系统。该系统读取OLAP建摸工具生成的语义对象存储文件，向用户屏蔽了各种分析数据源的差异，可以以普通关系数据库、数据仓库和数据立方体为分析数据源，通过浏览器向用户展示分析结果，同时可以对分析结果进行各种分析操作。