WO2025022157 - CONCURRENCY FOR EXECUTING OLTP AND OLAP QUERIES ON TABLES STORED IN COLUMNAR FORMAT
National phase entry is expected:
Publication Number
WO/2025/022157
Publication Date
30.01.2025
International Application No.
PCT/IB2023/057507
International Filing Date
24.07.2023
Title **
[English]
CONCURRENCY FOR EXECUTING OLTP AND OLAP QUERIES ON TABLES STORED IN COLUMNAR FORMAT
[French]
SIMULTANÉITÉ POUR L'EXÉCUTION D'INTERROGATIONS OLTP ET OLAP SUR DES TABLES STOCKÉES EN FORMAT COLONNAIRE
Applicants **
SHARMA, Pratik
Inventors
SHARMA, Pratik
Application details
| Total Number of Claims/PCT | * |
| Number of Independent Claims | * |
| Number of Priorities | * |
| Number of Multi-Dependent Claims | * |
| Number of Drawings | * |
| Pages for Publication | * |
| Number of Pages with Drawings | * |
| Pages of Specification | * |
| * | |
| Number of Office Actions | * |
| * | |
International Searching Authority |
IP India
* |
| Recordal of a Change of the Applicant's Name/Address |
Change of Applicant's Name and Address
* |
| Type of Assignment |
The Standard Agent's Assignment
* |
| Applicant's Legal Status |
Natural Person
* |
| * | |
| * | |
| * | |
| * | |
| * | |
| Entry into National Phase under |
Chapter I
* |
| Patent Delivery |
Send the Letters Patent by Courier
* |
| Translation |
|
* The data is based on automatic recognition. Please verify and amend if necessary.
** IP-Coster compiles data from publicly available sources. If this data includes your personal information, you can contact us to request its removal.
Quotation for National Phase entry
| Country | Stages | Total | |
|---|---|---|---|
| China | Filing, Examination, Granting | 1883 | |
| EPO | Filing, Examination, Granting | 8683 | |
| Japan | Filing, Examination, Granting | 1752 | |
| South Korea | Filing, Examination, Granting | 1179 | |
| USA | Filing, Examination, Granting | 4740 |
Total:
18,237
The term for entry into the National Phase has expired. This quotation is for informational purposes only
Contact Us
Abstract[English]
Here in this invention, for tables stored in columnar format to improve concurrency for executing Online Transaction Processing (OLTP) and Online Analytical Processing (OLAP) queries in parallel, we use the primary B+ index with S-lock (shared lock), X-lock (exclusive lock) and S-X lock (shared exclusive lock) like used in the primary B+ tree index of open source MySQL. Further for updates to column data and for deletes we temporarily allocate memory to store old or stale column data so that the Multi-Version Concurrency Control (MVCC) component of the database system can reference it, which after serving certain older timestamp queries is purged or garbage collected from the system.