Best Answer

DBMS (Database Management System) is a genaral term for any system used to store, manage, and retrieve from a collection of data. It can be something as simple as a box of index cards, a collection of computer documents or spreadsheets, or more commonly a software program designed specifically for managing collections of data. Most DBMSs today are RDBMSs and most DDBMSs are based on RDBMSs. The RDBMS (Relational DBMS) is based on a Computer Science concept known as relations. The purpose of the RDBMS is to organize the information logically (for humans) and to efficiently store and retrieve the information (by computers). Typically, tables are defined for each class of thing for which data is to be kept. Tables contain a row for each unique thing belonging to the table's class. Each row contain facts directly related to the thing and a unique identifer (name, code, number, etc.) that distinguishes each thing from all other things in the same class. A row may contain cross-references to the unique identifiers of one or more rows in other tables to show relationships that exist between things. Tables provide the logical organization for human use, and the unique identifiers and cross-reference relations provide the RDBMS system the technical mechanism to efficiently store and retrieve all the information in the database. For example, a Sales database might contain Customers, Products, Orders, and OrderItems tables defined as follows: Customer - ID:CustomerId Facts:Name,Address,Telephone,ContactName Products - ID:SKUNumber Facts:Price,QuantityOnHand,Description Orders - ID:OrderID CrossRefs:CustomerID Facts:OrderDate,PaymentStatus OrderItems - ID:OrderItemID CrossRefs:OrderID,ProductID Facts:Quantity,Price The DDBMS (Distributed DBMS) simply means the DBMS (which is usually also an RDBMS) data is stored on more than one computer. The computers may be physically in different parts of the world, connected by the internet or other type of network. The DDBMS software allows you to manage the database as one whole collection of data even though different parts of the data are distributed across multiple machines. If the data is updated more often than it is retrieved, each machine could store a different subset of the database most likely to be retrieved from that location (European Customers stored on the database server in London while U.S. Customers are on the database server in Seattle). So the DDBMS must know how to gather the data over the network from different servers, when a user runs a report of all Customers with sales greater than $1,000,000. If the data is retrieved more often than it is updated, all data updates done in one location could be replicated (automatically copied) to all of the other database servers in the system. This allows for faster retrieval of any information from any location. The efficiency of a DDBMS depends on making good decisions about the physical storage and replication plan (if, how often, and where to) for each subset of data.

User Avatar

Wiki User

โˆ™ 2006-09-02 18:48:36
This answer is:
User Avatar
Study guides

What are advantages of Database Approach

What is a network that covers a large geographical area such as a city country or world

What is the worlds largest wan

What is a network server

See all cards
89 Reviews

Add your answer:

Earn +20 pts
Q: What is the difference between ddbms and rdbms?
Write your answer...
Still have questions?
magnify glass
Related questions

What is the difference between ddbms and parallel dbms?

There is not a lot of difference between DDBMS and parallel DDBMS. Both systems store data over several sites, and parallel DDBMS uses parallelization over certain operations.

What is the major difference between rdbms and dbms?

The 'r'

Difference between dbms and rdbms?

dbms is support normalization process.. rdbms support does not support normalization process

What is the difference between sybase and rdbms?

An RDBMS is a general term for a relational database system and Sybase is a specific product which implements a relational database.

What is the difference between RDBMS and Datawarehouse?

RDBMS - is normalized. It has recent data upto 10 - 15 days. Datawarehouse - denoramlized. It has history of data.

Major difference between dbms vs rdbms?

1:In DBMS joining between table is not possible 2: Does not support Networking

What is the difference between odbms rdbms and ordbms in tabular form?

The acronym ODBMS stands for Object DataBase Management System. The acronym RDBMS stands for Object Relational DataBase Management System. RDBMS supports more complex types of data in tabular form.

What is the difference between DBMS and RDBMS?

RDBMS : Relational Data Base Management System. To achives consistance of Data via referntial integrity. It facilitates to give relation ship between tables. Like foreign key relationship , on delete cascade etc...

What is the difference between sqlplus and sqlserver?

what is the difference between sqlplus and sqlsever SQL*PLUS is oracle command line utility that allows access to Oracle databases sqlserver is a Microsoft RDBMS (database management system), vaguely based on a Sybase RDBMS if you are looking for SQL*PLUS like interface to SQL Server, the one one is SQLS*PLUS from

What are the application of RDBMS?

what is rdbms and its application

Is foxpro a rdbms?

yes it is a rdbms

What is the application of RDBMs?

What is the application of rdbms

People also asked