public marks

PUBLIC MARKS with tags sql & tree

2008

2007

DBAzine.com: Trees in SQL: Nested Sets and Materialized Path

by ogrisel & 1 other (via)
Relational databases are universally conceived of as an advance over their predecessors network and hierarchical models. Superior in every querying respect, they turned out to be surprisingly incomplete when modeling transitive dependencies. Almost every couple of months a question about how to model a tree in the database pops up at the comp.database.theory newsgroup. In this article I'll investigate two out of four well known approaches to accomplishing this and show a connection between them. We'll discover a new method that could be considered as a "mix-in" between materialized path and nested sets.

Making a tree with "millions and millions" of dynamic nodes

by ogrisel
First mail of a thread on the postgresql mailing list dealing of various ways to implement a tree structure with PostgreSQL.

Representing Trees in a relational DB

by ogrisel (via)
This document describes an approach for handling hierarchical data in a relational database.

2006

2005

Content with Style: Database-driven tree structures with XML and XSLT

by fastclemmy & 1 other
This article deals with the display of tree-structures that are driven by a database. There are actually a few approaches to transform a 2-dimensional structure into a tree, and it seems odd that most are unknown to many developers.

Content with Style: Database-driven tree structures with XML and XSLT

by fredbird & 1 other
This article deals with the display of tree-structures that are driven by a database. There are actually a few approaches to transform a 2-dimensional structure into a tree, and it seems odd that most are unknown to many developers.

PUBLIC TAGS related to tag sql

Algorithm +   data +   data-tree +   database +   db +   dev +   hierarchical +   howto +   lang:en +   modeling +   mysql +   php +   postgresql +   programming +   reference +   structure +   tech +   tree +   type:article +   web +   web-dev +   xml +  

Active users

kemar
last mark : 17/01/2008 08:26

krachot
last mark : 22/06/2007 13:08

ogrisel
last mark : 15/02/2007 01:28

smartynaoki
last mark : 25/07/2006 05:57

etng
last mark : 01/06/2006 01:27

bago
last mark : 28/11/2005 16:27

fastclemmy
last mark : 19/07/2005 17:06

fredbird
last mark : 19/07/2005 15:35