Top Answer
User Avatar
Wiki User
Answered 2006-09-02 18:48:36

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

Your Answer


Still have questions?

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 is the difference between OODBMS and DBMS?

Third generation of database design theory. DBMS: Database Management System RDBMS: Relational Database Management System OODBMS: Object Oriented Database Management System

Is foxpro a rdbms?

yes it is a rdbms

What are the application of RDBMS?

what is rdbms and its application

What is the application of RDBMs?

What is the application of rdbms

What is MPP based RDBMS?

RDBMS is short for Relational database management system . RDBMS defines relationship between the tables . MPP stands for massive parallel processing and in RDBMS MPP refers to the processing of several table ,that are in relation with one another together.

Dbms and rdbms?

DBMS and RDBMS both are used for storing data. DBMS is the database management system that refers to the collection of interrelated data. RDBMS define relation between the tables in the database

What are the component of DDBMS?

The components of a Disributed DataBase Management System (DDBMS) are the Database Manager, the User Interface Request, and a Distributed Transaction Manager.

Uses of rdbms?

what is the use of queues in rdbms

What is difference between Excel and RDBMS?

Excel is a spreadsheet application. RDBMS is a Relational Database Management System. Excel has databasing capabilities, but does not have the capabilities of a relational database. There are many facilities in a RDBMS that Excel cannot do or can only do to a very limited amount. Excel is for numerical analysis and manipulation, which is what a spreadsheet is for. Databases are for managing lists of data. So while they both can manipulate data, they are for different kinds of jobs.

Difference between rdbms and dbms?

dbms stands for data base management system whereas rdbms is relational data base management system. A Database Management System (DBMS) is collection of software programs which enable large, structured sets of data to be stored, modified, extracted and manipulated in different ways. Whereas Relational Database Managemet System (RDBMS) is a data structured in database tables, fields and records. Each RDBMS tables consist of database table rows.

Is Microsoft sql server dbms or rdbms?


How does a DBMS differ from RDBMS?

A database is to store data efficiently. DBMS is Database management system and RDBMS is Relational database management system which gives relation between every table. It (RDBMS) also follows codds rules.

What are advantages of rdbms over dbms?

advantage of rdbms over dbms

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 is main difference between dbms rdbms why it is called relational database?

There are mainly three different Database architectures and they are network, hierarchical and Relational. The DBMSystems that follow the Relational architectural concepts are known as RDBMS. This is supposed to be superior in design and performance to the other two and there are, to my knowledge, no functional DBMS following the other two concepts in the market today.

What are the advantages of rdbms over dbms?

The main advantage of an RDBMS is that it checks for referential integrity