Big Data in a small nutshell

We are well in to the 21st century and that has brought with it an influx of data. You might have a vibrant website showcasing your services, or an eCommerce platform selling your products. This is all made possible with databases whirring away behind the scenes. My passion is to make these databases run as smoothly as possible.

Content Managed Websites

Most websites today will incorporate some sort of content management. I am currently using WordPress to write this blog, and tomorrow I will be using Joomla. Joomla and WordPress require a database behind the scenes to store all the data for the site. This can take the form of webpage content, user details, or even your whole shop. All this data takes up space and when you have a big shop or lots of webpages it needs to be stored safely and efficiently.

Firstly we listen to our customers and we work with you to understand your requirements. We have customers that already have all their data stored in databases like Active Directory or ACT!, and other customers that have just started their business and need to know the best systems to stay future proof. We treat all our customers to the same high standard and deliver wesbites to match.

Secondly we choose our hosting platforms based on the requirements of the website. Everyone’s website is a little bit different and we match your requirements to the best provider. Our platform of choice is Linux for a stable base to run the website, however we are just as comfortable building within a Windows environment.

Finally we match the database to the data it will be storing. We are happy to work with MySQL and Microsoft SQL alike. MySQL is very flexible and can be used with Linux and Windows platforms, whereas Microsoft SQL used to only be available on Windows, however this has all changed this year with Microsoft announcing SQL server on Linux.

The data muscle behind the visual beauty

So what exactly is a database?

In simplest terms it is a way of storing pure data in the most efficient way possible, after that everything becomes a bit more complicated.

If I look at the difference between MySQL and Microsoft SQL we can see that MySQL is a Relational Database and Micrsosft SQL is a Transactional Database. What this means is that MySQL is very happy to work like a big folder of tables and you can stick little post-it notes on these tables when you need to cross reference. This is very useful for content managed websites that just needs to store the data and access it quickly. Microsoft SQL is better suited to storing sensitive data as it remembers all the changes made to the database. However this increased security comes at a price. Normally we will only consider Microsoft SQL for e-commerce.

Think of your database as being your library for all that important data that runs your website. Our tables are like your books, some can be small, and others can be huge. It is my job to keep your books in order and easy to find. You wouldn’t want to walk in to your library and find a mess, and I like to keep your databases fast efficient and clean.

 

Share On Social Media