公开(公告)号：US11698911B2

公开(公告)日：2023-07-11

申请号：US17093617

申请日：2020-11-09

Applicant: ServiceNow, Inc.

Inventor： Siddharth Rajendra Shah ,  Jeremy Norris ,  Joseph Michael Davis ,  Kausik Sridharabalan ,  Rajagopalan Madapusi Ammanur ,  Ashwin Kumar Kayyoor

IPC: G06F16/2458 ,  G06F16/21 ,  G06F16/27 ,  G06F16/22 ,  G06F16/23 ,  G06F16/2455

CPC classification number: G06F16/2471 ,  G06F16/214 ,  G06F16/22 ,  G06F16/221 ,  G06F16/2379 ,  G06F16/24553 ,  G06F16/27

Abstract: A processor may receive a request with a column-oriented operation. The query request may be related to updates to a row-oriented database based on the query request previously performed on the row-oriented database. The processor may determine the amount of time for replicating the updates to a column-oriented database. If the amount of time for replicating the updates to the column-oriented database is greater than a threshold amount of time, then the processor may create a transient file with the updates. The transient file may be in a format that is recognized by the column-oriented database. The processor may query the column-oriented database based on the query request and the transient file.

公开(公告)号：US20230076510A1

公开(公告)日：2023-03-09

申请号：US17470414

申请日：2021-09-09

Applicant: ServiceNow, Inc.

Inventor： Ashwin Kumar Kayyoor

IPC: G06F16/2452 ,  G06F16/22 ,  G06F16/27 ,  G06F16/2455

Abstract: A database query is received at a primary database in a query language of the primary database. A determination is made whether the database query is to be handled by a secondary database different from the primary database but storing synchronized records of at least a portion of the primary database. In response to determining that the database query is to be handled by the secondary database, the database query is translated to a query language of the secondary database, including by determining a tree data structure representation of the database query, translating one or more elements of the tree data structure representation, and synthesizing the tree data structure representation to automatically generate the database query in the query language of the secondary database. The automatically generated database query is provided in the query language of the secondary database to the secondary database.

公开(公告)号：US11620285B2

公开(公告)日：2023-04-04

申请号：US17470414

申请日：2021-09-09

Applicant: ServiceNow, Inc.

Inventor： Ashwin Kumar Kayyoor

IPC: G06F16/2452 ,  G06F16/2455 ,  G06F16/27 ,  G06F16/22

Abstract: A database query is received at a primary database in a query language of the primary database. A determination is made whether the database query is to be handled by a secondary database different from the primary database but storing synchronized records of at least a portion of the primary database. In response to determining that the database query is to be handled by the secondary database, the database query is translated to a query language of the secondary database, including by determining a tree data structure representation of the database query, translating one or more elements of the tree data structure representation, and synthesizing the tree data structure representation to automatically generate the database query in the query language of the secondary database. The automatically generated database query is provided in the query language of the secondary database to the secondary database.

公开(公告)号：US20210141796A1

公开(公告)日：2021-05-13

申请号：US17093617

申请日：2020-11-09

Applicant: ServiceNow, Inc.

Inventor： Siddharth Rajendra Shah ,  Jeremy Norris ,  Joseph Michael Davis ,  Kausik Sridharabalan ,  Rajagopalan Madapusi Ammanur ,  Ashwin Kumar Kayyoor

IPC: G06F16/2455 ,  G06F16/22 ,  G06F16/23

Abstract: A processor may receive a request with a column-oriented operation. The query request may be related to updates to a row-oriented database based on the query request previously performed on the row-oriented database. The processor may determine the amount of time for replicating the updates to a column-oriented database. If the amount of time for replicating the updates to the column-oriented database is greater than a threshold amount of time, then the processor may create a transient file with the updates. The transient file may be in a format that is recognized by the column-oriented database. The processor may query the column-oriented database based on the query request and the transient file.