TECHNIQUES FOR ENABLING AND INTEGRATING IN-MEMORY SEMI-STRUCTERED DATA AND TEXT DOCUMENT SEARCHES WITH IN-MEMORY COLUMNAR QUERY PROCESSING

• Main Authors: CHAVAN, Shasank K, CHANG, Hui Joe, MCMAHON, Douglas J, ROY, Shubhro Jyoti, LIU, Zhen Hua, MISHRA, Aurosish, ARORA, Vikas
• Format: Patent
• Language: English; French; German
• Published: 05.05.2021
• Subjects: CALCULATING; COMPUTING; COUNTING; ELECTRIC DIGITAL DATA PROCESSING; PHYSICS

A "hybrid derived cache" stores semi-structured data or unstructured text data in an in-memory mirrored form and columns in another form, such as column-major format. The hybrid derived cache may cache scalar type columns in column-major format. The structure of the in-memory mirrored form of semi-structured data or unstructured text data enables and/or enhances access to perform path-based and/or text based query operations. A hybrid derived cache improves cache containment for executing query operations. The in-memory mirrored form is used to compute queries in a transactionally consistent manner through the use of an invalid vector that used to determine when to retrieve the transactionally consistent persistent form of semi-structured data or unstructured text data in lieu of the in-memory form.