What is the differentiate between dbms and rdbms?

Answer 1

RDBMS.RDBMS is based on relation between data. Data the "belongs together", are "related" and where multiple data are related in the same way, one way of viewing these is as a row in a table, and where data of the same category are placed underneath one another as column. A single row is here called a "tupple". All the relational operators are defined from their mathematical properties, where you find addition, subtraction, division and multiplication. Beware that multiplication is not commutative, the order of the what you "join" matters.

Then on to ODBMS...

First, an object is an autonymous instance of a class tht contains data, methods and reference and relationship to other objects. Object can contain one or more other objects, and its methods or "procedures" can operate on data local to the object or on other object.

The dominant relationship between objects is their construction mode, or "inheritance". You may hide data in an object - "encapsulate" it, you make a new class, based on an existing class, creating a new object type. The new object type ("class") need not contain new data, may be just a change in the actions. Like "Parents: are still considered people but have one of more "children" - also people.

So, to be a proper ODBMS, the database must contain methods and procedures beside just data. There are some ODBMS around but most just makes claims to capability to support object oriented programming. The programming is where you keep all the logic, the methods and procedures, and the objects are "populated" with data from the database. The database can be anything - RDBMS and Codasyl DBTG type. Codasyl supports object reference, and allows People to have "Parents" that has "Children" - where this has to be implemented either by a special table that maps a "parent" to their "children" or make a column implement this.

A database is a repository of data in one place, allowing this to be used by all. Your address book is a repository of names, addresses, telephone numbers and how this is used is determined by the methods in the various applications - it is not held in the address book. The email client knows how to use the email address, the VoIP how to use the phone number, the IM how to use user ID - the methods are scattered around. This is not how it was intended in a object oriented context. To be blunt, the OO worried less about the "persistency" of data, that was considered "solved" but definitely not with a relational database system.

Good RDBMS contains extensions that supports referential integrity and logic consistency checks such as "every child must have parents". The RDBMS may better be considered as a special object that is used to hold data, abd retain consistency. Claims of ODBMS are usually a hogwash of marketing gimmickry and misunderstanding.

Answer 2

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.

Answer 3

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...

Answer 4

DBMS is the Database Engine itself

like MySql Server

RDBMS is the GUI (Graphical user interface)

for any Database Engine which used in

CRUD (Create, read, update and delete)

like PHPmyAdmin

Answer 5

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.

Answer 6

DBMS is database management system RDBMS is relational database management system a database software which satisfies more than 9 rules of codds rule then it is called RDBMS