Invention Grant
- Patent Title: Dynamic incremental updating of data cubes
-
Application No.: US16020246Application Date: 2018-06-27
-
Publication No.: US10740356B2Publication Date: 2020-08-11
- Inventor: Suryanarayana Rao , Viren D. Parikh , Ramesh Chandra Pathak , Ramesh Kumar Goel
- Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATION
- Applicant Address: US NY Armonk
- Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATION
- Current Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATION
- Current Assignee Address: US NY Armonk
- Agency: Roberts Calderon Safran & Cole, P.C.
- Agent Nicholas Bowman; Andrew D. Wright
- Main IPC: G06F16/28
- IPC: G06F16/28 ; G06F16/245 ; G06F16/25 ; G06F16/22 ; G06F16/23

Abstract:
Systems and methods for dynamic incremental updating of online analytical processing (OLAP) data cubes are disclosed. In embodiments, a computer-implemented method, comprises: receiving real-time transactional event data including a plurality of data fields; identifying aggregate computing functions for each of a plurality of standard query language (SQL) queries of a target data cube to be updated, wherein the target data cube is in a multidimensional form for storing OLAP data in the form of numeric values organized in fields; incrementally calculating the aggregate computing functions based on a current aggregated value obtained from an updated aggregated field database, and a value of one of the plurality of data fields; repeating the incremental calculation for each of the plurality of SQL queries to obtain updated field data for the target data cube; and updating the updated aggregated field database with the updated field data.
Public/Granted literature
- US20200004868A1 DYNAMIC INCREMENTAL UPDATING OF DATA CUBES Public/Granted day:2020-01-02
Information query