rasql insert within an MDD object

[Dimitar Misev]

In the way partial updates are supported we should support insert into an existing MDD object. This would allow to insert time slices in a time-series for example, after some data has already been ingested.

Example

insert into 3Dcube[5,*:*,*:*]
values VALUES

This would insert the VALUES (a 2D object) into the existing 3D objects in 3Dcube at slice t=5. The existing slices at t≥5 will be moved to t+1, i.e. slice 5 becomes 6, etc.

A more general and conceptually more appealing approach would be to implement a 'shift' operator in the update statement, that allows to move slices around.

Example (should be refined)

update 3Dcube as c
set c
assign shift(1, 5, 1)

shift(5, 1, 1) means move slice 5 (arg 1) of dimension 1 (arg 2) for 1 (i.e. to slice 6). The 3rd argument could be -1 for example to shift to slice 4.

Implementation: this could be implemented efficiently without moving any data but just shifting some OIDs in the index.