Oracle

What is a Database?

- Database is a software in which interrelated data is stored with controlled redundancy. The database also provides common set of routines to access/manipulate the data in the database.

Advantages of database

• Reduced Redundancy
• Reduced inconsistency of data
• Data Sharing due to centralization
• Better security and standards enforcement
• Better integrity management
• Concurrency control

Data Base Management System

Transaction Processing

Concurrency Management

Recovery
Security
Language Interface
Data Catalog

Storage Management

Database Models

Database models differ in the way relationships are enforced. 

There are 5 models:

• 
  
• Hierarchical Model
• Network Model
• Relational Model
• Object Oriented Model
• Deductive Inference Model

Hierarchical Model

•Data is organized as files and records

•Relationship is through logical proximity in a linearized tree

•Access language is procedural

Network Model

Data is organized as Files and Records.

Relationships is through intersecting networks

Access language is procedural