Adoption of database technology: A comparative study

Abstract

Database now a days,  has become an essential part for keeping any records secured and privatized In earlier we had least databases with unique features with their own. But as the era rises on, numerous databases came into existence. Among those Microsoft SQL server versions and Oracle database became the best but on the counterpart they have a war among themselves too. Each has some unique features and drawbacks. Hence, this white paper discusses that which database server Oracle or Microsoft SQL server is better in different aspects. It studies the working and response of both the databases in different realms. This paper is divided into four main parts. The first part discusses the security issues of oracle and Microsoft SQL server. The second discusses the comparative cost study which includes administration cost also. Third discusses the platform dependency of each of the database that which is more platform supportive, next highlights the performance issues in both the databases which includes scalability, reliability and availability of Oracle RAC and Microsoft SQL server. Performance comparison is also represented in tabular form. In each section, comparison between these two databases is done. In last section, it consists conclusion drawn analyzing all the data.

Keywords: Security comparison, Cost comparison, Platform dependency, Performance comparison