I've done some more searching and I think what I need to do is make my own custom key type as described at the bottom here: http://www.orientechnologies.com/docs/2.0/orientdb.wiki/Indexes.html
I guess I'd make a key based on the path delimited could be used in a range query? Still a bit unclear for me so anyone with some advice please help :-) On Thursday, September 11, 2014 9:40:16 PM UTC+1, Emrul Islam wrote: > > Does no one have a suggestion for me on how to do this? Perhaps I can > explain my data structure a bit better... > > I am using a document database and have an abstract class named 'Entry' > with property 'name' (String). > > I have 2 classes that extend the abstract class: Container - with property > 'children' (LinkList of type Entry) and the other class has no additional > properties. > > I want to retrieve an entry by a path separated by the 'name' property > (e.g. Top Level Container / Sub Container / Something). > > Is a traverse the right command to do this and if so how would I construct > such a query? > > > On Monday, September 8, 2014 1:29:14 PM UTC+1, Emrul Islam wrote: >> >> Hi, >> >> I'm working on a PoC where I need to maintain a file-system like >> hierarchy (e.g /Root/Folder 1/Folder 2/File). >> >> Each entry is represented by an OrientDB record that has a 'name' and >> 'children' properties. >> >> Most operations will be accessed via the path parameter so I'm looking >> for the most efficient way to query by path and also a way to update >> sub-folder/file paths in the event of a rename. >> >> The best approach I've thought of is to maintain a Key-Value index in >> OrientDB storing the path as the key and the rid in the value. Can someone >> suggest a more appropriate way? >> >> Also, is there any way to get OrientDB to assemble paths (e.g. using >> traverse, $path or $stack)? I've tried various combinations but nothing is >> quite right. >> >> >> Many thanks! >> > -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
