On Mon, 2 Jan 2012 20:32:32 +0100, Petite Abeille <petite.abei...@gmail.com> wrote:
>Recursive 'with' clause anyone? > >"goodbye Connect By or: the end of hierarchical querying as we know it" >http://technology.amis.nl/blog/6104/oracle-rdbms-11gr2-goodbye-connect-by-or-the-end-of-hierarchical-querying-as-we-know-it > >http://docs.oracle.com/cd/E11882_01/server.112/e10592/statements_10002.htm#i2077142 > > >Regarding hierarchical data, in addition to Joe Celkos nice book, here are a >couple of links summarizing different structures: > >Models for hierarchical data >http://www.slideshare.net/billkarwin/models-for-hierarchical-data > >What are the Options for Storing Hierarchical Data in a Relational Database? >http://stackoverflow.com/questions/4048151/what-are-the-options-for-storing-hierarchical-data-in-a-relational-database > >Aside from the materialized path approach, I personally like so-called >"closure tables": > >http://dirtsimple.org/2010/11/simplest-way-to-do-tree-based-queries.html > >And if you feel ambitious, matrix encoding might be for you: > >http://vadimtropashko.files.wordpress.com/2011/07/ch5.pdf > >As always, YMMV as to which one of these structures work best for a given >scenario. Great resources, thanks! -- Regards, Kees Nuyt _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
