Servicenow, Inc.

Olivier Baxa

Siddharth Rajendra Shah

Jeremy Norris

Vincent Seguin

Paul Wang

Josef Mart

Peng Wang

Qiang Gui

Systems and method for improving query performance by querying an appropriate database engine based on the operation of the query request is provided. In one aspect, this approach involves querying a row-oriented database, querying a column-oriented database, or blacklisting the query request. In particular, updating the column-oriented database involves delete and insert operations. By maintaining updated databases and querying appropriate database engines, the response time of a query request may be improved.

System and methods for querying and updating databases

Embodiments are provided that include receiving a search query that represents a particular table of a plurality of tables contained in a database and that includes an additional criterion. Records are contained within the tables, which are organized in a tree structure. An index of the database contains a plurality of entries, each corresponding to a respective record in the plurality of tables. A particular entry in the index includes a path string that is indicative of a location, within the tree structure, of a table that contains a record that corresponds to the particular entry. The embodiments also include determining whether the entries in the index satisfy the search query by: (i) determining that the path string of the particular entry begins with a further path string of the particular table, and (ii) responsively determining whether a particular record that corresponds to the particular entry satisfies the additional criterion.

Text-based search of tree-structured tables

A computing system may involve a time-series server device and computing devices. The time-series server device may be configured to: receive and store pre-defined trigger configurations; receive and store time-series data, wherein the pre-defined trigger configurations define states and/or state transitions for the received time-series data; apply, by way of a trigger engine, the pre-defined trigger configurations to the received time-series data to determine observed states and/or state transitions in the time-series data; and store, in transition storage, representations of the observed states and/or state transitions. One or more applications operating on computing devices may be configured to: transmit the pre-defined trigger configurations to the time-series server; transmit a stream of the time-series data to the time-series server; and repeatedly poll and receive, by way of a plurality of worker threads, the representations of the observed states and/or state transitions from the transition storage.

Distributed tool for detecting states and state transitions in remote network management platforms

Growing community of inventors

Kirkland, WA, United States of America

Olivier Baxa