Intelligent data simulator for performance testing
AssigneeDell Products L.P.
InventorsShibi Panikkar, Pratheek Veluswamy
Life of this patent
Estimating the term…
Abstract
An apparatus comprises at least one processing device comprising a processor coupled to a memory. The at least one processing device is configured to simulate a first data set stored in a first database to create a second data set, wherein the second data set maintains one or more query impacting characteristics of the first data set such that performing a query on the second data set yields a performance result similar to another performance result that would occur when the query is performed on the first data set. The at least one processing device is further configured to load the second data set into a second database, and then perform the query on the second data set stored in the second database to obtain the performance result.
Claims20
An apparatus comprising:
- at least one processor and at least one memory storing computer program instructions wherein, when the at least one processor executes the computer program instructions, the apparatus is configured to:
- obtain one or more query impacting characteristics, the one or more query impacting characteristics comprising a behavioral data set obtained from a first data set stored in a first database and a data structure parameter data set obtained from a second database, the data structure parameter data set comprising one or more partition types and one or more index types;
- simulate the first data set stored in the first database to create a second data set stored in the second database, wherein the second data set maintains the one or more query impacting characteristics of the first data set, wherein performing a query on the second data set yields a performance result similar to another performance result that would occur when the query is performed on the first data set, and wherein a second query response time for performing the query on the second data set is equal to a first query response time for performing the query on the first data set;
- load the second data set into the second database;
- and
- perform the query on the second data set stored in the second database to obtain the performance result.
(canceled)
A computer program product comprising a non-transitory processor-readable storage medium having stored therein program code of one or more software programs, wherein the program code when executed by at least one processing device causes the at least one processing device to:
- obtain one or more query impacting characteristics, the one or more query impacting characteristics comprising a behavioral data set obtained from a first data set stored in a first database and a data structure parameter data set obtained from a second database, the data structure parameter data set comprising one or more partition types and one or more index types;
- simulate the first data set stored in the first database to create a second data set stored in the second database, wherein the second data set maintains the one or more query impacting characteristics of the first data set, wherein performing a query on the second data set yields a performance result similar to another performance result that would occur when the query is performed on the first data set, and wherein a second query response time for performing the query on the second data set is equal to a first query response time for performing the query on the first data set;
- load the second data set into the second database;
- and
- perform the query on the second data set stored in the second database to obtain the performance result.
(canceled)
A method comprising:
- obtaining one or more query impacting characteristics, the one or more query impacting characteristics comprising a behavioral data set obtained from a first data set stored in a first database and a data structure parameter data set obtained from a second database, the data structure parameter data set comprising one or more partition types and one or more index types;
- simulating the first data set stored in the first database to create a second data set stored in the second database, wherein the second data set maintains the one or more query impacting characteristics of the first data set, wherein performing a query on the second data set yields a performance result similar to another performance result that would occur when the query is performed on the first data set, and wherein a second query response time for performing the query on the second data set is equal to a first query response time for performing the query on the first data set;
- loading the second data set into the second database;
- and
- performing the query on the second data set stored in the second database to obtain the performance result;
- wherein the method is performed by at least one processing device comprising a processor coupled to a memory.
Dependencies are inferred from the claim text.