Difference between DBMS and RDMS

Kiran Kumar

1y1.1kSQL Server

What is the difference between DBMS and RDMS

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sam Hobbs1y ago
Accepted answer
I assume you mean RDBMS, not RDMS. If you really meam RDMS then please tell us where you see that or at least what RDMS is an acronym for.

A RDBMS (Relational DataBase Management System) is a type of DBMS (DataBase Management System).

Relational databases were invented by E. F. Codd, employed by IBM at the time. IBM is among the oldest developers of database systems. IBM developed database technology when direct-access storage (disk drives) were invented by them.

See the following.

What is a database management system? - IBM Documentation
https://www.ibm.com/docs/en/zos-basic-skills?topic=zos-what-is-database-management-system

I think that when members post answers they found elsewhwere they should specify where they got the information from.
0

Tuhin Paul1y ago

Difference Between DBMS and RDBMS

Aspect	DBMS (Database Management System)	RDBMS (Relational Database Management System)
Data Model	Hierarchical, network, or file-based models.	Relational model (data stored in tables with rows and columns).
Data Relationships	Relationships are implicit (e.g., hierarchical parent-child) and not enforced.	Relationships are explicit (via foreign keys) and enforced.
Normalization	Does not support normalization.	Supports normalization (1NF, 2NF, 3NF, etc.) to reduce redundancy.

Now lets take a realtime example of a Library Management system.

DBMS:
A file-based system where each book is stored as a separate file (e.g., book1.txt, book2.txt). Relationships between books and authors are not enforced.
- Limitation: No way to query "Which books are written by Author X?" efficiently.

RDBMS:
Uses tables like Books, Authors, and BookAuthors with relationships enforced via foreign keys.

Tables:

CREATE TABLE Authors (AuthorID INT PRIMARY KEY, Name VARCHAR(100));
CREATE TABLE Books (BookID INT PRIMARY KEY, Title VARCHAR(100));
CREATE TABLE BookAuthors (BookID INT, AuthorID INT, FOREIGN KEY (BookID) REFERENCES Books(BookID), FOREIGN KEY (AuthorID) REFERENCES Authors(AuthorID));

Query:

SELECT Books.Title FROM Books
JOIN BookAuthors ON Books.BookID = BookAuthors.BookID
JOIN Authors ON BookAuthors.AuthorID = Au

DBMS is a generic term for systems managing data (file-based, hierarchical, etc.).
RDBMS is a subset of DBMS that uses tables and SQL, enforcing relationships and integrity.
Use RDBMS for complex queries, transactions, and scalability. Use DBMS for simpler, non-relational data needs.

Hope this pictorial presentation clears your doubts. Now you can ask some specific question as Amit Mohanty has mentioned in his response.

Amit Mohanty1y ago
It's look like your questions are quite broad and can be easily answered through a quick google search, where you'll find plenty of useful resources. To make the discussion more valuable for the community, consider asking about specific challenges or issues you are facing.
-1
Sangeetha S1y ago
differences between DBMS (Database Management System) and RDBMS (Relational Database Management System):
1. Structure:
  
  DBMS: Can handle various data formats and types, not necessarily structured. It allows for a more flexible approach to data storage.
  
  RDBMS: Organizes data into tables with rows and columns, enforcing a strict schema. Data is structured, and relationships between tables are established.
2. Relationships:
  
  DBMS: Typically does not support relationships between data. It’s more about storing data without inherent connections.
  
  RDBMS: Supports relationships through foreign keys, allowing for complex queries and data integrity.
3. Normalization:
  
  DBMS: May not support normalization, leading to data redundancy.
  
  RDBMS: Emphasizes normalization to minimize redundancy and improve data integrity.
4. ACID Properties:
  
  DBMS: May not fully adhere to ACID (Atomicity, Consistency, Isolation, Durability) properties.
  
  RDBMS: Strictly follows ACID properties to ensure reliable transactions.
5. Examples:
  
  DBMS: Examples include hierarchical databases and network databases (like XML databases).
  
  RDBMS: Common examples are MySQL, PostgreSQL, Oracle, and Microsoft SQL Server.
+1

Jaish Mathews1y ago

Here’s a tabular comparison between DBMS (Database Management System) and RDBMS (Relational Database Management System):

Feature	DBMS (Database Management System)	RDBMS (Relational Database Management System)
Definition	Software that manages databases.	Software that manages relational databases (tables with relationships).
Data Structure	Uses files or hierarchical, network, or object-oriented models.	Uses a tabular structure (rows and columns).
Normalization	No strict normalization rules.	Follows normalization to reduce redundancy.
Data Relationships	No predefined relationships between data.	Maintains relationships using foreign keys and constraints.
Data Integrity	Integrity constraints are not enforced strictly.	Enforces integrity rules like primary key, foreign key, and ACID properties.
Query Language	Uses simple query languages, sometimes proprietary.	Uses SQL (Structured Query Language) for data manipulation.
Multi-user Support	May not support multiple users efficiently.	Supports multiple users with high concurrency.
ACID Compliance	May not strictly follow ACID properties (Atomicity, Consistency, Isolation, Durability).	Ensures ACID compliance for data consistency and reliability.
Scalability	Suitable for small-scale applications.	Suitable for large-scale applications with high performance needs.
Examples	File systems, XML databases, NoSQL databases (MongoDB, Redis).	MySQL, PostgreSQL, SQL Server, Oracle, SQLite.

Let me know if you need any modifications or further explanations! ??