Anatomy of a dataset

A dataset is equivalent to a relational database table.

To get started, you define the table schema in a relational dataset definition. Note the primary key consists of multiple columns, some nominated by LUSID and some by you.

You can then add records to the dataset. A record with unique values in the primary key constitutes a data series:

Adding a record with a different value in any column in the primary key constitutes a new data series (example cell change highlighted in red below):

Adding a record with the same primary key but a change in the date column constitutes a new data point within an existing data series:

Adding a record with a change in any value or metadata column updates an existing data point:

By default, querying a dataset retrieves data series. You can optionally choose to also retrieve data points within data series.