Database Development

Our team have been working with databases of all types for more than 20 years. Often these systems are actually complex bespoke applications of which the 'database' is actually only a means of data storage at the heart of the system. Our goal is to capture your business process and from it develop a user-friendly application to massively improve your efficiency.

Scottish SPCA inspectorThe value in these systems is that they reflect your business processes, guiding users the best way through, enforcing requirements where necessary, capturing all the key information and relationships and providing powerful tools to give management an overview.

We work with users at all levels of the organisation - this helps ensure that the people who will ultimately use the system have buy-in which can be the key to successul adoption. This also helps us to understand how things actually work which may differ from the way they are supposed to - e.g. if the users know they often have incomplete information we can build that knowledge in rather than add work-arounds later.

We wil challenge your processes to help you choose the best path forward rather than always doing things a certain way "because that's the way it's always been done" but at the same time we are always aware that our job is to build a system to suit your process rather than forcing you to change to fit into ours.

We often build databases to replace legacy systems which 'do the job' but have not been designed with the user in mind.  It is often necessary to retain the existing legacy data, so we have developed a number of techniques to handle this, along with the skills to understand legacy systems which often come with limited or no documentation.

Sample Work

SSPCA Membership

SSPCA Animal Database

SSPCA Education DB

The Art Newspaper

St Andrews University

 

Technology

We work with a number of different technologies so that we can choose the most appropriate for your business needs.  We build database back-ends for our projects from the ground up in Oracle, MSSQL, MySQL, NoSQL and front-ends using web technologies like Coldfusion or PHP or desktop applications like Filemaker Pro.