Abstract: A system and method for defining a relational schema for a non-relational database are disclosed. In one embodiment, the system identifies a non-relational database; obtains a data structure of the non-relational database; determines a relational schema type; generates a relational schema based on the determined schema type; determines whether the relational schema includes a plurality of relational tables; and responsive to determining that the relational schema includes a plurality of relational tables, defines a relation between at least two of the relational tables in the relational schema.

Abstract: A system and method are disclosed for modeling a non-relational database as a normalized relational database. In one embodiment, the system identifies a column having a first type in a column-oriented, non-relational database; determines whether the column-oriented, non-relational database includes at least one column having a second type and identifies the one or more columns having the second type; virtually divides the column-oriented, non-relational database based on column type; and generates a normalized, relational model based on the virtual division of the column-oriented, non-relational database, the normalized, relational model including catalog information representing a parent table including the column having the first type and, when the column-oriented, non-relational database includes at least one column having the second type, catalogue information representing a child table, the parent table and child table both represented as relational tables.

Abstract: A system and method for receiving, using one or more processors, a query including an index predicate; determining, using the one or more processors, that the query includes a default to table scan issue; and responsive to determining that the query includes a default to table scan issue, generating, using the one or more processors, one or more synthesized predicates used to process the query using an index scan.

Abstract: A method of tunneling through a network separation device such as a firewall or a Network Address Translator comprising establishing via a custom socket factory coupled with a host device, a connection with a cloud server by tunneling through a network separation device; maintaining, via the custom socket factory, the connection with the cloud server through the network separation device; receiving, via the connection between the custom socket factory and the cloud server, connection information; and directly connecting, via the custom socket factory, to a client device using the connection information received from the cloud server.

Abstract: A system and method for mapping an application program interface (API) to a relational schema. In one embodiment, the system samples a first endpoint, the first endpoint exposed via a first application programming interface (API); automatically infers, based on a set of results received from the first endpoint responsive to the sampling and based on a set of inference rules, a first set of data types and a first relational data structure representing data stored by the first endpoint and exposed via the first API; generates a configuration profile based on the first set of inferred data types and the first relational data structure representing the data stored by the first endpoint and exposed via the first API; and obtains, using the configuration profile and via the first application programming interface, data from the first endpoint responsive to a query, the query received in a relational query language.

Abstract: A system and method are disclosed for bottom-up modeling and prediction of asset anomalies. In one embodiment, the system receives first sensor data from a first sensor, the first sensor associated with a first asset; smooths the first sensor data; determines a first stage within sensor data, the sensor data including the first sensor data; determines a first set of anomalies within the first stage; generates a first asset state space associated with the first asset; trains a base model describing a first group of one or more assets, the first group of one or more assets including the first asset; and trains, using the base model, a final model particular to the first asset.

Abstract: A system and method for processing of queries including receiving a query including a set operation and a sort operation, wherein the set operation includes a first data structure and a second data structure and the sort operation requests a result set that is sorted based on a column or attribute of the first data structure and a column or attribute of the second data structure; generating a query plan in which a sort operation occurs prior to the set operation; determining a first, partial set of one or more resultant rows responsive to the query; sending the first, partial set of one or more resultant rows responsive to the query to a client; determining a second, partial set of one or more resultant rows responsive to the query; and sending the second, partial set of one or more resultant rows to the client.

Abstract: A system and method for bi-directional design to code are disclosed. In one embodiment, the system includes a processor; a memory storing instructions that, when executed, cause the system to obtain, by a plugin, a web application design, the web application design generated using a first design tool; generate, by the plugin, an object model based on the web application design; access, by a configurator, the object model; and generate, by the configurator, for presentation to a developer, the web application design.

Abstract: A system and method for generating a multi-user presentation including receiving a graphic, anchoring a first instance of the graphic in a collaboration environment with a first position, first scale, and first orientation relative to an initial position of a presenting user in the collaboration environment; applying a first anchor transform to a second instance of the graphic, the first anchor transform anchoring the second instance of the graphic in the collaboration environment with the first position, the first scale, and the first orientation relative to an initial position of a first attendee in the collaboration environment; sending the first instance of the graphic for presentation to the presenter, and the second instance of the graphic for presentation to the first attendee; receiving a first presenter interaction modifying the first instance, where the modified first instance includes a first modification to one or more of the first position, the first scale, and the first orientation relative to t

Abstract: A system and method for defining a relational schema for a non-relational database are disclosed. In one embodiment, the system identifies a non-relational database; obtains a data structure of the non-relational database; determines a relational schema type; generates a relational schema based on the determined schema type; determines whether the relational schema includes a plurality of relational tables; and responsive to determining that the relational schema includes a plurality of relational tables, defines a relation between at least two of the relational tables in the relational schema.

Abstract: A system and method for technology agnostic page editing and/or rendering that includes receiving a first modification request associated with a first page, the first modification request generated by an agnostic page editor, the agnostic page editor compatible with a plurality of renderers from which an administrative user identifies a first set of renderers to be associated with the first page; modifying a first meta model associated with the first page based on the first modification request, the first meta model using a data interchange format; obtaining, by a first renderer belonging to the first set of renderers, the meta model associated with the first page; rendering, by the first renderer belonging to the first set of renderers, the first page for presentation to the administrative user using the first meta model; and sending first rendered content for presentation of the first page.

Abstract: A system and method for efficient query processing using a real index of a queried table are described. In one embodiment, the real index is used in an offset query type in order to reduce the number of rows that are sorted and thereby increases efficiency for processing offset query types. In another embodiment, the real index is used in a set operation query type where existing systems utilize a table scan and thereby increases efficiency of set operation query types.

Abstract: Techniques are described for managing creation and/or implementation of compliance-based procedures and policies for computing environments executing software programs using computing resources. In at least some situations, the described techniques include performing one or more defined compliance tests on a target computing environment by employing user-defined and/or predefined compliance profiles to test one or more computing resources in the target computing environment. Profiles typically include one or more user-defined or predefined controls that each includes one or more compliance tests, which in turn utilize one or more user-defined or predefined testing-implementation modules to execute the tests. Profiles can introduce dependencies so that one profile can access and utilize the controls or testing-implementation modules in other profiles. A user can dynamically execute a profile, and/or profiles can be scheduled for execution (e.g.

Abstract: A system and method for receiving a query of a partitioned table, the query including a first index predicate associated with a first partition key column; determining that one or more of the query is missing a second index predicate and the first index predicate is unusable for index probing; responsive to determining that one or more of the query is missing the second index predicate and the first index predicate is unusable for index probing, generating one or more synthesized predicates used to process the query using an index scan.

Abstract: A system and method for receiving, using one or more processors, a first testing identifier associated with a first element of an application under test; receiving, using the one or more processors, a second testing identifier associated with the first element of an application under test; evaluating, using the one or more processors, the first testing identifier; determining, using the one or more processors, a failure of the first testing identifier to identify an element in the application under test; evaluating, using the one or more processors, the second testing identifier; identifying, using the one or more processors, the first element in the application under test based on the second testing identifier; and repairing, using the one or more processors, the first testing identifier to identify the first element in the application under test.

Abstract: A system and method are disclosed for modeling a non-relational database as a normalized relational database. In one embodiment, the system identifies a column having a first type in a column-oriented, non-relational database; determines whether the column-oriented, non-relational database includes at least one column having a second type and identifies the one or more columns having the second type; virtually divides the column-oriented, non-relational database based on column type; and generates a normalized, relational model based on the virtual division of the column-oriented, non-relational database, the normalized, relational model including catalog information representing a parent table including the column having the first type and, when the column-oriented, non-relational database includes at least one column having the second type, catalogue information representing a child table, the parent table and child table both represented as relational tables.

Abstract: A method of tunneling through a network separation device such as a firewall or a Network Address Translator comprising establishing via a custom socket factory coupled with a host device, a connection with a cloud server by tunneling through a network separation device; maintaining, via the custom socket factory, the connection with the cloud server through the network separation device; receiving, via the connection between the custom socket factory and the cloud server, connection information; and directly connecting, via the custom socket factory, to a client device using the connection information received from the cloud server.

Abstract: A system and method for bi-directional design to code are disclosed. In one embodiment, the system includes a processor; a memory storing instructions that, when executed, cause the system to obtain, by a plugin, a web application design, the web application design generated using a first design tool; generate, by the plugin, an object model based on the web application design; access, by a configurator, the object model; and generate, by the configurator, for presentation to a developer, the web application design.

Abstract: A system and method for efficient query processing using multiple indices in a join operation are described. In one embodiment, a join query including a join operation on a first table and a second table and including a first condition and a second condition is received, wherein the first condition is based on a first index of the second table, and the second condition based on a second index of the second table; a first result set is determined by index scanning the second table using the first index as an index key; a second result set is determined by index scanning the second table using the second index as the index key; a third result set is determined by applying a set operation to the first result set and the second result set; and the third result set is provided in response to the join query.

Abstract: A system and method are disclosed for bottom-up modeling and prediction of asset anomalies. In one embodiment, the system receives first sensor data from a first sensor, the first sensor associated with a first asset; smooths the first sensor data; determines a first stage within sensor data, the sensor data including the first sensor data; determines a first set of anomalies within the first stage; generates a first asset state space associated with the first asset; trains a base model describing a first group of one or more assets, the first group of one or more assets including the first asset; and trains, using the base model, a final model particular to the first asset.