Re: File System Data Model
Date: Tue, 18 Mar 2003 17:48:36 GMT
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...Received on Tue Mar 18 2003 - 18:48:36 CET
> 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.