Abstract

In database and information systems, increasing attention has been focused lately on parallel and distributed database systems. The future of large database systems lies into the realm of distributed computing. The main reason for this is that distributed computing can be constructed at a low cost without the need for any specialized technology, using existing sequential computers and relatively cheap computer networks. The basic motivations for distributed databases are improved performance, increased availability, share ability, expandability, and access flexibility. Oracle9i is one of the most famous database management systems that provide distributed features. Oracle9i supports transparent distributed gains to access data from multiple databases. It also provides many other distributed features, such as transparent distributed transactions and transparent automatic two-phase commit. This paper presents a distributed registration database system using Oracle9i distributed features such as replication and fragmentation. The analysis and design steps of the distributed registration database system are shown as well as to the practical steps required for implementing the distributed database system using Oracle9i.

Highlights

  • Distributed computing is one of the most recent and important development in the computing era

  • The maturation of Database Management System (DBMS) technology has coincided with significant development in distributed computing and parallel processing technology

  • The end result is the emergence of Distributed Database Management System (DDBMS) and parallel database management system

Read more

Summary

Introduction

Distributed computing is one of the most recent and important development in the computing era. When the data and DBMS software are distributed over several sites, one site may fail while other sites continue to operate. This improves both reliability and availability (Loose & Church, 2004). Oracle9i supplies a variety of techniques that can be used to establish inter-database connectivity and data sharing. Robust and complete solution that addresses all the needs that may arise when operating in a distributed environment It includes communication between users on the Oracle database using queues, data replication, and distributed data access in both homogenous and heterogeneous environments (Oracle Corporation, 2002a; Oracle Corporation, 2002c).

Oracle9i Distributed Features
Distributed Terminology
Transparency
Replication
Design of the Distributed Registration System
Development and Implementation
Conclusion
Full Text
Paper version not known

Talk to us

Join us for a 30 min session where you can share your feedback and ask us any queries you have

Schedule a call

Disclaimer: All third-party content on this website/platform is and will remain the property of their respective owners and is provided on "as is" basis without any warranties, express or implied. Use of third-party content does not indicate any affiliation, sponsorship with or endorsement by them. Any references to third-party content is to identify the corresponding services and shall be considered fair use under The CopyrightLaw.