A Non-Parametric Analogy between Oracle & MySQL

Syeda Binish Zahra

  • Syed Muhammad Shabih-ul-Hassan Professional Academy of Commerce
  • Syeda Binish Zahra NCBAE
  • Sadia Kuasar Lahore College for Women University
  • SUNDUS MUNIR, Lahore College for Women University
  • Afrozah Nadeem University of Engineering and Technology
Keywords: Data Model (DM), Data Definition Language (DDL), Entity Relationship Diagram (ERD), Database Administration (DBA), Query Execution Plan (QEP), Automatic Workload Repository (AWR), configuration management pack (CMP), Oracle Manager Console (OMC), Oracle Real Application Cluster (Oracle RAC)

Abstract

Database Servers store, manipulate and retrieve critical information. In current computing era these database servers are often exercise unauthorized access, security breaches and violation. A sub field of digital forensic called Database Forensic deals with the study of database and about their data. Oracle server and SQL Server are two database server actively used by digital industry for their data store. This research paper is a detailed non parametric comparison between oracle server and SQL Server that helps forensic investigators in DB tool selection for the sake of forensic analysis and investigation of databases. According to findings oracle is more secure than SQL, oracle data types are more flexible than SQL. Both tools are good at query optimization but oracle is more expensive than SQL. This comparison is made with the expectation of escalating research in database forensic analysis and investigation areas.

Published
2020-09-01