Abstract: A method includes receiving a question phrased in natural language and related to data stored in a table of a structured query language database, wherein the table includes a plurality of fields containing a plurality of values, selecting a schema variant of a plurality of schema variants to apply to the question, converting the question to a structured query language query using a language model and applying a context of the schema variant, extracting a subset of the plurality of fields and a set of literals from the structured query language query, and defining a schema to be linked to the question as all subsets of the plurality of fields collected from all structured query language queries of a plurality of structured query language queries, wherein each structured query language query was generated by the language model using a different schema variant of the plurality of schema variants.

Abstract: A method includes receiving a question phrased in natural language and related to data stored in a table of a structured query language database, wherein the table includes a plurality of fields containing a plurality of values, selecting a schema variant of a plurality of schema variants to apply to the question, converting the question to a structured query language query using a language model and applying a context of the schema variant, extracting a subset of the plurality of fields and a set of literals from the structured query language query, and defining a schema to be linked to the question as all subsets of the plurality of fields collected from all structured query language queries of a plurality of structured query language queries, wherein each structured query language query was generated by the language model using a different schema variant of the plurality of schema variants.

Abstract: A method includes identifying a user of a text-to-SQL query system, identifying a machine learning model that has been trained based on a preference of the user to predict a presence of a target feature in an input SQL query based on a presence of a query feature in the input SQL query, receiving a question phrased in natural language, generating, using a language model, an SQL query designed to retrieve an answer to the question, extracting a set of query features and a set of target features from the SQL query, generating, using the machine learning model and based on the query features and target features, a prompt that makes a recommendation with respect to the presence of the target feature, providing the prompt to the language model to cause the language model to refine the SQL query, and querying a database using the SQL query that is refined.

Abstract: A method includes obtaining a query log from a database management system, wherein the query log contains a plurality of SQL queries previously executed against a target database, extracting, from the plurality of SQL queries, a plurality of features, associating the plurality of features with the plurality of SQL queries, generating a summary of the plurality of features, identifying, based on the summary, a subset of the plurality of features to use as a basis for extracting queries from the plurality of SQL queries, identifying a subset of the plurality of SQL queries that contains the subset of the plurality of features, converting, using a plurality of language models, each SQL query of the subset of the plurality of SQL queries into a question phrased in natural language, and storing the question with the each SQL query as a prompt for a text-to-SQL system.

Abstract: A system for transforming data instances between two tree-structured schemas using a collection of bidirectional tree-structured schema modification operations.

Abstract: In one example, a method performed by a processing system including at least one processor includes automatically inferring metadata about a structured query language database, constructing, based on the metadata, a prompt for generating a new structured query language query to be executed against the structured query language database, and providing the prompt to a language model for use in generating the new structured query language query.

Abstract: A method for transforming structured query language queries to expedite query execution includes detecting an explode operator in a structured query language query plan that is designed to execute a structured query language query against a database, identifying a query fragment within the structured query language query plan that starts with the explode operator and ends with a second operator, and replacing the query fragment in the structured query language query plan with an optimized query fragment in which the second operator operates directly on vectors that are a target of the second operator.

Abstract: A system for transforming data instances between two tree-structured schemas using a collection of bidirectional tree-structured schema modification operations.

Abstract: In one example, a method performed by a processing system including at least one processor includes automatically inferring metadata about a structured query language database, constructing, based on the metadata, a prompt for generating a new structured query language query to be executed against the structured query language database, and providing the prompt to a language model for use in generating the new structured query language query.

Abstract: A method for transforming structured query language queries to expedite query execution includes detecting an explode operator in a structured query language query plan that is designed to execute a structured query language query against a database, identifying a query fragment within the structured query language query plan that starts with the explode operator and ends with a second operator, and replacing the query fragment in the structured query language query plan with an optimized query fragment in which the second operator operates directly on vectors that are a target of the second operator.

Abstract: An exemplary embodiment of the present invention provides an exosuit support system, comprising first and second orthotic interfaces, first and second members, and first and second actuators. The first and second orthotic interfaces can be configured to attach to left and right legs of a user, respectively. The first member can comprise a first end connected to the first orthotic interface and a second end connected to a portion of the system configured to be positioned proximate a right shoulder of the user. The second member can comprise a first end connected to the second orthotic interface and a second end connected to a portion of the system configured to be positioned proximate a left shoulder of the user. The first actuator can be configured to apply a first tension to the first member. The second actuator can be configured to apply a second tension to the second member.

Abstract: Architectures and techniques are presented that can more efficiently update derived data products in response to updated source data. Source data is typically stored in source tables, whereas a materialized view of a query can generate a derived table based on the state of the source tables at the time the query is executed. When source data changes (e.g., in response to late-arriving input data), rather than recomputing the entire derived table (e.g., by again executing the original query, which can be expensive), an invertible relationship between timestamps can be leveraged to identify only those portions of the derived table that are affected by the update. Therefore, a new defining query can be generated to update only those portions of the derived table that are affected by the source data update.

Abstract: Architectures and techniques are presented that can more efficiently update derived data products in response to updated source data. Source data is typically stored in source tables, whereas a materialized view of a query can generate a derived table based on the state of the source tables at the time the query is executed. When source data changes (e.g., in response to late-arriving input data), rather than recomputing the entire derived table (e.g., by again executing the original query, which can be expensive), an invertible relationship between timestamps can be leveraged to identify only those portions of the derived table that are affected by the update. Therefore, a new defining query can be generated to update only those portions of the derived table that are affected by the source data update.

Abstract: A system for transforming data instances between two tree-structured schemas using a collection of bidirectional tree-structured schema modification operations.

Abstract: A system may include a processor, a user input, and memory comprising a graph and executable instructions. The executable instructions may cause the processor to effectuate operations. The operations include receiving, via the user input, a query comprising a class generalization and pathway variables. The operations include identifying a query class based on at least the class generalization and determining an anchor set based on at least one of the pathway variables. The operations also include translating the pathway variables into a pathway algebraic expression based on the anchor set and the query class and executing the pathway algebraic expression on the graph to return a pathway set.

Abstract: Systems and methods utilize a data model database which includes a plurality of symbol data types. Each of the plurality of symbol data types have one or more symbol data fields. The data model database further includes a plurality of concrete data types. Each of the concrete data types have one or more language-agnostic concrete fields associated with each of the one or more symbol data fields. Each of the one or more language-agnostic concrete fields apply one or more concrete constraints to each of the corresponding symbol data fields. The data model database further includes a plurality of carrier data types. The plurality of carrier data types having one or more language-specific carrier fields associated with each of the one or more language-agnostic concrete fields. Each of the one or more language-specific carrier fields apply one or more carrier constraints to each of the corresponding language-agnostic concrete fields.

Abstract: An exemplary embodiment of the present invention provides an exosuit support system, comprising first and second orthotic interfaces, first and second members, and first and second actuators. The first and second orthotic interfaces can be configured to attach to left and right legs of a user, respectively. The first member can comprise a first end connected to the first orthotic interface and a second end connected to a portion of the system configured to be positioned proximate a right shoulder of the user. The second member can comprise a first end connected to the second orthotic interface and a second end connected to a portion of the system configured to be positioned proximate a left shoulder of the user. The first actuator can be configured to apply a first tension to the first member. The second actuator can be configured to apply a second tension to the second member.

Abstract: Methods, systems, and products characterize consistency of data in a stream warehouse. A warehouse table is derived from a continuously received a stream of data. The warehouse table is stored in memory as a plurality of temporal partitions, with each temporal partition storing data within a contiguous range of time. A level of consistency is assigned to each temporal partition in the warehouse table.

Abstract: A system may include a processor, a user input, and memory comprising a graph and executable instructions. The executable instructions may cause the processor to effectuate operations. The operations include receiving, via the user input, a query comprising a class generalization and pathway variables. The operations include identifying a query class based on at least the class generalization and determining an anchor set based on at least one of the pathway variables. The operations also include translating the pathway variables into a pathway algebraic expression based on the anchor set and the query class and executing the pathway algebraic expression on the graph to return a pathway set.

Abstract: A device, method and computer-readable medium for generating unique identification for records in a data streaming processing system are disclosed. A method may collect an identification of a source of a data record, a timestamp of the data record and a count of a number of records a data source has added to the stream with that timestamp, generate a unique identification with the identification of the source of the data record, the timestamp of the data record and the count of the number of records the data source has added to the stream with that timestamp, apply the unique identification to the data record and transmit the data record with the unique identification to a downstream operator within a data stream processing system.