A Detailed Comparison of Oracle and Microsoft SQL Server RDBMS Systems

Verified

Added on  2022/11/17

|5
|778
|370
Report
AI Summary
This report provides a comparative analysis of two leading Relational Database Management Systems (RDBMS): Oracle and Microsoft SQL Server. It delves into their functionalities, highlighting how each system handles concurrent updates, data recovery, and data access. Oracle's locking systems (pessimistic and optimistic) are contrasted with SQL Server's row versioning for managing concurrent updates. The report examines the tools used for data recovery in both systems, such as Oracle's Data Recovery Advisor and Recovery Manager, and SQL Server's Database Recovery Advisor. Furthermore, it explores how data is accessed and managed within each system, including Oracle Warehouse Builder and the use of Visual Basic with JET in SQL Server. The report concludes with a recommendation for the Colonial Adventure Tours Database, suggesting MS SQL Server due to its table organization and ease of modification, ensuring efficient data updates and minimal failure risk.
Document Page
Running Head: RDBMS
Relational Database Management System
Name of the Student
Name of the University
Author Note
tabler-icon-diamond-filled.svg

Paraphrase This Document

Need a fresh take? Get an instant paraphrase of this document with our AI Paraphraser
Document Page
1RDBMS
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.
Document Page
2RDBMS
Handling Data recovery by Oracle and Microsoft SQL Server
The data recovery is handled by Oracle by two tools such as Data Recovery Advisor tool
and Recovery Manager (RMAN) tool. In Data Recovery Advisor tool, recovery activities
integrate with sessions and accessed by Oracle Enterprise manager or command line. The Data
Recovery Advisor tool finds data failures, repair options and apply those repairs.
The data recovery done in MS SQL Server by Database Recovery Advisor that provides
restore plans such as its algorithms and point-in-time restores. The algorithm constructs the plans
for complicated recovery scenarios. A visual timeline is given for point-in-time recovery in order
to restore the data of the database.
Handling Data Access by Oracle and Microsoft SQL Server
The Oracle Warehouse builder manages data system accessible to JDBC through Code
Template. The Warehouse Builder manipulates data movement. It is often possible that a user
access data within a schemas, a database application runs and connects to a username present
inside the database, then the user can access all the objects inside that schema (Selene & Gong,
2014).
Data access becomes easy by using Visual Basic 3.0 and combining it with JET that is
Joint Engine Technology. The JET allows data access objects which is an object based model for
programming. It is very easy and efficient.
Recommendation of a DBMS
MS SQL Server is the best option to opt for the Colonial Adventure Tours Database as
the organisation of tables are done by names which is easy to access in long run. The
Document Page
3RDBMS
modification of the table is also easy as all the records are updates at the same time. Therefore,
less chance of failure in data updating.
tabler-icon-diamond-filled.svg

Paraphrase This Document

Need a fresh take? Get an instant paraphrase of this document with our AI Paraphraser
Document Page
4RDBMS
Reference
Greenwald, R., Stackowiak, R., & Stern, J. (2013). Oracle essentials: Oracle database 12c. "
O'Reilly Media, Inc.".
Korytkowski, M., Scherer, R., Staszewski, P., & Woldan, P. (2015, June). Bag-of-features image
indexing and classification in Microsoft SQL server relational database. In 2015 IEEE
2nd International Conference on Cybernetics (CYBCONF) (pp. 478-482). IEEE.
Mistry, R., & Misner, S. (2014). Introducing Microsoft SQL Server 2014. Microsoft Press.
Selene Xia, B., & Gong, P. (2014). Review of business intelligence through data analysis.
Benchmarking: An International Journal, 21(2), 300-311.
chevron_up_icon
1 out of 5
circle_padding
hide_on_mobile
zoom_out_icon
[object Object]