ADVANCE DATABASE MANAGEMENT SYSTEM
Unit-1
Introduction of RDBMS / ADBMS
What is Data?
• Data is different types of information usually formatted in a
particular manner.
• Store meaningful information in proper structure and manner
its is called data.
• Data is information that has been translated into a form that
is efficient for movement or processing.
What is Information?
Information is defined as classified and organized data that has
some meaningful value for the user. Information is also the
processed data used to make decisions and take action.
What is Database?
A database is an organized collection of structured information, or
data, typically stored electronically in a computer system. A
database is usually controlled by a database management system
(DBMS). Together, the data and the DBMS, along with the
applications that are associated with them, are referred to as a
database system, often shortened to just database.
What is DBMS?
DBMS is a software or group of programs designed to perform
database operations such as creating a new database,
administering and managing the databases by performing various
user-specified database operations. The DBMS internally might
consist of a group of programs each performing different tasks
related to database management. Some DBMS examples, My
SQL, Oracle, System 2000, MS Access, My SQL server, etc.
2|Page
1
, ADVANCED DATABASE MANAGEMENT SYSTEM
What is RDBMS?
RDBMS is the collection of programs and capabilities that enables
the user to interact with a relational database. A relational
database management system (RDBMS) is a type of DBMS with
row-based table structure. Most commercial RDBMS is use SQL.
The most basic RDBMS functions are related to create, read,
update and delete operations, collectively known as the CRUD
cycle.
Features of RDBMS:
• An RDBMS is easily accessible using SQL commands.
• An RDBMS provides full data independence.
• The basic unit of data storage in a relational database is
called a table.
• A table consists of tuples/rows/records and each record has
one or more columns used to store values.
• In RDBMS, we can use conditional operations such as joins
and restrictions.
• An RDBMS enables data sharing between users.
• Also at the same time, you can ensure consistency of data
across multiple tables by using integrity constraints.
• An RDBMS minimizes the redundancy of data.
Advantages of RDBMS:
• Support for a very large database.
• Automatic optimization of searching (when possible).
• RDBMS has a simple view of the database that conforms to
much of the data used in businesses.
• RDBMS uses Structured Query Language.
• Easy extendibility, as new data may be added without
modifying existing records this is also known as scalability.
3|Page
2
, ADVANCED DATABASE MANAGEMENT SYSTEM
• RDBMS has data security which is critical when data sharing
is based on privacy.
• RDBMS defines how the data is organized and how the
relations among them are associated.
• It defines the entities and relationships among them. It
contains a descriptive detail of the database.
Disadvantages of RDBMS:
• No support for complex objects such as documents, video,
images.
• Often poor support for storage of complex objects.
• Still no efficient and effective integrated support.
Difference between DBMS RDBMS
ADBMS RDBMS
The concept of a relationship is not It is based on the concept of
there. relationship.
The speed of operation is slow. The speed of operation is fast
The hardware and software The hardware and software
requirements are very low. requirements are very high.
It uses the concept of files. It uses the concept of tables.
The facilities and utilities offered are The facilities and utilities offered are
limited. not limited.
DBMS normally uses a 3GL. RDBMS normally uses a 4GL.
Ex: Dbase, Fox base Ex: ORACLE, FOCUS
4|Page
3
Unit-1
Introduction of RDBMS / ADBMS
What is Data?
• Data is different types of information usually formatted in a
particular manner.
• Store meaningful information in proper structure and manner
its is called data.
• Data is information that has been translated into a form that
is efficient for movement or processing.
What is Information?
Information is defined as classified and organized data that has
some meaningful value for the user. Information is also the
processed data used to make decisions and take action.
What is Database?
A database is an organized collection of structured information, or
data, typically stored electronically in a computer system. A
database is usually controlled by a database management system
(DBMS). Together, the data and the DBMS, along with the
applications that are associated with them, are referred to as a
database system, often shortened to just database.
What is DBMS?
DBMS is a software or group of programs designed to perform
database operations such as creating a new database,
administering and managing the databases by performing various
user-specified database operations. The DBMS internally might
consist of a group of programs each performing different tasks
related to database management. Some DBMS examples, My
SQL, Oracle, System 2000, MS Access, My SQL server, etc.
2|Page
1
, ADVANCED DATABASE MANAGEMENT SYSTEM
What is RDBMS?
RDBMS is the collection of programs and capabilities that enables
the user to interact with a relational database. A relational
database management system (RDBMS) is a type of DBMS with
row-based table structure. Most commercial RDBMS is use SQL.
The most basic RDBMS functions are related to create, read,
update and delete operations, collectively known as the CRUD
cycle.
Features of RDBMS:
• An RDBMS is easily accessible using SQL commands.
• An RDBMS provides full data independence.
• The basic unit of data storage in a relational database is
called a table.
• A table consists of tuples/rows/records and each record has
one or more columns used to store values.
• In RDBMS, we can use conditional operations such as joins
and restrictions.
• An RDBMS enables data sharing between users.
• Also at the same time, you can ensure consistency of data
across multiple tables by using integrity constraints.
• An RDBMS minimizes the redundancy of data.
Advantages of RDBMS:
• Support for a very large database.
• Automatic optimization of searching (when possible).
• RDBMS has a simple view of the database that conforms to
much of the data used in businesses.
• RDBMS uses Structured Query Language.
• Easy extendibility, as new data may be added without
modifying existing records this is also known as scalability.
3|Page
2
, ADVANCED DATABASE MANAGEMENT SYSTEM
• RDBMS has data security which is critical when data sharing
is based on privacy.
• RDBMS defines how the data is organized and how the
relations among them are associated.
• It defines the entities and relationships among them. It
contains a descriptive detail of the database.
Disadvantages of RDBMS:
• No support for complex objects such as documents, video,
images.
• Often poor support for storage of complex objects.
• Still no efficient and effective integrated support.
Difference between DBMS RDBMS
ADBMS RDBMS
The concept of a relationship is not It is based on the concept of
there. relationship.
The speed of operation is slow. The speed of operation is fast
The hardware and software The hardware and software
requirements are very low. requirements are very high.
It uses the concept of files. It uses the concept of tables.
The facilities and utilities offered are The facilities and utilities offered are
limited. not limited.
DBMS normally uses a 3GL. RDBMS normally uses a 4GL.
Ex: Dbase, Fox base Ex: ORACLE, FOCUS
4|Page
3
