Relational Database Management System

Running Head: RDBMS
Relational Database Management System
Name of the Student
Name of the University
Author Note

RDBMS
1
About Oracle and Microsoft SQL Server
Oracles is a relational database management system that is a huge vendor for the
Information technology market. It supports the business intelligence, transactions processing,
analytics application, and data storage tools. The features of this system are high availability,
security, online analytical processing, management of data graph and spatial. It ensures security
by encryption with high authentication (Greenwald et al., 2013).
Microsoft SQL Server is a relational data base management system. It is a software
product that retrieve and stores data for other application. The features are this are less
vulnerable, robust auditing, data masking, and transparent data encryption. It provides BI
solutions to multi-dimension and tabular forms of queries of models (Korytkowski et al., 2015).
Handling concurrent updates by Oracle and Microsoft SQL Server
Oracle handles concurrent updates by two locking system are Pessimistic locking and
Optimistic locking. Pessimistic locking occurs when a record is locked till its use is finished. Its
application is designed to avoid Deadlock. Whereas, in Optimistic locking the record is read, and
checks for changes before the record is written back. If no changes are made then the version is
updated in one hit. And if not then the transaction is aborted and re-started.
The Row Versioning process in SQL server is used for handling concurrent updates. It
works by keeping record of the old transactions and checks for modification. When an update
occurs in the row of transaction-table a sequence number is assigned to the updated row (Mistry
& Misner, 2014). The old version of row gets stored in version store, and this process continues
till the transaction goes on.