5 drawbacks in File system and RDBMS importance

Oracle 12C new features
Oracle 12C new features

Oracle is a RDBMS. Before going into details, you need to know the drawbacks in file system and why you need to go for RDBMS.

Drawbacks in file systems

  • Redundancy -duplicate data
  • Inconsistency -changing data everywhere
  • Difficult to use – Difficult to search
  • Security – anybody can access it
  • Integrity  -constant rules you can apply

RDBMS supports 12 cardinal rules. Different RDBMS, who supports these rules

  1. Oracle
  2. SQL Server
  3. Teradata
  4. DB2
  5. Sybase
  6. Mysql

Difference between SQL and PL/SQL

SQL is a language to communicate with database structure query language.

PLSQL is a procedural language, where you can write SQL statements. And you can control execution of  SQL statements.

You can read difference between Function Vs Stored procedure

A2

Advertisements

Author: Srini

Experienced software developer. Skills in Development, Coding, Testing and Debugging. Good Data analytic skills (Data Warehousing and BI). Also skills in Mainframe.