Sunday, January 07, 2007

Maximising RDBMS effectiveness (1)

Consolidate your database needs.

In is not uncommon for, even small businesses, to accumulate a number of database systems throughout the organisation. The use of Oracle for your larger more complex systems and here and there Microsoft SQL, Filemaker and MySQL to name just a few of the possibilities.

This proliferation can be costing you money and limiting the businesses efficiencies and potentialities.

If you are users of DBMS then you know the criticallity of these systems your your overall effectiveness. But having more than one such system can be costing you money in the form of licensing fees and even where licensing fees may not exist (there are a lot of free RDBMS's available on-line) in terms of lots of people doing disparate systems development and too few people with an indepth knowledge of whole of organisation database needs and systems.

You also probably have people doing database work that should/could be more effective doing other tasks within the organisation. And this can become a real issue if people with the knowledge of 'their'system leave the organisation.

Recently Noel Yuhanna, a Senior Analyst with Forrester Research said, "Typically, enterprises can save over 20% on database management costs with a well-executed plan by reducing servers and storage, databases and tools licences and administrator requirements."

No comments: