점 이력, 선분 이력

점 이력, 선분 이력

점 이력

점 이력은 특정 시점에서의 데이터 상태를 기록하는 방식이다. 데터의 변경 사항을 추적하고 해당 시점에서의 데이터 값을 유지한다.

선분 이력

선분 이력은 데이터의 변경 사항을 추적하면서 데이터의 유효 기간을 관리하는 방식이다. 각 데이터에는 시작 시간과 종료 시간이 포함된다.

참고 자료

• https://origina1.tistory.com/107
• https://12bme.tistory.com/200
• https://medium.com/@vipulkr1698/a-point-in-time-database-design-a-comprehensive-guide-18c2cb4160d1
• https://www.codeproject.com/Questions/5257226/Db-design-with-historical-data-at-specific-point
• https://community.fabric.microsoft.com/t5/Desktop/Modeling-Historical-Data/td-p/1963547
• https://www.forecastr.co/blog/historical-financial-data-model-tips
• https://blog.panoply.io/the-role-of-historical-data-in-a-data-warehouse-insights-and-strategies
• https://www.linkedin.com/pulse/power-historical-data-financial-modeling-shashank-hegde-zrczc
• https://12bme.tistory.com/333
• https://im-wali.github.io/datamodeling/modeling-note-06-altered-data/
• https://rasony.tistory.com/m/170
• https://developer-syubrofo.tistory.com/198
• https://medium.com/towards-data-engineering/design-a-database-to-store-large-amounts-of-historical-data-that-needs-to-be-regularly-analyzed-dd6558e1bd02
• https://dev.to/zhiyueyi/design-a-table-to-keep-historical-changes-in-database-10fn
• https://vertabelo.com/blog/price-history-database-model/
• https://medium.com/@vipulkr1698/a-point-in-time-database-design-a-comprehensive-guide-18c2cb4160d1
• https://uta.pressbooks.pub/historicalresearch/back-matter/database-design-and-parts-of-a-database/
• https://gauravkantgoel.medium.com/data-modeling-patterns-for-historical-data-641f9087e887
• https://www.dataversity.net/brief-history-data-modeling/
• https://jaggedarray.hashnode.dev/building-a-historical-data-model
• https://historicalmodeling.com/