Published online by Cambridge University Press: 17 May 2010
Definition: An organized collection of information.
Overview
A collection of files and records is just raw data. Once it has been organized, rationalized, and formatted so that it can be effectively accessed in a uniform way, enabling general queries to be answered by a simple procedure, it becomes a database.
Rational organization is of course essential for any effective record keeping, but for a database system the demands are far more rigorous. A database system will be expected to be able to answer queries totally automatically. To answer even the simplest of queries, such as “what is the salary of the employee named Q. X. Smith in the advertising department?,” mechanically, without any access to intelligence, requires an established format to the data. A human searcher could simply leaf through all the employee records; they would easily be able to pick out the employee's name and their departmental assignment from each form, because everybody knows what proper names look like. It is just common sense; nobody would ever confuse a department name with a social-security number even if they were written in unexpected places on the form.
Of course, computers don't have common sense, and can't be expected to know what makes a credible name for a human. For any such query to be answerable, every single employee record must be formatted uniformly, so that the query application knows exactly where in each record to find the employee's name, department, and salary.
To save this book to your Kindle, first ensure [email protected] is added to your Approved Personal Document E-mail List under your Personal Document Settings on the Manage Your Content and Devices page of your Amazon account. Then enter the ‘name’ part of your Kindle email address below. Find out more about saving to your Kindle.
Note you can select to save to either the @free.kindle.com or @kindle.com variations. ‘@free.kindle.com’ emails are free but can only be saved to your device when it is connected to wi-fi. ‘@kindle.com’ emails can be delivered even when you are not connected to wi-fi, but note that service fees apply.
Find out more about the Kindle Personal Document Service.
To save content items to your account, please confirm that you agree to abide by our usage policies. If this is the first time you use this feature, you will be asked to authorise Cambridge Core to connect with your account. Find out more about saving content to Dropbox.
To save content items to your account, please confirm that you agree to abide by our usage policies. If this is the first time you use this feature, you will be asked to authorise Cambridge Core to connect with your account. Find out more about saving content to Google Drive.