What is the difference between DBMS, RDBMS and SQL?

Tags:
DBMS
RDBMS
SQL
What is the difference between DBMS, RDBMS and SQL?


Software/Hardware used:
DBMS
1

Answer Wiki

Thanks. We'll let you know when a new response is added.

DBMS : Database management systems (DBMSs) are computer software applications that interact with the user, other applications, and the database itself to capture and analyze data. A general-purpose DBMS is designed to allow the definition, creation, querying, update, and administration of databases.

RDBMS :  is a database management system (DBMS) that is based on the relational model as invented by E. F. Codd, of IBM’s San Jose Research Laboratory. Many popular databases currently in use are based on the relational databasemodel.
SQL : is a special-purpose programming language designed for managing data held in a relational database management system (RDBMS), or for stream processing in a relational data stream management system (RDSMS).

SOURCE : Wikipedia

The key
difference between DBMS, RDMS & SQL is that RDMS (relational database
management system) application store a Data in tabular form, while DBMS store data
in files and SQL is designed for managing data held in RDMS. In DBMS, there
will be no relation between the table, but in RDMS the relation between tables
exist.

In DBMS, data
is generally stored in either a hierarchical form or a navigational form. This
means that a single data unit will have one parent node and zero, one or more
child nodes. It may even be stored in a graph form, which can be seen in the
network model.

In an RDBMS,
the tables will have an identifier called a primary key. The Data values will
be stored in the form of tables. The relationships between these data values
will be stored in the form of a table as well.  Every value stored in the
relational database is accessible. This value can be updated by the system. The
data in this system is also physically and logically independent.

SQL consists of a data definition language (DDL) and a data manipulation language (DML). The scope of SQL includes data insert, query,
update and delete, 
schema creation
and modification, and data access control. Although SQL is often described as,
and to a great extent is, a 
declarative language (4GL), it also includesprocedural elements.


Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: