Computer Blog

---

Relational Database Management System

A relational database management system (RDBMS) is a database management system (DBMS) that is based on the relational model as invented by Edgar F.Codd, of IBM's San Jose Research Laboratory. 

To acquire basic knowledge about RDMS students can take admission in best polytechnic college in Pune. In Polytechnic, MSBTE Curriculum Relational Database Management System subject is present in that every Organization like shopping mall, hospital, banking, institutes, Industry etc. needs to share huge amount of data in effective manner. This subject enables to create, store,modify and extract information from a database. Relational database management system has been developed to manage the information stored in the database. After learning this subject student will be able to use RDBM package as a backend for developing database applications.

Database Management System:-

Databases store sets of data about products, customers, orders and other facets of business operations so the information can be used in transaction processing or business intelligence and analytics applications. As its name indicates, a database management system is software that supports the development, administration and use of databases.

Relational Database Management System:-

• A relational database management system (RDBMS) is a kind of DBMS that was created in the 1970s and has become the dominant technology for managing databases since then.
• Its hallmark is a row-based table structure that connects related data elements to one another and provides transactional integrity to maintain data accuracy and consistency.
• Another common RDBMS attribute is support for using the Structured Query Language (SQL), a standardized programming language for writing queries to modify databases and retrieve data from them.
• The top RDBMS products in the market include Oracle Database, Microsoft SQL Server, IBM DB2 and MySQL, an open source database platform that is owned by Oracle; other notable ones are SAP HANA another open source technology.

Difference between DBMS & RDMS

Sr. No.	DBMS	RDBMS
1	DBMS application store data as file.	RDBMS application store data in tabular form
2	Normalization is not present in DBMS.	Normalization is present in RDBMS
3	DBMS does not apply any security with regards to data manipulation.	RDMS define the integrity constraint for the purpose of ACID.
4	DBMS uses a file system to store data, so there will be no relation in table.	In RDBS data values stored in the form of tables, so relation between these data values will be stored in the form of table as well.
5	DBMS is meant to be small organization & deal with small data.It support single user.	RDBMS is designed to handle large amount of data.It support multiple user.
6	Example of DBMS are file system,xml etc.	Example of RDBMS are mysql,sqlserver,oracle,postgre