Re: Hierarchical Top Level BOM Query

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: --CELKO-- (jcelko212_at_earthlink.net)
Date: 02/27/05 

Date: 26 Feb 2005 16:21:54 -0800

Get a copy of TREES & HIERARCHIES IN SQL. I worked out a BOM using the
nested sets model. It will run at least an order of magnitude faster
and let you do hierarchical summaries in a single query.

Relevant Pages

  • Re: Hierarchies and Subtotals
    ... Here is the link on Amazon.com for my new book on "Trees & Hierarchies ... If you use a nested sets model instead of an adjacency list model, ... FROM OrgChart AS O1, OrgChart AS O2, ... Pure SQL, no proprietary stuff, no recursion, no loops. ...
    (microsoft.public.sqlserver.programming)
  • Re: help with query
    ... Get a copy of TREES & HIERARCHIES IN SQL look at other wasy to do this ... In particular, the Nested Sets model. ...
    (microsoft.public.sqlserver.programming)
  • Re: how would I store the XML
    ... Trees and hierarchies in SQL are fairly complex when it comes to ... So, unless you are using SQL Server 2005, I recommend storing the Xml ... Trees in SQL: ...
    (microsoft.public.dotnet.xml)
  • Hierarchy as UP constraint
    ... book (Joe Celko's “Trees and hierarchies in SQL for smarties“) have been written about hierarchies and relational databases, mostly on how to implement hierarchies in tables. ... PNR has a special foreign key-like constraint, ... and in the container interpretation: ...
    (comp.databases.theory)
  • Re: Trying to implent (Joe Celkos) Nested Sets, but need more data columns
    ... Nested sets are just one of many ways to model such ... >things in SQL. ... If anyone using nonrelational features needs help, ... It's possible to model hierarchies to obtain all the benefits of your ...
    (microsoft.public.sqlserver.programming)