Metadata

  • 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.

  • 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 2 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply