What is Relational Database Management System
What is Relational Database Management System Explanation with Example
you know that MS SQL Server, IBM DB2, Oracle, MySQL, and Microsoft Access are the modern database system.
Table Structure in RDBMS-
Relational Database Management System The data is stored in database objects which are known as table and it consists of numbers of columns and rows.
the table is a collection of related data entries.
| ID | Name | Age | Salary |
|---|---|---|---|
| 1 | Upasana | 28 | 25000.00 |
| 2 | Sachin Shukla | 27 | 56000.00 |
| 3 | Pinki Gupta | 45 | 45000.00 |
| 4 | Saumya | 34 | 34000.00 |
Table field:
Every table consists of Rows and columns, broken up into smaller entities called fields. The fields in the Employees table consist of ID, NAME, AGE, and SALARY. stored specific information about every record in the table.
Record and Row in Table
A record is also called as a row of data in each individual entry that exists in a table.
likewise, there are 4 records in the above Employee table. Following is a single row of data or record in the Employee table −
Finally, You can see that record is a horizontal entity in an Employee table.
| ID | Name | Age | Salary |
|---|---|---|---|
| 1 | Ankit | 34 | 34000 |
Table column:
A column is a vertical entity in a table that contains all information or data associated with a specific field in a table.
For example, a column in the Employee table is Salary −
| Salary |
|---|
| 35000.00 |
| 45000.00 |
| 22000.00 |
| 56000.00 |
POPULAR RELATIONAL DATABASE MANAGEMENT SYSTEMS
Here, we brif discussed about popular RDBMS Systems:
MySQL
MySQL is a most popular open source RELATIONAL DATABASE MANAGEMENT. Baically, It is mostly used for web application development, and often accessed using PHP.
The main advantages of MySQL Database are that it is very easy to use, reliable, inexpensive.
MYSQL disadvantages are that it has been known to suffer from poor performance when scaling, open source development has lagged since
Oracle has taken control of MySQL, and it does not include some advanced features that developers may be used to.
SQLite
SQLite is an (RDBMS)relational database management system contained in a C programS library.
In contrast to many Another database management systems such as open source SQL database.
it is not a client-server database engine and store an entire database in a single file.
the most significant advantages are that all of the data can be stored locally without having to connect your database to a server.
SQLite is a most popular choice for databases in cellphones, set-top boxes, MP3 players and other electronic gadgets.
SQL Server
Microsoft have owns SQL Server. such as Oracle DataBase, the code is close sourced.
Large Business applications mostly use SQL Server.
The key difference between SQL Server and Oracle is that SQL Server only supports the Windows Operating System.
which Microsoft offers a free entry-level version called Express
Oracle DB
Oracle Database is a multi-model database management system, Oracle Corporation owns Oracle Database and the code is not open source.
Oracle DB is for large applications, like as the Banking Sector.
Oracle offers a powerful combination of comprehensive and technology
its pre-integrated for business applications, having essential functionality built specifically for the banking sector.
a disadvantage of Oracle is that it is not free to use like its open source competitors and can be quite expensive.
PostgreSQL
It not controlled by any corporation, PostgreSQL is also an open-source SQL database
It is used for web application development, easy to use, reliable and inexpensive has a large community of developers.
PostgreSQL provides few additional features like as foreign key support without requiring complex configuration.
The main disadvantage of PostgreSQL is that it is slower in performance than other databases like as MySQL.
It is also less popular than MySQL.
Challenges of Relational Databases
Performance: Rapid growth in volume, variety, velocity, and complexity of data creates even more complicated relationships.
the Relational databases tend to have a hard time keeping up, which can slow down (slow speed) performance.
Scalability: Because it’s built on a single server.
means that, in order to scale, you’ll need to purchase more expensive hardware with more storage, memory, and power.
Relationships: the Relational databases don’t store relationships between elements, which makes understanding connections between your reliant data on other joins.
Benefits of Relational Databases
If you have lots of data of information to manage, you can design a data storage which is scalable and flexible, the relational database is a good bet
Manageability: Relational Databases is easy to manipulate.
you can update Each table of data without disrupting the others.
it’s possible to share certain sets of data with one group, but limit their access to others – such as confidential information.
Avoid Errors: there’s no change for mistakes in a relational database because it’s very easy to check for mistakes against the data in other parts of the records.
And since here each piece of information is stored at a single point, you will not face the problem of old versions of data clouding the picture.
Flexibility: if you want to update your data, you only have to do it once because no more having to change multiple files one at a time.
And it’s very simple to extend your database.
Resource
RDBMS
About Author
