Skip Navigation
The analysis and interpretation of Public Service data from secondary sources
Databases

Databases

A database is just another name for a large collection of information held on a computer in such a way that it can be retrieved in response to specific queries.

For example a query addressed to the DVLA database might be, "Give me a list of all the people living in Hereford who are the registered owner of a Ford Fiesta, colour red, registered between 1998 and 2003".

Click on the link below to learn more about how databases work:

http://www.dbcc.cc.fl.us/fipse_sh/database.htm

All of the Public Services use databases extensively to store information about people, vehicles, property, crime etc. These will either be designed specifically for a particular task, such as a Crime reporting package or may make use of off the shelf database applications such as Microsoft Access. The data is held in 'fields' such as :-

This allows for searches of the database using the field names, e.g.:

"List Crimes where Offence details = 'Criminal Damage' and Date Committed is 'between 01/03/2004 and 31/03/2004' and location = 'Beta Road'."

Here is an example of a Crime Report that would be found by this query.

©Coleg Llandrillo Cymru 2004. Contact: www.llandrillo.ac.uk (new window)