Databases, What are they?

Databases are a method of storing information / data, that you can run queries over. From these queries on the stored data, you are able to generate reports. These reports can be used to help make business decisions.  For example: A stock control system may store all sold products. From this data you can run a report to find out what is the best selling and worst selling product. Based on this information you can identify what product doesn't sell, and make a vital decision to continue selling that product or replace it with another one.

For more information on databases, click here.

databaseDatabases are at the heart of any application and organisation. The key to any good database is design. This allows the database to work at its best for you or your business, as it is tailored to your specifications.

Databases could be used for:

  • Stock control
  • Client details
  • Staff management
  • Work planners

The list could go on and on. The point is that databases can be used for so many different uses.

If you require any database system. Please feel free to contact me to determine requirements.

There are different types of databases, the most common type of database is called a Relational Database Management System (RDMS). Even tho this is the most common and well know type database, but it is not the only type. Other types are:

  • MultiValue Database
  • Object-Oriented Database Management System (OODMS)
  • Object-Oriented Relational Database Management System (OORDMS)

The design of database will depend on the type that is going to be used. You must also be aware that each type has its own benefits and drawbacks. The key is to use the correct type for your purpose.

Based on the most common database technology (RDMS), there are a number of software options you can choose.

  • MySQL
  • Ms Access
  • Oracle
  • Adobe File Maker (Apple Database)
  • LibraOffice Base (similar to Ms Access)