1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Difference between Database & Database Management System

Discussion in 'Database' started by aryan123, Feb 16, 2011.

  1. aryan123

    aryan123 New Member

    Joined:
    Jan 9, 2011
    Messages:
    22
    Likes Received:
    0
    Trophy Points:
    0
    Database is an organised collection of data or information so that it can be easily accessed, updated or manipulated.

    Database management system (DBMS) is a software that manages database on a computer. Eg. microsoft access, MySQL, oracle etc.

    Database are classified according to their organisational approach.

    Few of them are listed below :

    1. Relational database :- A tabular database in which data is defined so that it can be reorganized and accessed in a number of different ways. It stores data in tables with relationships to other tables.
    2. Distributed database :- A distributed database is one that can be dispersed or replicated among different point in a network.
    3. Object oriented programming database :- In this database, the data is defined in object classes and sub classes.
    MySQL, a popular DBMS used online is an example of object oriented DBMS.
     
  2. lionaneesh

    lionaneesh Active Member

    Joined:
    Mar 21, 2010
    Messages:
    848
    Likes Received:
    224
    Trophy Points:
    43
    Occupation:
    Student
    Location:
    India
    Re: Difference between database and database management system

    short and effective info!!
     
  3. shabbir

    shabbir Administrator Staff Member

    Joined:
    Jul 12, 2004
    Messages:
    15,283
    Likes Received:
    364
    Trophy Points:
    83
    You submitted the same as thread and article and I have moved the thread out.
     
  4. bhavanaets

    bhavanaets Banned

    Joined:
    Apr 8, 2011
    Messages:
    10
    Likes Received:
    0
    Trophy Points:
    0
    The database holds the records, fields, cells ..with data. The DBMS is the "tools" used to manipulate the data in the database. An example of a DBMS is SQL Server.
    The DBMS is the database engine itself. This is the core, the actual program that contains the logic to execute your SQL statements. performs that actual data access based upon these commands (relationaly).
    whereas DS is linked with improving the speed of traversing and searching the data in main memory.
    As we all know that the processor can only process the data that is available in main memory. Therefore the different models used to organize data in main memory are collectively referred as DS.
    In DBMS Normalization process wille not be present and in
    RDBMS normalization process will be present to check the
    database table cosistency.
     
  5. vinaykumar4670

    vinaykumar4670 Banned

    Joined:
    Dec 7, 2010
    Messages:
    26
    Likes Received:
    0
    Trophy Points:
    0
    Occupation:
    SEO
    Location:
    Delhi
    Home Page:
    nice post for DBMS purpose.
     
  6. Eldridge13

    Eldridge13 New Member

    Joined:
    May 23, 2011
    Messages:
    15
    Likes Received:
    0
    Trophy Points:
    0
    Location:
    USA
    Home Page:
    Thanks I just learn a lot from this DBMS article.
     
  7. expert_neel

    expert_neel New Member

    Joined:
    Jun 3, 2011
    Messages:
    2
    Likes Received:
    2
    Trophy Points:
    0
    Hi,
    As it is already explained very well by given answers.
    Database is nothing but collection of data, information like files, tables(cells, records) etc.
    Database management system as its lateral meaning shows its a system to manage database.
    it includes following functionality:
    ->how to store data
    ->how to display data
    ->how to manipulate data

    for example SQL Server data base management system
    Database : SQL database : collection of tables
    System Fucntionality:
    DDL-> how to store data: query like create, alter, insert...
    DML-> how to manipulate data: query like update, select...
    DCL-> how to control data : query like Commit, rollback, savepoints...

    Hope you would be getting some idea. :)

    Regards,
    Neel
     
    shabbir likes this.
  8. amankumar

    amankumar New Member

    Joined:
    Jul 21, 2011
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    0
    the data are store in the database is called database. and then database management system is the main
    memory and refer to the data structure.
     
  9. xcfrrdvd

    xcfrrdvd New Member

    Joined:
    Feb 24, 2012
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    0
    Occupation:
    http://www.idealdvdmall.com.au
    Location:
    http://www.idealdvdmall.com.au
    Home Page:
    I’d like to scrap some old childhood photos of myself. My Aunt gave them to me and I’d like to get those into an album.
     

Share This Page