Results 1 to 9 of 9
  1. #1
    Join Date
    Dec 2008
    Posts
    2

    Dmbs Vs Database ??

    if MySQL is DBMS ... what is it database ?? pls advice... urgent !!

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    MySQL is a SQL based relational database system RDMS
    for a defintion of a database try here
    for a defintion of a RDBMS try here

    for a defintion of other terms try opening a goolge window and typing define: term

    eg define: database
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Dec 2008
    Posts
    2
    basically there is no name for a database ? just a place to store data ??
    and mySQL, SQLserver is the DBMS to retrieve the data ?

    correct me if i am wrong

  4. #4
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    I don't understand..
    ..."basically there is no name for a database ? just a place to store data ??
    and mySQL, SQLserver is the DBMS to retrieve the data ?"..

    a database is an amorphus area on disk that stores data. the database engine is effectively asked questions (SQL Queries) and retrieves the data from a database.

    a database engine can have many databases stored within its control. each of those databases will have a name, but usually I'd expect one db per company (or per package the company buys). The name of the database within the sql engine will reflect its function (eg personell/HR) or its vendor (eg SAP),

    if its a shared web server db I'd expect the operators of the web server (the ISP) to create distinct dsatabases within their data server(s) which are named after the customer or the application.

    when you connect to most servers you have to specify the database sever you want, the name of the database within that server. each datastore in that database (usually RDBMS's store data in tables) wil have a unique name, and within that table you wil have columns which uniqeuly identify an attribute

    if you want to go into the mechaics of relational databases do a google on normalisation but these two references are a pretty good starting point
    www.r937.com/Relational.html
    http://www.tonymarston.net/php-mysql...tml#2005-08-12

    both of those sites have lots of other 'good' stuff that may be of interest
    I'd rather be riding on the Tiger 800 or the Norton

  5. #5
    Join Date
    Dec 2007
    Location
    London, UK
    Posts
    741
    A database is just any organised collection of data.
    A DBMS is the software that manages databases (creates them, updates them and queries them).

  6. #6
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    The DBA gives the database a name when they create the database.

    -PatP

  7. #7
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Quote Originally Posted by dportas
    A database is just any organised collection of data.
    Does that mean we class excel spreadsheets and CSV files as databases?
    *shrug*
    George
    Home | Blog

  8. #8
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Yes.
    But they are not RELATIONAL databases.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  9. #9
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Calling Excel a database makes me feel unclean...
    George
    Home | Blog

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •