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

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. Categories and Subject Descriptors H.2.4 [Database Management]: Systems – distributed databases, query Processing. Keywords Multidatabases, Global Queries/Updates, System o...

• Type: Conference
• Year: 2005
• Where: ACMSE
• Authors: Rajshekhar Sunderraman, Erdogan Dogdu, Praveen Madiraju, Laxmikanth Malladi
• Keywords: ACMSE 2005, Collaborative Application, Database, Multiple Databases, Theoretical Computer Science