Best Answer

DBMS stands for Database Management System which is a general term for a set of software dedicated to controlling the storage of data.

RDMBS stand for Relational DataBase Management System. This is the most common form of DBMS. Invented by E.F. Codd, the only way to view the data is as a set of tables. Because there can be relationships between the tables, people often assume that is what the word "relational" means. Not so. Codd was a mathematician and the word "relational" is a mathematical term from the science of set theory. It means, roughly, "based on tables".


DBMS includes the theritical part that how datas are stored in a table.It does not relates tables with another. While RDBMS is the procedural way that includes SQL syntaxes for relating tables with another and handling datas stored in tables.


1)rdbms is object based database management system while dbms 2)rdbms can maintain at many users at same time while dbms not 2)in rdbms is relation is more important than object itself while dbms entity is more important


The main advantage of an RDBMS is that it checks for referential integrity (relationship between related records using Foreign Keys). You can set the constraints in an RDMBS such that when a paricular record is changed, related records are updated/deleted automatically.


ORDBMS = ODBMS + RDBMS = (O + R) * DB * MS. On a logical level, an ORDBMS is the MS process methods applied for DB data structure, which is complied with O object and R relational concepts.


A database has to be persistent, meaning that the information stored in a database has to continue to exist even after the application(s) that saved and manipulated the data have ceased to run. A database also has to provide some uniform methods that are not dependent on a specific application for accessing the information that is stored inside the database.

An RDBMS is a Relational Data Base Management System. This adds the additional condition that the system supports a tabular structure for the data, with enforced relationships between the tables.


the difference is dbms has no tables

while rdbms has and also it describes

about the relationships among the tables

dbms for small organisatiions

where rdbms for large amonut of data


the difference between dbms and rdbms is that it doesn't show the relation while rdbms show the relation and moreover dbms is for small organisations where rdbms for large amount of data


In DBMS all the tables are treated as different entities. There is no relation established among these entities. But the tables in RDBMS are dependent and the user can establish various integrity constraints on these tables so that the ultimate data used by the user remains correct.


In DBMS there are entity sets in the form of tables but relationship among them is not defined while in RDBMS in each entity is well defined with a relationship set so as retreive our data fast and easy.


In DBMS tables are not related. In RDBMS tables are related

In DBMS only one user can access the same database, at the same time. In RDBMS many users simultaneously access the same database

RDBMS is more secure than DBMS

In DBMS store and retrieve small amount of Data In RDBMS store and retrieve large amount of Data



- Set of data and tools to manage those data. - Will not support RELATION SHIP between data. - Ex : - Foxpro data files and earlier Ms Access.


- Same as DBMS - Will Support RELATION SHIP between Tables. - Ex : - ORACLE,SQL 2000,DB 2 ...


dbms support 6 rules which were proposed by the developer of dbms and where as rdbms follows 8 rules which were proposed by the developer of rdbms.


1. dbms is a single user system rdbms is a multiuser system 2. dbms stores do not store data in the form of tables while rdbms stores it in the form of tables. 3. most of dbms are not supporting client/server architecture as it is supported by rdbms. 4. most dbms do not support distributed databases

DBMS - Database MAnagement System

Different types of dbms

1.DBMS simple databses management system , dbms does not support codd rules more than 5/6 rules.

2.RDBMS like sql server,mysql . Rdbms support more than 7 codd rules

3. ORDBMS like oracle 9i or later version


DBMS refers to DataBase Management System

and relatioonal data structure is the way of organizing the data stored so that each attribute is related to one another and that's y they are used for geographic information storing purposes.


A Database Management System (DBMS) is a set of computer programs that controls the creation, maintenance, and the use of the database in a computer platform or of an organization and its end users. It allows organizations to place control of organization-wide database development in the hands of database administrators (DBAs) and other specialists. DBMSs may use any of a variety of database models, such as the network model or relational model. In large systems, a DBMS allows users and other software to store and retrieve data in a structured way. It helps to specify the logical organization for a database and access and use the information within a database. It provides facilities for controlling data access, enforcing data integrity, managing concurrency controlled, restoring database.

Answerwell, DBMS differences depends upon many aspects likewise: Vendors, Security, Easy to access(UI) etc..

according to my opinion based on security ORACLE is far better than others..

2011-09-14 09:25:14
This answer is:
User Avatar

Add your answer:

Earn +5 pts
Q: What are the differences between different types of Database Management Systems?
Write your answer...

Related Questions

What is the difference between database management and documents management systems?

differences between document management and database technology

What is the role of database management systems to information management?

What is the role of database management systems

What are different types of database management?

There are currently 3 general categories of data base management systems in use today:relational database systemsmultidimensional database systems (often referred as 'cubes')object oriented database systemsPrior to the success of relational database systems (early 80's) there were also hierachical database systems and network (aka CODASYL) database systems.

What is differences between dbms and rdbms?

DBMS stands for "Database Management Systems" it includes all Databases. RDBMS are a special Type of DMBS. "Relational Database Management Systems". On RDBMS you have Tables. Some Tables have are in relation to other Tables. This is needed to organize complex Data. Systems like MySQL, MS Access or MS SQLServer are RDBMS. Other Types are: ODBMS - Object Database Management System ORDBMS - Object Relational Database Management System HDBMS - Hirarchical Database Management System NDBMS - Network Database Management System

What are the different types of database management systems?

1. relational database management system(RDBMS) 2. object Rdbms. 1. relational database management system(RDBMS) 2. object Rdbms.

What are two Database management systems products that run under the Linux operating system?

There are lot of Database Management systems that run on Linux, but MySQL and PostgreSQL seem to be the mostly used Database Management systems.

What Are responsible to oversee the general operations of the database system?

database management systems

What are database management systems used for?

Database management systems are typically used for organizing data within a database. The data is organized so that it can be retrieved and stored in the most efficient manner possible.

What database management systems are there?

There are four basic and main database management systems that are used today. Those four include hierarchical, network, relational and object-oriented.

Why are database management systems important in the business community?

Database management systems perform a multitude of functions including providing security, multi-user access, it also transforms data into information. Database management systems also manage data stored and contains programming languages.

Example of database management system?

A large number of database management systems (DBMS) exist. For example: Oracle, MySQL, DB2.

How are database management systems aka DBMS used in banking?

draw a diagram to show bank management system in ER model in database management system

What are the different views of data in a database management systems?

Classifications of database views (in Oracle) 1. Theoretical updateable 2. Partially updateable 3. Theoretically not updateable

Is it true that database management systems create and manage databases?

yes it mange database and also create it.

What are the file systems in fandamentel of database management system?

ankesh singh

What kind of a database management system is Oracle Database?

Oracle database is the first database management system based on the System-R model of IBM and the first relational database that uses SQL. Though it supports various operating systems.

What is data structures in database management system?

The correct term is "What are data structures in database management systems?" Please learn how to speak English ~Sincerely The Hacker

What are the advantage of distributed database over centralized database?

The database can be of two types either distributed or centralized . In distributed database the data is in different systems. In centralized database the data is in a single central system.We can categorize database as either distributed or centralized . In centralized database the data is in a single centralized system. While In distributed database the data is in different systems .


AnswerMySQL, like most modern Database Management Systems is based on the relational model. So it is a RDBMS (Relational Database Management System).

How many types of Data Base in market?

In many cases, each company has its own database (or several databases), so I would estimate that there are about as many databases as there are companies. If you are referring to the DBMS - the software that manages the databases - you can see a list of the most common ones in the following Wikipedia articles: * Comparison of relational database management systems * Comparison of object database management systems * Comparison of object-relational database management systems

What are the negatives of using a database?

Database management systems are intricately developed.Database systems are complex, difficult, and time-consuming to designManagement complexity.Frequent upgrade/replacement cycles.At risk from the attack of viruses and hackersInitial training required for all programmers and users

Where can you get a good database management?

If you are running Linux, the best database management systems are MySQL, Apache Derby, PostgreSQL, HSQLDB (HyperSQL), or Ingres. However, there are many types of database management softwares, so please be more specific with your question if this was not the answer you were looking for.

ADVANTAGES of database management system?

One advantage of having a database management system is the fact that it can store a lot of information about customers. Another advantage is the fact that businesses can easily secure these systems while they secure their other systems.

What softwares are available for small business owners that help with database management systems?

The best small business software is called Start Logic and it has excellent reviews for database management systems. A lot of companies use it and really seem to like it and what it does.

What is database management systems?

Database Management Systems are computer programs that keep track of the additions, updates, cancellations.. basically any changes made to data as transactions occur. For example: purchases and refunds, deposits and payments, and sent and cancelled orders.