November 11, 2019
  • Home
  • BIGDATA
  • The difference between oracle and MS SQL Server
difference between Oracle and Microsoft SQL Server

The difference between oracle and MS SQL Server

By on June 29, 2019 0 360 Views

The relational database has a very important role in the information system of companies, in the market we can find several software vendors that offers relational database, among the main relational database management systems are Oracle and Microsoft Sql server that presents several major differences, likely to influence the choice of companies. So we will start a new adventure in order to discover the difference between Oracle and Microsoft SQL Server.

In the IT market there are many relational database management systems, Among the RDBMS are Microsoft Access, PostGry, Sybase, and MySQL, in a first level the leaders of RDBMS are Microsoft SQL server and Oracle. There are several similarities and also essential differences between the two RDBMS. These differences usually relate to the command languages, the organization of database objects, and also the support of transactions.

sql

If we want to talk about the difference between Oracle and MS SQL Server, the first factor is the language they use, while Oracle and MS SQL Server have improved version of SQL Structured Query Language. However Oracle uses PL / SQL or Procedural Language / SQL and Oracle and MS SQL Server use T-SQL or Transact SQL.

PL / SQL and T-SQL are enhanced versions of SQL, while each has a different syntax and capability. One of the differences between T-SQL and PL / SQL is the way they support variables and native functions. For Oracle we have the ability to group procedures in packages with PL / SQL so we can do that in MS SQL Server. In general T-SQL is simpler and easier to use while PL / SQL is very powerful and more complicated.

Transaction control

Transaction Control is one of the major differences between the two systems MS SQL Server and Oracle, while a transaction is a group of operations or tasks to be treated as an individual unit.

Normally with MS sql Server it is impossible to go back in case of errors when executing a request because it executes each command individually. The “BEGIN TRANSACTION” command starts the start of a transaction. The “COMMIT” statement is used to write the changed data to disk and terminate the transaction.

Under Oracle the principle is different, because each new connection to a database corresponds to a transaction. As a result, the changes related to requests and commands only take place in memory. The validation will be confirmed after the validation of the COMMIT command.

The organization of database objects

For database administrators, the major difference is how Oracle and MS SQL Server organize database objects in SQL Server. For Oracle, schemas group all database objects. These are shared among schemas and users. Even if everything is shared, administrators set up a permission system to govern access to data.

On MS SQL Server all objects are linked to a database, while each table, view, functions, procedure corresponds to one and only one database. Likewise, each database has a private disk file that is not shared on the server.

In conclusion, MS SQL Server and Oracle are leaders in the relational database market, despite the differences between the two systems, these two solutions can be used in an equivalent way

  BIGDATA
Leave a comment

Your email address will not be published. Required fields are marked *