47 results about "Logical query" patented technology

The invention discloses a data query method and system. The data query method includes the steps of firstly, extracting various dimensionalities in a business system, building a plurality of logical tables of business data for describing the business system, building incidence relations between the logical tables and the dimensionalities, then building mapping relations between a physical table and the logical tables according to the physical table of the business system, writing logical query statements according to the logical tables and a logical data query grammar defined according to a rule, finally, according to the mapping relations between the physical table and the logical tables, converting the logical query statements into structuring query statements, and executing the structuring query statements in a database to complete querying of the business data. According to the data query method and system, the complexity of data table understanding and writing can be reduced, and the understandability of a data structure of the business system is improved.

A database query is received that includes a logical query indicator at a distributed database node within a distributed network of databases. The logical query indicator includes at least one physical database query and at least one database node identifier that allows at least one distributed database node to identify at least one physical database to execute the physical database query against. It is determined that the at least one database node identifier matches a local node identifier. The at least one physical database query is executed against at least one local physical database table. A local query response is formed including data retrieved from the at least one local physical database table. The database query is responded to with at least the local query response. This abstract is not to be considered limiting, since other embodiments may deviate from the features described in this abstract.

A system for executing a streaming query includes an interface and a processor. The interface is configured to receive a logical query plan. The processor is configured to determine a physical query plan based at least in part on the logical query plan. The physical query plan comprises an ordered set of operators. Each operator of the ordered set of operators comprises an operator input mode and an operator output mode. The processor is further configured to execute the physical query plan using the operator input mode and the operator output mode for each operator of the query.

The invention discloses a cross-platform unified big data SQL (Structured Query Language) query method, which comprises the following steps of: expanding part of SQL semantics, and providing a unifiedcross-platform SQL query language for a user; enabling a unified SQL parser to parse the query statement submitted by the user into a logic query plan, and verifying the legality of the query statement according to the meta information stored in the unified meta database; enabling a cross-platform optimizer to optimize the structure and the connection sequence of the logic query plan and convertthe logic query plan into an optimal physical execution plan composed of a plurality of sub-queries bound with an execution platform; enabling a cross-platform scheduler to convert the optimal physical execution plan into a task flow graph, automatically schedule the task flow graph according to the dependency relationship among the tasks and execute all the tasks; designing a unified platform layer interface meeting cross-platform SQL query requirements, and shielding operation differences between different execution platforms. The cross-platform unified big data SQL query method solves the problems that an existing cross-platform query method is poor in usability, low in performance, large in data migration cost and the like.

Provided are a computer program product, system, and method for building complex hierarchical queries. A User Interface (UI) representation of a logical query is received, wherein the UI representation describes object types, relationships between the object types, and attributes of the object types. The UI representation is translated to a logical query. The logical query is converted to data layer calls to retrieve objects having the object types, the relationships between the object types, and the attributes of the object types. The objects are received. Then, a directed graph is generated using the identified objects.

Digital fingerprint generation logic executed by a client device includes quirk-exposing logic configured to expose behavioral differences between various system configurations of client devices. The digital fingerprint generation logic queries a remote client device for system configuration, and generates a digital fingerprint of the client device that includes a system configuration characteristic reported by the client device in response to the query. Results of execution of the quirk-exposing logic are compared to expected results that are specific to the reported system configuration. If the results of execution do not match the expected results, the digital fingerprint is determined to have been spoofed.

The invention provides a SPARQL semantic data query optimization method based on connection cost. According to the method, the RDF mode information to simplify SPARQL basic graph pattern is used, then a B tree structure is used for rapidly estimating SPARQL connection diagram nose sizes and edge weight values, the connection cost is used for estimating and finding the optimal logical query plan by combining a dynamic planning method, and therefore the query efficiency for improving RDF semantic data is improved.

Embodiments of the invention disclose a query statement optimization method and apparatus, which relate to the technical field of data query and are used for solving the problem of occupation of a large amount of storage spaces caused by caching of historical logic query trees and corresponding query results of the query trees. The query statement optimization method provided by the embodiment of the invention comprises the steps of receiving n query statements; generating n logic query trees by the n query statements; according to a preset rule, adding version numbers for operands corresponding to operators in the n logic query trees; and optimizing the operators to reduce the number of physical tasks generated by the n logic query trees, wherein the operators belong to different logic query trees and the version numbers of the operands corresponding to the operators are same. The technical scheme provided by the embodiments of the invention can be used in a process that a big data query system performs batch query on a data warehouse.

The invention discloses a rule-driven and data-driven combined cross-platform SQL query optimization method. The method comprises the following steps of: 1, analyzing a cross-platform SQL statement into a logic query plan in a system; 2, enabling an optimizer scheduling module to schedule the most suitable optimizer to perform query optimization according to the characteristics of the logic queryplan; 3, enabling the rule-driven optimizer to perform plan search according to the rule, selecting an execution plan according to the cost model and the cardinal number estimation to obtain an optimal physical execution plan, and importing an optimization result into a sample collection module; and 4, converting the sample imported by the sample acquisition module into a training sample through adata adaptation module, performing reinforcement learning model training by using the training sample through a data-driven optimizer, and inputting query into the trained model to obtain an optimalphysical execution plan. The cross-platform SQL query optimization method solves the problems that an existing cross-platform SQL query optimization method is poor in expansibility, low in flexibility, poor in optimization effect and the like.

The present invention's efficient and economical maintenance strategy for a system of operation (such as involving various kinds of instrumentation) features a unique decision-making logic that incorporates reliability-centered maintenance principles. The initial logical inquiry filters out the non-critical cases, i.e., those instruments the failure of which does not jeopardize or compromise safety, or the environment, or an important function or operation. The logical construct proceeds as to the remaining (unfiltered) instruments in a series of logical steps wherein the satisfaction of one or more given conditions by a subject instrument directs the practitioner to the appropriate maintenance action for the subject instrument. Possible maintenance actions include the following: comparison check of the instrument with respect to the primary instrument; system operational check; repair of the instrument; replacement of the instrument; maintenance deferral until a scheduled failure finding task; system calibration procedure; individual maintenance procedure (on-site or off-site).

The invention provides a lease management method and a device based on a block chain and electronic equipment. The method comprises the following steps: receiving a first smart contract calling transaction initiated by the financing leasing equipment; in response to the first calling transaction of the intelligent contract, calling contract state query logic in the intelligent contract corresponding to the financing leasing equipment, and querying a financing leasing contract corresponding to the identifier of the lessee in a financing leasing contract library maintained by the intelligent contract and corresponding to the financing leasing equipment, determining whether the contract state of the financing lease contract is an overdue non-repayment state; and if the contract state of the financing lease contract is an overdue non-repayment state, further calling a generation logic in the intelligent contract, and generating a service stop instruction for the financing lease equipment,so that the financing lease equipment stops providing service for the lessee when acquiring the service stop instruction.

A computer-implemented method of providing a materialisation of a set of logical rules on a logical database comprising a set of logical facts. Each of a plurality of parallel processing threads performs the following steps. A logical fact that has not previously been received by any thread is received by the thread. By applying any of the logical rules to the received logical fact and/or any of the logical facts received by any thread prior to the received logical fact, the thread determines whether a new logical fact is implied, and if so the new logical fact is added to the set of logical facts. The thread then repeats the above steps on any further logical facts in the set of logical facts that have not previously been received by any thread. When all threads are waiting for a new logical fact, the method has completed.

The invention belongs to the technical field of information security. The invention particularly provides a gene data desensitization method for realizing efficient similarity query and access control. The similarity query of large-scale gene data in a ciphertext environment is effectively supported; meanwhile, complex logic query is supported to meet the personalized query requirement of the user; according to the method, the authorization mode is flexible, different access authorities can be given to different data, reliable control over the data access authority of a user is achieved in the query process, in addition, a specific Hash function is adopted for compressing the data, the number of matched elements in the ciphertext state is remarkably reduced, and the query retrieval efficiency is further improved.

The embodiment of the invention provides a batch data query method and a device. The method comprises following steps: obtaining multiple logic inquiry plan trees corresponding to multiple query statements; diving multiple query groups by all operators of each logical query plan tree, wherein logical query plan trees of each query group are in the relationships as follows: inter-query write-read dependency relationships; overlapping relationships between operators or operand overlapping relationships; optimizing inter-query logical query plan trees of each query group and generating multiple corresponding physical query plan trees based on multiple optimized query plan trees; and finally, executing physical obtaining query results of multiple sentences based on multiple physical query plan trees. The method helps to increase optimization opportunities between logical plan trees in query groups by grouping the multiple logical query plan trees. By performing inter-query optimization on the logical query trees of query groups, efficiency of batch data query is increased.

The invention discloses a big data processing system and method. The system comprises: a service interface which provides at least one external calling mode and is suitable for receiving a query statement in a specific language format, which is input by utilizing any external calling mode; an analysis module which is suitable for performing grammar analysis and verification on the query statementto generate a logic query plan; a routing module which is suitable for determining a calculation engine and/or a storage engine corresponding to the logic query plan according to the logic query plan,and routing the query statement to the calculation engine and/or the storage engine; and the plurality of computing engines and the plurality of storage engines which are suitable for executing corresponding query processing according to the query statement routed by the routing module, and obtaining and outputting a query result. By adopting the scheme, the user can process the big data only through the input query statement in the specific language format, so that the service logic of the user is decoupled from the calculation engine and the storage engine, the learning cost of the user isreduced, and the user experience is improved.

The invention discloses a real-time processing method and device based on big data. The method comprises the following steps of: receiving a query statement in a specific language format, which is input by utilizing any external calling mode; carrying out grammar analysis and verification on the query statement, and generating a logic query plan; determining whether a storage engine correspondingto the logic query plan comprises a real-time data storage engine or not according to the logic query plan; and if so, converting the query statement into a corresponding real-time calculation task, so as to enable a real-time data storage engine to execute the real-time calculation task. By the adoption of the scheme, a user can process big data in real time only through the input query statementin the specific language format, the learning cost of the user for the real-time data storage engine is reduced, and maintenance of real-time processing services is facilitated.

The present application relates to a search method, apparatus, computer device and storage medium based on large data. The method comprises the following steps of: obtaining a data query request; determining a search field according to the data query request; searching nodes corresponding to each search field from the pre-established data structure diagram; generating a data search instruction corresponding to the data query request according to the relationship between the queried nodes; the corresponding data is searched from the database according to the data search instruction. The searchmethod greatly improves the search efficiency, and the search method supports cross-table logical query, and the data corresponding to different search fields are stored in different tables, and can be directly queried at one time, which effectively solves the problem that only single table query is supported in the traditional technology.

The invention aims to provide a method and equipment for determining a target user based on user portrait data, and the method comprises the steps: firstly generating a logic query program for querying an expected attribute value of each attribute in the user portrait data, then obtaining user portrait description information about the target user, and then determining a logic query program corresponding to the attribute involved in the user portrait description information based on the user portrait description information, and finally executing the logic query program corresponding to the attribute involved in the user portrait description information based on the user portrait description information and the user portrait data; and determining a user corresponding to the user portrait data matched with the expected attribute value in the user portrait description information as a target user. By means of the method, developers can develop a user portrait data screening tool with high universality, user portraits are not limited, the query requirements of various screening condition combinations are met, and beneficial effects are brought.