Re: File System Data Model

In an older version of Velocis (2.0) (now known as RDM-Server from Birdstep), there was an example program for this. It disappeared from the last version of Velocis (3.0) that was produced by Centura (who acquired Velocis from Raima, then went bankrupt and sold the IP to Birdstep).

Send me an email (info_at_mcobject.com) and I'll send you the files, including the readme.txt that grants permission to "use all or portions of the contents of this directory for your own purposes."

--

McObject LLC
22525 SE 64th Place
Suite 302
Issaquah, WA  98027
Phone:+1 425 831 5964
Fax:    +1 425 831 1542
http://www.mcobject.com

"Peter" <junk_at_wendler.org> wrote in message
news:6a49813.0303180719.257b18d6_at_posting.google.com...


> I am attempting to create a db schema which would allow me to


> replicate a file system, i.e., locations of files within folders and

> folders within other folders. If anyone has an elegant solution, or

> can point me to a whitepaper on the subject, I would be very grateful.

>

> One of the areas with which I am having some difficulty is the

> creation of a complete path for a file which includes all of its

> parent folders back to the root share point or drive letter. Since

> there are n number of folders between the root and the file, it would

> seem that some kind of recursion would be needed to assemble the path.

> An alternative would be to de-normalize the data by maintaining a

> many-to-many relatoinship between each file or folder and all of its

> parents. This obviously creates some problems maintaining integrity,

> as after any folder is moved, all of its children and children's

> children must be updated.

>

> Thanks in advance for any help.

>

> Peter