Database design

Databases are a collection of data items organised in a logical and efficient way to ensure that data retrieval is quick and accurate. Databases are engineered in much the same way as software and in reality they are software built with a RAD system.

Client - Server

Client server architecture is where many client applications query data sitting on a server database. The database must follow certain rules processing multiple requests at the same time.

The key to a good database lies in the design. The design and functionality of a database needs a great deal of thought in the early stages to avoid situations whereby one client amending data does not interfere with another client removing it. A poorly written database can cause major headaches for individuals and companies.

Open Database Connectivity (ODBC)

ODBC is the term given to database programming that is non-specific. In short, it allows the design of a system around a generic database. A company may choose an ACCESS Database (a non client-server system) to start with and scale upwards to a fully laden SQL Server or MYSQL. If designed properly the code should remain the same.

Deadlock

Deadlock is where two clients access the same piece of data at the same time. The database gets 'stuck' as it doesn't know what to do first. This may result in the software returning an error message or worse still, it may require a reboot to clear the problem. Deadlock must be avoided at all costs.