Abstract
One way of achieving interoperability among heterogeneous, distributed DBMs is through a multidatabase system. Recently, there is an increasing use of CORBA implementation in developing multidatabase systems. Panorama is a multidatabase system that has been implemented on the top of CORBA compliant namely VisiBroker. It aims to achieve interoperability among Oracle, Sybase and other different DMBSs through the registration of these DBMSs to Panorama and through the single global query language-PanoSQL designed for this system. In this paper, we first introduce CORBA for the interoperability in multidatabase systems. Then, a general view for our designed multidatabase system. Panorama, has been given. In section four, we introduce the global query language-PanoSQL designed to achieve interoperability among the different DBMSs implemented in Panorama. Then, as an example, we present the registration of Oracle to panorama in order to achieve interoperability in this system. And, finally, a conclusion and the future work for this system have been given.
Similar content being viewed by others
References
Dogas A, Dengi C, Kilic E,et al. METU Interoperable Database System.ACM SIGMOD Record, 1995,24 (3): 56–61.
Gopi K. Attaluri. Concurrency Control of Unstructured Data in an Interoperable Environment: [Ph. D. Thesis]. The University of Waterloo: Computer Science Department, Canada, 1996. (Ch)
Laks V S Lakshmanan, Fereidoon Sadri, Iyer N Subramanian. ScemaSQL A Language for Interoperability in Relational Multi-database SystemsProc of the 22 nd VLDB Conference, Mumbai (Bombay), India, 1996, 239–250.
P Scheuermann, C Yu, A Elmagarmid,et al. Report on the Workshop on Heterogeneous Database Systems.SIGMOD Record, New York: ACM, 1990,19: 23–31.
Silberschatz A, Stonebraker M, Ullman J F. Database systems: Achievements and Opportunities.Communications of the ACM, 1991,34(10): 110–120.
Ahmed Elmagarmid, Marek Rusinkiewicz, Amit Sheth.Management of Heterogeneous and Autonomous Database Systems. San Francisco: Morgan Kaufmanns, 1999.
Michael Stonebraker, Paul Brown, Martin Herbach. Interoperability, Distributed Applications and Distributed Databases: The Virtual Table Interface.Bulletin of the IEEE Computer Society Technical Committee on Data Engineering, 1998,21(3): 25–33.
A Dogac, C Dengi, E Kilic,et al. A Multidatabase System implementation on CORBA.The 6 th Int’l Workshop on Research Issues in Data Engineering (RIDE-NDS’96), New Orleans, 1996, 2–11.
Mudar Sarem. Interoperability of Global-schema Multidatabase Systems; [Ph D Thesis]. Wuhan: Huazhong University of Science and Technology, School of Computer Science and Technology, China, 2002.
Ozhan G, Dogac A, Kilic E,et al. Making Oracle7, Sybase, and Adabas D Interoperable Through CORBA: MIND Project.Proc of European Oracle User Group Conference, Amsterdam, 1996, 1047–1058.
Mudar Sarem, Li Rui-xuan, Xiao Wei-jun,et al. Registering Different DBMSs to Panorama with CORBA.Wuhan University Journal of Natural Sciences, 2001,6 (1–2): 423–431.
Author information
Authors and Affiliations
Additional information
Foundation item: Supported by the National High Performance Foundation of China
Biography: Sarem Mudar (1966-), male, Ph.D candidate, research direction: multidatabase systems.
Rights and permissions
About this article
Cite this article
Mudar, S., Rui-xuan, L., Wei-jun, X. et al. The interoperability of distributed DBMSs in a CORBA-based multidatabase system. Wuhan Univ. J. Nat. Sci. 7, 408–414 (2002). https://doi.org/10.1007/BF02828239
Received:
Issue Date:
DOI: https://doi.org/10.1007/BF02828239