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

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.

REFERENCES

• 1: Rafi Ahmed , Philippe De Smedt , Weimin Du , William Kent , Mohammad A. Ketabchi , Witold A. Litwin , Abbas Rafii , Ming-Chien Shan, The Pegasus Heterogeneous Multidatabase System, Computer, v.24 n.12, p.19-27, December 1991 [doi>10.1109/2.116885]
• 2: Yigal Arens , Craig A. Knoblock , Wei-Min Shen, Query reformulation for dynamic information integration, Journal of Intelligent Information Systems, v.6 n.2-3, p.99-130, June 1996 [doi>10.1007/BF00122124]
• 3: S. Chawathe, H. Garcia-Molina, J. Hammer, K. Ireland, Y. Papakonstantinou, J. Ullman and J. Widom. The TSIMMIS project: Integration of heterogeneous information sources. Proceedings of IPSJ Conference, 1994
• 4: A. Dogac , C. Dengi , E. Kilic , G. Ozhan , F. Ozcan , S. Nural , C. Evrendilek , U. Halici , B. Arpinar , P. Koksal , N. Kesim , S. Mancuhan, METU interoperable database system, ACM SIGMOD Record, v.24 n.3, p.56-61, Sept. 1995 [doi>10.1145/211990.212017]
• 5: Stefan Grufman , Fredrik Samson , Suzanne M. Embury , Peter M. D. Gray , Tore Risch, Distributing Semantic Constraints Between Heterogeneous Databases, Proceedings of the Thirteenth International Conference on Data Engineering, p.33-42, April 07-11, 1997
• 6: Ashish Gupta , Jennifer Widom, Local verification of global integrity constraints in distributed databases, Proceedings of the 1993 ACM SIGMOD international conference on Management of data, p.49-58, May 25-28, 1993, Washington, D.C., United States
• 7: Donald Kossmann, The state of the art in distributed query processing, ACM Computing Surveys (CSUR), v.32 n.4, p.422-469, Dec. 2000 [doi>10.1145/371578.371598]
• 8: C. T. Kwok and D. S. Weld. Planning to gather information. Technical Report UW-CSE-96-01-04.Department of Computer Science, University of Washington, Seattle, WA, 1996.
• 9: Laks V. S. Lakshmanan , Fereidoon Sadri , Subbu N. Subramanian, SchemaSQL: An extension to SQL for multidatabase interoperability, ACM Transactions on Database Systems (TODS), v.26 n.4, p.476-519, December 2001 [doi>10.1145/503099.503102]
• 10: Lachlan M. Mackinnon , David H. Marwick , M. Howard Williams, A Model for Query Decomposition and Answer Construction inHeterogeneous Distributed Database Systems, Journal of Intelligent Information Systems, v.11 n.1, p.69-87, Aug. 1, 1998 [doi>10.1023/A:1008630910890]
• 11: Praveen Madiraju , Rajshekhar Sunderraman, A mobile agent approach for global database constraint checking, Proceedings of the 2004 ACM symposium on Applied computing, March 14-17, 2004, Nicosia, Cyprus [doi>10.1145/967900.968043]
• 12: P. Madiraju and R. Sunderraman. An Efficient Constraint Planning Algorithm for Multidatabases. Accepted in 2005 ACS/IEEE International Conference on Computer Systems and Applications, Cairo, Egypt, Jan, 2005
• 13: F. Ozcan, S. Nural, P. Koksal, C. Evrendilek, A. Dogac: Dynamic Query Optimization in Multidatabases. Bulletin of the IEEE Computer Society Technical Committee on Data Engineering, 1997.

INDEX TERMS

Primary Classification:
  H. Information Systems
  H.2 DATABASE MANAGEMENT
      H.2.4 Systems

Keywords:
distributed information retrieval, global queries/updates, multidatabases, system of databases