The Development of Ordered SQL Packages to Support Data Warehousing

The Development of Ordered SQL Packages to Support Data Warehousing

Wilfred Ng (Hong Kong University of Science and Technology, China) and Mark Levene (University of London, UK)
Copyright: © 2002 |Pages: 27
DOI: 10.4018/978-1-931777-02-5.ch018
OnDemand PDF Download:
$37.50

Abstract

Data warehousing is a corporate strategy that needs to integrate information from several sources of separately developed Database Management Systems (DBMSs). A future DBMS of a data warehouse should provide adequate facilities to manage a wide range of information arising from such integration. We propose that the capabilities of database languages should be enhanced to manipulate user-defined data orderings, since business queries in an enterprise usually involve order. We extend the relational model to incorporate partial orderings into data domains and describe the ordered relational model. We have already defined and implemented a minimal extension of SQL, called OSQL, which allows querying over ordered relational databases. One of the important facilities provided by OSQL is that it 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 present the details of the generic operations arising from these applications in the form of three OSQL packages called: OSQL_TIME, OSQL_INCOMP and OSQL_FUZZY.

Complete Chapter List

Search this Book:
Reset
Table of Contents
Foreword
Shirley Becker
Chapter 1
Stephan Kudyba, Richard Hoptroff
The world of commerce has undergone a transformation since the early 1990s, which has increasingly included the utilization of information... Sample PDF
An Introduction to Information Technology and Business Intelligence
$37.50
Chapter 2
Ladjel Bellatreche, Kamalakar Karlapalem, Mukesh Mohania
Information is one of the most valuable assets of an organization, and when used properly can assist intelligent decision-making that can... Sample PDF
Some Issues in Design of Data Warehousing Systems
$37.50
Chapter 3
Balaji Rajagopalan, Ravi Krovi
Data mining is the process of sifting through the mass of organizational (internal and external) data to identify patterns critical for decision... Sample PDF
Benchmarking Data Mining Algorithms
$37.50
Chapter 4
Ram L. Kumar
Organizations are increasingly recognizing the importance of information technology. Many large IT projects in the area of data warehousing and data... Sample PDF
Justifying Data Warehousing Investments
$37.50
Chapter 5
Sufi M. Nazem, Bongsik Shin
During the early years of database management the contemporary wisdom was to store only ‘useful data.’ In large part, this philosophy was encouraged... Sample PDF
Data Mining: A New Arsenal for Strategic Decision-making
$37.50
Chapter 6
Elizabeth J. Davidson
Data warehousing is an information technology (IT) innovation based on an evocative metaphor for physical materials management. This metaphor has... Sample PDF
What's in a Name? Exploring the Metaphysical Implications of Data Warehousing in Concept and Practice
$37.50
Chapter 7
Amita Goyal Chin
In a distributed database system, an increase in workload typically necessitates the installation of additional database servers followed by the... Sample PDF
Incremental Data Allocation and Reallocation in Distributed Database Systems
$37.50
Chapter 8
Youssef Amghar, Madjid Meziane, Andre Flory
Modeling behavior is an important task of the information system engineering process. This task is especially important when information systems are... Sample PDF
Using Business Rules within a Design Process of Active Databases
$37.50
Chapter 9
Jose Maria Cavero, Esperanza Marcos, Mario Piattini, Adolfo Sanchez
Data warehousing and online analytical processing (OLAP) technologies have become growing interest areas in latest years. Specific issues, such as... Sample PDF
A Methodology for Datawarehouse Design: Conceptual Modeling
$37.50
Chapter 10
Herna L. Viktor, Niek F. du Plooy
Data quality has a substantial impact on the quality of the results of a Knowledge Discovery from Data (KDD) effort. The poor quality of real-world... Sample PDF
Assessing and Improving the Quality of Knowledge Discovery Data
$37.50
Chapter 11
Witold Abramowicz, Pawel Jan Kalczynski, Krzysztof Wecel
The data warehouse is considered to be the best way to organize transactional data. However, as many researches claim data warehouse should be... Sample PDF
Complementing the Data Warehouse with Information Filtered from the Web
$37.50
Chapter 12
Reinhard Jung, Robert Winter
Project justification is regarded as one of the major methodological deficits in Data Warehousing practice. As reasons for applying inappropriate... Sample PDF
Justification of Data Warehousing Projects
$37.50
Chapter 13
Karine Zeitouni
This chapter reviews the data mining methods that are combined with Geographic Information Systems (GIS) for carrying out spatial analysis of... Sample PDF
A Survey of Spatial Data Mining Methods Databases and Statistics Point of Views
$37.50
Chapter 14
Vivekanand Gopalkrishnan, Qing Li, Kamalakar Karlapalem
In an Object Relational Data Warehousing (ORDW) environment, the semantics of data and queries can be explicitly captured, represented, and utilized... Sample PDF
Efficient Query Processing with Structural Join Indexing in an Object Relational Data Warehousing Environment
$37.50
Chapter 15
Anne Banks Pidduck, Quang Ngoc Tran
The accessibility of the Internet and the World Wide Web has provided an excellent means for presenting, disseminating and distributing information.... Sample PDF
An Electronic Commerce Framework for Small and Medium Enterprises
$37.50
Chapter 16
Jorg Schellhase, Udo Winand
For the realization and maintenance of high quality and complex Web-based applications, there is a need to use sound Web-engineering principles.... Sample PDF
The VLEG Based Production and Maintenance Process for Web-based Learning Applications
$37.50
Chapter 17
Martin Gaedke, Klaus Turowski
Developing application systems that use the World Wide Web (WWW, Web) as an application platform suffers from the absence of disciplined approaches... Sample PDF
Specification of Components Based on the WebComposition Component Model
$37.50
Chapter 18
Wilfred Ng, Mark Levene
Data warehousing is a corporate strategy that needs to integrate information from several sources of separately developed Database Management... Sample PDF
The Development of Ordered SQL Packages to Support Data Warehousing
$37.50
About the Editor