Scribd
Upload
9 views4 pages

Database Management System

The document provides a comprehensive overview of Database Management Systems, covering various architectures, storage structures, data models, and relational database design. It discusses transaction management, backup and recovery techniques, query processing, database security, and SQL/PLSQL functionalities. Additionally, it addresses emerging database technologies and their limitations.

Uploaded by

asb.asb.asbgfd
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
9 views4 pages

Database Management System

The document provides a comprehensive overview of Database Management Systems, covering various architectures, storage structures, data models, and relational database design. It discusses transaction management, backup and recovery techniques, query processing, database security, and SQL/PLSQL functionalities. Additionally, it addresses emerging database technologies and their limitations.

Uploaded by

asb.asb.asbgfd
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Database Management System – Concepts and Architectures

Introduction and Purpose


Database Architectures
o Centralized
o Client-Server
o Server system
Transaction servers
Data servers
Cloud based servers
o Parallel
o Distributed
o Web based system
Web architecture (2 tier, 3 tier, N-tier Architecture)
Web services – SOAP
Database Storage Structures
Introduction
Database – Table-space, Segment, Extent, Block, Data File
Indexing, Hashing, Clusters
Data Dictionary and Dictionary Views
Data Models
Introduction to various data models – Record based & Object
based
Cardinality Ratio & Relationships
Representation of entities, attributes, relationship attributes, and
relationship set, Generalization, aggregation
Structure of relational Database and different types of keys
Codd’s rules and Relational data model & relational algebra
Relational Database design
Basic System Development Life Cycle
Database Design – ER to Relational
Functional dependencies
Normalization
Normal forms based on primary keys (1NF, 2NF, 3NF, BCNF,
4NF, 5NF)
Loss less joins and dependency preserving decomposition
Transaction Management
Introduction
What is a Transaction?
o Transaction Properties
o Transaction Management with SQL
o The Transaction Log
Concurrency Control
o Concurrency control with Locking Methods
o Types of Locks
o Two-Phase Locking to Ensure Serializablility
o Deadlocks
Concurrency Control Methods
Backup and Recovery Techniques
Introduction
User Managed Backups
Recovery Manager Backups - RMAN
Transaction Recovery
System Recovery
Media Recovery
Query Processing and Evaluation
Introduction
Query Interpretation
Equivalence of Expressions
o Selection Operation
o Natural Join Operations
o Projection Operations
o Three-Way Join
Estimation of Query-Processing Costs
Estimation of Costs of Access Using Indices
Structure of Query Optimizer
Database Security and Authorization
Introduction
Security and Integrity Violations
Managing Users
Authorization-Privileges and Roles
Views
Integrity Constraints
Database Auditing
PL/SQL
SQL:
DDL(Data Definition Language)
DML(Data Manipulation Language)
DRL(Data Retrieval Language)
DCL(Data Control Language)
TCL(Transaction Control Language)
SQL Functions and Aggregate Functions
Join Operations
Views
Audit Trails
Plan Table
PL:
PL/SQL Block
Control Structures
Cursor, Trigger
Procedure
Functions
Emerging Databases and Case Studies
Limitations of Conventional Databases
Multimedia Database,
Temporal Databases,
Spatial Databases
Cloud Databases
Google Big Table
No SQL
SQLite

You might also like