An index rebuilding method for a virtual asset security system

Abstract

The invention belongs to the field of index rebuilding, and discloses an index rebuilding method of a fictitious asset preservation system. The method comprises the following steps of: (1) database log processing: analyzing a database operation log in the fictitious asset preservation system, counting the number of inquired times of each attribute value in a database, and calculating an inquiry hit rate of indexes; (2) index use condition analysis: counting the index item number and the bit item number of each attribute column, and calculating the index use rate; (3) index efficiency evaluation: setting the inquiry hit rate and the index use rate as measuring indexes, and evaluating the current index affiliation condition according to the inquiry hit rate and the index use rate; and (4) index rebuilding: according to the affiliation condition of the index efficiency evaluation in the third step, adding or deleting the indexes of the attribute columns to rebuild the indexes. The index rebuilding method provided by the invention by aiming at the fictitious asset preservation system has the advantages the space utilization rate of the rebuilt indexes is high, and the inquiry response time can be reduced.

Description

technical field [0001] The invention belongs to the field of index rebuilding, and in particular relates to an index rebuilding method of a virtual asset preservation system, which is used to solve the index rebuilding problem in the virtual asset preservation system. Background technique [0002] Virtual assets refer to competitive, persistent and exchangeable or tradeable items in the online world, including online banking, online account numbers, online game equipment and weapons, virtual currency, etc. [0003] At present, my country has carried out research on eID-based virtual asset management and preservation technology in cyberspace to achieve standardized and unified management of virtual assets. Massive multi-structure virtual asset data has a large amount of data and is growing rapidly. How to efficiently access it is an urgent problem that needs to be solved. Using Cassandra distributed database is a feasible solution, but according to the data storage structure...

AI Technical Summary

Problems solved by technology

However, the establishment of its secondary index is subjective to a certain extent, and once established, it will not be adjusted according to changes in the database. As time goes by, it will lead to excessive index maintenance costs and gradually reduce index efficiency.

Images