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 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 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 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: The disclosure includes a system and method for receiving a business process model for an application, the business process model including a human workstep, wherein input is received from a user to complete the human workstep; receiving a plurality of presentation types for association with the human workstep; receiving associated user interface (UI) metadata for the plurality of presentation types; and associating the human workstep with the plurality of presentation types and associated UI metadata.

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 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 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 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 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 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 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: The disclosure includes a system and method for receiving a business process model for an application, the business process model including a human workstep, wherein input is received from a user to complete the human workstep; receiving a plurality of presentation types for association with the human workstep; receiving associated user interface (UI) metadata for the plurality of presentation types; and associating the human workstep with the plurality of presentation types and associated UI metadata.

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: Systems and methods are described herein. In one embodiment, the method includes receiving a goal associated with a predicate-object pair; receiving utilization data including a plurality of predicate-object pairs including the predicate-object pair associated with the goal; determining a prediction model comprising a plurality of nodes that form a hierarchical structure including a root node and two or more leaf nodes and organized based on one or more of an information gain and a business gain, the two or more leaf nodes including a leaf node associated with the predicate-object pair of the goal; identifying nodes in the hierarchical structure that trace a path from the root node to the node associated with the goal; and causing a recommendation for at least partial completion of the goal to be presented to a user, the recommendation based on the one or more nodes that trace the path.

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: The methods and systems for providing real-time business intelligence using national language queries facilitate a user to search within a data warehouse using a natural language question. Such business intelligence platform may receive a natural language based question, extract one or more key words from the natural language based question, determine a first dependency graph of the one or more key words based on a relationship among the one or more key words, determine a second dependency graph of the one or more key words based on previously stored search indices, merge the first and the second dependency graphs to generate an integrated dependency graph, and generate a formatted search string based on the integrated dependency graph.

Abstract: A system and method for tunneling through a network separation device such as a firewall or a Network Address Translator including a first server receiving an access request from a client device to communicate with a host device, where the host device is behind the network separation device. The first server sending a message to a second server in response to receiving the access request, the message including host data for the host device. The second server is configured to send a notification to the host device, and the notification includes instructions for the host device to initialize a pass-through channel with the first server. The first server receiving a pass-through initialization request from the host device and establishing the pass-through channel for communication between the client device and the host device in response to receiving the pass-through initialization request.

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 business process management (BPM) system, a business event processing system, and a business visibility system are integrated into a responsive process management platform using standardized messages to permit communication and collaboration among the systems. The BPM system has the capability to model and execute at least one monitoring process including at least one monitoring workstep. This monitoring process makes visible in the BPM system processes of interest that are executing in external systems. The business event processing system and/or the business visibility system have tools to allow users to easily configure those systems to sense events and send appropriate standardized messages to the other systems, can extract and send data to the BPM system, and can send alerts to the BPM system.