US 12,353,381 B2
Large object data type support for column-based database system
Luis Eduardo Oliveira Lizardo, Böblingen (DE); Johannes Severin Kern, Boeblingen (DE); Mehmet Cuneyt Goksu, Schonaich (DE); and Daniel Martin, Leinfelden-Echterdingen (DE)
Assigned to International Business Machines Corporation, Armonk, NY (US)
Filed by International Business Machines Corporation, Armonk, NY (US)
Filed on Jul. 19, 2022, as Appl. No. 17/813,501.
Claims priority of application No. 21193863 (EP), filed on Aug. 30, 2021.
Prior Publication US 2023/0060702 A1, Mar. 2, 2023
Int. Cl. G06F 16/22 (2019.01); G06F 16/25 (2019.01)
CPC G06F 16/2219 (2019.01) [G06F 16/221 (2019.01); G06F 16/254 (2019.01)] 19 Claims
OG exemplary drawing
 
1. A computer-implemented method for processing an unsupported data type in a database, the method comprising:
providing a database management system comprising a primary database and a secondary database, wherein the primary database is a row-oriented database, and wherein the secondary database is a column-oriented accelerator portion of the database management system with support for row-oriented tables;
copying data from the primary database to the secondary database, wherein the copying comprises:
detecting, in the primary database, a table for data comprising a data type that is unsupported by the secondary database;
generating a column-oriented base table in the secondary database as a copy of the detected table of the primary database;
generating a row-oriented additional table in the secondary database;
linking the row-oriented additional table to the column-oriented base table in the secondary database via a row-identifier relationship;
inserting data of the supported data type from the detected table into the column-oriented base table; and
inserting data of the unsupported data type from the detected table into the row-oriented additional table;
receiving queries against the primary database, wherein the queries comprise an online analytical processing (OLAP) query and an online transaction processing (OLTP) query;
in response to the receiving the OLAP query, offloading the OLAP query to be executed by the secondary database; and
executing the OLAP query by the secondary database, wherein the executing comprises accessing data of the unsupported data type via the row-oriented additional table;
wherein the column-oriented base table comprises: an entry that corresponds to, but does not contain, data of the unsupported data type; and
a key column storing a row ID of a related entry in the row-oriented additional table; and
the row-oriented additional table comprises: in the related entry, the corresponding data of the unsupported data type; and
a key column storing a row ID of the entry in the column-oriented base table.