Servicenow, Inc.

Jeremy Norris

Siddharth Rajendra Shah

Vincent Seguin

Josiah Sullivan

Joe Davis

Josef Mart

Olivier Baxa

Joseph Michael Davis

Ashwin Kumar Kayyoor

Antony Chan

Kausik Sridharabalan

Herman Knief

Rajagopalan Madapusi Ammanur

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

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

An embodiment may involve persistent storage including a parent filesystem and a pre-configured amount of free space within the parent filesystem that is dedicated for shared use. The embodiment may also involve one or more processors configured to, for each of a plurality of child filesystems: create a sparse file with an apparent size equivalent to the pre-configured amount of free space; create a virtual mapped device associated with the sparse file; establish one or more cryptographic keys for the virtual mapped device; create an encrypted virtual filesystem for the virtual mapped device and within the sparse file, wherein the encrypted virtual filesystem uses the cryptographic keys for application-transparent encryption and decryption of data stored by way of the encrypted virtual filesystem; and mount the encrypted virtual filesystem within the parent filesystem as one of the child filesystems.

Security for data at rest in a remote network management platform

A database system could include a first database engine, a second database engine, and a replication engine. The database system could also include processors configured to perform operations. The operations could involve obtaining indicators that are respectively associated with performance issues that can occur in the database system, each indicator defining one or more conditions that, when satisfied, cause the indicator to become active. The operations could also involve obtaining mappings between: (i) at least some of the indicators, and (ii) remediation subroutines. The operations could additionally involve receiving operational data related to the first database engine, the second database engine, or the replication engine; determining, based on the operational data and the conditions defined by the indicators, that a particular indicator is active; determining, based on the mappings, that the particular indicator has an associated remediation subroutine; and executing the associated remediation subroutine.

Self-healing infrastructure for a dual-database system

A source control system is used for the distributed incremental updating of trays that include all of the dependencies needed for an application to execute within a computing environment. An application of a first version of a tray is executed on a server responsive to the first version of the tray being retrieved from a source control system. Tray management software of the first version of the tray receives a request to update the tray to a second version. The tray management software requests a changeset including file differences between the first and second versions of the tray from the source control system. Responsive to a determination by the tray management software that there are no pending requests preventing an update, the tray is updated from the first version to the second version by updating files in the tray according to the changeset.

Distributed incremental updating of trays using a source control system

In an operating system with access control functionality, a request for a function that requires kernel space access can be initiated by an application and executed in the kernel space using a management mechanism having access to the kernel space. An application container within which the application executes includes a signaling mechanism permitted to access a message bus external to the application container using an access control policy of the operating system. The signaling mechanism signals that a message associated with the request is to be processed with kernel space access. An access control policy of the operating system permits the signaling mechanism to access a message bus used to transmit the message to the management mechanism. The management mechanism executes the function in the kernel space responsive to receiving the message from the message bus and determining that the function requires kernel space access.

System for accessing a kernel space of an operating system with access control functionality

A node of an application instance in a distributed computing environment can be selectively hibernated and the execution of the node selectively restarted by first detecting a condition of the node that satisfies a criterion for hibernating the node. The node may then be hibernated by suspending execution of the node on a server and initiating execution of a listener. The listener can use a network port that the node used before the execution of the node was suspended. At a later time, a request from a client to the application instance can be received by the listener. The request can be a request to restart execution of the node. Responsive to the request and a determination that the server has a predefined amount of resources for permitting execution of the node, the execution of the node on the server can be restarted.

System and method for selectively hibernating and restarting a node of an application instance

The unauthorized access of database nodes by application nodes within an electronic computing and communications system can be prevented using an access table that stores access table records indicating that at least some of the application nodes are authorized to access at least some of the database nodes. The access table records can be generated by identifying connections between application nodes and database nodes within a configuration management database. Responsive to receiving a request to access a database node sent from a first application node, the access table can be queried to determine whether an access table record indicating that the first application node is authorized to access the database node is stored in the access table. If that access table record is not stored in the access table, the request is denied. Otherwise, the request is allowed.

System and method for application route management

A distributed backup method includes defining a server group having a plurality of server computers, and providing each server computer with an identical backup policy and an identical storage policy. The method also includes transmitting, at each server computer of the server group to every other server computer of the server group, advertisement messages describing available storage space for storing backups, and receiving, at each server computer from the server, at least some of the advertisement messages. The method also includes identifying, at a first server computer using the backup policy, at least a first service to be backed up, selecting a second server computer using the received advertisement messages, transmitting, from the first server computer to the second server computer, a backup including information corresponding to the at least one service, and storing the backup, by the second server computer using the storage policy.

Growing community of inventors

Poway, CA, United States of America

Jeremy Norris