Re: Q about materialized paths

On Wed, 29 Sep 2004 08:31:35 +0200, <Leander> wrote:

> Is it known who "invented" materialized path approach in modeling
> hierarchical data with SQL?

According to Celko[1], the materialized path (AKA "path enumeration") encoding was _made popular_ by [2], but Celko doesn't state who invented the encoding. Perhaps [2] has references to original works?

Notes

1. Joe Celko: Trees and Hierarchies in SQL for Smarties ISBN 1558609202 http://books.elsevier.com/mk/default.asp?isbn=1558609202
2. Ben-Gan, Moreau: Advanced Transact-SQL for SQL Server 2000 ISBN 1893115828 http://www.apress.com/book/bookDisplay.html?bID=72

-- 
Greetings from Troels Arvin, Copenhagen, Denmark