|
|
Re: difference between dbms & rdbms [message #10052 is a reply to message #10050] |
Mon, 29 December 2003 00:42 |
Jagdish
Messages: 43 Registered: September 2003
|
Member |
|
|
Hi,
A Relational DBMS considers the relationships betweeen entities (tables). E.g. a record on one (parent) table can have several records in another (child) related table- this would be a one-to-many relationship.
A database management system (DBMS), sometimes just called a database manager, is a program that lets one or more computer users create and access data in a database. The DBMS manages user requests (and requests from other programs) so that users and other programs are free from having to understand where the data is physically located on storage media and, in a multi-user system, who else may also be accessing the data. In handling user requests, the DBMS ensures the integrity of the data (that is, making sure it continues to be accessible and is consistently organized as intended) and security (making sure only those with access privileges can access the data). The most typical DBMS is a relational database management system (RDBMS). A standard user and program interface is the Structured Query Language (SQL). A newer kind of DBMS is the object-oriented database management system (ODBMS).
Best Regards,
Jagdish
|
|
|
|
|
|