Feeds

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

Nobody does, apparently...

  • alert
  • submit to reddit

Secure remote control for conventional and virtual desktops

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

Secure remote control for conventional and virtual desktops

More from The Register

next story
Musicians sue UK.gov over 'zero pay' copyright fix
Everyone else in Europe compensates us - why can't you?
Bladerunner sequel might actually be good. Harrison Ford is in it
Go ahead, you're all clear, kid... Sorry, wrong film
I'll be back (and forward): Hollywood's time travel tribulations
Quick, call the Time Cops to sort out this paradox!
Megaupload overlord Kim Dotcom: The US HAS RADICALISED ME!
Now my lawyers have bailed 'cos I'm 'OFFICIALLY' BROKE
Forget Hillary, HP's ex CARLY FIORINA 'wants to be next US Prez'
Former CEO has political ambitions again, according to Washington DC sources
Euro Parliament VOTES to BREAK UP GOOGLE. Er, OK then
It CANNA do it, captain.They DON'T have the POWER!
prev story

Whitepapers

Free virtual appliance for wire data analytics
The ExtraHop Discovery Edition is a free virtual appliance will help you to discover the performance of your applications across the network, web, VDI, database, and storage tiers.
A strategic approach to identity relationship management
ForgeRock commissioned Forrester to evaluate companies’ IAM practices and requirements when it comes to customer-facing scenarios versus employee-facing ones.
10 threats to successful enterprise endpoint backup
10 threats to a successful backup including issues with BYOD, slow backups and ineffective security.
High Performance for All
While HPC is not new, it has traditionally been seen as a specialist area – is it now geared up to meet more mainstream requirements?
Website security in corporate America
Find out how you rank among other IT managers testing your website's vulnerabilities.