Scribd
Upload
19 views3 pages

Chapter1 Introduction To DBMS

A database is a structured collection of data stored electronically, while a Database Management System (DBMS) is software that facilitates data management and access. DBMS offers advantages such as reduced data redundancy, improved security, and better performance compared to traditional file systems. However, it also has limitations, including high costs and complexity in management.

Uploaded by

Amit Shekhar
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
19 views3 pages

Chapter1 Introduction To DBMS

A database is a structured collection of data stored electronically, while a Database Management System (DBMS) is software that facilitates data management and access. DBMS offers advantages such as reduced data redundancy, improved security, and better performance compared to traditional file systems. However, it also has limitations, including high costs and complexity in management.

Uploaded by

Amit Shekhar
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

Chapter 1: Introduction to Database and DBMS

What is a Database?

A database is a structured collection of data that is stored and accessed electronically. It is designed

to efficiently store, retrieve, and manage large amounts of information.

Example: A bank database might store customer records, account balances, transactions, and loan

information.

What is DBMS (Database Management System)?

A DBMS is software that interacts with the user, application, and database to capture and analyze

data. It provides an interface to perform operations like data insertion, update, deletion, and

retrieval.

Components of DBMS:

1. Hardware - Physical devices (computers, servers, storage).

2. Software - DBMS software (e.g., MySQL, Oracle).

3. Data - Actual data stored in databases.

4. Users - DBA, developers, end users.

5. Procedures - Instructions and rules to manage DBMS.

6. Database Access Language - SQL (Structured Query Language).

Structure of DBMS:

- Tables: Rows and columns representing records and fields.

- Schemas: Logical structure of the database.

- Indexes: Used to quickly access data.

- Views: Virtual tables for custom data presentation.

- Stored Procedures: Precompiled SQL statements for automation.


Comparison: Traditional File System vs DBMS:

Feature File System DBMS

--------------------------------------------------------

Data Redundancy High Low

Data Integrity Poor High

Security Limited Strong

Querying Manual/Slow Optimized/SQL Based

Concurrency Control Not supported Supported

Backup and Recovery Manual Automated

Advantages of DBMS:

- Minimizes data redundancy

- Ensures data integrity and security

- Allows concurrent access

- Supports backup and recovery

- Facilitates data sharing

- Provides data abstraction and independence

Limitations/Drawbacks of DBMS:

- High cost of installation and maintenance

- Needs skilled personnel (DBA, Developers)

- Performance overhead for small applications

- Complexity in setup and management

Summary:

- A database is a structured data collection.


- A DBMS manages and provides access to the database.

- DBMS overcomes the limitations of traditional file systems by providing better security, integrity,

and performance.

- It involves various components and has a specific architecture.

You might also like