Data warehousing and the Internet's impact on ERP

Advances in data warehousing and Internet technology have spurred ERP development, but these systems still need some improvements. The information era has dramatically changed the business environment, and keen competition puts tremendous demands on companies to reduce total cost and maximize return on investment. This is why more businesses are seeing systems for enterprise resource planning (ERP) as key to remaining competitive. To keep pace, ERP systems themselves have undergone considerable change in the past 10 years (1990-2000). To help your organization make the right ERP choices, it is helpful to know how two key technologies: data warehousing and the Internet, are transforming these complex systems     

基于Web的数据仓库技术

本文的目的是对基于Web的数据仓库技术进行回顾,探讨数据仓库当前形式的局限性,然后引入基于Web的数据仓库技术,并介绍企业如何利用它来克服传统数据仓库的不足。给出一个模型使读者更容易理解基于Web数据仓库的构成。本文也讨论了企业在采用这项技术过程中可能面临的挑战及对策。     

基于Web的数据仓库技术

本文的目的是对基于Web的数据仓库技术进行回顾,探讨数据仓库当前形式的局限性,然后引入基于Web的数据仓库技术,并介绍企业如何利用它来克服传统数据仓库的不足。给出一个模型使读者更容易理解基于Web数据仓库的构成。本文也讨论了企业在采用这项技术过程中可能面临的挑战及对策。     

The benefits of data warehousing: why some organizations realize exceptional payoffs

Data warehousing is one of the key developments in the information systems (IS) field. While its benefits are plentiful, some organizations are receiving more significant returns than others. The types of returns can vary in the impact they have on the organization and the ease in which they can be quantified and measured. This article presents a framework that shows how data warehouses can transform an organization; it also offers a compelling explanation for why differences in impact exist. Case studies of data warehousing initiatives at a large manufacturing company (LMC), the Internal Revenue Service, and a financial services company (FSC) are presented and discussed within the context of the framework. The analysis shows that the benefits that each company received can be tied to the way in which it conforms to the framework.     

Web数据的数据仓库化模型

数据仓库化Web数据,以更好地支持企业的经营决策和联机分析处理,是当前数据库研究的一个热点。Web数据的数据仓库化包括数据抽取、数据集成和数据物化三个连续的阶段。本文在MIX模型的基础上,提出了一个数据仓库化Web数据的模型,描述了主要部分的接口功能,并详细讨论了Web数据的集成过程及物化过程中的有关问题。     

Safeguarding the data warehouse

Data warehousing and the Internet are regarded as the two most important changes to the information systems landscape in the past few years. Although they are agents of powerful change, their deployment presents many challenges and opportunities. Here is outlined one set of challenges that has emerged with the convergence of the Internet and data warehousing security.     

Towards a framework for evaluating investments in data warehousing

Data warehousing technology offers organizations the potential for much greater exploitation of informational assets. However, the evaluation of potential investments in this technology poses problems for organizations as traditional evaluation methods are constrained when dealing with strategic IT applications. Nevertheless, many organizations are procedurally obliged to use such methods for evaluating data warehousing investments. This paper identifies five problems with using such methods in these circumstances: evaluating intangible benefits; making the relationship between IT and profitability explicit; dealing with the vanishing status quo; dealing with the extended investment time frame; and evaluating infrastructural investments. The authors studied how four organizations in the UK and Ireland attempted to overcome these problems when introducing data warehousing, and propose a framework for evaluating data warehousing investments. This framework consists of a high‐level analysis of the economic environment and of the information intensity of the relationship between the organization and its customers. Based on the outcome of this analysis, the authors propose four factors that have to be managed during the evaluation process in order to ensure that the limitations of the traditional evaluation techniques do not adversely affect the evaluation process. These factors are: commitment and sponsorship; the approach to evaluation; the time scale of benefits; and the appraisal techniques used.     

电信渠道建设系统中分析环境的构建

利用数据仓库来构建企业的信息系统,可以将企业原来以单一数据库为中心的数据环境发展为体系化的分析型处理环境,系统整合各种异构数据源,建立适合分析处理的数据模型,利用联机分析处理技术和数据挖掘技术来展示和发现知识,指导企业经营发展。本文讨论如何构建一个企业级的数据仓库系统,建立渠道建设系统的分析处理环境,并并建立面向主题的分析模型,为营销服务人员提供决策支持。     

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.     

基于数据仓库开发方法的比较

数据仓库对于数据集成技术的发展起到了主要的作用，目前有许多数据仓库开发方法和工具可供使用。究竞选择何种数据仓库开发方法对于一个数据仓库开发项目的成败起到了至关重要的作用。因而，数据仓库开发方法的选择成为了许多公司开发数据仓库项目过程中的重中之重。本文通过对三类九种数据仓库开发方法基于一系列具有代表性的共同属性的比较，总结归纳了各自的优势与不足并对于在一个特定的数据仓库开发项目中使用何种方法提出了具体的建议。     

Involving domain experts in assistive technology research

Teams engaging in assistive technology research should include expertise in the domain of disability itself, in addition to other areas of expertise that are more typical in human–computer interaction (HCI) research, such as computer science and psychology. However, unexpected problems can arise when HCI researchers do not adequately plan the involvement of domain experts in a research project. Although many research teams have included domain experts when designing assistive technologies, there has been little work published on how to best involve these experts in the research process. This paper is a first step towards filling that void. Based on the authors’ own experiences involving domain experts in research, as well as those documented in the literature, five types of domain experts and three broad roles that domain experts can play are identified, and five guidelines for their involvement are presented. This analysis will be useful to anyone in the assistive technology and universal accessibility communities, especially those who are in the early stages of conducting research in this area. It is intended to lay the foundation of best practices for involving domain experts in assistive technology research.     

Web数据仓库系统

本文在简单介绍数据仓库技术和Web技术的基础之上,介绍了两种技术结合的产物——Web数据仓库系统。文中主要讨论了它的体系结构、特点以及安全性等问题,并介绍了它的主要应用领域。     

基于库存控制的数据仓库与决策支持

通过对传统决策支持系统已经不能满足当今企业对决策支持的需要的分析,提出了采用数据仓库（DW）,联机分析处理（OLAP）及数据挖掘技术为企业提供决策必要性,设计了一种利用数据仓库（DW）技术和联机分析处理（OLAP）、数据挖掘（DM）等数据仓库工具提供库存控制决策支持的方案,并着重阐述了联机分析处理（OLAP）与数据挖掘是如何为企业库存控制提供决策支持的。     

电子商务中OLAP技术的运用与实现

随着电子商务在WWW中的普及与发展，人们更加乐于在网上选购自己需要的商品，对于大量的网上订单，如果可以在后台建立相应的数据仓库，将很大程序上方便管理者进行宏观统计与决策。本文首先给出数据仓库以及OLAP（Online Analysis Processing)等一些相关概念，然后叙述了OLAP多维数据分析的几种方法，最后通过一个模型详细描述了数据仓库和O－LAP技术在电子商务中的运用和实现。     

Schema Evolution in Data Warehouses

In this paper, we address the issues related to the evolution and maintenance of data warehousing systems, when underlying data sources change their schema capabilities. These changes can invalidate views at the data warehousing system. We present an approach for dynamically adapting views according to schema changes arising on source relations. This type of maintenance concerns both the schema and the data of the data warehouse. The main issue is to avoid the view recomputation from scratch especially when views are defined from multiple sources. The data of the data warehouse is used primarily in organizational decision-making and may be strategic. Therefore, the schema of the data warehouse can evolve for modeling new requirements resulting from analysis or data-mining processing. Our approach provides means to support schema evolution of the data warehouse independently of the data sources. Received 20 March 2000 / Revised 5 January 2001 / Accepted in revised form 20 April 2001     

一种应用于OLAP的数据模型及其实现

数据仓库及OLAP技术是当前数据库领域研究的热点,而数据模型又是数据仓库及OLAP核心基础。文章提出了一种应用于OLAP的数据模型,并用于实际应用中。这种数据模型在概念上表达了OLAP特性,支持OLAP操作,而且其数学代数简单明白地表达了OLAP查询。     

An ontology to represent geospatial data to support building renovation

Energy-efficient building renovation is an inter-disciplinary task and requires investigation about the building condition in the urban, environmental, and societal context. Existing literature implicitly mentions the effect of surrounding data in different stages of building renovation. Nevertheless, no conceptual framework is available for practitioners to realize the potential of such data in specific phases of the renovation.The main goal of this study is to understand: (1) based on what knowledge framework surrounding geospatial and environmental data can support building renovation projects, (2) if developing an ontology can help representing this knowledge framework, and (3) how experts and engineers involved in the renovation process can contribute to development of this knowledge framework. The results present an ontology that maps surrounding geospatial and environmental concepts for different renovation tasks and use cases within building renovation. The ontology is built upon knowledge captured from previous studies that implicitly mention the effect of these datasets in building renovation, as well as expert knowledge, brainstorming, and monitoring construction sites. Additionally, a semi-structured verification and validation workshop has been performed to incorporate insights from experts directly involved in different stages of building renovation process.This paper contributes to the body of knowledge by generating a common framework for the surrounding data required in building renovation. It has an implication in practice for engineers by providing a shared knowledge framework and for software developers by providing a basis for BIM (Building Information Modeling) and GIS (Geographic Information System) data integration for renovation purposes.     

基于数据仓库的外贸业务分析决策系统

文章论述中国出口综合评价体系(CTPI)的建立,较详细地介绍了基于CTPI的外贸业务分析决策系统的研制开发,给出了基于数据仓库的外贸业务分析决策系统的体系结构,研究了数据仓库、联机分析处理和数据挖掘技术在对外贸业务分析决策系统中的应用。     

基于Agent的三层数据仓库系统体系结构的研究

针对传统数据仓库体系结构的不足，引入了软件Agent技术以及"数据仓库基库" 的概念，提出了一种基于Agent的三层数据仓库系统体系结构，一方面使得传统数据库更加 容易融入到数据仓库系统，增强了整个系统的伸缩性；另一方面，由于Agent技术的介入， 降低了网络数据传输量，适应了移动环境等复杂信息源的要求，拓广了数据仓库的应用领域 。     

Posix/Unix standards: foundation for 21st century growth

Posix standards represent approximately $80 billion of the $250+ billion-Unix market over the last decade; they also provide the basis for significant growth in the future. This picture of the substantial success of Posix standards (and the business impact of standards in general) differs from that presented in Micro's May/June 1998 issue. The overall Unix market boasts billions of dollars in revenues, and is projected to continue growing into the future. Major areas for this growth feature high-end systems (data warehousing, servers, and supercomputing) rather than desktop applications