Any product which handles data needs to consider using a database. A database provides efficient data management, data access and data updates. It helps to guard against errors and loss of information. ITDev can architect database solutions that are secure, reliable and easy to maintain.

Database Selection and Installation

Databases can range from a high-performance, real-time, small footprint, single-user embedded database (for example to go inside a data logging device) to a high-level, fully-featured, multi-user database, mirrored over servers on multiple sites.

ITDev has the experience to identify the most suitable database for your requirements. We are able to install and configure the chosen database on the required platform.

Data Modelling

ITDev can develop a data model which accurately represents your data and can then create properly normalised schema and table designs.

SQL

We can write programs to use SQL directly, that are optimised for performance, reliability and protection against injection bugs.

Reports

Our engineers can create sophisticated reports from your data with tables and graphs as required. We can use standard report generation tools to do this or develop custom software.

Database Hosting and Support

ITDev can host the database on its own servers if required and can provide full customer support. For example, if a user accidentally deletes records, we will be able to recover their data if it has been archived.

Typical Databases

• SQLite - a lightweight SQL database library suitable for embedded use.
• MySQL - the leading free relational database system.
• Microsoft SQL Server - a family of database products from Microsoft.