Storing Hierarchical Data in a Database [PHP & MySQL Tutorials] - The Diigo Meta page

• 18 Nov 09
  

  Edoardo Marcora

  tutorial gmarks

• 24 Apr 09
  

  Michael C. Harris

  Good explanation of MPTT

  mptt algorithms hierarchy programming

• 28 Mar 09
  

  Johann Lemaitre

  _SUPPORT php

• 27 Mar 09
  

  Ramon Garcia

  Whether you want to build your own forum, publish the messages from a mailing list on your Website, or write your own CMS: there will be a moment that you’ll want to store hierarchical data in a database. Gijs explains two practical methods to do just that.

  database hierarchical mysql nested nested sets

• 18 Mar 09
  

  Peter Jacobson

  Whether you want to build your own forum, publish the messages from a mailing list on your Website, or write your own cms: there will be a moment that you’ll want to store hierarchical data in a database. And, unless you’re using a XML-like database,

  Bookmarks Database tree hierarchical howto Tutorial

• 13 Feb 09
  

  kooala lo

  除了傳統遞迴的建樹方式
  這篇文章使用了二元樹的改進方式來儲存
  避免遞迴對大資料的效率與資源問題

  OOAD design-pattern

• 03 Jan 09
  

  Łukasz Bandzarewicz

  database sql

• 04 Sep 08
  

  owcs .

  programming database sql

• 09 May 08
  

  slith one

  programming php

• 08 Apr 08
  

  Richard Sheppard

  algorithm algorithms development preorder sitepoint traversal tree for:drewreece for:jakejays Hierarchical

• 02 Apr 08
  

  junkie o0o

  menu

• 21 Mar 08
  

  l.m orchard

  sql trees webdev

• 11 Mar 08
  

  Timothy Wood

  php database tutorial programming mysql tree sql data webdev google_maps hierachical_data HIERARCHICAL_DATA binderlibrary Development_Articles

• 31 Dec 07
  

  Brandon Skeen

  PHP MySQL sql programming database

• 29 Sep 07
  

  cullepm3
• 17 Aug 07
  

  Achmad Solichin

  Whether you want to build your own forum, publish the messages from a mailing list on your Website, or write your own CMS: there will be a moment that you’ll want to store hierarchical data in a database. Gijs explains two practical methods to do just .

  PHP

• 18 Apr 07
  

  Marcos Nagamura

  Technology

• 19 Mar 07
  

  courtingthegoldfish

  General

• 10 Jan 07
  

  Tracy Flynn

  database nested relational sets

• 29 Jul 06
  

  Jon Phipps

  mysql php rdf sql xml

  • Storing trees is a common problem, with multiple solutions. There are two major approaches: the adjacency list model, and the modified preorder tree traversal algorithm.

    
    
    

    In this article, we’ll explore these two methods of saving hierarchical data.

• 08 Jul 06
  

  Jack Baty

  linkdump mysql php

• 08 Feb 06
  

  adiwidjaja

  Very good description of storing trees in mysql. Adjacency list model and the modified preorder tree traversal algorithm.

  php mysql tree howto

• 17 Jan 06
  

  Allen Day

  Whether you want to build your own forum, publish the messages from a mailing list on your Website, or write your own CMS: there will be a moment that you’ll want to store hierarchical data in a database. Gijs explains two practical methods to do just tha

  programming

• 05 Oct 05
  

  Demian Turner

  sql

• 24 Apr 05
  

  scaracco

  PHP Database

  • Whether you want to build your own forum, publish the messages from a mailing list on your Website, or write your own cms: there will be a moment that you’ll want to store hierarchical data in a database. And, unless you’re using a XML-like database, tables aren’t hierarchical; they’re just a flat list. You’ll have to find a way to translate the hierarchy in a flat file.

Would you like to comment?

Join Diigo for a free account, or sign in if you are already a member.