Email: support@essaywriterpros.com
Call Us: US - +1 845 478 5244 | UK - +44 20 7193 7850 | AUS - +61 2 8005 4826

Strategies for Schema design

Read Operations

Row

Spec:

Row(<FIELD>=<ROW>)

Description:

Row retrieves the indices of all the columns in a row. It also retrieves any attributes set on that row.

Result Type: object with attrs and columns.

e.g. {"attrs":{"username":"mrpi","active":true},"columns":[10, 20]}

Examples:

Query all columns with a bit set in row 1 of the field stargazer (repositories that are starred by user 1):

Row(stargazer=1)
{"attrs":{"username":"mrpi","active":true},"columns":[10, 20]}
  • attrs are the attributes for user 1
  • columns are the repositories which user 1 has starred.

Row (Range)

Spec:

Row(<FIELD>=<ROW>, from=<TIMESTAMP>, to=<TIMESTAMP>)

Description:

Similar to Row, but only returns bits which were set with timestamps between the given from (inclusive) and to (exclusive) timestamps. Both from and toparameters are optional. The default for to timestamp is current time + 1 day. If a later end timestamp is required, specify it explicitly.

Result Type: object with attrs and bits

Examples:

Query all columns with a bit set in row 1 of a field (repositories that a user has starred), within a date range:

Row(stargazer=1, from='2010-01-01T00:00', to='2017-03-02T03:00')
{{"attrs":{},"columns":[10]}

This example assumes timestamps have been set on some bits.

  • columns are repositories which were starred by user 1 in the time range 2010-01-01 to 2017-03-02.

Row (BSI)