Invention Grant
- Patent Title: Method of performing transactional and analytical data processing using a data structure
-
Application No.: US17368677Application Date: 2021-07-06
-
Publication No.: US11886407B2Publication Date: 2024-01-30
- Inventor: Eric Hanson , Szu-Po Wang , Zhou Sun , Connor Gregory Watts , Nikita Shamgunov , Yevgeniy Kogan
- Applicant: SingleStore, Inc.
- Applicant Address: US CA San Francisco
- Assignee: SingleStore, Inc.
- Current Assignee: SingleStore, Inc.
- Current Assignee Address: US CA San Francisco
- Agency: EIP US LLP
- Main IPC: G06F16/22
- IPC: G06F16/22 ; G06F16/2453

Abstract:
Disclosed herein is a computer-implemented method of processing a query using a columnstore comprising a plurality of segments, the method comprising: receiving a query comprising a parameter; determining a key corresponding to the parameter; identifying a mapping structure, from a plurality of mapping structures, relating to said key, wherein each mapping structure corresponds to a respective segment of the columnstore; interrogating the identified mapping structure to determine a value corresponding to the key, wherein the value identifies an entry of an index table of a plurality of index tables that corresponds to the respective segment, wherein the entry of the index table identifies a row of the respective segment of the columnstore relating to the parameter; and retrieving data relating to the parameter from a data source based on data stored in the entry of the index table.
Public/Granted literature
- US20210334255A1 METHOD OF PERFORMING TRANSACTIONAL AND ANALYTICAL DATA PROCESSING USING A DATA STRUCTURE Public/Granted day:2021-10-28
Information query