A Compare and Contrast of Ms Sql Server and Oracle

A compare and contrast of MS SQL Server and Oracle

Darren Blake

CIS111006VA016-1118-001

11/30/2011

MS SQL server is a relational database management system (RDMS) developed by Microsoft. The term SQL stands for Structured Query language .This language is used to manage and administer the database server. It has two primary query languages: T-SQL and ANSI SQL. MS SQL a software product whose primary function is to store and retrieve data as requested by other software applications, be it those on the same computer or those running on another computer across a network (including the Internet). There are several editions of SQL server .The mainstream editions are datacenter, enterprise, Standard web Workgroup and express. Then there are the specialized editions: Azure, Compact (SQL CE), Developer, Embedded (SSEE), Evaluation, Fast Track, and Parallel Data Warehouse (PDW). The one main advantage of using SQL Server is the use of stored procedures. Stored procedures are lines of code that are called by the application. Microsoft SQL Server is quick for large and small businesses, so as the business grows, the SQL Server can handle the new volume of database requests. SQL Server can handle millions of records and transactions. SQL Server allows administrators to specify which tables and stored procedures users are able to access and query. This limits what records and user information can be queried, which protects the business's customer information. SQL Server also has procedures that allow the administrator to quickly restore a database when data is lost or corrupted, or the server has a hard drive crash. MS SQL Server is very easy to install.

Oracle is a very large and multi-user data management system. It was developed by Oracle Corporation. It is an excellent database for both client/server computing. Oracle supports all major operating systems for both clients and servers, including MSDOS, NetWare, UnixWare, OS/2 and most UNIX flavors. In...