Database Development


Database development for you

How can databases benefit me?

The most important features of databases are;

  • Security - access to sensitive information can be restricted.
  • Data recovery - databases offer many tools for backing up and restoring data.
  • Fast access to information - Databases are optimised for delivering data quickly.

Using these most important database features gives your company peace of mind when it comes to protecting and enhancing your commercial interests.

Examples of databases benefiting companies

Recording business operations

Databases store data. This means, your data, when secured correctly, will not be lost. This means you can be confident, that for the lifetime of your business, your data will exist. We can create web front-ends for your data too.

Organised data storage

Very small companies will often store documents and spreadsheets on their file system. When it comes to a certain amount of information, there is nothing wrong with doing that. Well designed databases are optimal at organising information efficiently - reducing time spent searching for and collating information.

Reporting

Databases are excellent at reporting - Monthly sales for the top five customers, weekly product sales by cost centre, best performing regional managers, customer churn rate. We can advise the point at which you may need a separate reporting database too.

Why use Info Rhino to develop your database?

There seems to be a trend, where most development is becoming less focused around the database and more towards the application. Info Rhino doesn’t see this as an issue and yet, more developers shy away from databases.

Not only does Info Rhino embrace both application and database development, but we have developed smart approaches to modelling application data to store data based upon business events. This means we can build classical and specific databases tailored to your business events.

Our principles on databases

  • We endeavour to use the right tool for the right job.
  • We advise on the benefits and costs to different approaches.
  • We remain confident on explaining our reasons for choosing a certain strategy.
  • We have access to trusted partners willing to offer their expertise on different approaches.
  • Always be humble, be willing to learn from others.

Factory Warehouse


About databases guide

What is a database?

A database is simply a place where you store information, you might want to use later. Ideally, this information should be organized efficiently, so information is easy to access. Libraries, address cards photo albums, email account mail boxes, numbered lockers are all great examples of physical databases.

Electronic databases

These are in many forms, and we feel the most important features of a database is that they are ACID;

  • Atomic.
  • Consistent.
  • Isolated.
  • Durable.

The simplest way to think of this is that information never gets lost if these databases are configured correctly.

Most common form of databases

Relational Databases (OLTP)

Relational databases are the most common form of databases inside enterprises. They offer full ACID compatibility, and allow for more optimal storage of information. We have extensive experience in building and reporting from OLTP databases.
Vendors we work with:

  • Microsoft SQL Server
  • Oracle
  • MySQL

NoSQL or document databases

It is rare to find full ACID compatibility. NoSQL databases store data as documents, typically, these types of databases are used by websites which are less concerned about collecting data, and more concerned with retrieving data to support more users. Examples of websites which uses NoSQL are; traveling websites, hotel websites, and larger websites. One downside to these solutions is the lack of ACID, which may mean both a relational and NoSQL database is used in parallel.

Vendors we can consider include;

  • MongoDb
  • Elastic Search

Multidimensional databases - Cubes

These sit on top of a standard form of database called a data warehouse. These are known as OLAP databases and allow for powerful analysis and presentation of data.
We think OLAP is a fantastic technology we love to work with.

Decentralised databases - blockchain

Blockchain, is a distributed ledger of events. You may know that cryptocurrencies sit on top of blockchain. A way to think of it, is that once a payment is validated, there are multiple copies of that payment saved everywhere. We, at Info Rhino are looking into using Bitcoin or Litecoin payments for our property platform, findigl.

Graph databases

We have no experience of using graph databases. Graph databases can dramatically help in linking information together. It just so happens, SQL Server - Info Rhino's weapon of choice supports graph databases, so, at some point we will venture into this area too.


Cargo Warehouse