There are two tables, table A and table B. Table A and table B have three field, ‘id’, ‘alpha’,‘delta’. And they all have more than 50,000 records.like:
id alpha delta
1 95.259888 61.118385
In fact, each record in the table represents a position of a star.we take table A and table B to cross-match. Looking for the same star by the records in table A and table B. For example, every record in table A need to calculate with all records in table B.The formula is：
Distance = acos(sin(A.alpha)*sin(B.alpha)
if the distance < 0.008, so the records in table A and table B are describe the same star.
The result table like this :
ida alpha delta idb alpha delta error
1 95.259888 61.118385 2 95.260040 61.117493 0.000895677
Now i want to solve this question with SciDB,I was a novice，could someone give me a good solution?