Servicenow, Inc.

Mega, Inc.

Joseph Michael Davis

Joey Mart

Siddharth Rajendra Shah

Josef Mart

Jeremy Norris

Scott Richard Wilson

Atul Saini

Ashwin Kumar Kayyoor

Kausik Sridharabalan

James F Kunz

Robert Gaetz

Jeffery Linn

Timothy M Hoover

Christopher Barry

Richard J Bando

Rajagopalan Madapusi Ammanur

Norman J Redenshek

Randall Raymond Harris

Scott Michael Nemes

Scott R Wilson

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.

System and methods for performing updated query requests in a system of multiple database engine

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.

Predictive query improvement

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.

Class path based database operations

A system for controlling water distribution from a water distribution vehicle includes spray heads for spraying water from the vehicle and an actuator system for turning the spray heads on and off. A computer processor is programmed to control the actuator system in response to a sensor input. The system can include means for measuring the ground speed of the vehicle, such as a GPS, and the sensor input signal can be associated with the ground speed of the vehicle. Using a pulse width modulated signal, the processor can adjust water flow from the spray heads based on the vehicle ground speed. The processor also can be programmed to prevent water flow from one or more spray heads when the vehicle speed is below a minimum speed or as the vehicle speed is reduced.

Digital spray control system

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.

Table-per-partition

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.

Techniques and devices for cloud memory sizing

Growing community of inventors

Carlsbad, CA, United States of America

Joseph Michael Davis