IMPLEMENTATION OF AN OPEN SYSTEMS APPLICATION ENVIRONMENT RDBMS COMPARATIVE ANALYSIS BACKGROUND AND OVERVIEW The Defense Finance and Accounting Services Financial Systems Organization (DFAS) plans to establish a standard development and operational environment for DFAS applications running on workstations, network servers, and mid-tier platforms. To accomplish this, the Government has commissioned a study to 1) evaluate currently used development environments and industry standards and 2) perform an analysis of these alternative development environment; identifying the most effective solutions for DFAS.A key component of this planned Open Systems Application Environment (OSAE) i ...view middle of the document...
ANSI has also adopted a standard for Embedded SQL as defined in the document ANSI X3.168-189 "Database Language Embedded SQL".The current SQL standard, ANSI SQL-92 is defined in FIPS PUB 127-2, ANSI X3.135-1992, and ISO 9075:1992.DFAS DEFINED RDBMS REQUIREMENTS Following is an overview of DFAS requirements for the RDBMS component of the Open Systems Application Environment.• The selected database must have full ANSI SQL Compliance • The RDBMS must be easily transported to the Oracle RDBMS which is currently in use on the DFAS mid-tier systems.• The RDBMS must provide salability from the workstation, Netware server, mid-tier, to the mainframe platforms.OVERVIEW OF FINDINGS AND CONCLUSIONS After careful review of the Government's requirements, in conjunction with a thorough evaluation of three RDBMSs, it is the evaluator's recommendation that DFAS standardize on the Oracle RDBMS. Key factors affecting the recommendation include Oracle's industry proven open and scalable architecture and it's superior ability to integrate into the current DFAS environment.The other two RDBMSs that were evaluated are IBM's DB2 and SYBASE's System 10. Though these RDBMS provided several capabilities that can meet the Government's needs, Oracle provided a far more comprehensive and superior solution.Below is an brief overview of the three RDBMSs reviewed, followed by a comparative analysis.RDBMS OVERVIEWS ORACLE7 RDBMS The Oracle7 Server is a relational database management system that enables true enterprise data management from the desktop to the data center. Oracle7's scalable, reliable, integrated server architecture dynamically adapts to exploit uniprocessor and parallel hardware, to deliver unprecedented performance, salability, and availability providing unmatched price performance. Flexible, integrated, manageable distributed database facilities facilitate the deployment of practical distributed solutions that meet specific business needs. Oracle7 includes all the facilities necessary to construct enterprise-class applications, assure end-to-end user and data security, and comprehensively manage the Oracle environment.For high-performance transaction processing, Oracle7 employs an integrated, multithreaded, multiserver architecture to handle thousands of simultaneous user requests. Through its adaptable parallel architecture, Oracle ensures optimal performance, salability, and availability facilitating organizational growth and data access predictability.The sophisticated data concurrency control model of the Oracle7 Server ensures the powerful support for a multitude of processing requirements including, but not limited to On-line Transaction Processing and Decision Support, thus meeting specific and varied application requirements.Distributed database query and transaction processing requirements are also supported with the Oracle7 Server. Developers and users can treat a physically distributed database as a single logical database though...