Shu-Chin Su Chen, Mike Yu, Yen-Yao Yao, San-Yih Hwang and B. Paul Lin
Computer and Communication Research Laboratories
Industrial Technology Research Institute
A00D, Bldg. 14, 195 Sec. 4 Chung Hsin Rd.
Chutung, Hsinchu, Taiwan, R.O.C.
We have developed a multidatabase system prototype called virtual DBMS (VDBMS) that integrates DBMSs developed independently. The VDBMS addresses several research and engineering issues. It incorporates schema integration, global query processing/optimization, global transaction processing, data dictionary management, and security enforcement. This paper describes our experience in the design and implementation of the VDBMS. We also discuss the design choices of various components of the VDBMS and the performance bottleneck we observed in the prototype. We believe these lessons are essential for practitioners as well as researchers to identity the important aspects of a multidatabase design.
Keywords: multidatabases, interoperability, database system design, client-server architecture, distributed databases
Received December 9, 1994; revised December 17, 1996.
Communicated by Wen-Hsiang Tsai.