Version: 1.1
Seller:
Price:
-
-
System:
Rating:
4.7
4.7
License:
sql database oracle9i database access database northwind database sql 2005 email addresses database sql query efficient frontier
Description - Efficient database trees
Sometimes it can be hard to work out a way of efficiently representing a tree in the database. Combining modified preorder tree traversal with a parent child model allows most common queries to be represented in a single SQL Query. This example uses MySQLdb, but can easy be changed to use any DBI compatable module.