RDBMS => ( Relational Database + Enterprise Services + SQL Queries)
In the digital world, different types of database management system exist to manage the data. In these groups, Relational database management is popular and easy to manage organization transaction data. RDBMS to create, update, and administer a relational database. Relational database management systems use the SQL language to access and manage the database(DB).
Relational Database:
RDBMS manages the relational data and get information from relational database. Apart from managing the data, it provides transaction management, handling for failure, system crash, backup the database, working with third party enterprise application to provide enterprise solutions. For example, oracle RMAN component in oracle provides backup the database with application consistency,multi tenancy.
Enterprise Services by RDBMS:
RDBMS provides enterprise level services to the database. These services ensures data access in multiple user environment, restriction of data access, backup and recovery services. Apart from these services, powerful SQL supports to access t0 RDBMS.
Data Concurrency and Consistency :
Database is accessed by multiple user. Data must be read/write in a consistent fashion. Data consistency is ensured by handling the transaction and concurrent access.
Data integrity:
Data should be allow to access to privileged user, not to all. For example, HR should have access to all the employee in the organization. But employee should have access for his information in the organization data. RDBMS provides security and integrity in accessing database.
Backup and Recovery :
Database handle mission critical information of the organization. It should be unaffected in case of failures. Even if any failure, it should be able to recover the database without corrupting the data in the database. RDBMS provides services to handles the backup and recovery of the database.
Distributed Databases:
Few RDBMS provides distribution of database to multiple location to handle the system failure. In case of active database failure, the replicate database in different location comes as rescue. The replicatad database becomes active and provides access to the database.
Structured Query Language(SQL):
Structured Query Language(SQL) is a specification/programming model to communicate with data stored in a relational database management system. SQL is powerful and concise. We can access the data with filters, conditions and select only few rows for processing. It is powerful set of specification supported by all the RDBMS.
RDBMSs implements the SQL specification and access the data in tables using SQL statement. For example, SQLite is a relational database management system. SQLite contains the most minimal set of SQL commands (which are the same across all RDBMSs). Oracle Database, MySQL, Microsoft SQL Server,Postgresql and IBM DB2 implements SQL specification and allow to access the tables by SQL statements.
SQL is Specification or Programming Model.
Oracle Database, MySQL, Microsoft SQL Server,Postgresql and IBM DB2 implements SQL Programming Model.
We install RDBMS and access by SQL. We are using SQL query to access RDBMS data. Don’t say “Is SQL installed” or “Installed SQL in the system”. We installed RDBMS such as oracle database, MySQL,MS SQL Server. I hope now we are clear on RDBMS and SQL. Now our statements should change as below,
“Is Oracle database installed.”
“Installed MySQL database in the system.”
We would discuss on SQL in upcoming sections. Happy Selecting:)
