User:JoshiRavi101/sandbox/differences between DBMS V/S RDBMS
Appearance
This is not a Wikipedia article: It is an individual user's work-in-progress page, and may be incomplete and/or unreliable. For guidance on developing this draft, see Wikipedia:So you made a userspace draft. Find sources: Google (books · news · scholar · free images · WP refs) · FENS · JSTOR · TWL |
Differences Between DBMS V/S RDBMS
DBMS | RDBMS |
---|---|
DBMS is Data Base Management System | RDBMS is Relation Data Base Management System |
DBMS is a Management System which manages the data, shares data and retrieves the data. | RDBMS is a relational Management System which also manages data, shares data and retrieves data by creating relationship between two or more tables in database. |
You can create relationship among the tables by using some specific code. | There is no need to write any code, because it has an built in integrity. |
In DBMS, if two tables are related, there may be invalid records in either of the two tables. | In RDBMS, a feature called referential integrity is available, so there can’t be any invalid records into related tables. |
It can handle small volume of data. | It can handle large volume of data. |
Its performance is slower compare to RDBMS. | Its performance is faster for query and data retrieval. |
DBMS has various modules which include Networking database, store database, and relational database. | RDBMS uses the relational database and is based on it has no modules as in DBMS. |
In DBMS, you have to create one table with all the fields, so management of tables is complex. | In RDBMS, you can break table into small modules i.e. main table storesm main information and other stores the details of that so the management of table is easier. |
There is no facility of looking up table, so you have to type the value again whenever you need in another field. | inRDBMS, there is a facility of looking up values from other separate tables,so it eliminates the need of entering values altogether. |
You can’t create related separate tables for a single cause, hence its not easy to design form or reports for different purposes. | By keeping records for a single cause in different tables that are separate but related, it’s easier to design forms and reports for different purposes. |
References
[edit]External links
[edit]