August 15, 2003 at 12:38 pm
We've recently decided to add fields to track the date updated and date added of some records, plus the id of the manager who performed these operations.
My boss suggested creating new tables to store this metadata instead of putting the fields within the table itself.
Which would be better?
August 15, 2003 at 1:43 pm
Difficult problem.
I would probably go for the separate table. This keeps both functionalities (data and auditing) neetly separated and gives you the greatest flexibility in the future.
It will also avoid any problems if an application uses a select * in a query.
December 8, 2014 at 10:01 am
I think you are looking for a metadata management tool.
A few good ones available. Google "Metadata Management Software"
The main idea is to capture metadata on a schedule, then have it available for search and impact analysis.
very handy.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy