SQL is referred as Structured Query Language, a standard query language certified by ANSI and ISO. SQL is used to access different databases like SQL Server, MySQL, MS Access, Sybase, Oracle, DB2, Informix and Teradata etc.
SQL is a database computer language designed for the retrieval and management of data in a relational database. This tutorial will give you a quick push towards SQL database. It covers most of the topics required for a basic understanding of SQL and to get a feel of how it works.
No. | DBMS | RDBMS |
---|---|---|
1) | DBMS applications store data as file. | RDBMS applications store data in a tabular form. |
2) | In DBMS, data is generally stored in either a hierarchical form or a navigational form. | In RDBMS, the tables have an identifier called primary key and the data values are stored in the form of tables. |
3) | Normalization is not present in DBMS. | Normalization is present in RDBMS. |
4) | DBMS does not apply any security with regards to data manipulation. | RDBMS defines the integrity constraint for the purpose of ACID (Atomocity, Consistency, Isolation and Durability) property. |
5) | DBMS uses file system to store data, so there will be no relation between the tables. | in RDBMS, data values are stored in the form of tables, so a relationship between these data values will be stored in the form of a table as well. |
6) | DBMS has to provide some uniform methods to access the stored information. | RDBMS system supports a tabular structure of the data and a relationship between them to access the stored information. |
7) | DBMS does not support distributed database. | RDBMS supports distributed database. |
8) | DBMS is meant to be for small organization and deal with small data. it supports single user. | RDBMS is designed to handle large amount of data. it supports multiple users. |
9) | Examples of DBMS are file systems, file system, XML, Windows Registry, etc. | Example of RDBMS are mysql, postgre, sql server, oracle etc. |
10) | Data redundancy is common in this model. | Keys and indexes do not allow Data redundancy. |
11) | Data elements need to access individually. | Data can be easily accessed using SQL query. Multiple data elements can be accessed at the same time. |
12) | Data fetching is slower for the complex and large amount of data. | Data fetching is rapid because of its relational approach. |