The book chapter is an extended version of the research paper entitled “Use of Component Integration Services in Multidatabase Systems”, which is presented and published by the 13th ISITA, the National Conference of Recent Trends in Mathematical and Computer Sciences, T.M.B. University, Bhagalpur, India, January 3-4, 2015. Information is widely distributed across many remote, distributed, and autonomous databases (local component databases) in heterogeneous formats. The integration of heterogeneous remote databases is a difficult task, and it has already been addressed by several projects to certain extents. In this chapter, we have discussed how to integrate heterogeneous distributed local relational databases because of their simplicity, excellent security, performance, power, flexibility, data independence, support for new hardware technologies, and spread across the globe. We have also discussed how to constitute a global conceptual schema in the multidatabase system using Sybase Adaptive Server Enterprise’s Component Integration Services (CIS) and OmniConnect. This is feasible for higher education institutions and commercial industries as well. Considering the higher educational institutions, the CIS will improve IT integration for educational institutions with their subsidiaries or with other institutions within the country and abroad in terms of educational management, teaching, learning, and research, including promoting international students’ academic integration, collaboration, and governance. This will prove an innovative strategy to support the modernization and large expansion of academic institutions. This will be considered IT-institutional alignment within a higher education context. This will also support achieving one of the sustainable development goals set by the United Nations: “Goal 4: ensure inclusive and quality education for all and promote lifelong learning”. However, the process of IT integration into higher educational institutions must be thoroughly evaluated, identifying the vital data access points. In this chapter, Section 1 provides an introduction, including the evolution of various database systems, data models, and the emergence of multidatabase systems and their importance. Section 2 discusses component integration services (CIS), OmniConnect and considering heterogeneous relational distributed local databases from the perspective of academics, Section 3 discusses the Sybase Adaptive Server Enterprise (ASE), Section 4 discusses the role of component integration services and OmniConnect of Sybase
References
[1]
Joshi, K. (2023) Chapter 6, Database Management. https://www.umsl.edu/~joshik/msis480/chapt06.htm
[2]
Kroenke, D. and Auer, D. (2007) Database Concepts. 3rd Edition, Prentice, New York.
[3]
Mansour, M. and Yang, W. (2017) History of Database Applications. Term Paper, Spring, The University of Rochester’s Computer Science Department, Rochester.
[4]
Lin, C. (2003) Object-Oriented Database Systems: A Survey.
Umar, A. (1988) Distributed Database Management Systems Issues and Approach. Technical Report, The University of Michigan, Ann Arbor.
[7]
Tsichritzis, A.K. (1978) The ANSI/X3/SPARC DBMS Framework Report of the Study Group on Database Management Systems. Information Systems, 1, 173-191. https://doi.org/10.1016/0306-4379(78)90001-7
[8]
Ozsu, T. and Valduriez, P. (2020) Principles of Distributed Database Systems. Springer Nature, Cham.
[9]
How Does the Evolution of Database Systems Happened? https://www.geekinterview.com/question_details/35087
[10]
What Are the Advantages of Relational Data Model? https://science.blurtit.com/634750/what-are-the-advantages-of-relational-data-model?expand_article=1
[11]
Berg, K.I., Seymour, T. and Goel, R. (2013) History of Databases. International Journal of Management & Information Systems, 17, 29-36. https://doi.org/10.19030/ijmis.v17i1.7587
[12]
Advantages of Relational Databases. https://techspirited.com/advantages-of-relational-databases
Ali, M.G. (2022) Adopting a Proxy Database to Prevent Direct Access to Distributed Transaction Databases Ensuring Information Security. Journal of Advances in Mathematics and Computer Science, 37, 43-55. https://doi.org/10.9734/jamcs/2022/v37i330441
[16]
Ali, M.G. (2010) A Framework for Creating Global Schema Using Global Views from Distributed Heterogeneous Relational Databases in Multidatabase System. Global Journal of Computer Science and Technology, 10, 31-35.
[17]
Ali, M.G. (2010) A Framework for Creating Global Schema Using Proxy Tables from Distributed Heterogeneous Relational Databases in Multidatabase System. International Journal of Computer and Electrical Engineering, 2, 846-851. https://doi.org/10.7763/IJCEE.2010.V2.238
[18]
Ali, M.G. (2010) Local Schemas Modifications Propagation and Maintenance of Metadata in Multidatabase System. International Journal of Computer Applications, 6, 6-9. https://doi.org/10.5120/1112-1456
[19]
Ali, M.G. and Murtuza, M.G. (2015) Use of Component Integration Services in Multidatabase Systems. 13th ISITA; National Conference of Recent Trends in Mathematical and Computer Sciences, Bhagalpur, 3-4 January 2015, 172-176.
[20]
Ali, M.G. (2009) Object-Oriented Approach for Integration of Heterogeneous Databases in a Multidatabase System and Local Schemas Modifications Propagation. International Journal of Computer Science and Information Security, 6, 55-60.
[21]
Ali, M.G. (2019) Method and System for Local and Distributed Remote Schemas Structure Modifications Propagation and Maintenance of Metadata of Multidatabase and All Subsequent Local Distributed Remote Databases. Copyright Retained with IIT Kharagpur, Reg. No. L-84975/2019, Copyright Office, Government of India.
[22]
Ko, C.Y. (2000) Three Approaches to a Multidatabase System. Proceedings of the Philippine Computing Science Congress (PCSC), Manila, 29 November-1 December 2000.
[23]
Czejdo and Taylor, M. (1991) Integration of Database System Using an Object-Oriented Approach. Proceedings of 1st International Workshop on Interoperability in Multidatabase Systems, Kyoto, 7-9 April 1991, 30-37.
[24]
Gotthard, W., Lockemann, P.C. and Neufeld, A. (1992) System-Guided View-Integration for Object-Oriented Databases. IEEE Transactions on Knowledge and Data Engineering, 4, 1-22. https://doi.org/10.1109/69.124894
[25]
Kaul, M., Drosten, K. and Neuhold, E.J. (1990) ViewSystem: Integrating Heterogeneous Information Bases by Object-Oriented Views. Proceedings of 6th International Conference on Data Engineering, Los Angeles, 5-9 February 1990, 2-10.
[26]
Koh, L. and Chen, A.L.P. (1994) Integration of Heterogeneous Object Schemas. In: Elmasri, R.A., Kouramajian, V. and Thalheim, B., Eds., Entity-Relationship Approach, Springer-Verlag, Berlin, 297-314. https://doi.org/10.1007/BFb0024375
[27]
Ching-Ming, C. (2001) Schema Integration between Object-Oriented Databases. Tomkang Journal of Science and Engineering, 4, 37-44.
[28]
Duwairi, R.M. (2003) A Framework for Generating and Maintaining Global Schemes in Hetrogeneous Multidatabases Systems. Proceedings of the 2003 IEEE International Conference on Information Reuse and Integration (IN-2003), Las Vegas, 27-29 October 2003, 200-207.
[29]
Chung, S.M. and Mah, P.S. (1995) Schema Integration for Multidatabase Using the Unified Relational and Object-Oriented Model. CSC‘95: Proceedings of the 1995 ACM 23rd Annual Conference on Computer Science, Nashville, 28 February-2 March 1995, 208-215. https://doi.org/10.1145/259526.259556
[30]
SAP Adaptive Server Enterprise, Component Integration Services Users Guide, Component Integration Services Overview. https://help.sap.com/docs/SAP_ASE/af9a1f6aa41e49cb8759274040665d0f/a9fc7fb1bc2b10149fe08325c19c990e.html?version=16.0.3.4
[31]
SAP Adaptive Server Enterprise (SAP ASE). https://www.sap.com/india/products/sybase-ase/features.html
[32]
SAP Sybase Adaptive Server Enterprise. https://www.sap.com/india/index.html?url_id=auto_hp_redirect_indial http://www.sybase.com/products/databasemanagement/adaptiveserverenterprise
[33]
Real Time Data Services 3.5, Replication Server Heterogeneous Replication Guide, Data Server Issues. https://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.rs_15.0.rshetrep/html/rshetrep/CHDJJBJG.htm
[34]
Olson, S. (1998) Distributed Query Processing Using Sybase Adaptive Server Enterprise and OmniConnect 11.9.2.
[35]
OmniConnectTM, Introducing OmniConnect for Sybase Adaptive Server Enterprise. https://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.rs_15.0.rshetrep/html/rshetrep/CHDJJBJG.htm
