click tracking

Database Installation & Configuration

/Database Installation & Configuration
Database Installation & Configuration 2017-10-12T11:48:34+00:00

Database Installation and Configuration

Choosing a database management system (DBMS) for your requirement is an important decision to get right. Generally speaking there are two categories of modern relational (with tables) databases; those designed for multi-user server environments and those for single-user applications on desktop or mobile machines.

There are many small databases for example; Windows Phone’s Isolated Storage, Apple iOS Core Data, SQLite, Microsoft Access, SQL Server Express or Windows CEDB. The choice depends on the requirement and is often influenced by the choice of server database.

Server databases include Oracle, SQL Server, MySQL. These contain specialised mechanisms to ensure that the data is kept reliable and accessible. They are intended to be used by multiple users, and tend to run on high performance server hardware.

We can assist you with carrying out an analysis to determine the best database for you, assist with migrating your data, configuring and deploying your new database and maintaining it. We will go through a thorough analysis of your requirements, asking questions such as;

  • Who uses the database and what tasks do they perform?
  • How often is the data modified, by whom and with what?
  • Who provides technical support for the database?
  • What hardware is available to host the database?
  • Will data be accessible over the internet? (This usually indicates whether a second replicated server or additional security measures or web services need to be implemented).

Often a customer will have their own database, in which case we will work within the constraints of any legacy database. Our Gateway Solver software is even capable of linking flat file systems directly with HM Revenue & Customs!

Careful selection of database options

We keep the latest knowledge on best database practices and available products so that we can match what’s available to your requirements.

Vendor certified

We use Microsoft and Oracle certified developers who understand the capabilities and limits of the vendor platforms to get the very best performing and reliable designs and code made.

The future

We host both SQL Server and Oracle databases on the Microsoft Azure cloud platform, giving up to 100% availability and the ability to dynamically scale the server hardware to ensure operational reliability at peak times and low costs during off peak times.