Effective correlation of multiple time-series result sets

1. A method of storing and time-correlating real-time and queryable test results of a test of a device under test (DUT), where the test of the DUT results in a multitude of data streams of multiple aspects of the DUT, the method comprising:

initiating the test applied to the DUT according to test configuration data to collect, among multiple databases, real-time data from the multitude of data streams for the multiple aspects of the DUT, the collected data including counters and fact-type values, the collected data having imperfectly synchronized time bases among the multiple databases and the collected data being collected from different sources asynchronously at different times;

prior to applying the test to the DUT or during the application of the test on the DUT, specifying a user configurable recording time interval for recording the data collected among the multiple databases;

recording the data collected among the multiple databases according to the specified recording time interval, such that each piece of the recorded data is associated with a respective particular time interval, which has a duration of the specified recording time interval, each piece of the recorded data being associated with the respective particular time interval in dependence upon time series information of the piece of data;

at a conclusion of the test, correlating the recorded data with the test configuration data about a test state in the respective time intervals; and

at the conclusion of the test or during the test performing a user defined query on the recorded data according to a user defined query time interval that is the same as or greater than the specified recording time interval according to which the data collected among the multiple databases is recorded,

wherein, when multiple pieces of data exist within the user defined query time interval for a particular aspect of the DUT, the user defined query on the recorded data provides a single result, per each respective time interval that is equal to the user defined query time interval for the particular aspect of the DUT, that is determined based on the multiple pieces of data that exist within the respective time interval.

2. The method of claim 1 , wherein the recorded data collected among the multiple databases is recorded into a database that implements a star schema including a fact table and a dimension table.

3. The method of claim 1 , wherein the time series information is timestamp information.

4. The method of claim 3 , wherein the recorded data is treated as dimensional if timestamps are not available.

5. The method of claim 1 , wherein the recorded data includes data-plane data and control-plane data.

6. The method of claim 1 , further comprising providing, for display in a web user interface, results of the user defined query.

7. The method of claim 1 , further comprising changing a value of the user configured recording interval from one value to another value during the test applied to the DUT.

8. A non-transitory computer-readable recording medium having a program recorded thereon, the program for storing and time-correlating real-time and queryable test results of a test of a device under test (DUT), where the test of the DUT results in a multitude of data streams of multiple aspects of the DUT, and the program, when executed on a computer, causes a processor of the computer to perform a method comprising:

initiating the test applied to the DUT according to test configuration data to collect, among multiple databases, real-time data from the multitude of data streams for the multiple aspects of the DUT, the collected data including counters and fact-type values, the collected data having imperfectly synchronized time bases among the multiple databases and the collected data being collected from different sources asynchronously at different times;

prior to applying the test to the DUT or during the application of the test on the DUT, specifying a user configurable recording time interval for recording the data collected among the multiple databases;

recording the data collected among the multiple databases according to the specified recording time interval, such that each piece of the recorded data is associated with a respective particular time interval, which has a duration of the specified recording time interval, each piece of the recorded data being associated with the respective particular time interval in dependence upon time series information of the piece of data;

at a conclusion of the test, correlating the recorded data with the test configuration data about a test state in the respective time intervals; and

at the conclusion of the test or during the test performing a user defined query on the recorded data according to a user defined query time interval that is the same as or greater than the specified recording time interval according to which the data collected among the multiple databases is stored,

wherein, when multiple pieces of data exist within the user defined query time interval for a particular aspect of the DUT, the user defined query on the recorded data provides a single result, per each respective time interval that is equal to the user defined query time interval for the particular aspect of the DUT, that is determined based on the multiple pieces of data that exist within the respective time interval.

9. The non-transitory computer-readable recording medium of claim 8 , wherein the recorded data collected among the multiple databases is recorded into a database that implements a star schema including a fact table and a dimension table.

10. The non-transitory computer-readable recording medium of claim 8 , wherein the time series information is timestamp information.

11. The non-transitory computer-readable recording medium of claim 10 , wherein the recorded data is treated as dimensional if timestamps are not available.

12. The non-transitory computer-readable recording medium of claim 8 , wherein, when multiple pieces of data exist within the user defined query time interval for a particular aspect of the DUT, the user defined query on the recorded data provides a result based on at least one of determining a sum of the multiple pieces of data, determining an average of the multiple pieces of data, identifying a maximum value of the multiple pieces of data and identifying a minimum value of the multiple pieces of data.

13. The non-transitory computer-readable recording medium of claim 8 , wherein the recorded data includes data-plane data and control-plane data.

14. The non-transitory computer-readable recording medium of claim 8 , wherein the method further comprises providing, for display in a web user interface, results of the user defined query.

15. The non-transitory computer-readable recording medium of claim 8 , wherein the method further comprises changing a value of the user configured recording interval from one value to another value during the test applied to the DUT.

16. A system including one or more processors coupled to memory, the memory loaded with computer instructions to store and time-correlate real-time and queryable test results of a test of a device under test (DUT), where the test of the DUT results in a multitude of data streams of multiple aspects of the DUT, the instructions, when executed on the processors, implement actions comprising:

initiating the test applied to the DUT according to test configuration data to collect, among multiple databases, real-time data from the multitude of data streams for the multiple aspects of the DUT, the collected data including counters and fact-type values, the collected data having imperfectly synchronized time bases among the multiple databases and the collected data being collected from different sources asynchronously at different times;

prior to applying the test to the DUT or during the application of the test on the DUT, specifying a user configurable recording time interval for recording the data collected among the multiple databases;

recording the data collected among the multiple databases according to the specified recording time interval, such that each piece of the recorded data is associated with a respective particular time interval, which has a duration of the specified recording time interval, each piece of the recorded data being associated with the respective particular time interval in dependence upon time series information of the piece of data;

at a conclusion of the test, correlating the recorded data with the test configuration data about a test state in the respective time intervals; and

at the conclusion of the test or during the test performing a user defined query on the recorded data according to a user defined query time interval that is the same as or greater than the specified recording time interval according to which the data collected among the multiple databases is recorded,

wherein, when multiple pieces of data exist within the user defined query time interval for a particular aspect of the DUT, the user defined query on the recorded data provides a single result, per each respective time interval that is equal to the user defined query time interval for the particular aspect of the DUT, that is determined based on the multiple pieces of data that exist within the respective time interval.