Cache fetching of OLAP based data using client to client relationships and data encoding
AssigneeInternational Business Machines Corporation
InventorsSaurabh Dwivedi, Rahul Parashar
Life of this patent
Estimating the term…
Abstract
Embodiments include techniques for implementing cache fetching of online analytical processing (OLAP) based data using client to client relationships and data encoding, where the techniques include assigning codes for each dimension of a data cube, and determining a client stores data corresponding to the data cube based on a client ID, wherein the client ID indicates the client stores the data. The techniques also include transmitting a request to the determined client for the data, wherein the request includes one or more assigned codes for the data, and receiving and storing the data.
Claims15
A computer-implemented method for implementing cache fetching online analytical processing (OLAP) based data using client to client relationships and data encoding, the computer-implemented method comprising:
- assigning codes for each dimension of a data cube;
- determining a client stores data corresponding to the data cube based on a client ID, wherein the client ID indicates the client stores the data;
- transmitting a request to the determined client for the data, wherein the request includes one or more assigned codes for the data;
- receiving and storing the data;
- wherein a combination of assigned codes exceed a threshold number of requests, mapping the combination of assigned codes to a short code;
- and
- storing the short code in a separate frequently used table.
A system for implementing cache fetching online analytical processing (OLAP) based data using client to client relationships and data encoding, the system comprising:
- a storage medium, the storage medium being coupled to a processor;
- the processor configured to:
- assign codes for each dimension of a data cube;
- determine a client stores data corresponding to the data cube based on a client ID, wherein the client ID indicates the client stores the data;
- transmit a request to the determined client for the data, wherein the request includes one or more assigned codes for the data;
- receive and storing the data;
- wherein mapping tables store cube information, page information, server hash table ID, and a client ID;
- concatenate the assigned codes for each dimension to produce a concatenated code used in the request;
- convert the concatenated code into a short code, wherein a length of the short code is shorter than a length of the concatenated code;
- and
- store the short code in a separate frequently used table.
A non-transitory computer program product for cache fetching online analytical processing (OLAP) based data using client to client relationships and data encoding, the computer program product comprising:
- a computer readable storage medium having stored thereon first program instructions executable by a processor to cause the processor to:
- assign codes for each dimension of a data cube;
- determine a client stores data corresponding to the data cube based on a client ID, wherein the client ID indicates the client stores the data;
- transmit a request to the determined client for the data, wherein the request includes one or more assigned codes for the data;
- receive and storing the data;
- wherein mapping tables store cube information, page information, server hash table ID, and a client ID;
- concatenate the assigned codes for each dimension to produce a concatenated code used in the request;
- convert the concatenated code into a short code, wherein a length of the short code is shorter than a length of the concatenated code;
- and
- store the short code in a separate frequently used table.
Dependencies are inferred from the claim text.