CODEWITHSUNDEEP
sql-serverdatabase
Eros
Eros

Reputation: 703

What is meant by 'House Keeping' in context of a database?

One of my clients has mentioned the term 'Database House Keeping' in his tender specs. I am not sure about the term, please help.

Upvotes: 4

Views: 14149

Answers (4)

gbn
gbn

Reputation: 432471

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.

Upvotes: 4

RickNZ
RickNZ

Reputation: 18652

Usually things like:

  1. Recalculating table statistics
  2. Defragmenting tables and indexes
  3. Backups
  4. Managing data and file sizes

Upvotes: 2

Blorgbeard
Blorgbeard

Reputation: 103525

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.

Upvotes: 4

Andrew
Andrew

Reputation: 1507

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.

Upvotes: 1

Related Questions