Invention Grant
- Patent Title: Performing cross-tabulation using a columnar database management system
-
Application No.: US15430223Application Date: 2017-02-10
-
Publication No.: US10282355B2Publication Date: 2019-05-07
- Inventor: Carles Bayés Martín , Jesús Malo Poyatos , Marc Rodríguez Sierra , Alejandro Sualdea Pérez
- Applicant: OPEN TEXT HOLDINGS, INC.
- Applicant Address: US CA San Mateo
- Assignee: Open Text Holdings, Inc.
- Current Assignee: Open Text Holdings, Inc.
- Current Assignee Address: US CA San Mateo
- Agency: Sprinkle IP Law Group
- Main IPC: G06F17/30
- IPC: G06F17/30 ; G06F16/2455 ; G06F16/22 ; G06F16/2458 ; G06F16/2453 ; G06F16/28

Abstract:
Cross-tabulation operation is performed within a columnar database management system. The columnar database management system receives a request to perform a cross-tabulation operation on a set of database tables. The columnar database management system determines values of cross-tabulation operation for each row of the result. The columnar database management system determines a domain for each value of the row dimension corresponding to a row combination. The columnar database management system determines an intersection set of the domains corresponding to values of the row dimensions for the row combination. The columnar database management system determines a value for the result column for the row combination as an aggregate value based on the records of the intersection set.
Public/Granted literature
- US20170154079A1 PERFORMING CROSS-TABULATION USING A COLUMNAR DATABASE MANAGEMENT SYSTEM Public/Granted day:2017-06-01
Information query