A CORBA-based Multidatabase System—panorama Project
Lou Qin-jian,Sarem Mudar,Li Rui-xuan,Xiao Wei-jun,Lu Zheng-ding,Chen Chuan-bo
DOI: https://doi.org/10.1007/bf02902059
2003-01-01
Abstract:Panorama is a multidatabase system (MDBS) developed in HUST. The project aims to achieve interoperability among existing, heterogeneous, 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 infrastructure. Panorama can provide its users a single common data model and a single global 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 data model, a schema integrator, a global query language, and a global query processing and optimization. We first discuss the architecture and components of Panorama system. We also discuss the schema integration in this system. And we extend our discussion to the query language, transaction management, and the query processing developed for this system. Finally, a conclusion and the future work for our designed system have been given.