I am doing a hands-off evaluation of Graph Databases and came across ArcadeDB. I scoured the documentation but did not find explicit mention of which of the supported types can also be indexed, I am especially interested in LIST collections.
I would appreciate any insight, perhaps I missed something in the manual.
I am doing a hands-off evaluation of Graph Databases and came across ArcadeDB. I scoured the documentation but did not find explicit mention of which of the supported types can also be indexed, I am especially interested in LIST collections.
I would appreciate any insight, perhaps I missed something in the manual.
Share Improve this question edited Nov 19, 2024 at 11:54 Stefan - brox IT-Solutions 2,2956 silver badges16 bronze badges asked Nov 18, 2024 at 17:59 VitaliyVitaliy 8,2269 gold badges42 silver badges70 bronze badges1 Answer
Reset to default 2If I understand your question correctly, you are asking which data types can be indexed. So AFAIK all data types are indexable, but only as a whole. So for scalar types (Boolean, Numbers, Strings, ...) this is as expected, and for collection types (Lists, Maps, ...) this means, for example, a list [1,2,3] is indexed as this specific list with these exact elements, and not as contents 1, 2, 3. However there are exceptions, such as the full-text index for strings, and BY KEY or BY VALUE modifiers for the first level of map types (objects), see https://docs.arcadedb/#SQL-Create-Index . For lists this is currently not possible, but there is an open feature request, see https://github/ArcadeData/arcadedb/issues/1593 .