| Les deux révisions précédentes Révision précédente | |
| informatique:developpement:memos:base-de-donness-historique [2020/05/22 20:15] – [Bases de données temporelles] jpmilcent | informatique:developpement:memos:base-de-donness-historique [2020/05/22 20:15] (Version actuelle) – jpmilcent |
|---|
| |
| ==== Principes de gestion de l'historique ==== | ==== Principes de gestion de l'historique ==== |
| - https://cybergeo.revues.org/2500 | * https://cybergeo.revues.org/2500 |
| - https://stephanelegrand.wordpress.com/2008/08/17/mise-en-place-dun-historique-des-enregistrements-sous-mysql/ | * https://stephanelegrand.wordpress.com/2008/08/17/mise-en-place-dun-historique-des-enregistrements-sous-mysql/ |
| - http://dba.stackexchange.com/questions/25548/separate-archive-tables-or-soft-delete-for-inventory-database?rq=1 | * http://dba.stackexchange.com/questions/25548/separate-archive-tables-or-soft-delete-for-inventory-database?rq=1 |
| - http://dba.stackexchange.com/questions/35627/best-practices-for-history-temporal-tables | * http://dba.stackexchange.com/questions/35627/best-practices-for-history-temporal-tables |
| |
| ==== Comment gérer l'historique des tables de liaison ==== | ==== Comment gérer l'historique des tables de liaison ==== |
| - http://stackoverflow.com/questions/18988041/history-tables-for-many-to-many-relationships | * http://stackoverflow.com/questions/18988041/history-tables-for-many-to-many-relationships |
| - http://stackoverflow.com/questions/2588521/how-to-track-history-of-db-tables-that-include-many-to-many-mapping-tables | * http://stackoverflow.com/questions/2588521/how-to-track-history-of-db-tables-that-include-many-to-many-mapping-tables |
| |
| ==== Bases de données temporelles ==== | ==== Bases de données temporelles ==== |
| - https://en.wikipedia.org/wiki/Temporal_database | * https://en.wikipedia.org/wiki/Temporal_database |
| - Snodgrass, Richard T. (1999). [[http://www.cs.arizona.edu/people/rts/tdbbook.pdf|Developing Time-Oriented Database Applications in SQL]] PDF (4.77 MiB) | * Snodgrass, Richard T. (1999). [[http://www.cs.arizona.edu/people/rts/tdbbook.pdf|Developing Time-Oriented Database Applications in SQL]] PDF (4.77 MiB) |
jpmilcent