LUSID data storage options

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 (File storage)

3rd party DB (Read by Luminesce)

Data: File types

JSON

N/A

N/A

N/A

N/A

N/A

✅

✅

✅

✅

CSV

N/A

N/A

N/A

N/A

N/A

N/A

✅

✅

✅

XML

N/A

N/A

N/A

N/A

N/A

N/A

N/A

✅

✅

TXT

N/A

N/A

N/A

N/A

N/A

N/A

N/A

✅

✅

Excel

N/A

N/A

N/A

N/A

N/A

N/A

N/A

✅

✅

Parquet

N/A

N/A

N/A

N/A

N/A

N/A

N/A

✅

Roadmap

Data: Data types

String

✅

✅

✅

✅

✅

✅

✅

N/A

✅

Decimal*

✅

✅

✅

✅

✅

✅

✅

N/A

✅

Boolean

✅

✅

✅

✅

N/A

N/A

N/A

N/A

✅

DateTime

✅

✅

✅

✅

✅

✅

✅

N/A

✅

Storage: Constructs

Transaction

✅

N/A

✅

✅

N/A

N/A

N/A

N/A

N/A

Position

✅

N/A

✅

✅

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

✅

N/A

N/A

N/A

Quote

N/A

N/A

N/A

N/A

✅

N/A

N/A

N/A

N/A

Instrument

✅

N/A

✅

✅

N/A

N/A

N/A

N/A

N/A

Portfolio

✅

N/A

✅

✅

N/A

N/A

N/A

N/A

N/A

Valuation result

N/A

N/A

N/A

N/A

N/A

N/A

✅

N/A

N/A

Legal entity

✅

N/A

✅

✅

N/A

N/A

N/A

N/A

N/A

Data quality check

N/A

✅

✅

✅

N/A

N/A

N/A

N/A

N/A

Workflow rules

N/A

✅

✅

✅

N/A

N/A

N/A

N/A

N/A

Returns

N/A

N/A

N/A

N/A

Not recommended

N/A

✅

N/A

N/A

ESG data

✅

✅

✅

✅

Not recommended

N/A

✅

✅

✅

Storage: Capability

Bitemporal

✅

✅

✅

✅

✅

✅

✅

❌

Depends on DB

Entitled

✅

✅

✅

✅

✅

✅

✅

✅

Only via Luminesce

Structured

✅

N/A**

✅

✅

✅

✅

✅

❌

Not in a data lake

Scoped

✅

✅

✅

✅

✅

✅

✅

❌

❌

Indexed

✅

✅

✅

✅

✅

✅

Roadmap

❌

Depends on DB

Access: Mechanisms

API

✅

✅

✅

✅

✅

✅

✅

✅

Via Luminesce API

Luminesce

✅

✅

✅

✅

✅

Roadmap

✅

✅

✅

Access: Functionality

Record fetch

✅

✅

✅

✅

✅

✅

✅

✅

✅

Bulk fetch

✅

✅

✅

✅

✅

✅

✅

✅

✅

Filtering

✅

✅

✅

✅

✅

Roadmap

Roadmap

N/A

✅

Aggregation

❌

N/A

✅

✅

N/A

N/A

✅

N/A

✅

Joins

❌

N/A

N/A

N/A

N/A

N/A

✅

N/A

✅

Access: Performance

Optimised for read

✅

✅

✅

✅

✅

Roadmap

Roadmap

Depends on file type

Depends on DB

Optimised for write

✅

✅

✅

✅

✅

Roadmap

Roadmap

✅

Depends on DB