RDBMS and DBMS in Oracle

5 pts.
Oracle 9i
What is RDBMS and DBMS in Oracle?

Answer Wiki

Thanks. We'll let you know when a new response is added.

Database Management System is a kind of tool which is used to
create and maintain database. It does not provide the relationship between the
tables. Whereas RDBMS is Relational Database Management System which establish
the relationship between the tables and mainly used to store intricate and
large quantity of data.

For more Info you can visit following Link: http://docs.oracle.com/cd/E11882_01/server.112/e25789/intro.htm#CNCPT88781

Discuss This Question: 5  Replies

There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • shaper
    rdbms-relational dbms:
    in this each db has relation with others.

    10 pointsBadges:
  • Joeprior
    DBMS deals with small organisation and handle small or less quantity of data but RDBMS deals with multiple users and handle large amount of data.
    500 pointsBadges:
  • rvijay926

    DBMS is database management system in short and is the technology which deals with the handling of small/large databases. RDBMS is relational DBMS which connects the tables thru relationships like foreign keys.

    280 pointsBadges:
  • danieljones

    DBMS: A database management system (DBMS) is system software for creating and managing databases

    RDBMS: is a database management system (DBMS) that is based on the relational model

    2,840 pointsBadges:
  • DexterCode
    Database is a collection of data usually in the form of tables.

    DBMS (Database Management System) is a set of programs to "manage" a database. Management here means that you can perform stuff like deleting, modifying, adding data in a table. You can also add, delete, modify rows and columns in a table. In short, DBMS is a software that enables you to do all the common database operations mentioned above.

    RDBMS (Relational Database Management System) is a set of programs which has all the features of DBMS plus it helps you establish connections between tables. This is important. In DBMS, you can't really connect data in one table with data in another table. But with RDBMS you can.

    For example, if one table has information about orders placed by customers, then it only makes sense that you assign a unique id to every customer and mentioned that id with items list instead of giving the name, address, contact number etc. everytime with an item. So you can create a table having information about items (name, quantity, price) along with the id of the customer who ordered that particular item and another table that contains information about customers (id, name, address, contact number etc) and link the two tables. By linking them, you can benefit in the following ways:-

    1. You can get information about a particular customer from first table. You can also get the items that a particular customer ordered from second table.
    That's because both the tables have customer id stored in them.

    2. If a customer dies or stops buying from you, then you can delete her information from first table and the changes will cascade or propagate to the second table!

    But this awesome feature is available only in an RDBMS. Not in DBMS.
    10 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.


Share this item with your network: