Benefits of databases
What is a database?
A database is a collection of data which has been organised so that a computer program can quickly select desired items. This could be something as straightforward as a list of names in alphabetical order or an ascending list of numeric stock codes. The secret to the successful use of database technology is the way in which data or information is structured to enable efficient processing.
Manual filing systems can have several drawbacks that make them inefficient. For example, if your business uses a simple card file index of customer information, it will probably depend on consistent use to be effective. If all of the cards have the customer's surname in the top left-hand corner, then they may be easy to put in alphabetical order. However, if some cards have the postcode in this position instead, it becomes more complicated.
Database tools and applications are designed to help you store and manage data in a controlled and structured manner.
Single-card file indexes can be simple, but it is more complex to cross-reference information held in two separate files. The relational database management system makes use of common 'keys' to tie related information together. For example, a customer ID number could be used to identify an individual customer in a large list of customers, or to link a customer with an order for specific goods.
Subjects covered in this guide
- Introduction
- What is a database?
- Benefits of database development
- Types of database system
- Deciding what type of database you need
- Systems development
- Potential drawbacks of database development
- Questions to ask a database supplier
