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!