Share |

At the heart of a professional software system resides a database which is modeled for best performance, data integrity and scalability.

Most developers neglect to spend adequate time on database design/modeling, with the attitude that the database is only used as a storage location.
Poor database design or choice of database engine can lead to the following: Loss of data, data integrity violations or even a very slow database.

A badly designed database will eventually effect the front-end that utilizes it i.e. your website. This can all be avoided by properly planning the database model based on the technical specification, and following good database design practices in terms of normalization, indexes etc.
It becomes significantly difficult to correct a poorly designed database after it has gone into production and started collecting data - its a good idea to get it right the first time!

I’ve been working extensively with the MySQL database for the last few years and have modeled relational databases with up to  100 tables, 100% normalized. I also have good experience with the EAV model as used by Magento commerce, 200+ tables. Additionally I also have adequate knowledge of MS SQL Server and SQLite to accomplish most things, although MySQL remains my favorite.

Some database services I offer:

  • Custom Database design.
  • Altering of existing database.
  • Data mining.
  • Database optimization and profiling

Featured Posts

How to avoid “spaghetti mess” co..

I believe all programmers found themselves caught in this situation at least once… the dreadful ...

freelance web development vs full-ti..

I quit my full-time job in August 2010 -  I’ve been doing full-time freelance Web ...

Zend Framework vs Codeigniter vs Cak..

There are so many other blogs on this topic and I'm not about to start ...

How to eliminate creative block..

Yet another article on the dreaded phenomena, creative block! I’ve been suffering from this quite a ...

jQuery active link, active page..

I was recently asked to set the current page hyperlink (button) active, I did not ...

Zend Framework new era..

PHP has come a long way over the past decade and is still the most ...

Google interrupts natural progressio..

Is Google (and other SE's) hindering natural technological growth? I think websites would have looked somewhat ...

Magento Pros and Cons..

I've been involved in a 4 month, extensive Magento development, during this time I got ...

Resources