3369results about How to "Improve query efficiency" patented technology

In embodiments, methods and systems for improving a query in a database system are provided. These method and system embodiments can enable greater contextual knowledge about the types and use of data in tables underlying a relational database to be employed to improve query efficiency. By employing contextual information, embodiments can provide improved queries and / or make recommendations to a query optimizer of a database system to improve its operation based upon knowledge of the data and / or application gathered. Embodiments can be useful in improving query performance in multi-tenant database systems.

Embodiments include a method, apparatus, program, and system for distributing data items among a plurality of data storage units, the data items being an aggregation of data from a plurality of data sources. The method comprises generating a semantic description of each of the plurality of data sources; calculating, for each pair of data sources from among the plurality of data sources, a degree of similarity between the semantic descriptions of the pair of data sources; and allocating data items to data storage units in dependence upon the calculated degree of similarity between the data source of a data item being allocated and the or each data source of data items already allocated to the data storage units.

The present invention discloses a digital transaction system, and an account information query method therefor. The digital transaction system comprises verification nodes configured to store latest account information and latest blocks including latest transaction information and latest account indication information in block chains, and to respond to account information query requests from transaction nodes according to the latest account information, wherein the latest account information is generated by updating existing account information by the verification nodes according to latest transaction information, the latest account indication information is generated by the verification nodes according to the latest account information, and the latest blocks are the reference of consensus between the verification nodes and other verification nodes in the digital transaction system according to a consensus algorithm; and the transaction nodes configured to transmit the account information query requests to the verification nodes and receive responses of the verification nodes to the account information query requests.

The invention is mainly used for searching a searchable encryption technology under a public key password system, and discloses a multi-user cloud encryption keyboard searching method capable of verifying integrity and completeness. The method can be used for verifying the search result completeness and the outsourced data integrity under the cloud environment and setting the multi-user authority. The method can be used for realizing the verification of the search result completeness and the outsourced data integrity by using signatures to bind keyword indexes and associated encryption files thereof, realizing multi-user privacy query by using a re-encryption technology and dynamically updating the query authority of the user. Moreover, the index structure and the query mechanism of the encrypted file are further optimized, so that the query efficiency is improved by using hash query in the query process, and the rapid access to the cloud data is realized.

The invention discloses a credit investigation data query method. The credit investigation data query method comprises the following steps: obtaining a credit investigation query authorization request initiated by a target user; using the credit investigation query authorization request, generating and storing authorization certificates in one-to-one correspondence with each credit investigation system respectively, and obtaining a corresponding authorization certificate set; if a credit investigation data query request for the target user is detected, sending the authorization certificate set to a block chain server; obtaining the credit investigation data corresponding to each authorization certificate in the authorization certificate set in the block chain server, and obtaining a corresponding credit investigation data block, wherein the credit investigation data corresponding to each authorization certificate come from a credit investigation system corresponding to the authorization certificate respectively. The query efficiency of the credit investigation data is improved. Moreover, the invention also discloses a credit investigation data query system.

The invention provides a data correlation query device and a data correlation query method. The data correlation query device comprises a data acquisition unit, an SQL (structured query language) execution unit, a cache number-picking formula construction unit and a cache execution unit. The data acquisition unit is used for obtaining a fundamental field of a fact table and selecting a field of a dimension table based on the fundamental field to be used as an correlation field for correlation of the fact table and the dimension table; and the SQL execution unit is used for implementing query operations through SQL statements based on the fundamental field and a datasheet with the fundamental field, and obtaining a result set; the cache number-picking formula construction unit is used for obtaining a main key value corresponding to the correlation field from the result set, and constructing a cache number-picking formula in combination with a data path with the correlation field; and the cache execution unit is used for obtaining the value of the correlation field according to the cache number-picking formula and combining the value of the correlation field and the result set to obtain final query results. The fact table and the dimension table can be associated efficiently, results can be implemented efficiently, the fatal pressure on the system caused by correlation query of the fact table and the dimension table with a large number of data can be avoided, and the efficiency can be improved.

The invention discloses an automatic question-answer processing method and an automatic question-answer system. The method includes: acquiring question text from question-answer data pairs collected in advance, performing word separation on the question text to obtain the corresponding key words of the question text, and building the index relation between the key words and the question text; whenoptional target question text is received, and performing word separation on the target question text to acquire target key words corresponding to the target text question text; according to the index relation of the key words and the question text, determining key words matched with the target key words, and acquiring the question text having index relation with the key words to serve as the candidate question text; calculating the semantic similarity of the candidate question text and the target question text; determining an answer corresponding to the target question text according to thesemantic similarity. The method has the advantages that the semantic similarity of the target question text and each question text is considered to determine the answer of the target question text, and the accuracy of automatic question-answer processing is increased.

The invention relates to a real time data compressing method, for compressing in-data packet data in a process control system, where the real time data comprises numerical values of analogue quantities and the method comprises: 1) initializing a dictionary, i.e. initializing characters that possibly occur during compressing into a dictionary; 2) reading in numerical valves; 3) making subtraction of adjacent data to obtain difference values and storing the first read-in numerical value in compressed files; 4) adopting LZW algorithm to compress the difference values. The invention realizes the lossless compression of real time data and the compressing course is safe and reliable. The invention has very good rapidness and can meet the requirements of real time databases and raises the history data inquiring efficiency.

The invention provides a customizable query method and a platform on the basis of service composition. The method comprises: describing own demands to the platform by a user through an appointed client end visible component and through operations of selecting and filling the attribute value of the component, analyzing the initial state and the target state of a data query request, then, searching and combining a corresponding basic service calling sequence, then, executing basic services in the sequence, thereby obtaining a result set which contains user expected result data, and generating a final result to display to the user through screening, sequencing and assembling. In the method, the user describes own demands to a system actively, the system can effectively adapt different individualized demands of different users through receiving user description and dynamic analysis processing, the application system development work load and the later maintenance cost are lowered, and the friendliness of a data query application system is improved, which enables the user to customize data query actively and enables inquiry to be flexible and convenient.

The invention discloses a query optimization method based on a unified view of a distributed heterogeneous database. The method comprises the following steps of: configuring the unified view for the distributed heterogeneous database for external access; effectively decomposing SQL query statements of the unified view according to a physical table of a database to be queried so as to maximally reduce the number of accesses; querying corresponding physical table by the decomposed SQL query statements and returning back resultant data, wherein a cache region is firstly queried, if the cache region contains corresponding resultant data, the result is directly obtained, and priorities are set for the SQL query statements so as to obtain an optimal result set as much as possible in each time while querying the physical table; and combining the resultant data returned after querying the physical table, and storing the combined resultant data and the corresponding SQL query statements into the cache region. The query optimization method based on the unified view of the distributed heterogeneous database improves efficiency for querying the unified view of the distributed heterogeneous database and reduces usage of resource.

The embodiment of the invention provides a block chain data indexing method and device. The method comprises the following steps: receiving transaction information and an index identifier associated with the transaction information; determining whether an index list associated with the index identifier exists in an index list set of a block chain; and in response to the result that the index list associated with the index identifier exists in the index list set of the block chain, adding a new item associated with the transaction information to the index list. By means of this manner, the inquiry efficiency of the block chain can be greatly improved, and meanwhile the effective support of complex inquiry (for example, range inquiry or condition inquiry) can be provided at the same time.

The invention relates to a blockchain network, an object transaction method, a device and node equipment, wherein the object transaction method comprises the steps of transmitting a transaction request of a preset object to authorized nodes in a blockchain to which a preset object transaction is related; respectively receiving transaction verification information which is obtained by each authorized node according to the received transaction request; acquiring a verification result according to the transaction verification information; and transmitting the verification result to each authorized node, wherein the verification result is used for confirming or canceling transaction of the preset object by each authorized node. According to the blockchain network, different objects correspond with different blockchains; and in a transaction confirmation process, through co-verification of the nodes in multiple blockchains, the verification result is obtained, thereby ensuring high transaction safety, reducing the length of a single blockchain, reducing data volume of each node, improving searching efficiency of the blockchain, improving gathering efficiency and statistics efficiency of single kind of objects and improving concurrence.

The invention relates to a data processing method used for implementing a multilist inquiry of a database and used in a computer database inquiring and processing module, including: configuring the relative information to data inquiry, decomposing the data inquiry into many sub-inquiries; as inquiring database, first reading parameter information in the inquiry configuration information; reading the relative information to the inquiry from the configuration information; composing SQL sentences according to the inquiry sentences and the parameter information, connecting the databases the sub-inquiries are related to, then executing the SQL sentences; write the inquiry result in a corresponding memory data region in a form prescribed by a configuration file, and arranging data records according to key words; according to collected attributes of inquiry elements, generating a total record; writing the data column description information in an inquiry memory data region. On the other side, it can complete the multilist and complex database inquiries at a high speed and implement universal inquiries, i.e. it need not compose programs so as to complete complex database inquiry by configuring information.

The invention discloses a historical data storage and indexing method and belongs to the field of real-time historical databases. According to the characteristics of industrial historical data storage formats, a simple and efficient historical data storage method and an efficient indexing mechanism are given. According to the historical data storage method, on the one hand, the I / O of a magnetic disk is reduced as much as possible by performing compression and cache on historical data and optimizing the data archiving sorting process; on the other hand, the I / O load of the magnetic disk in the data archiving sorting process is distributed to all time points in a balanced mode, and thus it is guaranteed that the requirement for storage of current historical data is met, and meanwhile the storage method has the dynamic extension characteristic. Through the indexing mechanism, the historical data can be fast accessed, and when a database is dynamically extended, the system can be not influenced by data access by dynamically modifying indexing files.

The invention discloses a theme map expansion based knowledge resource organizing method, which is characterized by including: organizing resources to build resource indexes, and providing a search architecture based on themes on the basis of a map architecture formed by knowledge resources and theme incidence relations therein. In the search architecture, themes of documents are organized to be index entry, document collection is divided by combining internal relations of succession, correlation, polysemy of the document themes and multi-label classifying technology, proper partition is selected by a partition selecting method based on threshold value so as to guide building and inquiring of the indexes. During inquiring, inquiry results are acquired from a route to the relevant index partition and are gathered and organized according to the theme relations, and resource utilization rate and inquiring efficiency are improved sufficiently on the premise of guaranteeing quality of the inquiry quality. Further, by the index partition gathering and breaking technology, the index structure is further optimized and quality of the inquiry results and inquiring efficiency are improved.

The invention provides a method and a system for inquiring personal credit information, and a personal credit inquiring system. A client and the personal inquiring system adopt a mode of asynchronous communication, and process inquiry requests of a plurality of clients synchronously, so as to improve inquiry efficiency, improve performance of the system, and meet requirements of clients. The system for inquiring personal credit information in a personal credit investigation system comprises the plurality of the clients for initiating the inquiry requests to the personal credit inquiring system through calling service of an information middleware of the personal credit inquiring system and ending request processing, and the personal credit inquiring system for receiving the inquiry requests sent by the plurality of the clients, inquiring the personal credit information in the personal credit investigation system according to the inquiry requests, updating a local database according to the inquired personal credit information, and calling the information middleware of the clients to send the inquired personal credit information to the clients.

The invention discloses a method for constructing a semantic data model for a material science field based on ontology. The method comprises the following steps of: designing the semantic data model for the material science field based on the ontology, and establishing a mapping rule between the data model and the ontology; based on the semantic data model, carrying out data semantic analysis and annotation based on the ontology aiming at structured data, semi-structured data and non-structured data, constructing a semantic visual model of field data to support the semantic integration and the efficient retrieval of massive heterogeneous data in the material science field; and based on an OWL-S (ontology web language for service) technique, describing, issuing and acquiring a relevant data service to support the higher-level service semantic synergy in the material science field. The method has the advantages that the semantic integration, the intelligent inquiry and the personalized service of the data in the material science field can be realized effectively.

Provided are an index creation method, querying method, apparatus and device for spatial-temporal data. The index creation method comprises: generating a multistage time index tree by taking a pre-set time range as a root node; moreover, generating a multistage spatial index tree by taking a pre-set spatial range as a root node; respectively mapping each time slice leaf node and each space leaf sub-node into a spatial-temporal file, wherein the spatial-temporal file is used for storing time slices which are characterized by the time slice leaf nodes having a mapping relationship with the spatial-temporal file and spatial-temporal data which is characterized by the space leaf sub-nodes and corresponds to subspaces. The spatial-temporal data index created on the basis of the index creation method for spatial-temporal data provided in the embodiments of the present invention improves the querying efficiency when spatial-temporal data is searched. The present invention relates to the technical field of computers.

The invention discloses a query method and system for colored message log, which is based on a distributed database. The system includes a colored message centre, a log server, a log query server and a WEB client-side. The colored message centre includes a plurality of service processors which are used for simultaneous business treatments. Log files are produced during the business treatment process of every business processor. The log server includes a relative collector and a database, which are used for collecting the log files produced by the business processors and introducing the files to the database in batches. The log query server is used for providing a query interface for the log server and providing WEB services for WEB clients. The query method and system for colored message log which is based on a distributed database adopts the three-tier architecture of a query thread manager which is arranged between a database connection pool and query services. The concurrent query of a plurality of log servers is realized. The query efficiency is improved and at the same time the robustness of the system is promoted.

The present invention provides a method for transforming a concept-based query into SQL query statements, comprising the steps of: transforming inputted concept-based queries into logic rules; checking validity of the logic rules; optimizing the valid logic rules; and translating the logic rules into SQL query statements in accordance with the optimization result. The present invention further provides corresponding transformation engine, database query system and computer program product. The present invention facilitates people to use more descriptive query language to query data stored in relational database. Furthermore, the present invention can automatically generate the correct and efficient SQL query statements so that people's efforts to deal with complex data model are saved significantly.

The invention relates to the field of communication and discloses a Bluetooth function control method of a mobile terminal and the mobile terminal. According to the invention, the mobile terminal automatically starts the Bluetooth function when receiving a trigger signal of a voice application and finds a Bluetooth headset which can be paired with the mobile terminal to be paired by searching the Bluetooth headset which is in an available state around, and the Bluetooth headset is utilized to send and receive a relevant signal of the voice application (for example, the Bluetooth headset is utilized to carry out communication) after the pairing is succeeded. After the voice application is ended, the Bluetooth function of the mobile terminal is automatically closed. According to the Bluetooth function control method of mobile terminal and mobile terminal, the Bluetooth function on the mobile terminal still can use the Bluetooth headset to carry out communication or other voice applications without keeping open, thereby greatly lowering the power consumption and the electromagnetic radiation of the mobile terminal.

The embodiment of the invention discloses a method and equipment for identifying repeated information. When the technical scheme adopted by the embodiment of the invention is used, released information is stored in an internal memory in form of feature codes; when a new information release request is received, the internal memory is searched for a corresponding feature code, and whether the information the information releaser requires to be released is the same as released information is determined by judging if repeated feature codes exist through comparison; and thus, under the condition of guarantying the repeated information identification accuracy, the database access flow load brought by searching the database for repeated information is reduced, the identification efficiency of repeated information is increased, and the repetition identification time in an information release process is reduced.

Character of the method includes following points: triggering local program or script program of searching web pages; monitoring information on search bar inputted by user, and sending the information to the search server instantly; carrying out match between the said input information and database of the search server, and returning the matched instant result back to the local program or script program; displaying the instant result on hint bar of the current search page. Using search steps for query determined through comparing simplified results, the invention increases searching speed, and makes more intuitive operations for users. Introducing fuzzy query technique and each prompting message, the invention can carry out search even user is unable to input query completely so as to help user to do query and operation further. The invention is applicable to computers, handsets and information household electric appliances. Features are: low cost and no special secret algorithm.

The invention discloses a reverse index mixed compression method based on an Hbase database. The reverse index mixed compression method comprises the steps of processing the Hbase database to obtain an Hbase database reversed index data table including keys and values; compressing the key part by a key dictionary compression method; compressing the value part by a variable bytecode compression method; and writing the compressed content into files. The invention also discloses a decompression method of the compressed file key part after being compressed by the compression method. The decompression method comprises the steps of judging the length of each compressed data item, processing to obtain decompressed data according to two conditions of the length being less than or equal to 13, and the length being more than or equal to 25, otherwise, failing to decompress. According to the method adopts the classification mixed compression and the classification decompression method, the compression ratio is improved on the condition that the high decompression ratio is ensured possibly; the unified considerations of file reading and data decompression can be achieved; and the query efficiency of the reverse index can be improved completely and the storage space can be saved.

The invention provides a method for constructing a financial knowledge map in the field of non-performing asset management. The method comprises: firstly, performing triple construction on structuredtexts in the field of non-performing asset management; secondly, intelligently extracting unstructured text information based on a semantic recognition model and constructing a triple, to realize structured extraction of unstructured texts; and then, performing data fusion on bodies in a contract, attributes of the bodies, and relations of body pairs with ontology base information, to fuse multi-source heterogeneous data and visually show information related to user search. Through the above steps, the method realizes knowledge reasoning, calculation and completion, so that complete, true, andeffective information is visually shown to business experts. The method is used to solve a problem that an enterprise and employees are lack of risk control decision support when conducting businessin the field of non-performing asset management.

The invention relates to a trajectory tracking system based on face recognition, which comprises a control center and a plurality of photographing units, and is characterized in that the control center is internally provided with a face recognition unit, an information adding unit, a trajectory querying unit and a trajectory editing unit, wherein the face recognition unit is used for acquiring first face recognition information in a video scene; the information adding unit is used for adding trajectory information to the first face recognition information and storing the first face recognition information into a face recognition information base; the trajectory querying unit is used for acquiring second face recognition information of a query person, comparing the second face recognition information with the first face recognition information, and acquiring a face similarity comparison value; and the trajectory editing unit calls all first face recognition information with the face similarity comparison value being greater than a set threshold value, and performs sorting according to the trajectory information. According to the invention, the face recognition information of related figures in multiple video scenes is extracted through a face recognition technology, the extracted face recognition information is compared with acquired face recognition information, the similarity is added, all trajectory information with high similarity with a query person is extracted with querying is performed again, and a moving trajectory of the query person is displayed.

The invention provides an association relationship query method and a device. The association relationship query method comprises the following steps: receiving an association relationship request carrying an object identifier and a scheme identifier; obtaining an association relationship table which is associated with the scheme identifier from the preset association relationship table; and querying the association relationship which corresponds to the object identifier from the obtained association relationship table. The association relationship query technical method directly queries the association relationship of an object from the association relationship table which is associated with the scheme, thereby overcoming the problems of slow query speed and low efficiency produced by multi-table combined query of the association relationship in the prior art and realizing the rapid and high-efficient association relationship query.

The invention provides a gate rapid transit control method based on a mobile terminal. The method comprises the steps that a cloud server judges whether a user carrying the terminal reaches a gate entrance, an account preset inside the terminal and related to identity information is inquired, and it is determined that the status of the account is normal; if the status of the account is normal, a camera arranged at the gate entrance photographs an image of the user and sends the image to a local server so as to perform identity verification; according to the recognition result of the local server, a gate stop level is started or closed, and the user enters the station from the gate entrance. Due to face recognition, physical characteristic recognition and limb shape recognition, the database query range is decreased, whether the current user is a real user of the terminal or not can be rapidly judged, the query efficiency is improved, the phenomenon that a jammed queue is caused by slowidentity recognition is avoided, and identity recognition and accurate positioning can be achieved without any special movement of the user.

The invention discloses a decision tree generation method and equipment, and a decision tree-based message classification method and equipment. The decision tree generation method includes: transforming the rules in the original rule set into the range array of the decision tree; starting from the root node, cutting by combining multi-bit prefix and HiCuts algorithm until the number of rules in each node is less than the preset value. The message classification method based on the decision tree includes: extracting the source and destination IP addresses in the message, and converting them into a decision tree query array; starting from the root node to search, and searching in turn according to the cut dimension and the number of cuts, Until the leaf node is obtained; compare the message query array with the rules in the leaf node to obtain the rule matching the message. The present invention combines bit prefixes with HiCuts to generate a decision tree, reduces the depth of the decision tree, improves query efficiency and saves memory space when searching based on the decision tree.