Predicting scale of data migration between production and archive storage systems, such as for enterprise customers having large and/or numerous files
First Claim
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 age or size of data;
providing an initial database query based on the request,wherein the initial database query is related to an initial table in an initial 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.
2 Assignments
0 Petitions
Accused Products
Abstract
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.
370 Citations
20 Claims
-
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, and wherein the at least one criterion is related to age or size of data; providing an initial database query based on the request, wherein the initial database query is related to an initial table in an initial 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. - View Dependent Claims (2, 3, 4, 5, 6, 7)
-
-
8. At least one non-transitory, computer-readable medium carrying, instructions, which when executed by at least one data processor, performs a method of presenting data to a user based on requests to move data from primary storage to secondary storage, comprising:
-
receiving, from a client computing device, a request from a user to move data that satisfies a criterion, from a primary storage system to a secondary storage system; identifying an initial database query from the request, wherein the initial database query is related to an initial table in the initial 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; estimating a size of a result of executing the nested database query; and providing the estimated size to be displayed to the user. - View Dependent Claims (9, 10, 11, 12, 13, 14, 15)
-
-
16. A system configured to present data to a user related to requests to move data from primary storage to secondary storage, the system comprising:
-
at least one processor; at least one memory coupled to the processor and storing instructions for execution by the processor, wherein the instructions encode a method comprising; receiving a request from a user to move data that satisfies a criterion from a primary storage system to a secondary storage system; providing the request to a remote computing device to provide an estimated size of data to be moved, wherein the remote computing device identifies an initial database query from the request,
wherein the initial database query is related to an initial table in an initial database;builds a database query from the initial database query according to a database schema, wherein building the database query includes determining additional tables linked to the initial table, and estimates a size of a result of executing the database query; receiving from the remote computing device, the estimated size; and providing for display to the user the estimated size. - View Dependent Claims (17, 18, 19, 20)
-
Specification