What is Oracle server’s implementation of RDBMS and ORDBMS? PowerPoint PPT Presentation

presentation player overlay
About This Presentation
Transcript and Presenter's Notes

Title: What is Oracle server’s implementation of RDBMS and ORDBMS?


1
What is Oracle servers implementation of RDBMS a
nd ORDBMS?
  • In todays IT world for controlling the storage,
    organization and back up of data a Data Base
    Management System.
  • SQL is a Structured Query Language for used for
    retrieving data form the database.

2
Characteristics of a Relational Database
  • Structures For accessing data from the data
    base. Tables, views, and indexes are examples of
    structures in Oracle.
  • Operations For defining the structure or to
    change data between the structures are the
    actions .
  • SELECT statements and CREATE statements are
    types of operations in Oracle.
  • Integrity rules regulate what kinds of actions
    are allowed on data and the information base
    framework.

3
Oracle utilizes the RDBMS features using the
following set of structures
  • Tables are used for data storage.
  • Views and synonyms are created for data access.
  • Indexes are used to speed up data retrieval.
  • Primary keys, foreign keys, and unique keys are
    called constraints and are created to enforce
    data integrity.
  • Triggers are created to satisfy the business
    rules
  • Roles and privileges are used for security.
  • Procedures, functions, and packages are used to
    code the application.

4
  • Thus you can join the oracle training institute
    in Pune.

5
  • Thank You
Write a Comment
User Comments (0)
About PowerShow.com