I'm wondering if its possible to index and search complex data types in
Derby. Something along the lines of Oracle cartridge:
http://wiki.oracle.com/page/Data+Cartridge
Scenaio would be that I have a complex blob of data (e.g. could be
stored in a BLOB, CLOB, VARCHAR column) and wand to be able to create
custom index type and allow it to be searched. I know how to decompose
the object into something that can be searched using Java code.
I see various things that are somewhat along these lines, but no obvious
solution:
User defined types: but can't be indexed
Derby-style table functions: but unclear how these could be used
Java Functions: but unclear how these can be used in a where clause, and
can't take BLOB, CLOB params.
I've also seen some discussion on mailing lists on spatial functions,
but nothing that really helps me.
Thanks
Tim
