======Gestion d'historique en base de données====== ==== Principes de gestion de l'historique ==== * https://cybergeo.revues.org/2500 * 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/35627/best-practices-for-history-temporal-tables ==== 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/2588521/how-to-track-history-of-db-tables-that-include-many-to-many-mapping-tables ==== Bases de données temporelles ==== * 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)