104results about How to "Improve data query efficiency" patented technology

The invention relates to the technical field of big data, and discloses a business data query method, device and equipment and a storage medium, which are used for improving the data query efficiency.The business data query method comprises the steps of obtaining a plurality of business table names and a plurality of pieces of business field information corresponding to each business table; generating a target page based on the label tree data, and setting a corresponding content data box for each piece of service field information in the target page; screening a content data box corresponding to each piece of service field information according to the data box operation instruction to obtain to-be-queried field information; determining a to-be-queried data table name from the plurality of service table names, and sending the to-be-queried data table name and the to-be-queried field information to a target server, so that the target server splices the to-be-queried data table name andthe to-be-queried field information into a structured query language statement; and obtaining target service data according to the structured query language statement. In addition, the invention alsorelates to the blockchain technology, and a plurality of pieces of service field information can be stored in the blockchain node.

The invention is suitable for the technical field of data treatment and discloses a data storage method and system. The data storage method includes that acquiring data to be stored, and storing the data in a non-relational database; carrying out data mining on the data in the non-relational database according to a preset time interval to obtain keywords of the data; building index of the data according to the keywords, and storing the keywords and index in a relational database. The data storage method and system lower the security data storage cost, improve the security data storage safety and improve the security data mining and inquiry efficiency.

The present invention belongs to the technical field of data processing, and provides a data processing method and apparatus based on a graph database. The method comprises: establishing an association relationship between entities involved in each piece of data, wherein the entities comprise a person, an enterprise, an event, or a standard address; and transforming the association relationship between each entity into graph data. According to the data processing method and apparatus based on the graph database, the query efficiency of big data can be improved, and the data query result can beefficiently obtained.

The application discloses a data storage method and data storage devices and a storage medium, and belongs to the technical field of information processing. The method includes when at least one datarecord is acquired, determining bitmaps of label values in each bitmap index partition, which is included by an bitmap index, through a preset mapping/reducing model on the basis of the at least one data record to realize storage of the at least one data record into a corresponding bitmap index partition. The bitmap index includes at least one bitmap, each bitmap corresponds to one of the label values, thus a carrying body identifier with label values can be found through the bitmap index on the basis of the label values, and efficiency of carrying out data querying on the basis of the label values is improved. In addition, the bitmaps of the label values in each bitmap index partition can be determined in parallel through the preset mapping/reducing model, and efficiency of storing data is improved.

The invention belongs to the field of power plant operation data processing, and particularly relates to a method and device for processing mass real-time generated data of a thermal power plant. On the basis of modeling and storing massive time series data generated in the production process of a thermal power plant based on a key value data model, the time series data is sliced according to timedimensions and stored in an HBase, and meanwhile, a SparkSQL execution process is fused to inquire the massive time series data. The Spark SQL is a module of the spark for processing the structured data, and provides a programming abstraction called DataFrame and used as a distributed SQL query engine. Data query is converted into Spark RDD, then the Spark RDD is submitted to a cluster to be executed, and extremely high data query efficiency is achieved.

The invention provides an injection machine technological parameter record query system and an injection machine technological parameter setting method; the injection machine technological parameter record query system can store and record injection moulding technological parameters satisfying injection moulding processing requirements, and can provide following queries; the method using the injection machine technological parameter record query system to set injection machine technological parameters comprises the following steps: controlling a technological parameter record query device parameter query display to input a to-be queried injection mould number, thus searching and extracting a technological parameter data set matching the query trigging environmental parameters from the recorded environmental parameters, and displaying the recorded injection moulding technological parameters in the data set, so technical personnel can set the injection machine according to the displayed parameters; the novel system and method can effectively solve the problems of long injection moulding technological parameter debug duration and frequent de-bugging times, thus reducing time consumption cost and raw material consumption cost caused by debug and de-bugging, and providing very well application promotion values.

The invention provides a method and a device for querying a double-transcript parallel database, and belongs to the technical field of databases. The method comprises the following steps: obtaining a query request and data storage unit information; forming a plurality of execution plans according to the query request and the data storage unit information; calculating resource occupation rates of the execution plans according to the resource utilization rates of execution nodes and the estimated data transmission quantity of the execution nodes in the execution plans; selecting one execution plan from the execution plans according to the resource occupation rate; and querying data according to the selected execution plan. The method provided by the invention is used for calculating the resource occupation rates of the execution plans according to the resource utilization rates of the execution nodes and the estimated data transmission quantity of the execution nodes in the execution plans and selecting one execution plan from the execution plans according to the resource occupation rate, and since the resource occupation condition influences the data transfer time consumption and the data query efficiency, the data transfer time consumption of the execution plan in the final query is short, and the data query efficiency is high.

The embodiment of the invention discloses a data query method, system and device and electronic equipment, and the method comprises the steps: receiving a data query request carrying a user identifier, the data query request comprising a query time range; estimating the query data volume in the query time range; determining the splitting quantity of the data query request according to the query data quantity, so that the data query request is split according to the splitting quantity to obtain a query sub-request, and the query data quantity corresponding to the query sub-request does not exceed the database load for performing data query on the query sub-request; adjusting the splitting number by using historical query behavior data corresponding to the user identifier; and splitting thedata query request according to the adjusted splitting number, so that a database performs data query according to a query sub-request obtained according to the adjusted splitting number.

The invention relates to an electronic device, a multiple table association query method and a storage medium. The multiple table association query method comprises the steps that multiple query conditions for conducting association queries on multiple tables are received, if the query conditions comprise at least two query conditions which are logical and relational, one or more associated fieldsare determined according to the query conditions which are logical and relational; corresponding data of the same associated fields are obtained from multiple data tables respectively, and merge processing is conducted on the corresponding data of the same associated fields; the data on which the merge processing is conducted of the same associated fields are converted to a form of columns, and queries are performed based on the converted data and multiple query conditions. The multiple table association query method has the advantage of being capable of improving multiple table association data querying efficiency.

The invention relates to the technical field of virtual storage, and particularly discloses a multi-source database access method and device, a storage medium and electronic equipment. The multi-source database access method comprises the steps of acquiring interface information of multiple databases, integrating and packaging the interface information, and connecting the multiple databases with apackaging interface; wherein the interface information comprises access grammar corresponding to each database; connecting the packaging interface with a query platform through a preset interface; receiving query information sent by the query platform, and matching grammar corresponding to the query information with the access grammar to obtain a target database; and obtaining target data corresponding to the query information through the target database. According to the invention, the access efficiency of the multi-source database is improved, and the operation and maintenance manpower is saved.

The provided Sh interface data query method for application server (AS) and attributive signed user server (ASUS) comprises: a. AS sends request for correlating public marl set including third type mark parameter and second public user mark to ASUS; b. it analyzes the relation between two public user marks; c. ASUS returns response including the third-type public mark node with public mark set message and attribution value.

Disclosed are a method, apparatus and system for processing data. The method comprises: a server receiving real-time data, sent by an unmanned aerial vehicle, of the unmanned aerial vehicle; the server caching the real-time data into packet data sets corresponding to unique codes comprised in the real-time data, wherein the unique codes correspond to the packet data sets on a one-to-one basis, thereal-time data generated by means of the unmanned aerial vehicle during one flight process comprises the same unique codes, and the real-time data generated by means of the unmanned aerial vehicle during different flight processes comprises different unique codes; and the server storing data comprised in the packet data sets in sub-tables, corresponding to the unique codes, in a database, whereinthe sub-tables correspond to the unique codes on a one-to-one basis. By means of the embodiments of the present invention, real-time data generated by means of an unmanned aerial vehicle during one flight process can be stored in the same sub-table, thus improving the data query efficiency to a certain extent.

The invention discloses a realization method for unified management and centralized check of an enterprise report and belongs to the fields of computer software. According to the realization method, a report system is integrated by a report center; the report is managed in a unified manner; process control of the whole life cycle of the report is realized; and a report access environment for a user is established. The report center mainly comprises three functional modules, such as a report design center, a report management center and a report application center. Compared with the prior art, according to the realization method for the unified management and the centralized check of the enterprise report, the improvement on the data query efficiency of the user is facilitated; the establishment result of the report system can be fully exerted; and favorable popularization and application values are obtained.

The embodiment of the invention discloses a data query method and a data query device, which can improve the efficiency of data query. The method comprises the following steps of: receiving request information sent by a user, wherein the request information contains key words for data query; storing the key words, and distributing scheme marks to the stored key words; and returning the scheme marks to users. The embodiment of the invention also provides a data query device. Through the data query method and data query device provided by the embodiment of the invention, the efficiency of data query can be effectively improved.

Embodiments of the present application provide a data caching method and apparatus, a computer device, and a storage medium. The method comprises the following steps of obtaining the data to be cachedof the business scenario; determining a serialization mode corresponding to the data to be cached according to the business scenario and the characteristics of the data to be cached; determining a caching strategy corresponding to the data to be cached according to the service scenario; configure serialization methods and caching strategies; when the cache instruction is received, storing the data to be cached in the cache database according to the configured cache strategy according to the serialized mode. Embodiments of the present application improve serialization efficiency, data cachingefficiency, and data query efficiency, thereby improving user experience.

The invention relates to the technical field of data query, and discloses a data query method and device based on a big data query engine, equipment and a medium, the method comprises the following steps: analyzing an obtained SQL query statement to obtain a corresponding query table and filtering information in the SQL query statement, then obtaining associated file information corresponding to the query table, and storing the associated file information in the SQL query statement; the method comprises the following steps: filtering SQL query statements, generating a target query table in combination with filtering information, performing matching processing on the SQL query statements, then replacing corresponding query tables in the matched SQL query statements with the target query table to obtain target SQL query statements, performing data query on the target SQL query statements through a big data query engine, and sending an obtained query result to a user side. The invention further relates to a block chain technology, and the query result is stored in the block chain. According to the method, the associated file information and the filtering conditions are added into the query statement, so that the data query range is reduced, and the data query efficiency of big data is improved.

The invention provides a rapid network visualization method of three-dimensional seismic data. The method comprises the following steps that a memory cell of a server stores all three-dimensional seismic data cubes in the study area; the server establishes a bitmap index of all three-dimensional seismic data cubes; when the request message for displaying a specified local area image in the study area transmitted by a client is received, the server searches the memory cell through the bitmap index, acquires the special three-dimensional seismic data cube corresponding to the plane feature point coordinate values, positions in a complete picture based on the special three-dimensional seismic data cube and acquires the specified local area images; the server compresses the specified local area images to obtain compressed local images; the server transmits the compressed local images to the client through network; and the client displays the compressed local images. By improvements from various aspects, the display speed of three-dimensional visualization images at the client is enhanced, and the user experience is improved.

The invention discloses a block chain data processing method and device, equipment and a storage medium. The method can be executed by a blockchain node, and comprises the following steps: respondingto a blockchain branch request sent by a proof node in a blockchain network, the blockchain branch request being generated when the proof node detects that a current blockchain satisfies a branch condition; according to a chaining rule, performing child-mother chaining on the current block chain, and storing the chained mother chain in the proving node; and processing the data of each block in themother chain, constructing a provenance block of a sub-block chain according to a processing result, and taking the sub-block chain as a new current block chain. The data storage space of the block chain network can be reduced, so that the data synchronization and data query efficiency of each node is improved.

The invention discloses a log storage method, a control node and a computer-readable storage medium. The method comprises the following steps: a control node receives a log reported by a cloud management platform and a log reported by at least one cloud host; the control node creates a current block, the current block comprising a block header and a log side chain, the block header comprising a hash value of a previous block, and the log side chain storing received logs in a predetermined order. The logs reported by the cloud management platform and the logs reported by the cloud host are stored in the log side chain and the hash value of the previous block is included in the block header, so that reliable and accurate operation log service is provided for the cloud platform, and reliableservice for the subsequent functions of the cloud platform is further provided, and the data query efficiency is improved by utilizing the advantages of the chain data query.

The invention provides a well logging knowledge graph construction query method and device, equipment and a storage medium. The method comprises the steps of acquiring query information input by a user; extracting key information of the query information according to natural language processing; querying in a well logging knowledge graph according to the key information, and determining triple data corresponding to the query information; wherein well logging data samples in the logging knowledge graph are stored in the forms of entities, attributes and relationships, and the key information comprises at least one of the entities, the attributes and the relationships in the query information; returning related well logging data in the knowledge graph corresponding to the query information according to the triple data corresponding to the query information; and displaying the returned related well logging data of the knowledge graph, so that the data query efficiency of well logging personnel is improved, and the well logging personnel can conveniently and efficiently obtain main information required in an oil well exploration process.

The invention relates to the technical field of data processing, and discloses a service data query platform configuration method, which comprises the steps of: acquiring service data types and database information corresponding to a plurality of service systems, wherein the database information at least comprises a database address and a database type; deploying a database connection string corresponding to each service system according to the database address, and generating an SQL script corresponding to each service system according to the service data types and the database type; performing performance test on the SQL scripts; deploying the SQL scripts into the service systems corresponding to the SQL scripts; and configuring a query entrance of a service data query platform accordingto keywords of the service data types corresponding to the SQL scripts and calling relationships among the service systems. The service data query platform configuration method can further be appliedto the technical field of blockchains. The invention further discloses a service data query platform configuration device, computer equipment and a computer readable storage medium. The data query efficiency of the service data query platform is improved.

The invention relates to the field of artificial intelligence, and provides a data query method and device based on semantic recognition, equipment and a storage medium. The method comprises the stepsof receiving a data query request sent by a user, obtaining first voice data carried in the request, identifying an intention result of the first voice data based on a pre-constructed intention template, obtaining a target character set corresponding to the intention result, and judging whether the target character set meets a preset condition for generating a target SQL statement or not; when the target character set meets the condition of generating the target SQL statement, generating the target SQL statement based on the target character set, inquiring the preset database according to thetarget SQL statement to obtain the target data, and reporting the target data back to the user. The invention also relates to the technical field of block chains. The first voice data and the targetdata can also be stored in a node of a block chain.

The invention aims to provide a method and equipment for data querying in a non-relational database. The method specifically comprises the following steps: acquiring a querying command regarding datain the non-relational database, wherein row primary key information of the data in the non-relational database comprises time versions, and granular times longer than data aggregation cycles; determining one or more granular times matched with a querying time range corresponding to the querying command; and determining one or more pieces of target data corresponding to the querying command according to the granular time(s), wherein the time version of each piece of the target data is included by the granular time or one of the granular times. Compared with the prior art, the method and equipment provided by the invention has the advantages that the granular times longer than the data aggregation cycles are added to the row primary key information of the data in the non-relational database,the granular time(s) matched with the querying time range is/are determined during querying, and the target data is determined according to the granular time(s), so that the efficiency of the data querying in the non-relational database under the big data scenario can be improved.