LUSID data storage options

However you load data into LUSID, the following storage options are available. 

Storage options

 

Core LUSID (data model)

LUSID data stores

Other data stores

 

Built-in entities

Custom entities

Properties

Multi-value properties

Quote Store

Complex Market Data Store

Structured Result Store

Drive(FINBOURNE file storage)

3rd party DB(Read by Luminesce)

Data:File types

JSON

N/A

N/A

N/A

N/A

N/A

YES

YES

YES

YES

CSV

N/A

N/A

N/A

N/A

N/A

N/A

YES

YES

YES

XML

N/A

N/A

N/A

N/A

N/A

N/A

N/A

YES

YES

TXT

N/A

N/A

N/A

N/A

N/A

N/A

N/A

YES

YES

Excel

N/A

N/A

N/A

N/A

N/A

N/A

N/A

YES

YES

Parquet

N/A

N/A

N/A

N/A

N/A

N/A

N/A

YES

Roadmap

Data:Data types

String

YES

YES

YES

YES

YES

YES

YES

N/A

YES

Decimal*

YES

YES

YES

YES

YES

YES

YES

N/A

YES

Boolean

YES

YES

YES

YES

N/A

N/A

N/A

N/A

YES

DateTime

YES

YES

YES

YES

YES

YES

YES

N/A

YES

Storage:Constructs

Transaction

YES

N/A

YES

YES

N/A

N/A

N/A

N/A

N/A

Position

YES

N/A

YES

YES

N/A

N/A

N/A

N/A

N/A

Complex market data (ie. curve)

N/A

N/A

N/A

N/A

N/A

YES

N/A

N/A

N/A

Quote

N/A

N/A

N/A

N/A

YES

N/A

N/A

N/A

N/A

Instrument

YES

N/A

YES

YES

N/A

N/A

N/A

N/A

N/A

Portfolio

YES

N/A

YES

YES

N/A

N/A

N/A

N/A

N/A

Valuation result

N/A

N/A

N/A

N/A

N/A

N/A

YES

N/A

N/A

Legal entity

YES

N/A

YES

YES

N/A

N/A

N/A

N/A

N/A

Data quality check

N/A

YES

YES

YES

N/A

N/A

N/A

N/A

N/A

Workflow rules

N/A

YES

YES

YES

N/A

N/A

N/A

N/A

N/A

Returns

N/A

N/A

N/A

N/A

Not recommended

N/A

YES

N/A

N/A

ESG data

YES

YES

YES

YES

Not recommended

N/A

YES

YES

YES

Storage:Capability

Bitemporal

YES

YES

YES

YES

YES

YES

YES

NO

Depends on DB

Entitled

YES

YES

YES

YES

YES

YES

YES

YES

Only via Luminesce

Structured

YES

N/A**

YES

YES

YES

YES

YES

NO

Not in a data lake

Scoped

YES

YES

YES

YES

YES

YES

YES

NO

NO

Indexed

YES

YES

YES

YES

YES

YES

Roadmap

NO

Depends on DB

Access: Mechanisms

API

YES

YES

YES

YES

YES

YES

YES

YES

Via Luminesce API

Luminesce

YES

YES

YES

YES

YES

Roadmap

YES

YES

YES

Access: Functionality

Record fetch

YES

YES

YES

YES

YES

YES

YES

YES

YES

Bulk fetch

YES

YES

YES

YES

YES

YES

YES

YES

YES

Filtering

YES

YES

YES

YES

YES

Roadmap

Roadmap

N/A

YES

Aggregation

NO

N/A

YES

YES

N/A

N/A

YES

N/A

YES

Joins

NO

N/A

N/A

N/A

N/A

N/A

YES

N/A

YES

Access: Performance

Optimised for read

YES

YES

YES

YES

YES

Roadmap

Roadmap

Depends on file type

Depends on DB

Optimised for write

YES

YES

YES

YES

YES

Roadmap

Roadmap

YES

Depends on DB

* OpenAPI describes Decimals as Doubles in Swagger.

** You define the structure in the schema; LUSID performs validation on the schema.