Database management method, device, electronic device and readable storage medium

By acquiring basic statistical information of data tables, processing regular rules and counting table rows for the database, the problem of enterprises lacking database management strategies is solved, and the classification, grading and management of database data is realized, and security and privacy protection is improved.

CN114996273BActive Publication Date: 2025-03-28CHINA TELECOM CORP LTD
2 Cites 0 Cited by

Patent Information

Application Number
CN202210661269.9
Authority / Receiving Office
CN · China
Patent Type
Patents(China)
Current Assignee / Owner
Filing Date
2022-06-13
Publication Date
2025-03-28
Estimated Expiration
2042-06-13

AI Technical Summary

Technical Problem

Enterprises, especially large enterprises, lack management strategies when using databases, resulting in a large number of garbage tables, super large tables manufactured by individual businesses, and detection and protection of sensitive data information after business changes.

Method used

Provide a database management method, by obtaining the database data table and basic statistical information, processing the table fields according to the preset regular rules and table field types, obtaining classification information and grading information, and counting the exact number of rows of the table to generate the current scan result.

Benefits of technology

It realizes the classification, grading and management of database data, and can promptly discover sensitive data stored in the database, improve intranet security and protect user privacy.

✦ Generated by Eureka AI based on patent content.
Patent Text Reader

Abstract

The embodiment of the present invention provides a database management method, device, electronic device and readable storage medium, the method comprising: obtaining a data table and basic statistical information of the data table in a database to be scanned; processing the table fields in the data table according to preset regular rules and table field types to obtain classification information and grading information; if the statistical time of the precise number of rows in the table exceeds the preset number of rows operation time, then stop counting the precise number of rows in the data table, and use the basic statistical information, classification information and grading information as the current scanning result of the data table; if the statistical time of the precise number of rows in the table does not exceed the preset number of rows operation time and the precise number of rows in the data table is obtained at the end of the statistics, then replace the fuzzy number of rows in the basic statistical information with the precise number of rows in the table, and use the replaced basic statistical information, classification information and grading information as the current scanning result of the data table. The embodiment of the present invention realizes the management of database data.
Need to check novelty before this filing date? Find Prior Art