Database design – Back to basics

Over my 15 years of developing with Microsoft Access, I have found myself adding functionality onto existing databases that I have inherited so to speak and sooner or later found that my clients database was not grounded from sensible database design and so the scalability is severely stunted and has little room for expansion and being useful to the users. I always find myself going back to basics and mentally sitting those first classes at college to mull over the relational database and normalisation of the data you want to store and ultimately the information you wish to extract from it.

This shows that it is vital to spend time with the client, understand their needs implicitly in order to root in a solid database design allowing scalability as one day they may well expand , require an upscale to SQL server, where this will pay dividends.

How do you get to the first page on a search engine

The most important for you is to first identify what words that you want customers to find you on search engines is? The less unique the search term, the more competitive your site will be with others. Ultimately this will cost but depends on your search words or ‘keywords’ as they are known. ¬†There are things that you can do to help the search engine rankings but it does require effort and you can speed this process up by paying for such services.

Be warned of black hat services that offer you better search rank position which may get you blacklisted from search engine listings. These can take forms such as link farms.

I take a holistic approach and combine a mixture of techniques based on quality content, blogs, and strong inbound links as part of a strategic seo (Search engine optimisation) / sem (Search engine marketing) campaign. I would budget for a number of hours a month over a six month period to see some serious improvements in search listing placement, depending on your keywords if you want to become first place in your niche Market on the search listing results.

But a campaign shouldn’t stop there like any business shouldn’t stay stagnant, your business is always a work in progress.

Let me know your thoughts?

Welcome to the Linear Solutions blog

Welcome to the linear Blog where I will be hopefully posting useful information and insight into what I come across day to work with challenges of web projects and solutions to hopefully inspire you also and if you are interested to contact me to use on projects , which would be a bonus.

Like business, its important to embrace it as a work in progress and ever will be, To think otherwise will be your downfall. I welcome comments on my posts and strongly believe that there should be a balanced benefit to contributors of quality content, that I will arrange for comments to be do follow using a fair mechansim.