RDBMS I Query

Discussion in 'Database' started by honey86, Jul 29, 2008.

  1. honey86

    honey86 New Member

    Joined:
    Jul 29, 2008
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    0
    Hello Sir,

    May i know some basic details of RDBMS like what is it, differ from DBMS and so on.
     
  2. xpi0t0s

    xpi0t0s Mentor

    Joined:
    Aug 6, 2004
    Messages:
    3,009
    Likes Received:
    203
    Trophy Points:
    63
    Occupation:
    Senior Support Engineer
    Location:
    England
    The question's a bit vague. RDBMS=Relational Database Management System which comprises a number of tables that contain related information and a whole stack of software (the Management System) that manages the data. Probably what you need is a book on Databases.

    Alternatively you could download Oracle ( http://www.oracle.com/technology/software/products/database/index.html ) and have a look through the documentation ( http://www.oracle.com/technology/documentation/database.html ) starting with the Concepts manual ( http://download.oracle.com/docs/cd/B28359_01/server.111/b28318/toc.htm ). Concepts will (eventually) answer your questions.
     
  3. xpi0t0s

    xpi0t0s Mentor

    Joined:
    Aug 6, 2004
    Messages:
    3,009
    Likes Received:
    203
    Trophy Points:
    63
    Occupation:
    Senior Support Engineer
    Location:
    England
  4. honey86

    honey86 New Member

    Joined:
    Jul 29, 2008
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    0
    Hi,

    May i know some information of language it's contents is as follows:-

    Type of languages low level ,mid level,high level ,3rd generation lanuages, 4th gen language.

    machine level language, Asemblers, decoders, compilers.
     
  5. skp819

    skp819 New Member

    Joined:
    Dec 8, 2008
    Messages:
    89
    Likes Received:
    3
    Trophy Points:
    0
    #1 A DBMS has to be persistent, that is it should be
    accessible when the program created the data ceases to
    exist or even the application that created the data
    restarted. A DBMS also has to provide some uniform methods
    independent of a specific application for accessing the
    information that is stored.

    RDBMS is a Relational Data Base Management System
    Relational DBMS. This adds the additional condition that
    the system supports a tabular structure for the data, with
    enforced relationships between the tables. This excludes
    the databases that don't support a tabular structure or
    don't enforce relationships between tables.


    #2 DBMS does not impose any constraints or security with
    regard to data manipulation it is user or the programmer
    responsibility to ensure the ACID PROPERTY of the database
    whereas the rdbms is more with this regard bcz rdbms difine
    the integrity constraint for the purpose of holding ACID
    PROPERTY.

    #3 DBMS are for smaller organizations with small amount of
    data, where security of the data is not of major concern
    and RDBMS are designed to take care of large amounts of
    data and also the security of this data.
     

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice