THE USE OF DATABASES IN WEBSITE

There are lots of sites on the Internet, Movie Database,Monster.com, Amazon.com etc who offer ways to search, sort, and viewmassive amounts of data.

Each of these sites work on a relational database. Since these siteshave to handle a tremendous number of hits, they use big, expensiveRDBMSes (Relational Database Management System). The names for theRDBMSes they user is familiar to anyone who follows the Nasdaq: Oracle,Sybase, Microsoft SQL Server, and Informix. These are pretty high endand huge databases.

The use of content management systems to allow website owners to maintain their own websites also requires the technology of relational databases.What is a Database?

In database parlance, the phone book is a table which contains arecord for each subscriber. Each subscriber record contains threefields: Name, Address, and Phone number. The records are sortedalphabetically by the name fields, which is called the key fields.

Database Programs:

To create and maintain a computer database, you need a database program, often called a database management system, or DBMS. Just as databases programs, too, range in complexity.

Other database programs, called relational database programs orRDBMS, are designed to handle multi-file databases. FileMaker Pro is arelational database thats easy to use and fairly inexpensive.

Database program tools:

A database program gives you the tools to:

• Design the structure of your database.
• Create data entry forms so you can get information into the database.
• Validate the data entered and check for inconsistencies.
• Sort and manipulate the data in the database.
• Query the database (that is, ask questions about the data).

Using a database:

If mentions of programming languages make you feel youre gettingout of your depth, dont worry! Most of the database programs yourelikely to encounter can be used at a variety of levels.