Invention Grant
- Patent Title: Materialized query tables with shared data
-
Application No.: US14552557Application Date: 2014-11-25
-
Publication No.: US09934274B2Publication Date: 2018-04-03
- Inventor: Rafal P. Konik , Roger A. Mittelstadt , Brian R. Muras , Mark W. Theuer
- 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
- Agent Jared L. Montanaro
- Main IPC: G06F7/00
- IPC: G06F7/00 ; G06F17/30

Abstract:
A computer system can generate a materialized query table (MQT) for data from a base table that has a plurality of rows and columns that each contain stored data. The computer system can receive a query to data stored in a row from the base table. The system can identify a column in the row and determine that data from a cell in the row and the column is above a threshold memory size. The system can generate, in response to determining that the data being above the threshold memory size, an MQT that includes data for the row and that includes a reference pointer that points to a location shared with another table.
Public/Granted literature
- US20160132558A1 MATERIALIZED QUERY TABLES WITH SHARED DATA Public/Granted day:2016-05-12
Information query