What is DBMS, RDBMS and MySQL?


What is DBMS?


  • A database management system (DBMS) is a system, usually automated and computerized, used to manage any collection of normalized data.
  • The DBMS manages storage and access to the data, and provides a query language to specify actions associated with the data. The standard query language is SQL.
  • A DBMS generally provides a client application that can be used to directly manipulate the data, as well as a programmable interface. MySQL provides a set of command line clients, as well as a program interface.

What is RDBMS ?


  • Information is stored in tables. Tables store information about entities.
  • Entities have characteristics called attributes.
  • Each row in a table represents a single entity Each row is a set of attribute values Every row must be unique, identified by a key.
  • Relationships --associations among the data values are stored

PHP and MySQL ?


  • MySQL is a database server
  • MySQL is ideal for both small and large applications
  • MySQL supports standard SQL
  • MySQL is free to download and use
PHP + MySQL ("PHP combined with MySQL are cross-platform (means that you can develop in Windows and serve on a Unix platform)")

No comments:

Post a Comment