15results about How to "Speed up query" patented technology

The invention provides a method, system and equipment for querying asset depreciation data and a medium, and the method comprises the steps: creating a depreciation data table corresponding to a year according to the year, and storing the depreciation data of assets over the years in the corresponding depreciation data table; compressing the depreciation data of the assets over the years; carrying out depreciation data partitioning on the database by taking the financial division as a partitioning key; establishing data query entries over the years, and querying the asset depreciation data in the database by calling the query entries of the corresponding years; according to the method, the problem that a user cannot obtain a response in a reasonable corresponding time when querying reports such as general ledger or unit depreciation details or performing counting and depreciation operation is solved, and the speed of querying and updating asset depreciation data is increased.

A digital archive data management system comprises a user terminal, a server, a data acquisition module, an authority distribution module, an access identification module, an access sorting module, an access tracking module and a cloud database. According to the digital archive data management system, through registration and login, accurate tracking and identification of identities are ensured, responsibility state information of visitors is collected, visit values are obtained through quantitative assignment processing, permission range type levels are matched according to the visit values, and visitors can only access data in an authorized range; then the access state of the digital archive file is intelligently analyzed, abnormity is monitored in real time, an access limiting instruction is triggered, a target access person is optimally selected in combination with multi-dimensional data, meanwhile, the access behavior state of the access person can be monitored in real time, the digital archive file is pushed in a personalized mode, the safety of the digital archive file is guaranteed, and the user experience is improved. And furthermore, the query and calling efficiency of the visitors is improved, and the use experience of the user is optimized.

The application discloses a system and method for accelerating reading compressed files based on A Virtual File System, and belongs to the technical field of time series databases; the technical problem to be solved by the application is how to realize column format compressed storage and reading of time series data types, reduce IO, memory and CPU consumption caused by decompression, and improve the ability of the system to process time series data; the technical scheme adopted is as follows: in the time series engine of the open database ZNBase, an execution engine generates an execution plan according to SQL semantic analysis, calls a storage layer interface of ZNBase, and queries accurate time series history partition compressed data; the storage layer completes fast execution of the query in the storage layer based on various compressed query interfaces provided by AVFS, and accelerates the query of the database; the specific steps are as follows: pre-analysis; compressed file pre-reading; reading compressed data.

The embodiment of the invention provides a visual chart updating method and device, electronic equipment and a storage medium, and belongs to the technical field of financial science and technology. The method comprises the following steps: acquiring an original visual chart of an original sliding component of which report data is provided with a configuration label; obtaining historical query time information of the report data, and performing label configuration on the original sliding component according to the historical query time information to obtain a preliminary sliding component; performing color configuration on the preliminary sliding component according to the color configuration parameter to obtain a candidate sliding component; wherein the candidate sliding component comprises a historical interval label; obtaining mark style information of the current query interval; performing label attribute configuration on the candidate sliding component according to the mark style information, the color configuration parameter and the historical interval label to obtain a target sliding component; and updating the original visual chart according to the target sliding component to obtain a target visual chart. According to the embodiment of the invention, multiple data query or export operations of the visual chart can be simplified.

The application discloses a planning processing method and system for pre-aggregation calculation of a time series database, belongs to the technical field of time series databases, and aims to solve the technical problem of how to quickly query the aggregation calculation results of each collection point. The method comprises the following steps: obtaining a pre-aggregation calculation statement input by a user; calling a logical execution plan generation interface of a parser to analyze the pre-aggregation calculation statement, analyzing the pre-aggregation calculation statement into a corresponding logical plan, and analyzing the result type of the aggregation rule of the pre-aggregation calculation statement; creating a result table according to the obtained result type, wherein the result table is used for storing the aggregation calculation results; calling an execution plan generation interface of the parser to generate a general execution plan based on the logical plan; clipping the execution plan to obtain a clipped execution plan; and matching the clipped execution plan with the result table and executing the result table.

The invention discloses a data display method and system based on multi-source data fusion, and relates to the technical field of big data. When the system runs, data feature extraction is carried out on access information of a user through a log extraction module, and a data type log information group is formed; performing type classification marking, quantity marking and data state information marking on the data type log information group through a data type marking module to obtain a data marking information group, and processing through a type level extraction module to form a first data set, a second data set and a third data set; a data cache index module analyzes and obtains a data type processing index Clzs, a data cache index is obtained after matching, an evaluation scheme is established, specific execution is carried out according to the content of the scheme, the user query access rate is dynamically evaluated, the resource utilization rate is improved for data display, and the user experience is improved. And the multi-source data fusion display effect can be displayed more effectively and quickly.

The invention discloses a Spring and Mybatis-based self-defined table division strategy according to a service code, and relates to the technical field of relational number libraries, the strategy comprises a table division client and a table division server, the table division client comprises a CodeShard Aop table division section, a CodeShard Interceptor table division interceptor and a CodeTableShard table division context; and the sub-table server side comprises a code-hard-service sub-table service, and the sub-table server side comprises a code-hard-service sub-table service. According to the method, table division is carried out according to the service code, tables which are related to the code and need to be subjected to table division are uniformly partitioned, which sub-table the data exists can be self-defined, the table division condition of the data can be dynamically adjusted, the data related to the service code can be locked in the adjusting process, in addition, the database division condition is supported, the data are dispersed into a plurality of tables, and the table division efficiency is improved. The data volume of a single table is reduced, so that the data query and operation performance is improved, the index of the database can be more effectively utilized, the index efficiency is improved, and the data retrieval speed is increased.

The invention relates to a transaction authentication method, device, equipment, system and storage medium, and the method comprises the steps: setting a plurality of data storage tables in a business module, dividing and storing member data through the plurality of data storage tables, carrying out the Hash calculation of first member data contained in a transaction request after the transaction request is received, and carrying out the Hash calculation of second member data contained in the transaction request; the method comprises the steps of obtaining first member data, obtaining a first hash value corresponding to the first member data, determining a first target data storage table corresponding to the first hash value from a plurality of data storage tables according to a mapping relation between the hash value and the data storage tables, and querying the first member data in the first target data storage table. And the transaction request is authenticated according to the query result. According to the embodiment of the invention, after the transaction request is received, query can be carried out from the corresponding data storage table according to the hash value of the first member data without querying all member data in the business module, so that the efficiency of member data query and transaction authentication is improved.

The utility model discloses a buoy edge computing voice service system, which relates to the technical field of voice processing and communication and comprises a box body, a power supply, a transformer and a loudspeaker which are arranged on a buoy. An edge calculation module, a VHF voice communication module and a 4G internet access module are arranged in the box body; the VHF voice communication module is connected with a power supply through a transformer, the VHF voice communication module is connected with a tweeter, and the VHF voice communication module is connected with an edge calculation module through a network cable; the edge calculation module is also connected with the power supply and the 4G internet access module; and the 4G internet access module is connected with the cloud server. According to the utility model, the key technical problems of real-time voice processing, voice recognition, information inquiry, data interconnection and the like of a communication system in marine navigation are solved, so that the functions of real-time processing, voice recognition and answering of voice input of sailors are realized, and the capability of inquiring channel information such as water level and the like is also realized.

The present invention belongs to the field of communication voice technology, and discloses a Q.921 link test method, system and storage medium. When the present invention tests the Q.921 link, the ISDN protocol stack uses a Q.921 entity as both the user side and the network side based on the local loopback function of the E1 port, establishes a Q.921 link inside the E1 port, obtains the Q.921 link status information and reports it to the IUA protocol stack, and the IUA protocol stack queries the Q.921 link status and feeds back to the NGN platform. The present invention can determine whether the integrated digital access gateway can work normally based on the Q.921 link status without connecting the E1 line or other equipment, thereby reducing the workload and time cost of equipment installation and cutover. The present invention writes the Q.921 link status into a table, and the IUA protocol stack directly queries the table to obtain the Q.921 link status after receiving the link query message, which can reduce the system response time and improve the link test efficiency.

The application discloses a kind of graph data heterogenous layered storage structure and method based on persistent memory, the application uses layered hash table heterogenous storage structure, stores the equivalent query data structure in topology data and index data in graph data, simultaneously using a layered storage B+Tree storage structure, stores the range query data structure in index data, solves the problem of query speed and limited memory space, simultaneously by converting the random write of persistent memory into sequential write, reduce write delay, by constructing the architecture of layered storage, reduce the write times of data structure in persistent memory, improve query efficiency.

The invention relates to a project debugging method, device and system, computer equipment, a storage medium and a computer program product. The method comprises the following steps: receiving business demand information of a to-be-debugged project sent by a local server; configuring an interface corresponding to the business demand information, and generating an interface document corresponding to the interface; the interface document is used for recording a corresponding relationship between a request parameter of the business demand information and a response data result; receiving a target request parameter which is sent by the local server and is associated with the to-be-debugged item; querying the corresponding relationship recorded in the interface document according to the target request parameter to obtain a target response data result corresponding to the target request parameter; and sending the target response data result to the local server, so that the local server performs corresponding debugging processing on the to-be-debugged item according to the target response data result. By adopting the method, the project debugging efficiency can be improved.

The invention provides a distributed cluster data backup method, which is applied to a distributed cluster data backup system, the distributed cluster data backup system comprises a distributed cluster, a client and a server, the client is a node in the distributed cluster, and the distributed cluster data backup method is characterized in that the client is a node in the distributed cluster. The method comprises the following steps: the client receives a backup instruction sent by the server; the client side inquires metadata of data to be backed up according to the backup instruction, the metadata is stored in the client side, and the metadata comprises position information of the data to be backed up; the client reads the data to be backed up from a distributed cluster according to the metadata; and the client sends the data to be backed up to the server through a high-speed serial bus, and the server receives and stores the data to be backed up.

The present invention discloses a database encryption query processing method and a confidential computing coprocessor. The method comprises: obtaining a connection establishment request from a client through a host machine, determining a user role and an encryption key used for interaction with the client according to the connection establishment request; obtaining encrypted query information from the client through the host machine, obtaining decrypted query information according to the encryption key and the encrypted query information; obtaining a database execution result of a local database according to the user role and the decrypted query information; generating an encrypted execution result according to the encryption key and the database execution result, and sending the encrypted execution result to the client through the host machine. The database of the present invention stores non-confidential data, the carrier of the database cannot be connected to the Internet, and the communication between the client and the database needs to be forwarded via the host machine. The communication between the carrier of the database, the host machine and the client is fully encrypted, which can accelerate the query while protecting the confidentiality of the data.

The invention discloses a method and system for reducing storage synchronization delay of a cloud edge object storage system, and belongs to the field of object storage, and the method comprises the following steps: abstracting a newly-added SSD supporting a ZNS standard and an original cloud edge object storage system into an integral system, and receiving a request from an upper layer; when a synchronous file adding request is received, the sum of the file size and the size of the used space of the added SSD and the utilization rate eta of the original cloud edge object storage system are calculated, and if any one of (a)-(c) is met, a memory used for storing the file is determined to be the added SSD; the method comprises the following steps: (a) a sum size; the method comprises the following steps of: performing defsize; (b) Desize is smaller than or equal to sum size; maxsize and [eta] gt; hdduti is carried out; (c), max size is smaller than or equal to sum size; ssdsize and [eta] gt; hdduti is carried out; and when (c) is satisfied, the newly-added SSD does not accept the write request any more until the used space is smaller than the maxsize. According to the method, the storage architecture and the request processing mode of the cloud edge object storage system can be improved, and the file synchronization delay is reduced.