Database abnormal key identification method, device and data system

Abstract

The invention provides an abnormal key recognition method of a database, an abnormal key recognition device of the database and a data system. The abnormal key recognition method of the database comprises: a step of obtaining data types of key values in the database to be analyzed and determining characteristic data information needed for data comparison of the data types; a step of scanning the database to be analyzed to determine the data type of the key value of each key in the database to be analyzed and to determine the characteristic data corresponding to the data type of the key value; and a step of recognizing the abnormal key by using a preset rule according to the characteristic data information, the data type of each key and the corresponding characteristic data. According to the technical scheme of the invention, the method is especially applicable to Redis database, and the analysis efficiency is significantly improved; the memory using situation of the database can be directly reflected, so that the data can be further analyzed and processed.

Description

technical field [0001] The invention relates to the technical field of data processing, in particular to a database abnormal key identification method device and data system. Background technique [0002] Database (Database) is a data processing system that organizes, stores and manages data according to the data structure. With the development of the Internet, the application of database is more extensive, and its performance requirements are getting higher and higher. At present, the database system must have high transaction processing speed and application reliability. [0003] In actual use, due to application errors or inappropriate use, the database will occupy too many hardware resources, and because the current available data is stored in the database, all data cannot be cleaned up. At this time, the release of memory resources needs to analyze the data stored in the database and determine the abnormal data before cleaning. [0004] Especially for memory-based dat...

AI Technical Summary

Problems solved by technology

[0004] Especially for memory-based databases such as Redis, where data is stored in memory, invalid data (such as garbage data, useless data, expired data, etc.) will consume a large amount of memory, greatly increasing hardware costs

However, there is a lack of invalid data analysis tools for memory-based databases similar to Redis in the prior art, which brings great inconvenience to database developers, and causes the hardware cost of the database to increase and the application reliability to decrease.

Images