Changes between Version 117 and Version 118 of members/GRIP-UQAM
- Timestamp:
- May 4, 2016, 12:02:29 PM (8 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
members/GRIP-UQAM
v117 v118 920 920 * https://pragprog.com/book/bksqla/sql-antipatterns 921 921 === Tree or Hierarchical Data === 922 * [https://en.wikipedia.org/wiki/Tree_(data_structure)]923 * http://www.worldcat.org/title/joe-celkos-trees-and-hierarchies-in-sql-for-smarties/oclc/795963625922 * Wiki: [https://en.wikipedia.org/wiki/Tree_(data_structure) Tree_(data_structure)] 923 * Book: [http://www.worldcat.org/title/joe-celkos-trees-and-hierarchies-in-sql-for-smarties/oclc/795963625 **Joe Celkos**: '''Trees and Hierarchies in SQL for Smarties'''] 924 924 * http://aleph.unisg.ch/hsgscan/hm00391779.pdf 925 * https://stackoverflow.com/questions/38801/sql-how-to-store-and-navigate-hierarchies926 * https://stackoverflow.com/questions/2175882/how-to-represent-a-data-tree-in-sql927 * http://www.slideshare.net/billkarwin/models-for-hierarchical-data925 * FAQ: https://stackoverflow.com/questions/38801/sql-how-to-store-and-navigate-hierarchies 926 * FAQ: https://stackoverflow.com/questions/2175882/how-to-represent-a-data-tree-in-sql 927 * Slides: http://www.slideshare.net/billkarwin/models-for-hierarchical-data 928 928 * https://yellowpencil.com/blog/how-to-represent-a-tree-structure-numerically-in-sql-server/ 929 929 * http://technobytz.com/closure_table_store_hierarchical_data.html 930 * https://stackoverflow.com/questions/192220/what-is-the-most-efficient-elegant-way-to-parse-a-flat-table-into-a-tree930 * FAQ: https://stackoverflow.com/questions/192220/what-is-the-most-efficient-elegant-way-to-parse-a-flat-table-into-a-tree 931 931 === Blobs for documents === 932 * http://stackoverflow.com/questions/211895/storing-documents-as-blobs-in-a-database-any-disadvantages932 * FAQ: http://stackoverflow.com/questions/211895/storing-documents-as-blobs-in-a-database-any-disadvantages 933 933 === Serialized Objects === 934 934 * https://www.percona.com/blog/2010/01/21/when-should-you-store-serialized-objects-in-the-database