One of my clients has mentioned the term 'Database House Keeping' in his tender specs. I am not sure about the term, please help.
+1
A:
I would assume it means maintaining the db, and cleaning up after yourself. For instance, linking the tables properly so that if a user deletes their account, it automatically (or via a cron job/automatic process) cleans up the relational tables associated with that user.
Andrew
2009-11-30 04:23:58
+2
A:
Probably he means clean-up of old records, either moving them to some kind of archive, or just deleting them.
But to be sure, you should ask him to clarify what he means.
Blorgbeard
2009-11-30 04:25:08
+1
A:
Usually things like:
- Recalculating table statistics
- Defragmenting tables and indexes
- Backups
- Managing data and file sizes
RickNZ
2009-11-30 04:44:14
+1
A:
It should be:
- Index rebuild or reorgansise
- Statistics update
- DBCC CHECKDB (check integrity etc) -etc
Other stuff:
- Check backups on tape/offline
- Check backups can be restored
- Monitor size changes
- etc
In this context, I guess:
- Managing older data (I've worked with systems with defined archive processes)
The 1st and 2nd list should be done anyway, regardless of what some vendor says.
gbn
2009-11-30 05:51:10