The Development of Ordered SQL Packages in Peer-to-Peer Data Warehousing Environments

The Development of Ordered SQL Packages in Peer-to-Peer Data Warehousing Environments

Wilfred Ng (The Hong Kong University of Science and Technology, Hong Kong) and Mark Levene (University of London, England)
Copyright: © 2003 |Pages: 32
DOI: 10.4018/978-1-59140-063-9.ch005
OnDemand PDF Download:
$37.50

Abstract

This chapter discusses how the capabilities of database languages are enhanced to manipulate user-defined data orderings within the framework of the Ordered Relational Model (the ORM), which incorporates partial orderings into data domains. The motivation for applying the ORM in data warehousing environment is that business queries in an enterprise usually involve order. We have already defined and implemented Ordered SQL (OSQL), which allows users to capture the underlying semantics of the ordering of the data for a given application. Herein we demonstrate that OSQL aided with a package discipline can be an effective means to manage the inter-related operations and the underlying data domains of a wide range of advanced applications that are vital in data warehousing, such as temporal, incomplete, and fuzzy information. We also discuss the employment of OSQL system with three packages of OSQL_TIME, OSQL_INCOMP, and OSQL_FUZZY over a Peer-to-Peer network. Using our suggested framework, the data content of a data warehouse can be better adapted in a dynamic environment.

Complete Chapter List

Search this Book:
Reset
Table of Contents
Preface
Keng Siau
Chapter 1
Luyin Zhao, Keng Siau
Information mediation is one of the major approaches to solve interoperability problems related to heterogeneous information integration. This paper... Sample PDF
Meta-Model Based Information Mediation
$37.50
Chapter 2
Juan Trujillo, Sergio Lujan-Mora, Il-Yeol Song
Multidimensional (MD) modeling is the basis for Data warehouses (DW), multidimensional databases (MDB), and On-Line Analytical Processing (OLAP)... Sample PDF
Applying UML for Designing Multidimensional Databases and OLAP Applications
$37.50
Chapter 3
Salvatore T. March, Gove N. Allen
Research in temporal database management has suggested that the Entity-Relationship model must be extended to compensate for its lack of constructs... Sample PDF
On the Representation of Temporal Dynamics
$37.50
Chapter 4
Hock Chuan Chuan, John Lim
This chapter provides a review, using both qualitative and quantitative approaches, of experimental studies on natural language interfaces. As data... Sample PDF
A Review of Experiments on Natural Language Interfaces
$37.50
Chapter 5
Wilfred Ng, Mark Levene
This chapter discusses how the capabilities of database languages are enhanced to manipulate user-defined data orderings within the framework of the... Sample PDF
The Development of Ordered SQL Packages in Peer-to-Peer Data Warehousing Environments
$37.50
Chapter 6
Jung-Ho Ahn, Ha-Joo Song, Hyoung-Joo Kim
An efficient object manager, a middle layer on top of a storage system, is essential to ensure acceptable performance of object-oriented database... Sample PDF
Implementation Techniques for Extensible Object Storage Systems
$37.50
Chapter 7
Latifur Khan, Arunkumar Ponnusamy, Dennis McLeod, Cyrus Shahabi
An adaptive probe-based optimization technique is developed and demonstrated in the context of an Internet-based distributed database environment.... Sample PDF
A Run-Time Based Technique to Optimize Queries in Distributed Internet Databases
$37.50
Chapter 8
Ling Liu, Calton Pu
We introduce the ActivityFlow specification language for flexible specification, composition, and coordination of workflow activities. The most... Sample PDF
Towards Flexible Specification, Composition and Coordination of Workflow Activities
$37.50
Chapter 9
Balaji Rajagopalan, Ravindra Krovi
This chapter introduces knowledge discovery techniques as a means of identifying critical trends and patterns for business decision support. It... Sample PDF
Performance Implications of Knowledge Discovery Techniques in Databases
$37.50
Chapter 10
Ajantha Dahanayake, Henk Sol, Zoran Stojanovic
Components are already prominent in the implementation and deployment of advanced distributed information systems. Part and parcel of this... Sample PDF
Methodology Evaluation Framework for Component-Based System Development
$37.50
Chapter 11
Mihhail Matskin, Amund Tveit
This chapter considers an application of software agents to mobile commerce services provision. With the increasing number of e-commerce services... Sample PDF
Software Agents for Mobile Commerce Services Support
$37.50
Chapter 12
Andrés Coratella, Miguel Felder, Roberto Hirsch, Eduardo Rodriguez
Currently, mobile technology is undergoing a high growth stage, allowing an increasing plethora of mobile devices (handheld PCs, handsets, etc.) to... Sample PDF
A Framework for Analyzing Mobile Transaction Models
$37.50
Chapter 13
Chih-Horng Ke, Chiang Lee
With the merge of mobile computing and electronic commerce technologies, millions of mobile users in the near future could carry a mobile device... Sample PDF
Considering Mobility in Query Processing for Mobile Commerce Systems
$37.50
About the Authors