SciDB

SciDB Resource Interface

Introduction

SciDB is an array database management system developed by Paradigm4, Inc. The SciDB resource interface communicates with SciDB through the SHIM interface.

You can find out more about SciDB at http://www.scidb.org

Installation

1. Download the latest version of the SciDB setup.sql script which can be found here.

2. Edit the following script parameters:

• {{scidbresourcename}} - The name of SciDB Service (e.g. Local SciDB)
• {{scidbresourceurl}} - The URL of the SciDB service (e.g. http://192.168.56.101:8080)

3. Run the sql script against the IRCT DB.
4. Restart the IRCT

Order of Operation

The SciDB Resource Interface executes clauses in the following order.

1. SubQueries
2. Joins
3. Where Clauses
4. Sorts
5. Selects

Supported Joins

- Cross Join

• Display Name: Cross Join
• Name: CROSSJOIN
• Description: Performs a cross-product join with equality predicates.

Fields

Name	Path	Description	Required	Types	Supported Values
Right	RIGHT	Right Query	True	SUBQUERY	NA
Dimensions	DIMENSIONS	Dimensions	True	DIMENSION, Array	NA
Left Alias	LEFT_ALIAS	Left Alias	False	String	NA
Right Alias	RIGHT_ALIAS	Right Alias	False	String	NA

Supported Where Predicates

- Filter

• Display Name: Filter
• Name: FILTER
• Description: Filter by value

Fields

Name	Path	Description	Required	Types	Supported Values
Operator	OPERATOR	Operator	True	NA	EQ, NE, GT, GE, LT, LE
Value	VALUE	Value	True	String, Integer, Float, Double	NA

- Between

• Display Name: Between
• Name: BETWEEN
• Description:

Fields

Name	Path	Description	Required	Types	Supported Values
Low Bound	LOWBOUNDS	Low Bounds	True	String, Array	NA
High Bound	HIGHBOUNDS	High Bounds	True	String, Array	NA

Supported Sorts

- Sort

• Display Name: Sort
• Name: SORT
• Description: Sorts the field

Fields

Name	Path	Description	Required	Types	Supported Values
Direction	DIRECTION	Sort Direction	False	NA	DESC, ASC

Supported Select Actions

- Aggregate

• Display Name: Aggregate
• NAME: AGGREGATE
• Description: A set of aggregate functions that can be run

Fields

Name	Path	Description	Required	Types	Supported Values
Aggregate	FUNCTION	Aggregate Function	True	NA	count, approxdc, avg, var, stdev, mad, min, max, median, first_value, last_value, sum, prod
Dimension	DIMENSION	Aggregate Dimension	False	DIMENSION	NA