Is there something like foreign keys?


#1

Hi,

I’m new to scidb.
I want to create relationships between tables. Is it possible? A database schema.
Is there something like foreign keys?

If possible, how can I get tables and relationships of the database by AFL(or AQL)?

Thanks


#2

SciDB uses the array model, not the relational model. So SciDB has arrays, not tables; SciDB has dimensions, not keys. Therefore, there is no notion of foreign key.
The closest to the foreign-key concept in SciDB is the support of non-integer dimensions. See the index_lookup() and uniq() operators.


#3

Thank you!!