公开(公告)号：US10216813B2

公开(公告)日：2019-02-26

申请号：US15719367

申请日：2017-09-28

Applicant: ServiceNow, Inc.

Inventor： Joseph Michael Davis ,  Joey Mart

IPC: G06F17/30

Abstract: The present approach improves the query performance of a database in a manner that is transparent to a user. In one aspect, this approach creates separate partition tables that are not directly accessible to a user of the database. A client-facing aspect of the database is a logical model which may correspond to a single, main table with which the user interacts. Thus, queries or operations may be generated on the client side in the context of the logical model. A database or query layer can then, transparent to the user, translate the user generated requests into query language that addresses the proper partitions to generate a result set or otherwise perform a database operation.

公开(公告)号：US11520787B2

公开(公告)日：2022-12-06

申请号：US17061042

申请日：2020-10-01

Applicant: ServiceNow, Inc.

Inventor： Josef Mart ,  Joseph Michael Davis

IPC: G06F17/30 ,  G06F16/2453

Abstract: The present approach relates to improving query performance in a database context. Examples of query improvement are described in the context of certain query patterns, one or more of which may be observed in a given query. When a given query pattern is observed, changes may be made to the query at the application or database level to improve performance of the respective query. Query improvements may be performed in a manner transparent to the user.

公开(公告)号：US20190278780A1

公开(公告)日：2019-09-12

申请号：US16286313

申请日：2019-02-26

Applicant: ServiceNow, Inc.

Inventor： Joseph Michael Davis ,  Joey Mart

IPC: G06F16/25 ,  G06F16/22 ,  G06F16/27

Abstract: The present approach improves the query performance of a database in a manner that is transparent to a user. In one aspect, this approach creates separate partition tables that are not directly accessible to a user of the database. A client-facing aspect of the database is a logical model which may correspond to a single, main table with which the user interacts. Thus, queries or operations may be generated on the client side in the context of the logical model. A database or query layer can then, transparent to the user, translate the user generated requests into query language that addresses the proper partitions to generate a result set or otherwise perform a database operation.

公开(公告)号：US11238038B2

公开(公告)日：2022-02-01

申请号：US16821703

申请日：2020-03-17

Applicant: ServiceNow, Inc.

Inventor： Joseph Michael Davis ,  Joey Mart

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

Abstract: The present approach assigns a code to each node class of a data tree modeling a database. The node class codes may be used to generate a node class path for each node class. This class path may be used as a discriminator to reference a given node class or portion of the tree including the class path and may be stored in a field of the database and/or cached. Use of the class path in query operations reduces the complexity of certain queries, thereby speeding up query performance.

公开(公告)号：US20210019317A1

公开(公告)日：2021-01-21

申请号：US17061042

申请日：2020-10-01

Applicant: ServiceNow, Inc.

Inventor： Josef Mart ,  Joseph Michael Davis

IPC: G06F16/2453

Abstract: The present approach relates to improving query performance in a database context. Examples of query improvement are described in the context of certain query patterns, one or more of which may be observed in a given query. When a given query pattern is observed, changes may be made to the query at the application or database level to improve performance of the respective query. Query improvements may be performed in a manner transparent to the user.

公开(公告)号：US20180322128A1

公开(公告)日：2018-11-08

申请号：US15719367

申请日：2017-09-28

Applicant: ServiceNow, Inc.

Inventor： Joseph Michael Davis ,  Joey Mart

IPC: G06F17/30

CPC classification number: G06F17/3056 ,  G06F17/30315 ,  G06F17/30336 ,  G06F17/30339 ,  G06F17/30584

Abstract: The present approach improves the query performance of a database in a manner that is transparent to a user. In one aspect, this approach creates separate partition tables that are not directly accessible to a user of the database. A client-facing aspect of the database is a logical model which may correspond to a single, main table with which the user interacts. Thus, queries or operations may be generated on the client side in the context of the logical model. A database or query layer can then, transparent to the user, translate the user generated requests into query language that addresses the proper partitions to generate a result set or otherwise perform a database operation.

公开(公告)号：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.

公开(公告)号：US10795885B2

公开(公告)日：2020-10-06

申请号：US15814132

申请日：2017-11-15

Applicant: ServiceNow, Inc.

Inventor： Josef Mart ,  Joseph Michael Davis

IPC: G06F17/30 ,  G06F16/2453

Abstract: The present approach relates to improving query performance in a database context. Examples of query improvement are described in the context of certain query patterns, one or more of which may be observed in a given query. When a given query pattern is observed, changes may be made to the query at the application or database level to improve performance of the respective query. Query improvements may be performed in a manner transparent to the user.

公开(公告)号：US20200285640A1

公开(公告)日：2020-09-10

申请号：US16821703

申请日：2020-03-17

Applicant: ServiceNow, Inc.

Inventor： Joseph Michael Davis ,  Joey Mart

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

Abstract: The present approach assigns a code to each node class of a data tree modeling a database. The node class codes may be used to generate a node class path for each node class. This class path may be used as a discriminator to reference a given node class or portion of the tree including the class path and may be stored in a field of the database and/or cached. Use of the class path in query operations reduces the complexity of certain queries, thereby speeding up query performance.

公开(公告)号：US10452529B1

公开(公告)日：2019-10-22

申请号：US14736424

申请日：2015-06-11

Applicant: ServiceNow, Inc.

Inventor： Joseph Michael Davis ,  Scott Michael Nemes ,  Atul Saini ,  Siddharth Shah

IPC: G06F12/02 ,  G06F3/06

Abstract: Systems, apparatuses, and methods for cloud memory sizing are disclosed. An initial database memory allocation is determined for the provisioning of a database server instance. Periodically, sizes of key database tables of the database server instance are measured and an upper and a lower bound ratio are determined based on the key database table sizes and a buffer pool size. The upper and lower bound ratios are used to determine a desired memory allocation from which a report is generated including an interface for generating an instance move action for re-provisioning the database server instance with the desired memory allocation.