<pedrocorreia.net ⁄>
 

<Nested set in MySQL ⁄ >




clicks: 3003 3003 2008-12-27 2008-12-27 goto programacao myNews programacao  Bookmark This Bookmark This


There seems to be massive confusion about the concept behind nested set and when/how it should be used. In this article I will attempt to remove some of the mystery behind nested set, explain some of the magic and provide a few easy to understand examples for implementing and working with nested set in MySQL.

Before I get started I should note that there is a reasonably extensive article at MySQL on this topic. What I am trying to achieve here is an easier to understand explanation to the same problem.

What is nested set? When should I use it?

The nested set model is a way of efficiently storing and retrieving hierarchical data in a database. The model requires "sequence" data to be stored with each record to indicate it's order and depth within a hierarchy. That stored sequence data can then be used to retrieve the data or parts of the data along with the associated depth information without the need to use multiple queries or sub-queries.

Nested set can be used whenever you need to store and retrieve any kind of hierarchical data. Regardless of whether it is single parented or multi-parented data. For example, if you have a "family tree" that you want to store in a database or if you need to store an organisational structure.



este é só um excerto do artigo, para aceder ao artigo completo, clique no link em baixo:
this is just a small excerpt from the article, to access the full article please click in the link below:

http://www.fliquidstudios.com/2008/12/23/nested-set-in-mysql/




Subscribe News RSS  Subscribe News Updates by E-mail





myNews <myNews show="rand" cat="programacao" ⁄>

RouterJs: easy routing for your ajax Web applications new ...

RouterJs is a simple router for your ajax web apps. It's build upon History.js which means that Rout (...)

clicks: 16497 16497 2012-05-14 2012-05-14 goto url (new window) haithembelhaj.g... goto myNews programacao


Backbone computed properties new ...

This gist shows one way to implement read- and write-enabled computed properties on a Backbone Model (...)

clicks: 16343 16343 2012-05-13 2012-05-13 goto url (new window) https://gist.gi... goto myNews programacao


HTML5 jQuery Paint Plugin new ...

Websanova Paint is a HTML5 canvas based jQuery plugin. It allows you to free paint on a canvas area (...)

clicks: 27132 27132 2012-05-12 2012-05-12 goto url (new window) websanova.com/t... goto myNews programacao


Android Query new ...

Android-Query (AQuery) is a light-weight library for doing asynchronous tasks and manipulating UI el (...)

clicks: 16533 16533 2012-05-12 2012-05-12 goto url (new window) code.google.com... goto myNews programacao


Create Instagram Filters With PHP new ...

In this tutorial, I'll demonstrate how to create vintage (just like Instagram does) photos with PHP (...)

clicks: 16039 16039 2012-05-12 2012-05-12 goto url (new window) net.tutsplus.co... goto myNews programacao


Sass vs. LESS vs. Stylus: Preprocessor Shootout new ...

CSS3 preprocessors are languages written for the sole purpose of adding cool, inventive features to (...)

clicks: 15738 15738 2012-05-11 2012-05-11 goto url (new window) net.tutsplus.co... goto myNews programacao


Real-time Applications With Node.js and Socket.IO new ...

Hey everyone! Sorry about the long pause since the last blog post, life has been quite hectic for th (...)

clicks: 16410 16410 2012-05-11 2012-05-11 goto url (new window) codingcookies.c... goto myNews programacao


15 Handpicked jQuery Drop Down Menus Tutorials new ...

Here we are presenting another brilliant collection of 15 jQuery navigation menu that you can downlo (...)

clicks: 15451 15451 2012-05-10 2012-05-10 goto url (new window) smashingapps.co... goto myNews programacao