|
|
|
|
|
|
by icsa
764 days ago
|
|
|
If the arrays of objects can conform to a single schema (across all scalar attributes), then make a second table to hold the objects in the arrays. Now you have a two table schema with (at most) one join in a given query. Check out Vertica. It does a great job at various forms of compression.
In addition, DuckDB is an easy way to get started with efficient OLAP queries. |
|
|