Prochaine révision | Révision précédente |
informatique:developpement:memos:base-de-donness-historique [2020/05/22 20:14] – créée 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) |