Definition of array join


#1

Hi,

We have started using SciDB (ver.11.06) recently, and we found that current SciDB supports array-join only for the same forms.
However, in the following paper, array join allows different forms of inputs (structural join).
Will SciDB team plan to support structural join in the future ?

– Paul G. Brown. 2010. Overview of sciDB: large scale array storage, processing and analysis. In Proceedings of the 2010 international conference on Management of data (SIGMOD '10). ACM, New York, NY, USA, 963-968. DOI=10.1145/1807167.1807271 doi.acm.org/10.1145/1807167.1807271

Thanks in Advance,

– Hideyuki Kawashima
Center for Computational Sciences, University of Tsukuba, Japan


#2

Hello, Hideyuki,

SciDB 11.06 provides three types of join operations. As per our AFL reference:
trac.scidb.org/wiki/Docs/Release … uage_11.06

Please see the documentation on three operators

  • join
  • cross
  • cross_join

See also “merge”.
This is what we support right now. You can also combine cross with slice, redimension and other ops to get a more powerful result. Are there other kinds of patterns that you think would be useful?