38results about How to "Reduce query time" patented technology

The invention relates to the technical field of big data and the field of financial science and technology, and discloses a data dependency relationship confirmation method, which comprises the following steps of: importing metadata information containing a field name, a data table name and data source information into a data processing module to obtain a target field name, and retrieving a target field in the metadata information by utilizing the data processing module to confirm a data dependency relationship. Determining an upstream data source and a downstream data destination of the target field; generating upstream and downstream data link diagrams of the target field, wherein the upstream and downstream data link diagrams are used for identifying a flow relation of data, a data generator and processing logic; and analyzing a dependency relationship between the target field and the upstream and downstream fields based on the link diagram, and further determining a data table on which the target field depends and owner information of the data table. According to the method, through automatic analysis and link diagram generation, the original complex process needing manual query and processing is simplified, the data dependency relationship is clearer, the communication cost and query time of developers are reduced, and the data use accuracy and processing efficiency are effectively improved.

The invention relates to an intelligent expert extraction system based on deep learning. The intelligent expert extraction system comprises an expert database module, an expert information index module and an intelligent extraction and matching module, the expert database module is used for storing expert information from different fields and carrying out standardization processing; the expert information indexing module is used for intelligently indexing expert information by using a deep learning model and an information retrieval technology, receiving bid evaluation task requirements, screening out experts most conforming to conditions and providing matching degree scores; and the intelligent extraction and matching module converts the bid evaluation task into a task feature vector through an adaptive algorithm, performs similarity calculation on the task feature vector and the expert feature vector, and automatically extracts the most matched expert. According to the method, the standardized expert database is established, intelligent indexing and feature extraction are performed by using the deep learning model, and accurate matching between the experts and the bid evaluation task is realized through the adaptive algorithm, so that high efficiency, justice and transparency of the bid evaluation process are ensured.

According to the SQL query optimization method and system based on deep reinforcement learning driving, in the stage that an optimizer generates a physical query execution plan, action screening and state regression technologies are combined, and the performance of a deep Q network is improved. And a more accurate Q value can be obtained by training the neural network by using the'action-state 'pair. Besides, by balancing the weight of the Q network and the weight of the dual-depth Q network, the error of a target estimation value is effectively reduced, so that more accurate Q value estimation is realized. After the method is adopted, the following technical effects are achieved: (1) flexible connection sequence optimization: deep reinforcement learning enables the action values of the target network and the evaluation network to be optimally updated by analyzing SQL query and dynamically adjusting the connection sequence; and (2) compared with the traditional method, the method not only can dynamically adjust the connection sequence in the query, but also can perform optimal selection according to reward feedback and historical data. According to the optimization strategy, the query time is remarkably shortened in complex multi-table connection query, the query execution efficiency is improved, and generation of a non-optimal plan is avoided.

The invention discloses a hydropower station production and emergency coordination method and platform based on a communication system, and the method comprises the steps: a power plant duty room receives event information, and an on-duty person immediately calls the hydropower station production and emergency coordination platform; corresponding event important information is clicked or supplemented on the basis of the current template, and disposal prompt information pointing to corresponding event levels of all departments is automatically activated; checking the default notification object of the current event and confirming the accuracy; processing prompt information is automatically sent according to a pointed department; a receiver signs for receiving; the receiver carries out disposal according to the event information or the related regulations of the emergency response level, and the disposal process is fed back to the platform publishing page in real time; and if the event is completely handled, final reporting can be carried out, and a corresponding event flow is closed. The method can replace a current one-to-one telephone notification coordination mode in hydropower station production operation event disposal, greatly improves the event disposal efficiency, reduces human error factors, and improves the event disposal accuracy and the operation management level.

An online sorting system for narrow-gauge blood collection tube transmission includes a horizontal transmission track, a slow-down track, a sorting device and a feeding reversing device, wherein the sorting device and the feeding reversing device are fixedly connected to a ceiling or a wall, and in the feeding stage, the outlet of the adjacent front horizontal transmission track is connected to the inlet of the feeding reversing device, the outlet of the feeding reversing device is connected to the inlet of the adjacent rear horizontal transmission track, and the angle between the adjacent front horizontal transmission track and the adjacent rear horizontal transmission track is a preset angle; in the sorting stage, the outlet of the adjacent front horizontal transmission track is connected to the inlet of the sorting device, and the outlet of the sorting device is respectively connected to the inlet of the adjacent rear horizontal transmission track and the receiving hopper of the slow-down track, and the angle between the adjacent front horizontal transmission track and the adjacent rear horizontal transmission track is 180 degrees. The present invention has good scalability, realizes the sorting of blood collection tubes with one input and multiple outputs on the aerial assembly line, saves ground space, and is easy to install.

The present application discloses an underwater noise processing method, device, equipment and medium. The method comprises: in response to an underwater noise processing request received in real time, converting the latitude and longitude coordinates of the noise source entity and the detection entity in the target sea area contained in the underwater noise processing request into simulated geographic grid coordinates respectively; calculating the grid standard distance corresponding to the noise source entity and the detection entity according to the simulated geographic grid coordinates; and determining the underwater noise value corresponding to the grid standard distance according to the grid standard distance. The embodiment provided by the present application maps the target entity to the simulated geographic grid, simplifies the calculation of the grid standard distance between the target entities, and then uses the grid standard distance to determine the underwater noise value corresponding thereto, avoiding multiple repeated calculations, saving a lot of calculation time, and thus improving the response speed of the system.

The invention provides a data query method and related equipment, which can be used in the field of data processing. The method comprises the following steps: acquiring a first identifier of target data requested to be queried by a query request, and acquiring a first session key between a query end and a data end; encrypting the first identifier by using the first session key to obtain a second identifier; in response to each piece of historical query data in a storage area of the query end including first data associated with the second identifier, outputting the first data as target data, the historical query data being used for indicating data corresponding to an encrypted data identifier acquired by a coordination end from a data end, and the data corresponding to the encrypted data identifier being used for indicating the coordination end; the encrypted data identifier is obtained by encrypting the identifier of the data by the query end based on the first session key. According to the method and the device, the advantages of high query data security of the query end and high data query efficiency of the query end are considered.

This application provides a method, apparatus, server, storage medium, and product for querying business data, belonging to the field of Internet technology. The method first parses the query request to obtain multiple query statements. Based on these multiple query statements, multiple data structures are generated. Based on these data structures, multiple query execution tasks are generated. Through the first and second nodes of the multiple query execution tasks, multiple data sources are queried in parallel. The multiple business sub-data obtained from the multiple data sources are summarized to obtain the business data, which is then returned to the terminal. This method can query multiple data sources in parallel based on multiple query fields, thus shortening the query time and improving query efficiency.

This application discloses a credit report generation method, system, computer equipment, and storage medium. The method includes: generating a report pre-assembly request via a first server and uploading it to a credit reporting chain; generating a set of keys and a data preparation request based on the report pre-assembly request via a second server, and obtaining a first key, a second key, and the data preparation request from them, and sending them to a third server; enabling the third server to obtain target data, encrypting the target data sequentially using the first key and the second key, and uploading it to the credit reporting chain; enabling the first server to decrypt the encrypted data based on the second key, and generating a pre-assembled report based on the decrypted data and a preset report template; enabling the first server to decrypt the decrypted data based on the first key, and generating a credit report based on the decrypted data and the pre-assembled report. This application can balance the timeliness of credit inquiries with data security.

The present invention relates to the technical field of nuclear power plant equipment monitoring, and discloses a method and system for monitoring the action of switch quantity equipment in a nuclear power plant. The method compares the action changes of all equipment within a time period, records the number of changes and the specific time of the changes, and directly assigns the traversed data to the temporary variable if the temporary variable is empty. If the temporary variable is not empty, it is determined whether the value of the temporary variable is the same as the variable value. If the value of the temporary variable is the same as the variable value, the next value is traversed. If the values ​​are different, it is determined that the data has changed, the change is input into the result of the data comparison module, and the current data is assigned to the temporary variable, and the next data is traversed. The system includes an automatic display module, a query display module, a data comparison module and a drawing association module, and the data comparison module is used to determine whether the temporary variable is empty. The present invention enables the main control operator to grasp the action of all equipment of the nuclear power unit under his jurisdiction in real time and efficiently.

The invention discloses a structured report management method and device, equipment and a storage medium. Comprising the steps of obtaining an original report file, and processing the original report file to generate structured data; establishing an index according to the structured data, and generating storage data according to the index and the structured data; and obtaining a user query request, determining target data from the storage data based on the query request, and generating a reconstruction report according to the target data. By obtaining the original report file and processing the original report file to generate the structured data, normalization and standardization of the report file are achieved, and the quality and availability of the data are improved. And the index is established according to the structured data, so that the data retrieval speed and efficiency are remarkably improved. In the face of a large amount of report data, accurate and valuable report information can be quickly provided for the user according to the query request of the user, so that the query time is saved, the user experience is enhanced, the efficiency and quality of report file management are improved, and the value and the utilization degree of the data are improved.

The present application provides a node connectivity query method, system, computer device and storage medium, which are applied to a network system built based on a graph structure, wherein the graph structure includes multiple first nodes, multiple second nodes, original graph edges between the first nodes and the second nodes, and original graph edges between the second nodes, and each node can be dynamically closed or opened. The query method includes: updating at least one maximum connected component corresponding to the graph structure before the change according to multiple XOR value sets and original graph edge sets obtained based on the changed graph structure; querying the connectivity of a pair of nodes in an open state according to the at least one maximum connected component obtained by the update. The query method of the present application can quickly update at least one maximum connected component according to the node update and quickly query whether a pair of nodes in an open state are connected according to the at least one maximum connected component after the update.

The invention provides a directed acyclic graph reachability query method and system based on a structured jump index, and the method comprises the steps: S1, carrying out the topological sorting of a directed acyclic graph G, and carrying out the calculation to obtain a depth-first search starting point; s2, starting depth-first search from all starting points in sequence, and constructing a depth-first search serial number and an index in the depth-first search process; and S3, based on the index and the depth-first search serial number, judging the accessibility between the queried source node and the queried target node. According to the directed acyclic graph reachability query method based on the structured jump index, reachability information of the directed acyclic graph can be stored through a small index, a reachability query result can be returned in a short time, and the size of an index space and query time can be conveniently adjusted and balanced.

The invention relates to the technical field of artificial intelligence, can be applied to the field of financial science and technology, and discloses a financial report data query method, device and equipment and a storage medium. Obtaining a financial report text in the current financial report data; determining an expansion word corresponding to the current financial report data based on the financial report text; inputting the financial report text and the expansion word into a preset target language model; determining a current data report based on the target language model, the expansion word and the financial report text; and executing query operation in the current data report to obtain a query result of the current financial report data. The query efficiency of the current financial report data can be improved.

The invention relates to a multi-thread SQL (Structured Query Language) query and progress tracking method and system, and the method comprises the steps that a webpage end receives a user query request, queries SQL statements from an SQL configuration table, and assembles the queried SQL statements into an SQL statement list; and allocating a thread to each SQL statement in the SQL statement list for query. After query of each thread is finished, a query result is inserted into the query result record table, and the query progress of the query record table of the user is updated. According to the method, a query function of a webpage end is established, so that business personnel can query required data at the webpage end by themselves, meanwhile, a progress system can display the query progress of multiple segments of data, and after query is completed, excel synthesized by queried results can be downloaded on a query record page. The invention provides a query progress display function and an error information display function, so that when an error occurs in the query process, a user can immediately obtain error information, and a problem can be quickly positioned and handled.

The present invention discloses a graph-based BIM data storage management method, comprising constructing a data structure based on a multi-level graph, wherein the first-level graph is used to represent the overall architecture of different projects in the BIM model, the second-level graph is used to present the structural relationship between different partitions in each project, and the third-level and lower-level graphs are used to carefully depict the entities in the partitions and their mutual relationships; a unique identifier with a timestamp and a version number is assigned to each entity in the BIM data, and the identifier is associated with detailed attribute information including geometric information, material properties, construction technology, etc. and stored; a graph algorithm, such as a graph neural network algorithm based on deep learning, is used to deeply analyze and process the complex relationships in the BIM data to achieve efficient data query, update and prediction operations; the present invention can accurately represent the complex relationships and hierarchical structures in the BIM model by constructing a multi-level graph data structure, facilitates rapid positioning and operation of data, and significantly improves the efficiency of data storage and management.

The present application relates to the technical field of computer network, and especially relates to a fast forwarding method and system of network data packet of zero-patch kernel integration. The method comprises the following steps: registering a hook function at a key node of data packet processing, obtaining a registration custom processing function, expanding a connection tracking structure in a Linux kernel connection tracking system, and adding a custom field to store a fast forwarding state; constructing a fast NAT connection table; when the data packet reaches the registration custom processing function, calculating a hash value of the data packet, searching for a corresponding connection node in the fast NAT connection table through the hash value; if the valid connection node is found, updating header information of the data packet and sending the data packet to a target interface; otherwise, marking connection tracking information and making the data packet go through a regular Netfilter processing flow. The present application can solve the performance bottleneck problem caused by the dependence of the Netfilter complete flow in the traditional Linux kernel network forwarding scheme.

The invention provides a protocol identification method and system of photovoltaic equipment, computer equipment and a storage medium. According to the method, firstly, the address where the photovoltaic equipment possibly exists is predicted to improve the query efficiency and save the query time, and the target Modbus protocol is selected from the pre-constructed Modbus protocol library to poll the predicted address to determine whether the photovoltaic equipment exists in the predicted address and whether the existing photovoltaic equipment is the target photovoltaic equipment; and under the condition that the photovoltaic equipment exists in the predicted address, the target Modbus protocol is sent to the photovoltaic equipment again, so that the type of the photovoltaic equipment is further verified, the error recognition rate is reduced, the recognition accuracy of the protocol matching process of the photovoltaic equipment is improved, and the efficiency of the whole protocol automatic recognition process is ensured.

The invention discloses a power grid enterprise supply chain purchase standard digitization system based on a knowledge graph, and relates to the technical field of digitization. A data processing layer; a knowledge extraction layer; a knowledge model layer; a knowledge management layer; a knowledge application layer; according to the invention, based on related technologies in the field of knowledge graph construction, the supply chain purchase standard knowledge graph is constructed to realize the linkage relationship of parameters between the purchase standard and the supply chain standard, so that an offline supply chain purchase standard document which cannot be directly understood by a machine is efficiently converted into a digital knowledge system; technical support is provided for supply chain purchase standard digital application, the supply chain purchase standard query time is saved, and the accuracy of supply chain purchase standard application is greatly improved.

The invention discloses an Internet of Things access authentication system capable of bidirectional authentication, which comprises a key distribution center and an authentication information monitoring unit, and is characterized in that a group of output ends of the key distribution center are wirelessly connected with Internet of Things equipment a. According to the Internet of Things access authentication system capable of bidirectional authentication, when the Internet of Things equipment a and the Internet of Things equipment b are accessed, the key distribution center sends verification information and inputs the verification information into the information integration unit for integration, so that waiting time and processing time are reduced, the verification speed is accelerated, the bidirectional authentication platform can accept the verification information, and the verification efficiency is improved. The Internet of Things equipment a and the Internet of Things equipment b establish communication after verification succeeds, the encryption communication unit can encrypt the information during communication, the dynamic firewall can adapt to dynamic address changes in a large-scale network, and the security of the Internet of Things equipment a and the Internet of Things equipment b is improved. And protection is carried out through the API protection module after dangerous information is found.

The embodiment of the invention discloses a data processing method and device, a computer, a storage medium and a program product, and relates to the technical field of computers.The method comprises the steps that a business processing request text sent by a first business object is obtained in an intelligent session page, and the business processing request text is analyzed to obtain a business processing request text; service semantic information and intention demand information are obtained; determining a business database associated with the first business object; obtaining a first target type indicated by the business semantic information, obtaining a first business data set belonging to the first target type from classified data corresponding to N business types of a business database, performing information retrieval in the first business data set, obtaining retrieval content associated with a first target component, and sending the retrieval content to the business database; and generating a service result for the service processing request text based on the intention demand information and the retrieval content, and displaying the service result in the intelligent session page. By adopting the method, the data retrieval efficiency can be improved, and the labor cost can be saved.

The invention relates to a three-party system integrated AD domain user login method and device and a storage medium, and is applied to the technical field of three-party system integrated AD domain, and the method comprises the steps: setting a local cache in a three-party system, and when an AD domain user carries out login operation, checking whether login user information exists in the local cache; if so, directly logging in by directly using the user information in the local cache; if not, executing an asynchronous processing AD domain query operation for login; according to the method, frequent AD domain query operation can be avoided by caching the AD domain user information, and the user information is directly acquired from the cache, so that the query time is greatly shortened, the login response speed is improved, meanwhile, asynchronous processing AD domain query operation is performed in a background thread, a main thread cannot be blocked, and the concurrent processing capability and stability of a system are improved.

The present application discloses a product history query method, device, equipment and medium. The method includes receiving a product query request, the product query request includes at least one product query parameter; querying a pre-created product map database according to the product query parameter to obtain product history data corresponding to the product to be queried, the product map database includes a relationship map constructed based on product entities, production entities, and relationship pairs between product entities and production entities, and the product history data is composed of production entities that have relationship pairs with the product to be queried and are obtained according to the relationship map according to time attributes. The technical solution provided by the embodiment of the present application obtains product history data by querying a pre-constructed product map database, which effectively saves the query time of product history data and improves the query efficiency of product history data.

Embodiments of the present application disclose an information determination method, which comprises the following steps: after receiving query information of a target user for a target bidding system, obtaining historical behavior information and user attribute information of the target user; based on the query information, obtaining a set of bidding information by obtaining bidding information from a plurality of bidding applications through the target bidding system; determining key bidding information from the set of bidding information; and based on the query information, the historical behavior information and the user attribute information, determining target bidding information from the key bidding information. Thus, the operation of user query screening is effectively simplified, the query time is reduced, and the query efficiency is improved. Embodiments of the present application also disclose an information determination device, equipment and computer readable storage medium.

The embodiment of the invention provides a product data extreme value query method and device, electronic equipment and a storage medium, belongs to the technical field of data processing, and is suitable for the field of financial science and technology. The method comprises the following steps: acquiring user behavior data of a target product, and acquiring timestamp data of the user behavior data; based on the timestamp data, performing interval maximum and minimum value searching on the user behavior data to obtain interval maximum and minimum value data, the interval maximum and minimum value data being used for representing maximum and minimum values of the user behavior data in a time interval formed by the timestamp data; based on the interval extreme value data, performing data filling on a preset initial user behavior array to obtain a target user behavior array; and based on a preset query time period and the target user behavior array, performing dynamic planning extreme value query on the target user behavior array. According to the embodiment of the invention, the query time of the product data extreme value can be shortened.

The invention relates to the technical field of data analysis, in particular to a real-time design interaction system which comprises a multi-source data management module, a data interaction middle table and a dynamic maintenance scheduling module. By performing classification and data processing on an original data set of a target area, a data set is obtained, a data table is created, a database is used for storage, and meanwhile, an index is established, so that original data can be converted into a high-quality data set which can be used for subsequent analysis, and the data retrieval speed is increased; data from the multi-source data management module is integrated through the data interaction platform, and integration processing is carried out, so that data exchange is carried out among different types of data; quantitative analysis is carried out according to the data exchange result, the crop growth condition is dynamically adjusted, the strategy can be quickly responded and adjusted, and the agricultural production efficiency is improved. The method is used for solving the technical problem of insufficient data integration and real-time regulation and control capability in current agricultural production management.

The invention provides a smooth aluminum cable auxiliary selection method and device, and relates to the technical field of cables, and the method comprises the steps: S1, collecting environment parameters and use demands of a cable use site, inputting the environment parameters and use demands into a cable auxiliary selection device, and verifying the data integrity; s2, determining the material requirement of each part structure of the cable and the use requirement of the cable according to the environmental parameters of the cable use site, and establishing a preliminary cable structure; s3, calculating the minimum thickness of the aluminum sheath based on the requirement of the short-circuit current; and S4, inputting the maximum allowable cable diameter of the working environment, performing adaptation with the existing cable model based on the initial cable structure and the minimum thickness of the aluminum sheath, and determining an output result based on an adaptation result. According to the method, firstly, the initial cable structure and the minimum thickness of the aluminum sheath are established according to the field environment parameters and the use requirements, and are matched with the existing cable model, so that a large amount of data query time is saved, the cable selection efficiency is greatly improved, and the result accuracy is improved through data updating.

The present application is applicable to the field of data processing, and provides a data jump display method, system, terminal and readable storage medium, wherein the method includes: based on the number of data items in the data query results that meet the query conditions, determining the page numbers of the data query results for paging display and the data identifiers of the data content displayed in the pages under each page number; obtaining a page cursor set, the page cursor set including the page cursors corresponding to each page number in the page number set determined from the data identifier, the page number set being a set that matches the window size of the page number sliding window; based on the jump page number selected by the user from the page number sliding window, determining the jump page cursor corresponding to the jump page number from the page cursor set; based on the jump page cursor, obtaining and displaying the target data content from the data query results. This solution reduces the query time of paging display and improves the efficiency of paging display.

The invention relates to a method for improving the digital reconstruction efficiency of electromechanical equipment of the Internet of Things and terminal equipment, and mainly relates to the field of data processing. According to the method, the data association operation is performed by selecting the big table association key, and the broadcast mechanism is adopted for processing when the data volume meets the condition, so that the connection calculation efficiency is effectively improved. The method comprises the following steps: performing association operation on big table data and storing a processing result; determining whether to broadcast data according to the data volume; executing a left connection operation by using the broadcast data and generating a dynamic partition mark; performing duplicate removal processing on the data; and establishing an index type adapted to the data features. And when the data volume exceeds the memory limit, a data fragmentation and partition adjustment strategy is adopted. The method is especially suitable for the field of big data processing, and can significantly improve data processing speed and system resource utilization rate.

The invention discloses an Internet of Vehicles data storage and query system and method, and the system comprises a mobile terminal which is used for receiving a query instruction and outputting a query request in response to the received query instruction; the Internet of Vehicles cloud platform is in communication connection with the mobile terminal, and the Internet of Vehicles cloud platform receives the query request through the mobile terminal; the first device is arranged at a vehicle end, the first device is in communication connection with the vehicle end bus, the first device obtains and stores a vehicle end bus signal in real time, the first device is in communication connection with the Internet of Vehicles cloud platform, the first device receives a query request through the Internet of Vehicles cloud platform, and the first device responds to the query request to judge the state of the vehicle end bus; the first device outputs a query result to the Internet of Vehicles cloud platform according to a vehicle-end bus signal stored by the first device in response to the vehicle-end bus sleep state, and the first device is connected with the second device in response to the vehicle-end bus wake-up state to obtain the query result and outputs the query result to the Internet of Vehicles cloud platform, the second equipment is vehicle-end equipment corresponding to the query request.