[go: up one dir, main page]
Scribd
Upload
34 views8 pages

Intro To DBMS

The document provides an introduction to database management systems (DBMS). It discusses data and information, limitations of file processing systems, definitions of a database and DBMS, and types of databases. It also outlines advantages of using a database such as controlling redundancy, avoiding inconsistency, and restricting unauthorized access.

Uploaded by

Ravi Varma D V S
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
34 views8 pages

Intro To DBMS

The document provides an introduction to database management systems (DBMS). It discusses data and information, limitations of file processing systems, definitions of a database and DBMS, and types of databases. It also outlines advantages of using a database such as controlling redundancy, avoiding inconsistency, and restricting unauthorized access.

Uploaded by

Ravi Varma D V S
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
You are on page 1/ 8

Intro to DBMS

Prepared by Harish Patnaik

School of Computer Engineering, KIIT Deemed to be University


Content

1. Data & Information


2. imitations of File processing System
3. Database
4. DBMS
5. TYpes of database
6. Advantages of databse
Introduction

• Data
• Known facts that can be recorded
• Raw facts, unprocessed facts
• Information
• Processed data
• Understood by user
Data management focuses on the generation,
storage & retrieval of data
Limitations of File Processing System

Redundancy Problem
• Repetitive data
• Data-inconsistency problem
• Incorrectness of data
• Lack of data integration
• Complex & time consuming
Database

ü It is a collection of interrelated data


ü It is a shared, integrated structure that stores -
• End- user data: raw facts of interest to the end-user
• Meta data: through which the end-user data are
integrated & managed. The metadata provides a
description of the data characteristics and the set
of relationships that link the data present in the
database
ü Database is an organized collection of data of an
organisation
DBMS

• It is a collection of programs that manages structure &


controls the access to the data stored in the database
• It includes tools to add, modify or delete data from the
database, ask questions (or queries) about the data stored in
the database and produce reports
• DBMS serves as the interface between the user & the
database
Types of Database

• Single user database system


• Multi-user database system
• Centralised database system
• Distributed database system
• Relational database system
• NoSQL database system - MongoDB
•Object oriented database -PostgreSQL
• Hierarchical Database - XML data storage
•Network Database - Ingres database
Advantages of Database

• Controls Redundancy
• Avoids Inconsistency
• Allows Data Sharing
• Restricting Unauthorized Access
• Providing Storage Structures for efficient query
processing
• Facilitates Backup & Recovery
• Enforcing Integrity Constraints
• Supports data isolation

You might also like