Patent classifications
G06F16/24528
Systems and methods for managing a highly available distributed hybrid transactional and analytical database
Systems and methods for managing a highly available distributed hybrid database comprising: a memory storing instructions; and one or more processors configured to execute the instructions to: receive a query from a user device to retrieve data from a distributed database comprising a source node, a first plurality of replica nodes, and a second plurality of replica nodes, wherein the source node and the first plurality of replica nodes form a transactional cluster, and wherein the second plurality of replica nodes forms an analytical cluster; determine whether to process the query using the transactional cluster or the analytical cluster based on one or more rules; translate the query into a first protocol that the determined cluster comprehends; select a replica node corresponding to the determined cluster; process the query using the selected replica node; and send data associated with results from processing the query to the user device.
DATA SIMULATION USING A GENERATIVE ADVERSARIAL NETWORK (GAN)
A Generative Adversarial Network is used to train and/or tune a model used to analyze data in a database or data stream. The Generative Adversarial Network intermittently trains or tunes the model as the database is actively ingesting data and/or while the data stream is streaming. This intermittent refreshing of the model, performed by the Generative Adversarial Network, is sometimes described as “dynamic” or “dynamical.” Analytics type software is queried in order to perform normalization and/or model training.
Monitoring interface for information technology environment
An example method of implementing a monitoring interface for an information technology environment comprises: identifying machine data reflecting activity in the information technology environment comprising a plurality of entities providing a service; executing a search query to derive, from the machine data, a value of a key performance indicator (KPI) reflecting performance of the service; and causing display of a monitoring interface including: an identifier of the service, a color coded indication of a state of the KPI, and a visual representation of time series data associated with the service.
Emulation of database catalog for migration to a different database
Some embodiments provide a method of emulating a presentation of at least one system object of a first database, based on multiple system objects of a second database. From a client, the method receives a first query for the first database requesting a presentation of the system object. From a metadata storage, the method identifies a second query for the second database that references the system objects of the second database, and generates the requested presentation of the system object. The method replies to the client with the generated presentation.
Query Generation and Processing System
A query generation and processing system includes a relational data store, a query generator, and a query processor. The relational data store stores data ingested from data sources in a first and second datasets. The query generator interprets a data expression in a simplified query language to generate a query in a structured query language based on identifying quads corresponding to the first and second datasets in the data expression and determining an implicit join between the quads based on an unambiguous relationship obtainable from a schema of the first and datasets, in which the data expression does not expressly identify a join between the first quad and the second quad. The query processor generates a query pipeline that uses the data of the first and second datasets stored by the relational data store to execute the query generated by the query processor.
Query Generation Using Derived Data Relationships
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.
AUTOMATIC QUERY OPTIMIZATION FOR CONTROLLED DATA ACCESS
Computer-readable media, methods, and systems are disclosed for applying rules and roles to generate optimized queries for optimized queries implementing restricted access to data. receiving, from a querying user, a data query including a data type and a query action. Roles associated with the querying user are retrieved from the querying user corresponding to the data type and the query action. A plurality of rules associated with the roles are retrieved by a security controller. Based on the rules and by way of the security controller, a query restrictor is computed to secure the data query for the action. One or more conditions associated with the rules are combined by conjunction. The rules associated with the role and the roles are combined by disjunction, to form restriction terms associated with the query restrictor. Finally, the data query is executed at a database server and results are returned.
SCHEDULING OF QUERY PIPELINE EXECUTION
A system includes reception of a query execution plan associated with a plurality of query execution pipelines, estimated execution costs and estimated intermediate result cardinalities, determination of one or more precedence relationships of the plurality of query execution pipelines, determination of an execution order of the plurality of query execution pipelines based on the estimated execution costs, the estimated intermediate result cardinalities, and the one or more precedence relationships, and providing of the execution order of the plurality of query execution pipelines and the query execution plan to a query execution engine.
Method, apparatus, and computer program for specializing serializer
To provide a method, apparatus, and computer program for performing type inference of serialization for each generation site and specializing a serializer for each generation site. A type of serialization is inferred for each generation site of compiling a query, and a serializer is specialized for each generation site based on the inferred type and a type that is actually used. A data value is serialized using the specialized serializer for each generation site. The inference is executed while transcribing identification information assigned to each generation site to a type as an annotation, and the inferred type and the type used in serialization are recursively compared.
SYSTEM FOR PREDICTING RESIDUAL SERVICE LIFE OF FIRE-DAMAGED CONCRETE STRUCTURES AND METHOD FOR THE SAME
Provided are: a system for predicting the residual lifespan of a fire-damaged concrete structure and a method therefor, the system being capable of acquiring sample data by performing a chemical analysis on a sample obtained from the fire-damaged concrete structure, comparing the obtained sample data with data pre-stored in a standardization DB so as to quickly predict the residual lifespan of the fire-damaged concrete structure, and accurately and scientifically assessing the level of fire damage of the fire-damaged concrete structure so as to perform appropriate repair and reinforcement of the fire-damaged concrete structure.