Comparative Evaluation and Investigation of MS SQL Server 2000 and Oracle 9i with respect to Integrity and SQL 2003 Standards
Database Management and transaction processing systems occupy a crucial position in our information technology-based world. It is imperative that these systems function correctly and reflect real world actions on the data that they store, manage and manipulate. The constantly evolving nature of RDBMSs has lead to database wars among the various vendors in the market. This is evidenced by each vendor in the market making claims of the superiority of his product, hence making the task of choosing a RDBMS not an easy one for a DBA. Thus, the DBMS selection process requires consideration, knowledge and skills. One of the major drives behind the development of RDBMSs is to ensure data consistency, yet this is one of those things that do not seem like an obvious topic for Database Administrators to address directly. Furthermore this has been totally ignored by database benchmarks. Oracle and SQL Server are well established DBMSs, which are amongst the world’s “Big three” DBMSs and are very strong rivals. This project gives an overview of a comparative evaluation of Oracle 9i and Microsoft SQL Server 2000 with respect to Integrity and conformity to the SQL 2003 standards. The results of testing and evaluating the current Database Management Systems help to highlight the problems found in each, hence allowing for improvements if necessary.
Database Management and transaction processing systems occupy a crucial position in our information technology-based world. It is imperative that these systems function correctly and reflect real world actions on the data that they store, manage and manipulate. The constantly evolving nature of RDBMSs has lead to database wars among the various vendors in the market. This is evidenced by each vendor in the market making claims of the superiority of his product, hence making the task of choosing a RDBMS not an easy one for a DBA. Thus, the DBMS selection process requires consideration, knowledge and skills. One of the major drives behind the development of RDBMSs is to ensure data consistency, yet this is one of those things that do not seem like an obvious topic for Database Administrators to address directly. Furthermore this has been totally ignored by database benchmarks. Oracle and SQL Server are well established DBMSs, which are amongst the world’s “Big three” DBMSs and are very strong rivals. This project gives an overview of a comparative evaluation of Oracle 9i and Microsoft SQL Server 2000 with respect to Integrity and conformity to the SQL 2003 standards. The results of testing and evaluating the current Database Management Systems help to highlight the problems found in each, hence allowing for improvements if necessary.
…
Website: is.ru.ac.za | Filesize: 1118kb
No of Page(s): 96
Click here to download Comparative Evaluation and Investigation of MS SQL Server 2000 and Oracle 9i with respect to Integrity and SQL 2003 Standards.
Related Tutorial
Tags: data types, database management, database server, database tables, Oracle, SQL, sql data, SQL Query, SQL Server
Comments
Leave a Reply