Feeds

It's 11 o'clock. Do you know where your databases are?

Nobody does, apparently...

  • alert
  • submit to reddit

High performance access to file storage

Do you know how many databases your organisation has installed? Locally? Across whatever continent you are on? Globally? I don't just mean: which vendors have you bought them from (even if you know that much, which many large organisations won't), but how many instances of each database are there? And of those instances, do you know which instance relates to which version of each product? And do you know which patches have been applied to each of these?

No? Welcome to the club. Neither does anyone else. Why not? Because there is no software currently available that will go and find out all of this information for you.

When I first discovered this I was rather surprised, to say the least. I mean, systems management products like UniCenter, OpenView and Tivoli have been auto-discovering bits of your network for years, so you would have thought that BMC, Quest, ALG and Embarcadero, for example, would be able to do the same thing for databases; but apparently not. I guess it's more difficult to auto-discover a database than a router, though I am not sure that I know why. Actually, it probably isn't finding the database that is difficult but being able to read the metadata that allows you to discover such things as the version number, patches applied and so on.

Why is this an issue? Well, for starters, you can't manage what you don't know. If you have tightening batch windows (and who doesn't?) how can you prioritise the background tasks that need to be run (taking back-ups, for example) if you don't know what databases you have and which are most important? And the same applies to applying patches - the ideal management tool would tell you what patches had been applied to which databases, which newly issued patches were relevant to which of your existing databases, how long each would take to install on each system, and so on and so forth. With that sort of information you can plan. Moreover, it would take a lot of the tedious database management stuff out of the equation.

But, of course, because you don't know what databases you have, you can't do any of this stuff, or a lot more.

So, what if I told you that there is a company that is working on precisely this sort of capability: auto-discover all of your databases, identify the version and patches applied, help to identify the owner of each database, filter new patches according to their relevance to you, allow you to prioritise across database instances for back-up and similar purposes? Would you be interested in such a solution? I can't tell you who it is because they haven't gone public yet and the product is only in the alpha stage. However, the company will be looking for beta partners soon and if you are interested then you can contact me and I'll pass your name on.

Copyright © 2005, IT-Director.com

Related stories

Privacy watchdog warns job seekers to beware
Smile: you're under global surveillance
Privacy from the trenches

Combat fraud and increase customer satisfaction

More from The Register

next story
Sorry London, Europe's top tech city is Munich
New 'Atlas of ICT Activity' finds innovation isn't happening at Silicon Roundabout
MtGox chief Karpelès refuses to come to US for g-men's grilling
Bitcoin baron says he needs another lawyer for FinCEN chat
Dropbox defends fantastically badly timed Condoleezza Rice appointment
'Nothing is going to change with Dr. Rice's appointment,' file sharer promises
Audio fans, prepare yourself for the Second Coming ... of Blu-ray
High Fidelity Pure Audio – is this what your ears have been waiting for?
Did a date calculation bug just cost hard-up Co-op Bank £110m?
And just when Brit banking org needs £400m to stay afloat
Zucker punched: Google gobbles Facebook-wooed Titan Aerospace
Up, up and away in my beautiful balloon flying broadband-bot
Apple DOMINATES the Valley, rakes in more profit than Google, HP, Intel, Cisco COMBINED
Cook & Co. also pay more taxes than those four worthies PLUS eBay and Oracle
prev story

Whitepapers

Designing a defence for mobile apps
In this whitepaper learn the various considerations for defending mobile applications; from the mobile application architecture itself to the myriad testing technologies needed to properly assess mobile applications risk.
3 Big data security analytics techniques
Applying these Big Data security analytics techniques can help you make your business safer by detecting attacks early, before significant damage is done.
Five 3D headsets to be won!
We were so impressed by the Durovis Dive headset we’ve asked the company to give some away to Reg readers.
The benefits of software based PBX
Why you should break free from your proprietary PBX and how to leverage your existing server hardware.
Securing web applications made simple and scalable
In this whitepaper learn how automated security testing can provide a simple and scalable way to protect your web applications.