PREDICTING SCALE OF DATA MIGRATION BETWEEN PRODUCTION AND ARCHIVE STORAGE SYSTEMS, SUCH AS FOR ENTERPRISE CUSTOMERS HAVING LARGE AND/OR NUMEROUS FILES

摘要

This application discloses a system for presenting data to a user based on requests to move data from primary storage to secondary storage. The system receives a request to move data that satisfies at least one criterion, from primary to secondary data storage. The system then identifies an initial database query from the request, and further builds a nested database query from the initial database query according to a database schema. Next, the system estimates a size of a result of executing the nested database query. Finally, the system provides for display to the user the estimated size.

主权项

1. A computer-implemented method of predicting an amount of data storage needed when moving data from primary data storage to secondary or archive data storage, the method comprising:
receiving, at a client computing device, a request to move data that satisfies at least one criterion,
wherein the moving of data is from a primary data storage system to a secondary data storage system, andwherein the at least one criterion is related to the age or the size of data; providing an initial database query based on the request,
wherein the initial database query is related to an initial table in the database; building a nested database query from the initial database query according to a database schema,
wherein building the nested database query includes determining additional tables linked to the initial table; predicting a size of data that will be returned as a result of executing the nested database query; and providing the predicted size before moving the data from the primary data storage system to the secondary data storage system.