Database system for management of arrays

Method for processing multidimensional array data in a database system, comprising:

• a) transmitting an array input via an application programming interface and an input query to a processing unit;
• b) generating and optimizing a query plan from the input query;
• c) modifying the input array according to the query plan and translating the input array into a predetermined internal format of the processing unit;
• d) determining an array data or array partial data affected by the query plan, the array data or array partial data are stored in storage means of the database system;
• e) loading into the processing means, decoding and decompressing the determined array data or array partial data according to an indicator assigned to the data, generating a modified array data or array partial data from the data of the input array;
• and
• f) translating overwritten array data or array partial data into a storage format predetermined by an indicator assigned to the data and transferring the data to a storage interface.

Method for processing multidimensional array data in a database system, comprising:

• a) transmitting an input query through an application programming interface to a processing unit;
• b) generating and optimizing a query plan on the basis of the input query;
• c) allocating a storage place for a resulting array obtained by the input query;
• d) determining an array data or array partial data affected by the query plan, the array data or array partial data are stored in storage means of the database system;
• e) loading into the processing unit, translating the determined array data or array partial data from a storage format predetermined by an indicator assigned to the data into a predetermined internal format of the processing unit, copying of relevant array partial data into a resulting array according to the query plan;
• f) effecting further operations according to the query plan;
• g) translating the resulting array data into an output format predetermined by an indicator transmitted via an application programming interface, in case the output format differs from the internal data format;
• and
• h) transmitting the resulting arrays to the application programming interface.