87 results about "Conjunctive query" patented technology

A persistent federated folder within a federated content management system saves the result of a search or selection of items stored in various heterogeneous datastores. The federated folder can be used to save federated search results, to act as a container in a workflow process, or a container for a set of documents or folders with similar characteristics. The search result may be shared by several application programs without performing a separate search for each application. The federated folder and its associated storage structure have the capability to save its instances persistently. The federated folder operations can selectively create, retrieve, update, and / or delete an instance of a federated folder in addition to adding, retrieving updating and deleting its parts and its members. Seamless integration with the federated query is provided to operate on the federated folder transparently regardless of the locality of the user or the datastores the user is searching. Access rights for federated folders are enforced according to user's general privileges.

A tagging tree that defines a hierarchical output data structure and relational database query operations that retrieve the data to be included in each hierarchical section is accepted and processed. A query optimizer analyzes the tagging tree to determine database query operations that can be combined into a single query command. An outer-union query command is generated to allow efficient combination of multiple query commands, some of which are predicates to others. The tagging tree is modified to replace the database queries that were combined into the outer-union query to extract data from the results set produced by the outer-union query as opposed to submitting queries to the database manager. The optimized queries can be reused an arbitrary number of times to leverage the optimizing resources that were used in their creation.

To answer one or more queries of semistructured data, an answer automaton is constructed, based at least in part on the queries and on a schema of the data. The answer automaton is applied to the data to answer the queries. Preferably, to construct the answer automaton, a schema automaton is constructed for the schema, a query automaton is constructed for the queries, and the schema automaton and the query automaton are merged. If there are more than one query, separate query automata are constructed for the different queries and then are united to provide a joint query automaton. Preferably, all the automata are deterministic finite automata. Most preferably, all the automata are isostate automata.

A plurality of sources are registered. A plurality of schemas are constructed, based on the plurality of sources. A desired output is obtained as a conjunctive query. A list of potential connections between at least selected ones of the sources is provided. A plurality of join plans are developed, based on the connections.

Disclosed are a method and a system for executing a query that requires an expensive process, such as a join, between two or more datasets. If each dataset has multiple partitions that are located at multiple sources, then each of the multiple partitions for each dataset must be unioned prior to completing execution of the query. The method and system develop both a query execution plan and at least one alternative query execution plan to indicate when the process should be pushed down below the unions and when the process should be pulled up above the unions based on collocation of partitions. The query execution plan and the alternative query execution plan(s) are embedded in a composite query execution plan which is evaluated and re-evaluated at run time to determine which of the query execution plan and the alternative query execution plan is currently the most efficient plan and the query is executed, accordingly.

The invention discloses a blockchain state storage method based on an SQL database. By the adoption of the method, when a blockchain is initialized, a database is generated, a plurality of data sheets can be built by each contract, creating, reading, updating, deleting operations based on SQL grammar can be conducted on sheet structures and sheet data by contracts, and some interfaces with permission are encapsulated to be called by other accounts. A database change log (log) is generated by nodes after each transaction is highly executed, and the log is used as hash depository receipt, wherein a world state continuously proceeds to ensure the accordance of each node data. According to the method, the present situation that only simple data structures can be stored in blockchains is changed, a data sheet structure used widely is adopted, the creating, reading, updating, deleting operations are supported, even a cross-contract conjunctive query is carried out, the functions which intelligent contracts on the blockchain can perform are enriched, and at the same time, the docking difficulty of systems out of blockchain is reduced.

Embodiments of the present invention generally provide a system, method and article of manufacture for managing federated queries. In general, the availability of one or more databases targeted by a federated query may be determined prior to running the federated query against the targeted databases. In response to determining one or more of the targeted databases are unavailable, a user may be notified. The user may also be presented with options for running the federated query. The options may include being notified when all of the targeted databases are available, automatically running the federated query (in the background) when all of the targeted databases are available, and modifying the query to run against currently available databases.

A method for ranking data-objects retrieved from a plurality of databases is provided. First, data-objects are retrieved from a plurality of databases, wherein each database is accessed using a retrieval product. Second, a representation of each of the data-objects retrieved from the plurality of databases is generated in a conceptual representation space. Third, a representation of a query is generated in the conceptual representation space. Then, the data-objects are ranked with respect to the query based on a similarity between the representation of each data-object and the representation of the query.

Embodiments of the invention provide techniques for performing federated queries of data records stored in multiple data sources. In one embodiment, an aliased key table may be configured to store relationships between key fields of multiple data sources. The aliased key table may specify a mapping function to translate a value of one key field to an equivalent value of a second key field. The mapping function may be used with a mapping table storing sets of key values of different data sources, with each set corresponding to a given entity. In another embodiment, the mapping function may call a web service configured to translate key values. In yet another embodiment, federated queries may be specified in terms of attributes, which may be matched to key values.

The invention provides an HBase table conjunctive query optimization method which includes the following steps: enabling an Hive to be combined with an HBase, achieving HBase table conjunctive querying through an HQL language provided by the Hive, then conducting optimization by setting parameters having influences on a bottom layer MapReduce task, and improving the conjunctive query performance. Compared with the prior art, the HBase table conjunctive query optimization method has the advantages that unnecessary programming trouble is reduced, parallel processing can be carried out on conjunctive query tasks, the query efficiency is improved, the practicability is high, and popularization is easy to achieve.

A method for database multi-list union query comprises the steps of determining a plurality of lists associated with service logic in a relational database; connecting the database, and obtaining information of the plurality of lists; associating the plurality of lists into a materialized view list according to foreign key information; processing fields in the materialized view list, generating a combination key, and setting the combination key as a row key of a newly-built column type data table; establishing a mapping relation from the relational database to the column type data table, and writing the mapping relation and data records in the materialized view list into an XML file; mapping data in the materialized view list to the row key and a column identifier in the column type data table, writing the data records into the column type data table; performing multi-list query in the column type data table, and obtaining query results. According to the method, multi-list union query can be implemented quickly and efficiently under the condition of mass data.

System, method and article of manufacture for securing data. Queries are analyzed to detect security violation efforts. In one embodiment, algorithms for detecting selected security violation patterns are implemented. Generally, patterns may be detected prior to execution of a query and following execution of a query. Illustrative patterns include union query analysis, pare down analysis, non-overlapping and others.

A method, apparatus, and article of manufacture for optimizing a query in a computer system, wherein the query is performed by the computer system to retrieve data from a database stored on the computer system. The optimization includes: (a) combining join predicates from a query with local predicates from each branch of one or more UNION ALL views referenced by the query; (b) analyzing the combined predicates; and (c) not generating the join when the analysis step indicates that the combined predicates lead to an empty result.

The invention provides a natural language treating technology used for mobile phone message query and a device thereof, which comprise the steps that: 1) the natural language texts are divided into frequent words; 2) the frequent words are marked by characteristics of the part of speech, and the query sentences are classified according to syntax characteristics; 3) the natural language texts belonging to communication information are selected; 4) the possible field entities are identified; 5) the correct entity words and possible entity string of words are identified. The technology and the device of the invention have the advantages that: the natural language treating technology is applied to a message query platform, so the clients do not need to remember complicated key in formats, and the key in method is similar to that of a common message, which is more user-friendly. Through the technology and the device of the invention, the query sentences that are keyed in by clients with natural languages become words that can be understood by the system, and the geographical entity words mastered by the system constitute a joint query, which is convenient for the further treatment of the later geographical navigation system.

A tagging tree that defines a hierarchical output data structure and relational database query operations that retrieve the data to be included in each hierarchical section is accepted and processed. A query optimizer analyzes the tagging tree to determine database query operations that can be combined into a single query command. An outer-union query command is generated to allow efficient combination of multiple query commands, some of which are predicates to others. The tagging tree is modified to replace the database queries that were combined into the outer-union query to extract data from the results set produced by the outer-union query as opposed to submitting queries to the database manager. The optimized queries can be reused an arbitrary number of times to leverage the optimizing resources that were used in their creation.

Embodiments of the invention provide techniques for performing federated queries of data records stored in multiple data sources. In one embodiment, an aliased key table may be configured to store relationships between key fields of multiple data sources. The aliased key table may specify a mapping function to translate a value of one key field to an equivalent value of a second key field. The mapping function may be used with a mapping table storing sets of key values of different data sources, with each set corresponding to a given entity. In another embodiment, the mapping function may call a web service configured to translate key values. In yet another embodiment, federated queries may be specified in terms of attributes, which may be matched to key values.

The invention relates to an MPP engine-based cross-data center rapid query method and system, belongs to the field of big data retrieval and analysis, and can be applied to real-time systems or offline backup systems. The method comprises the following steps of: uniformly marking data in different MPP engines and storing the data into metadata; receiving a query request by a global center point and carrying out grammar analysis on the query request, and sending the query request to corresponding data branch center nodes; carrying out query by each data branch center node through corresponding MPP engines of the metadata, and transmitting the data to the global center node; and rapidly querying the data returned by the data branch center points by the global center point by utilizing the MPP engines, and outputting a query result. According to the method and system, the union query of data of different data centers can be realized, a plurality of MPP engines are compatible, characteristics of different storage modes are sufficiently utilized to optimize the query, and the export of query result in a plurality of manners is supported, and convenience is brought to realize the different requirements, for result data re-analysis, of different upper applications.

The invention provides a cloud computing security data sharing method based on a double-chain structure. The method comprises the following steps: adopting a joint query architecture of a private blockchain and a public block chain, and protecting cloud platform data through a blockchain and a data encryption technology; guaranteeing that the ownership of the data is controlled by a data owner through an encryption system, and only returning a service result during service processing through a blockchain smart contract; during data sharing, enabling a data requester to obtain original data ofa data provider by retrieving public blockchain data, and enabling the data owner to submit the data to the requester according to an authorization certificate. Based on the blockchain technology, a double-chain structure is adopted, it is guaranteed that data is real and cannot be tampered through a unique and safe encryption system, and the privacy and safety of platform data during service processing are effectively guaranteed.

The embodiment of the invention discloses a multi-party data joint query method and device, a server and a storage medium. The multi-party data joint query method executed by a management party comprises: analyzing a multi-party joint query statement to obtain a logic execution plan; processing according to a provider to which each node belongs in the logic execution plan to obtain a physical execution plan of each provider; and generating a query instruction of each provider according to the physical execution plan of each provider, and sending the query instruction to each provider, the query instruction being used for indicating each provider to cooperatively perform query. According to the technical scheme of the embodiment of the invention, the multi-party computing method for protecting the data security of the provider is realized, and the data query efficiency is improved on the premise of ensuring the security of the query data.

The invention provides a data joint query method, device and equipment and a computer readable storage medium. The method relates to a database technology and a block chain technology, and comprises the following steps: carrying out analysis and arithmetic unit division on a received joint query statement to obtain at least one operator containing a joint query operator; the joint query statement is used for synchronously initiating data joint query to the first equipment and the second equipment; converting the joint query operator into a first joint security operator based on a preset security protocol; synchronously executing the first joint security operator and a second joint security operator on the second equipment, and performing data interaction and joint calculation on first to-be-exchanged data of the first equipment and second to-be-exchanged data of the second equipment in a ciphertext form to obtain a joint data table; and processing at least one operator based on the joint data table to realize data joint query. By means of the method and device, the safety of data joint query can be improved.

An example system for processing a federated query includes a query proxy that receives a federated query including a plurality of source queries and receives an indication that a failed set of one or more source queries failed to execute successfully. Each source query is specific to an autonomous data source belonging to a federation. The system also includes a data federation engine that identifies a plurality of autonomous data sources to which to send the plurality of source queries. The plurality of autonomous data sources belong to the federation. The system further includes a query fail analyzer that updates a data structure to reflect the unsuccessful execution of one or more source queries of the failed set.

The invention discloses a method and a device for querying data. The method includes acquiring query plans; determining data source information in the query plans; executing meaning transferring operation on the query plans according to the data source information; querying the data in data sources according to query plans with transferred meaning and demonstrating query results. The data sourcescorrespond to the data source information. The method and the device have the advantages that the meaning transferring operation is carried out on the query plans, the meaning of the query plans is transferred into language capable of being identified by databases required to be queried, the different databases can be simultaneously queried by the aid of each single query plan by the aid of the operation, cross-platform union query can be implemented, accordingly, the data query efficiency can be enhanced, technical barriers between the different databases can be broken through, and the learning threshold can be lowered for developers.

The invention provides a spelling correction technology for mobile phone message query and a device thereof. The steps of the spelling correction technology are as follows: step 1: the homophony and approximant entities of an entity are searched and the homophony or approximant wrongly written or mispronounced characters are matched and corrected; step 2: the fuzzy syllable entity of the entity is searched and the fuzzy syllable is matched and corrected; step 3: the expansion terms in similar forms to the entity are searched and sigla are matched and corrected. The technology and the device of the invention have the advantages that: according to the input characteristics of a mobile phone, the spelling correction technology and the abbreviation identification technology are utilized to identify geographical names, thus solving the problem that a client does not know the detailed spelling of geographical names or the geographical names include uncommon characters, and the client needs not to remember the complete geographical names, which is more convenient and more suitable for the habits of the client. Through the technology and the device of the invention, the query sentences that are keyed in by clients with natural languages become words that can be understood by the system, and the geographical entity words mastered by the system constitute a joint query, which is convenient for the further treatment of the later geographical navigation system.

Embodiments of the invention provide techniques for generating database statistics for optimizing union queries. In general, working sets including samples of values in database columns are persistently maintained in a database. To optimize a union query, the working sets describing the columns included in the union query are combined to generate an ad hoc working set. The ad hoc working set is then used to generate a database statistic describing the combined columns. In another embodiment, working sets may also be maintained for generating statistics for optimizing non-union queries, thus enabling statistics to be refreshed more frequently.

The invention discloses a method for querying the appointed field data of a data table under a simplified JAVA program. The method comprises the following steps: creating a data entity class corresponding to a table field one by one; describing a field name to be queried by a character string array; creating a corresponding sql (Structured Query Language) query statement, and initiating and obtaining a result; utilizing reflection to map the result data to each attribute of a corresponding data entity object; and during data operation, directly utilizing a "get" method in the object to read a certain value.

The present invention provides a system standard retrieval method and system based on an electric power knowledge base and a readable storage medium, field migration is easy, and the detection efficiency and the coverage rate are improved. The method comprises the steps of 1, extracting keywords of an input power system standard sentence; 2, retrieving in an electric power system standard knowledge base according to the keywords, obtaining entity words corresponding to keyword semantics and associated entity words similar to the semantics, and jointly forming a retrieval keyword base; 3, combining the words in the retrieval keyword library in pairs to form retrieval word groups respectively, and gathering the retrieval word groups to obtain a query word group set; 4, taking words in the retrieval word group as joint query keywords, retrieving related system standard IDs in the electric power system standard knowledge base, and calculating the system standard ID with the highest confidence coefficient as a retrieval result; and 5, retrieving a relational database storing detailed system standard contents according to the system standard ID with the highest confidence coefficient toobtain system standard text data, and outputting the system standard text data.