You are here: Your Professional Advice Please - Design « MsSQL Server « IT news, forums, messages
Your Professional Advice Please - Design

Posted by vbnetguy on 05/18/06 02:13

Hi All, I have read MANY posts on how to track changes to data over
time

It appears there are two points of view

1. Each record supports a Change Indicator flag to
indicate the current record
(would this be EVERY table?)
2. Each table is duplicated as an archive table and
triggers are used to update archive


Can someone give me some guidance based on REAL world experience
which works best for them?
My scenario - I have insurance policies and must track history as
policies are updated by customer service reps.
Imagine many tables Policy>LifePol>LifePolRiders
>AccidentPol >etc...
>DIPol>DIPolRiders
To me the archive table scenario does not seem scalable at all....some
guidance on design would be aprreciated...Thanks!!!

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация