Database storage optimization method and system, electronic device and storage medium

By acquiring database instance information and utilizing machine learning prediction models, the database storage strategy is automatically optimized, solving the problems of high storage costs and low tuning efficiency in existing technologies, and achieving cost reduction and efficiency improvement.

CN116361265BActive Publication Date: 2026-07-07ALIBABA CLOUD COMPUTING CO LTD
1 Cites 0 Cited by

Patent Information

Application Number
CN202310223086.3
Authority / Receiving Office
CN · China
Patent Type
Patents(China)
Current Assignee / Owner
Filing Date
2023-03-03
Publication Date
2026-07-07
Estimated Expiration
2043-03-03

AI Technical Summary

Technical Problem

Existing technologies such as solid-state drive hot storage and full indexing result in high storage costs and total cost of ownership in databases. Furthermore, it is difficult for database administrators to effectively identify unaccessed database table objects, leading to increased labor costs and low optimization efficiency.

Method used

By obtaining instance information of the database instance, the machine learning prediction model is used to predict the probability of future access to database table objects. Based on the prediction results, the expected optimization benefits are determined, and optimization suggestions are automatically output. These suggestions include moving unaccessed database table objects from hot storage to cold storage or deleting indexes, thus achieving automatic tuning.

Benefits of technology

It reduces storage costs, lowers total cost of ownership, improves tuning efficiency, saves on labor costs, and eliminates the need to rely on a database administrator.

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

Abstract

The application provides a database storage optimization method, system, electronic equipment and storage medium. The database storage optimization method comprises: obtaining instance information of a database instance; determining expected optimization benefits of a library table object in the database instance according to the instance information; the expected optimization benefits are expected benefits brought by application of optimization suggestions for a storage strategy of the library table object; outputting corresponding optimization suggestion information to the database instance according to the expected optimization benefits; and the optimization suggestion information is used for suggesting optimization of the storage strategy of the library table object. According to the embodiment of the application, better optimization suggestion information can be given to reduce the storage cost and total cost of ownership of the user.
Need to check novelty before this filing date? Find Prior Art