DATABASE MANAGEMENT SYSTEM
Data and Information
Data is raw, unorganized facts that need to be processed. Data can be something
simple and useless until it is organized.
When data is processed, organized, structured or presented in a given context
so as to make it useful, it is called information.
Database
The database is a collection of inter-related data which is used to retrieve, insert
and delete the data efficiently. It is also used to organize the data in the form of a table,
schema, views, and reports, etc.
For example: The college Database organizes the data about the admin, staff, students
and faculty etc.Using the database, you can easily retrieve, insert, and delete the
information.
Database Management System
Database management system is software which is used to manage the database.
For example: MySQL, Oracle, SQL Server etc are a very popular commercial database
which is used in different applications.
DBMS provides an interface to perform various operations like database creation,
storing data in it, updating data, creating a table in the database and a lot more.It
provides protection and security to the database. In the case of multiple users, it also
maintains data consistency.
DBMS allows users the following tasks:
o Data Definition: It is used for creation, modification, and removal of definition
that defines the organization of data in the database.
o Data Updation: It is used for the insertion, modification, and deletion of the
actual data in the database.
o Data Retrieval: It is used to retrieve the data from the database which can be
used by applications for various purposes.
o User Administration: It is used for registering and monitoring users, maintain
data integrity, enforcing data security, dealing with concurrency control,
monitoring performance and recovering information corrupted by unexpected
failure.
, Characteristics of DBMS
A database management system has following characteristics:
1. Data stored into Tables: Data is never directly stored into the database. Data is
stored into tables, created inside the database. DBMS also allows to have
relationships between tables which makes the data more meaningful and
connected. You can easily understand what type of data is stored where by
looking at all the tables created in a database.
2. Reduced Redundancy: In the modern world hard drives are very cheap, but
earlier when hard drives were too expensive, unnecessary repetition of data in
database was a big problem. But DBMS follows Normalisation which divides the
data in such a way that repetition is minimum.
3. Data Consistency: On Live data, i.e. data that is being continuously updated
and added, maintaining the consistency of data can become a challenge. But
DBMS handles it all by itself.
4. Support Multiple user and Concurrent Access: DBMS allows multiple users to
work on it (update, insert, and delete data) at the same time and still manages to
maintain the data consistency.
5. Query Language: DBMS provides users with a simple Query language, using
which data can be easily fetched, inserted, deleted and updated in a database.
6. Security: The DBMS also takes care of the security of data, protecting the data
from un-authorized access. In a typical DBMS, we can create user accounts with
different access permissions, using which we can easily secure our data by
restricting user access.
Data and Information
Data is raw, unorganized facts that need to be processed. Data can be something
simple and useless until it is organized.
When data is processed, organized, structured or presented in a given context
so as to make it useful, it is called information.
Database
The database is a collection of inter-related data which is used to retrieve, insert
and delete the data efficiently. It is also used to organize the data in the form of a table,
schema, views, and reports, etc.
For example: The college Database organizes the data about the admin, staff, students
and faculty etc.Using the database, you can easily retrieve, insert, and delete the
information.
Database Management System
Database management system is software which is used to manage the database.
For example: MySQL, Oracle, SQL Server etc are a very popular commercial database
which is used in different applications.
DBMS provides an interface to perform various operations like database creation,
storing data in it, updating data, creating a table in the database and a lot more.It
provides protection and security to the database. In the case of multiple users, it also
maintains data consistency.
DBMS allows users the following tasks:
o Data Definition: It is used for creation, modification, and removal of definition
that defines the organization of data in the database.
o Data Updation: It is used for the insertion, modification, and deletion of the
actual data in the database.
o Data Retrieval: It is used to retrieve the data from the database which can be
used by applications for various purposes.
o User Administration: It is used for registering and monitoring users, maintain
data integrity, enforcing data security, dealing with concurrency control,
monitoring performance and recovering information corrupted by unexpected
failure.
, Characteristics of DBMS
A database management system has following characteristics:
1. Data stored into Tables: Data is never directly stored into the database. Data is
stored into tables, created inside the database. DBMS also allows to have
relationships between tables which makes the data more meaningful and
connected. You can easily understand what type of data is stored where by
looking at all the tables created in a database.
2. Reduced Redundancy: In the modern world hard drives are very cheap, but
earlier when hard drives were too expensive, unnecessary repetition of data in
database was a big problem. But DBMS follows Normalisation which divides the
data in such a way that repetition is minimum.
3. Data Consistency: On Live data, i.e. data that is being continuously updated
and added, maintaining the consistency of data can become a challenge. But
DBMS handles it all by itself.
4. Support Multiple user and Concurrent Access: DBMS allows multiple users to
work on it (update, insert, and delete data) at the same time and still manages to
maintain the data consistency.
5. Query Language: DBMS provides users with a simple Query language, using
which data can be easily fetched, inserted, deleted and updated in a database.
6. Security: The DBMS also takes care of the security of data, protecting the data
from un-authorized access. In a typical DBMS, we can create user accounts with
different access permissions, using which we can easily secure our data by
restricting user access.
