Skip to main content

Web Database Servers

A database is a collection of recorded information held in a table. Computer databases allow you to search through records very quickly based on a query. For example "find all records of people who have the name bob and are aged 34 years".

Database servers use DBMS (Database Management Systems) to add and extract data from the database tables. Databases can be relational or non-relational.

Relational databases have a relationships between tables for example one database table can hold information about car parts i.e. engine, wheels etc. and another table holds information about registration number, chassis number etc. But both tables have a relationship through the chassis number.

A non-relational database simply lists information such as names. In terms of the Internet, non-relational databases can be used to list domain names or E-mail addresses in a search engine database.

All major database servers accessed on a network or over the Internet are queried using SQL (Structured Query Language). Example query:

SELECT carreg, ChassisNo FROM carparts WHERE enginesize >1000

The above query will return a query report of car registrations and chassis numbers of all cars listed in the carparts database with engine size greater than 1000cc

Next: Scripting Languages and APIs