A CORBA-Based Multidatabase System——Panorama Project

Panorama is a multidatabase system (MDBS) devel oped in HUST. The project aims to achieve interoperability among existing, heter ogeneous, federated database management systems such as Oracle8, Sybase, and DM2 (A database management system developed at HUST, Wuhan, China). This system is based on OMG’s distributed object management architecture and it is implemented on top of CORBA compliant, namely VisiBroker, which is used as its infrastructu re. Panorama can provide its users a single common data model and a single globa l query language named PanoSQL, which make it possible to incorporate different databases into the system. The main component of this system are interfaces for the Local DBMSs that participate in Panorama, a transaction manager, a common da ta model, a schema integrator, a global query language, and a global query proce ssing and optimization. We first discuss the architecture and components of Panorama system. We also dis cuss the schema integration in this system. And we extend our discussion to the query language, transaction management, and the query processing developed for t his system. Finally, a conclusion and the future work for our designed system ha ve been given.