Wednesday, 26 November 2008

Make your software do all the work

If you work daily with databases you’ll know that there are certain jobs that you have to perform over and over again. This is where Database Automation comes in, which Wikipedia defines as “the automation of servers and databases respectively causing the reduction of database related tasks” which is pretty succinct and sums it up very well.

And this doesn't only mean tasks like taking backups. Activities like creating database, purging tables and running optimisation scripts can all the automated, but one must realise that this only reduces the amount of mundane, repetitive activities and does not eliminate the need for DBAs. The intention of DBA automation is to enable DBAs to focus on more proactive activities around database architecture and deployment.

No comments: