A Java API for global querying and updates for a system of databases

Authors:
Rajshekhar Sunderraman;Erdogan Dogdu;Praveen Madiraju;Laxmikanth Malladi
Affiliations:
Georgia State University, Atlanta, GA;Georgia State University, Atlanta, GA;Georgia State University, Atlanta, GA;Georgia State University, Atlanta, GA
Venue:
Proceedings of the 43rd annual Southeast regional conference - Volume 1
Year:
2005

Citing 10
Cited 0

The Pegasus Heterogeneous Multidatabase System

Computer
Local verification of global integrity constraints in distributed databases

SIGMOD '93 Proceedings of the 1993 ACM SIGMOD international conference on Management of data
METU interoperable database system

ACM SIGMOD Record
Query reformulation for dynamic information integration

Journal of Intelligent Information Systems - Special issue on intelligent integration of information
A Model for Query Decomposition and Answer Construction inHeterogeneous Distributed Database Systems

Journal of Intelligent Information Systems
The state of the art in distributed query processing

ACM Computing Surveys (CSUR)
SchemaSQL: An extension to SQL for multidatabase interoperability

ACM Transactions on Database Systems (TODS)
Distributing Semantic Constraints Between Heterogeneous Databases

ICDE '97 Proceedings of the Thirteenth International Conference on Data Engineering
A mobile agent approach for global database constraint checking

Proceedings of the 2004 ACM symposium on Applied computing
An efficient constraint planning algorithm for multidatabases

AICCSA '05 Proceedings of the ACS/IEEE 2005 International Conference on Computer Systems and Applications

Quantified Score

Hi-index	0.00

Visualization

Abstract

In this paper, we present the design of system of databases (SyDb). We also give the design and implementation of a Java API for global querying and updates on the SyDb. The databases may be heterogeneous. The API allows for queries and updates that have global references to schema elements of multiple databases to be executed in a seamless manner. The API can be used to develop collaborative applications that need access to several independent databases on the network. One such collaborative application, called the Calendar application, is illustrated in the paper. In this application each individual keeps their schedule information in their personal database. The users can schedule meetings with others, view others schedules, cancel meetings, etc. We implement the API using direct JDBC connections to databases.