Enhanced active databases for federated information systems

Doctoral Thesis / Dissertation , 2006 , 147 Pages , Grade: 1.0

Computer Science - Applied

Federated information systems provide access to interrelated data that is distributed over multiple autonomous and heterogeneous data sources. The integration of these sources demands for flexible and extensible architectures that balance both, the highest possible autonomy and a reasonable degree of information sharing. In current federated information systems, the integrated data sources do only have passive functionality with regard to the federation. However, continuous improvements take the functionality of modern databases beyond former limits. The significant improvement, on which this work is based on, is the ability of modern active database systems to execute programs written in a standalone programming language as user-defined functions or stored procedures from within their database management systems.

We introduce Enhanced Active Database Systems as a new subclass of active databases that are able to interact with other components of a federation using external program calls from within triggers. We present several concepts and architectures that are specifically developed for Enhanced Active Databases to improve interoperability and consistency in federated information systems. As the basic concept we describe Active Event Notifications to provide an information system with synchronous and asynchronous update notifications in real-time. Based on this functionality, Enhanced Active Databases are able to actively participate in global integrity maintenance executing partial constraint checks on interrelated remote data. Furthermore, we present an architecture for a universal wrapper component that especially supports Active Event Notifications, which makes it perfectly suitable for event-based federated systems with real-time data processing. This tightly coupled wrapper architecture is used to build up the Dígame architecture for a peer data management system with push-based data and schema replication. Finally, we propose a Link Pattern Catalog as a guideline to model and analyze P2P-based information systems.

Inhaltsverzeichnis (Table of Contents)

• Preface
• Abstract
• 1 Introduction
• 2 Related Work
• 3 Enhanced Active Databases
• 3.1 Active Database Systems
• 3.2 Active Event Notifications
• 3.3 Enhanced Active Databases in Federated Systems
• 3.4 Related Work on Active Database Systems
• 4 Implementing Enhanced Active Databases
• 4.1 Wrapper Architecture
• 4.2 DÍGAME Architecture
• 4.3 Related Work on Wrapper Architecture
• 5 Case Studies
• 6 Discussion
• 7 Conclusion

Zielsetzung und Themenschwerpunkte (Objectives and Key Themes)

This dissertation investigates the application of enhanced active databases in federated information systems. It explores how these systems can be used to improve interoperability and consistency across distributed data sources. The work aims to provide a comprehensive understanding of the concepts, architectures, and implementation strategies related to enhanced active databases in a federated context.

• Active Event Notifications
• Interoperability in Federated Systems
• Global Integrity Maintenance
• Wrapper Architecture for Enhanced Active Databases
• DÍGAME Architecture for Peer Data Management

Zusammenfassung der Kapitel (Chapter Summaries)

• Chapter 1: Introduction provides an overview of federated information systems and the challenges associated with integrating distributed data sources. It introduces the concept of enhanced active databases and outlines the key contributions of this thesis.
• Chapter 2: Related Work reviews existing literature on federated information systems, active database systems, and wrapper architectures. It discusses the strengths and limitations of current approaches and sets the stage for the proposed solutions.
• Chapter 3: Enhanced Active Databases delves into the concept of enhanced active databases. It examines the functionality of active database systems, introduces the concept of Active Event Notifications, and explores their application in federated systems for improved interoperability and consistency.
• Chapter 4: Implementing Enhanced Active Databases focuses on practical implementations. It presents a universal wrapper architecture specifically designed for Active Event Notifications, which is then used to build the DÍGAME architecture for peer data management with push-based data and schema replication.
• Chapter 5: Case Studies provides real-world examples of how enhanced active databases can be applied in different scenarios. It demonstrates the practical benefits of the proposed solutions.
• Chapter 6: Discussion discusses the implications of the research findings and explores potential future directions for research in enhanced active databases and federated information systems.

Schlüsselwörter (Keywords)

This work focuses on the development of enhanced active databases within the context of federated information systems. It explores key concepts like Active Event Notifications, interoperability, global integrity maintenance, wrapper architectures, and the DÍGAME architecture. These concepts are fundamental to understanding the benefits and challenges of using enhanced active databases to improve data consistency and management in distributed environments. The research contributes to the field of database systems and federated information systems by providing practical solutions and insightful analysis of these crucial concepts.

• College: University of Dusseldorf "Heinrich Heine"
• Grade: 1.0
• Author: Christopher Popfinger (Author)
• Publication Year: 2006
• Pages: 147
• Catalog Number: V79268
• ISBN (eBook): 9783638799782
• ISBN (Book): 9783638799621
• Language: English
• Tags: Enhanced