What is RDBMS
RDBMS stands for Relational Database Management Systems..
All modern database management systems like SQL, MS SQL Server, IBM DB2, ORACLE, My-SQL and Microsoft Access are based on RDBMS.
It is called Relational Data Base Management System (RDBMS) because it is based on the relational model introduced by E.F. Codd.
How it works
Data is represented in terms of tuples (rows) in RDBMS.
A relational database is the most commonly used database. It contains a number of tables and each table has its own primary key.
Due to a collection of an organized set of tables, data can be accessed easily in RDBMS.
Brief History of RDBMS
From 1970 to 1972, E.F. Codd published a paper to propose the use of the relational database model.
RDBMS is originally based on that E.F. Codd's relational model invention.
Below are the basic term used in RDBMS
1) Database:- Database is a collection of schemas. We can create more than databases on the same server.
2) Objects:- Objects can be created by CREATE command. Objects are the
basic elements of the database.
Example :- Below are the Oracle Objects
1) Table
2) View
3) Synonym
4) Sequence
5) Index
6) Function
7) Procedure
8) Package
9) Trigger
2) Schema:- Collection of objects under one user is called its schema.
Example:- SCOTT Schema, HR Schema
3) Instance:- Instance is a memory architecture of Oracle Database. It is also
known as SGA (System Global Area). More than one databases
can be configured under one instance.
4) RDBMS:- RDBMS is a software which can manage the relational database.
5) Transaction:- Collection set of statements between login to TCL command
or between any two TCL commands.
6) Table:-Table is the basic unit for storing data. The table is a structure with
collection of columns.
1) Database:- Database is a collection of schemas. We can create more than databases on the same server.
2) Objects:- Objects can be created by CREATE command. Objects are the
basic elements of the database.
Example :- Below are the Oracle Objects
1) Table
2) View
3) Synonym
4) Sequence
5) Index
6) Function
7) Procedure
8) Package
9) Trigger
2) Schema:- Collection of objects under one user is called its schema.
Example:- SCOTT Schema, HR Schema
3) Instance:- Instance is a memory architecture of Oracle Database. It is also
known as SGA (System Global Area). More than one databases
can be configured under one instance.
4) RDBMS:- RDBMS is a software which can manage the relational database.
5) Transaction:- Collection set of statements between login to TCL command
or between any two TCL commands.
6) Table:-Table is the basic unit for storing data. The table is a structure with
collection of columns.
0 comments:
Post a Comment