Database Basics

From Techotopia
Revision as of 19:11, 24 September 2007 by Neil (Talk | contribs) (New page: == What is a Database? == The chances are that if you have ever logged into a web site or purchased an item on the internet you have interacted with a database in some way. Anything that...)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

What is a Database?

The chances are that if you have ever logged into a web site or purchased an item on the internet you have interacted with a database in some way. Anything that involves the retreval or storage of information on a computer system is most likely to involve a database. In fact, databases are the core of just about every application that relies on data of some form to complete a task.

The first step in learning MySQL is to understand the difference between a database and a database management system (DBMS). The term database refers to the entity which stores the actual data (such as names and address for example) in a structured way. A database management system (DBMS) on the other hand, refers to the software used to store, access and manipulate the data stored in the database. All interactions with the database are always performed via the DBMS.

Modern databases and database management systems are not restricted to storing just text. Today, databases are used to store such items images, videos and software objects.

Understanding Database Tables