The invention discloses a method and a device for constructing a SQL statement based on reinforcement learning, wherein the method includes: initializing an actor-critic network parameter; acquiring a sequence pair of natural language and real SQL statement from a data set; inputting a natural language sequence into an actor network encoder, and inputting a real SQL sequence into a critic network encoder; using an encoded hidden state as an initialized hidden state of a corresponding decoder; gradually predicting, by an actor network decoder, a SQL statement action, and inputting the SQL statement action to a critic network decoder and an environment to obtain a corresponding reward; and using a gradient descent algorithm to update the network parameters, and obtaining a constructing model of the natural language to the SQL statement after repeated iteration training.

Technologies are provided for database modification using a script component. In some embodiments, a method comprises executing, by a computing system comprising at least one processor, a script component comprising one or more functions to transform a database. The method also includes modifying, by the computing system, the database based on at least one transformation defined by the one or more functions in response to executing the script component.

Aspects of the disclosure relate to transliteration of machine interpretable languages. A computing platform may receive a query formatted in a first format for execution on a first database. The computing platform may translate the query to a second format for execution on a second database by: 1) extracting non-essential portions of the query from the query, and replacing the non-essential portions of the query with pointers to create a query key; 2) storing, along with their corresponding pointers, the non-essential portions of the query as query parameters; 3) executing a lookup function on a query library to identify a translated query corresponding to the query key and including the corresponding pointers; and 4) updating the translated query to include the query parameters based on the corresponding pointers to create an output query. The computing platform may execute the output query on the second database.

A method of driving SQL optimization in a relational database by anti-pattern analysis of dynamic performance characteristics is provided. The method includes receiving a SQL statement, analyzing execution plan of the SQL statement and other SQL runtime statistics, and detecting presence of any anti-patterns for the SQL statement. The method also presents a list of recommendations for remediation of the anti-patterns. The method further includes calculating a quality index value for the SQL statement by performing a weighted analysis of a number of attributes. When the quality index value of the execution plan is determined to be greater than or equal to the predetermined threshold value, the execution plan is sent to a production environment for execution. When the quality index value of the execution plan is determined to be less than the predetermined threshold value, the execution plan is sent to a client terminal for remediation.

Data expressions in a simplified query language are processed to generate queries in a structured query language which can then be executed against data ingested from one or more data sources. The data expression is parsed to determine quads and to produce a tree of the quads. A derivation graph including nodes representing the quads and including at least one edge representing a derivation relationship between two of the quads determined based on attributes of the quads is generated based on the tree of quads and a data schema. The derivation graph is then queried based on a grain of the quads to generate the query. The simplified query language does not require an expression of a join relationship between the quads within the data expression when an unambiguous relationship between the quads is obtainable from the data schema.

Injecting override instructions associated with query executions instructions performed on a distributed database includes receiving a data-query; generating, by a first database instance, a query plan that includes a first query execution instruction for transmission to a second database instance; transmitting, by the first database instance, a request for partial results to the second database instance, where the request includes the first query execution instruction and an indication of override instructions corresponding to the first query execution instruction; responsive to a determination that the request includes the indication, including, by the second database instance, the override instructions in a set of high-level language query instructions; obtaining, by the second database instance, a machine language query based on the set; executing, at the second database instance, the machine language query to obtain the partial results; and transmitting, by the second database instance, the partial results to the first database instance.

Described herein is a computer implemented method. The method comprises generating a subscription identifier based on an original SQL query and determining if a set of first stage query results is associated with the subscription identifier in a cache. If so, the method further comprises generating a second stage SQL query based on a second subset of the plurality of clauses and the set of first stage query results, causing execution of the second stage SQL query to obtain a set of second stage query results from a database, and returning the set of second stage query results.

Methods, systems, devices, and tangible non-transitory computer readable media facilitating assignment and/or dynamic application of a permission rule to a group of entities. In an example embodiment, the disclosed technology can: define a group of entities having a common attribute; assign a permission rule to the group of entities based at least in part on the common attribute; project the permission rule onto one or more entities in the group of entities based at least in part on assignment of the permission rule to the group of entities; obtain data indicative of a change in group membership status of an entity in the group of entities; and/or update a projection of the permission rule onto the entity to modify an association of the entity with the group of entities and/or the permission rule based at least in part on receipt of the data.

A distributed event processing system is disclosed that receives a batch of events via a continuous data stream and performs the serialization of data in the batch of events. In certain embodiments, the system identifies a first data type of a first attribute for each event in a batch of events and determines a first type of data compression to be performed on data values represented by the first attribute. The system determines a first type of data compression to be performed on data values represented by the first attribute based on the first data type of the first attribute. The system then generates a first set of serialized data values for the first attribute. The system processes the first set of serialized data values against a set of one or more continuous queries to generate a first set of output events.

The present disclosure describes hybrid transactional and analytical processing (HTAP) techniques. A HTAP system comprises a first processing engine configured to perform online transactional processing, a second processing engine configured to perform online analytical processing, and a storage in communication with the first processing engine and the second processing engine. The first processing engine, the second processing engine, and the storage may be modularized and configured to be decoupled from each other. The system may be configured to capture data by the first processing engine in real time, organize the data in a first format in a first part of the storage for use by the first processing engine, propagate the data to a second part of the storage subsystem, and organize the data in a second format in the second part of the storage for use by the second processing engine.