IP Library Granted Patent US 7,783,510
Granted Patent B1
US 7,783,510 · App. 11/823,108 · Granted Aug 24, 2010

Computer storage capacity forecasting system using cluster-based seasonality analysis

View Patent ↗
Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US 7,783,510
App. No.
11/823,108
Granted
Aug 24, 2010
Kind
B1
Abstract

A methodology for automatic a priori data pattern analysis is provided. Described methods allow consistent and objective determination of outliers; trend; seasonality; and level shifts; and the production of better models and more accurate forecasts. In addition, a two-step way to automatically determine seasonality and locate possible events in the data set is described. Decomposition of data into seasonal, trend and level components; detection of outliers and level-shift events in the time series based on statistical analysis of the time series; detection of seasonality based on statistical analysis of clusters of data, known as cluster-based seasonality analysis, or CBSA; evaluation of the goodness of fit of a model to data, using the existing goodness of fit indicator, R 2 ; and seasonality analysis, using a sequence of cluster-based seasonality analysis (CBSA) and Fourier analysis are described.

Claims (47)

1. A system for generating a forecasting model for storage capacity planning, the system comprising:

a computer system comprising computer hardware, the computer system programmed to implement:

a data pattern analysis engine configured to:

receive time series data reflecting computer storage capacity;

identify a trend in the received time series data, using the received data, said identifying the trend comprising performing a transform of the time series data to derive a parameter, using the parameter to calculate a goodness-of-fit for a selected trend, and selecting the trend based at least partly on the calculated goodness-of-fit;

perform cluster-based seasonality analysis to identify seasonality in the received time series data, said performing comprising analyzing intervals between consecutive events to detect the seasonality; and

a forecast engine configured to select a forecast model adapted to predict an amount of additional computer storage capacity to obtain in the future and when to obtain the additional computer storage capacity, the forecast model operative to select the forecast model based at least partly on the identified trend and seasonality.

2. The system of claim 1 , wherein the data pattern analysis engine is further configured to perform the cluster-based seasonality analysis by at least grouping data points in said intervals into clusters.

3. The system of claim 2 , wherein the data pattern analysis engine is further configured to perform the cluster-based seasonality analysis by at least determining sizes of the clusters and determining whether a distribution of the cluster sizes approximately corresponds to a Poisson probability distribution.

4. The system of claim 3 , wherein the data pattern analysis engine is further configured to, in response to determining that the distribution does not approximately correspond to the Poisson probability distribution, perform Fourier analysis to identify the seasonality in the time series data.

5. The system of claim 3 , wherein the data pattern analysis engine is further configured to perform a Chi-square test to analyze the distribution's goodness of fit with the Poisson probability distribution.

6. The system of claim 1 , wherein identifying the outlier points comprises calculating a standard deviation and running mean of the time series data, determining whether any data point is within a number of standard deviations from the running mean, and considering each data point that is greater than the number of standard deviations of the running mean to be an outlier point.

7. A method for detecting seasonality in time series data, the method comprising:

by a computer system comprising computer hardware:

receiving time series data reflecting computer storage capacity;

identifying a plurality of events in the time series data, the events comprising one or more of outlier points and level shifts;

performing an interpolation of the outlier points by at least substituting a value of each outlier point with a value calculated using linear interpolation;

identifying a trend in the received time series data;

performing cluster-based seasonality analysis to identify a first seasonality in the received time series data, said performing comprising analyzing intervals between consecutive events to detect clusters of data points and analyzing the clusters to identify the first seasonality; and

generating a forecast model based at least in part on the identified trend and first seasonality, the forecast model adapted to predict an amount of additional computer storage capacity to obtain in the future and when to obtain the additional computer storage capacity.

8. The method of claim 7 , further comprising performing Fourier analysis to identify a second seasonality.

9. The method of claim 8 , using one of the first and second seasonalities to select a forecast model.

10. The method of claim 8 , using both the first and second seasonalities to select a forecast model.

11. The method of claim 7 , wherein identifying the outlier points comprises:

calculating a standard deviation and running mean of the time series data,

performing a T-test to determine whether any data point is within a number of standard deviations from the running mean, and

considering each data point that is greater than the number of standard deviations of the running mean to be an outlier point.

12. The method of claim 7 , wherein said identifying the trend comprises:

performing a Fisher transform of the time series data to derive a parameter,

using the parameter to calculate a goodness-of-fit for a selected trend, and

selecting the trend based at least partly on the calculated goodness-of-fit.

13. A method for data forecasting, the method comprising:

by a computer system comprising computer hardware:

receiving time series data reflecting computer storage capacity; and

generating a forecasting model from the time series data, the forecasting model adapted to predict an amount of additional computer storage capacity to obtain in the future and when to obtain the additional computer storage capacity, said generating the forecasting model comprising:

identifying a plurality of events in the time series data, the events comprising outlier points, wherein identifying the outlier points comprises calculating a standard deviation and running mean of the time series data, determining whether any data point is within a number of standard deviations from the running mean, and considering each data point that is greater than the number of standard deviations of the running mean to be an outlier point;

performing an interpolation of the set of outlier points by at least substituting a value of each outlier point with a value calculated using linear interpolation;

identifying a trend in the received time series data, using the received data and the interpolation, said identifying the trend comprising performing a transform of the time series data to derive a parameter, using the parameter to calculate a goodness-of-fit for a selected trend, and selecting the trend based at least partly on the calculated goodness-of-fit;

performing cluster-based seasonality analysis to identify seasonality in the received time series data, said performing comprising analyzing intervals between consecutive events to detect the seasonality; and

creating the forecasting model based at least in part on the identified trend and seasonality.

14. The method of claim 13 , wherein the events further comprise level shifts.

15. The method of claim 14 , wherein said identifying the events further comprises detecting the level shifts from rate-of-change information derived from the time series data.

16. The method of claim 13 , wherein said performing the cluster-based seasonality analysis further comprises grouping data points in said intervals into clusters.

17. The method of claim 16 , wherein said performing the cluster-based seasonality analysis further comprises determining sizes of the clusters and determining whether a distribution of the cluster sizes approximately corresponds to a Poisson probability distribution.

18. The method of claim 16 , further comprising, in response to determining that the distribution does not approximately correspond to the Poisson probability distribution, performing Fourier analysis to identify the seasonality in the time series data.

19. The method of claim 17 , further comprising performing a Chi-square test to analyze the distribution's goodness of fit with the Poisson probability distribution.

20. The method of claim 18 , further comprising de-trending the time series data prior to performing the Fourier analysis.

Assignments (31)
RELEASE OF SECURITY INTEREST Recorded Nov 19, 2025
From: MORGAN STANLEY SENIOR FUNDING, INC.
To: QUEST SOFTWARE INC.; ANALYTIX DATA SERVICES INC.; BINARYTREE.COM LLC; ERWIN, INC.
Reel/Frame 073606/0001 →
RELEASE OF SECURITY INTEREST Recorded Nov 18, 2025
From: GOLDMAN SACHS BANK USA, AS COLLATERAL AGENT
To: QUEST SOFTWARE INC.; ANALYTIX DATA SERVICES INC.; BINARYTREE.COM LLC; ERWIN, INC.
Reel/Frame 073613/0326 →
SECURITY INTEREST Recorded Jun 8, 2025
From: QUEST SOFTWARE INC.; ANALYTIX DATA SERVICES INC.; ERWIN, INC.
To: ALTER DOMUS (US) LLC
Reel/Frame 071527/0649 →
SECURITY INTEREST Recorded Jun 8, 2025
From: QUEST SOFTWARE INC.; ANALYTIX DATA SERVICES INC.; ERWIN, INC.
To: ALTER DOMUS (US) LLC
Reel/Frame 071527/0001 →
RELEASE OF FIRST LIEN SECURITY INTEREST IN PATENTS Recorded Feb 2, 2022
From: CREDIT SUISSE AG, CAYMAN ISLANDS BRANCH, AS COLLATERAL AGENT
To: QUEST SOFTWARE INC.
Reel/Frame 059105/0479 →
FIRST LIEN INTELLECTUAL PROPERTY SECURITY AGREEMENT Recorded Feb 2, 2022
From: QUEST SOFTWARE INC.; ANALYTIX DATA SERVICES INC.; BINARYTREE.COM LLC; ERWIN, INC.; ONE IDENTITY LLC; ONELOGIN, INC.; ONE IDENTITY SOFTWARE INTERNATIONAL DESIGNATED ACTIVITY COMPANY
To: GOLDMAN SACHS BANK USA
Reel/Frame 058945/0778 →
SECOND LIEN INTELLECTUAL PROPERTY SECURITY AGREEMENT Recorded Feb 2, 2022
From: QUEST SOFTWARE INC.; ANALYTIX DATA SERVICES INC.; BINARYTREE.COM LLC; ERWIN, INC.; ONE IDENTITY LLC; ONELOGIN, INC.; ONE IDENTITY SOFTWARE INTERNATIONAL DESIGNATED ACTIVITY COMPANY
To: MORGAN STANLEY SENIOR FUNDING, INC.
Reel/Frame 058952/0279 →
RELEASE OF SECOND LIEN SECURITY INTEREST IN PATENTS Recorded Feb 2, 2022
From: CREDIT SUISSE AG, CAYMAN ISLANDS BRANCH, AS COLLATERAL AGENT
To: QUEST SOFTWARE INC.
Reel/Frame 059096/0683 →
FIRST LIEN PATENT SECURITY AGREEMENT Recorded Jun 7, 2018
From: QUEST SOFTWARE INC.
To: CREDIT SUISSE AG, CAYMAN ISLANDS BRANCH, AS COLLATERAL AGENT
Reel/Frame 046327/0347 →
SECOND LIEN PATENT SECURITY AGREEMENT Recorded Jun 7, 2018
From: QUEST SOFTWARE INC.
To: CREDIT SUISSE AG, CAYMAN ISLANDS BRANCH, AS COLLATERAL AGENT
Reel/Frame 046327/0486 →
RELEASE OF FIRST LIEN SECURITY INTEREST IN PATENTS RECORDED AT R/F 040581/0850 Recorded May 22, 2018
From: CREDIT SUISSE AG, CAYMAN ISLANDS BRANCH, AS COLLATERAL AGENT
To: QUEST SOFTWARE INC. (F/K/A DELL SOFTWARE INC.); AVENTAIL LLC
Reel/Frame 046211/0735 →
CHANGE OF NAME Recorded Dec 6, 2017
From: DELL SOFTWARE INC.
To: QUEST SOFTWARE INC.
Reel/Frame 044800/0848 →
CORRECTIVE ASSIGNMENT TO CORRECT THE ASSIGNEE PREVIOUSLY RECORDED AT REEL: 040587 FRAME: 0624. ASSIGNOR(S) HEREBY CONFIRMS THE ASSIGNMENT. Recorded Nov 28, 2017
From: CREDIT SUISSE AG, CAYMAN ISLANDS BRANCH
To: QUEST SOFTWARE INC. (F/K/A DELL SOFTWARE INC.); AVENTAIL LLC
Reel/Frame 044811/0598 →
SECOND LIEN PATENT SECURITY AGREEMENT Recorded Nov 10, 2016
From: DELL SOFTWARE INC.
To: CREDIT SUISSE AG, CAYMAN ISLANDS BRANCH, AS COLLATERAL AGENT
Reel/Frame 040587/0624 →
FIRST LIEN PATENT SECURITY AGREEMENT Recorded Nov 9, 2016
From: DELL SOFTWARE INC.
To: CREDIT SUISSE AG, CAYMAN ISLANDS BRANCH, AS COLLATERAL AGENT
Reel/Frame 040581/0850 →
RELEASE OF SECURITY INTEREST IN CERTAIN PATENTS PREVIOUSLY RECORDED AT REEL/FRAME (040039/0642) Recorded Oct 31, 2016
From: THE BANK OF NEW YORK MELLON TRUST COMPANY, N.A.
To: AVENTAIL LLC; DELL PRODUCTS L.P.; DELL SOFTWARE INC.
Reel/Frame 040521/0016 →
RELEASE OF SECURITY INTEREST Recorded Oct 31, 2016
From: CREDIT SUISSE AG, CAYMAN ISLANDS BRANCH
To: AVENTAIL LLC; DELL PRODUCTS, L.P.; DELL SOFTWARE INC.
Reel/Frame 040521/0467 →
RELEASE OF SECURITY INTEREST Recorded Sep 14, 2016
From: BANK OF AMERICA, N.A., AS COLLATERAL AGENT
To: DELL MARKETING L.P.; ASAP SOFTWARE EXPRESS, INC.; APPASSURE SOFTWARE, INC.; COMPELLENT TECHNOLOGIES, INC.; CREDANT TECHNOLOGIES, INC.; DELL INC.; DELL PRODUCTS L.P.; DELL USA L.P.; DELL SOFTWARE INC.; FORCE10 NETWORKS, INC.; PEROT SYSTEMS CORPORATION; SECUREWORKS, INC.; WYSE TECHNOLOGY L.L.C.
Reel/Frame 040040/0001 →
SECURITY AGREEMENT Recorded Sep 14, 2016
From: AVENTAIL LLC; DELL PRODUCTS L.P.; DELL SOFTWARE INC.
To: THE BANK OF NEW YORK MELLON TRUST COMPANY, N.A., AS NOTES COLLATERAL AGENT
Reel/Frame 040039/0642 →
SECURITY AGREEMENT Recorded Sep 14, 2016
From: AVENTAIL LLC; DELL PRODUCTS, L.P.; DELL SOFTWARE INC.
To: CREDIT SUISSE AG, CAYMAN ISLANDS BRANCH, AS COLLATERAL AGENT
Reel/Frame 040030/0187 →
RELEASE OF SECURITY INTEREST Recorded Sep 14, 2016
From: BANK OF NEW YORK MELLON TRUST COMPANY, N.A., AS COLLATERAL AGENT
To: DELL MARKETING L.P.; ASAP SOFTWARE EXPRESS, INC.; APPASSURE SOFTWARE, INC.; COMPELLENT TECHNOLOGIES, INC.; CREDANT TECHNOLOGIES, INC.; DELL INC.; DELL PRODUCTS L.P.; DELL USA L.P.; DELL SOFTWARE INC.; FORCE10 NETWORKS, INC.; PEROT SYSTEMS CORPORATION; SECUREWORKS, INC.; WYSE TECHNOLOGY L.L.C.
Reel/Frame 040065/0618 →
RELEASE OF SECURITY INTEREST Recorded Sep 13, 2016
From: BANK OF AMERICA, N.A., AS ADMINISTRATIVE AGENT
To: DELL MARKETING L.P.; ASAP SOFTWARE EXPRESS, INC.; APPASSURE SOFTWARE, INC.; COMPELLANT TECHNOLOGIES, INC.; CREDANT TECHNOLOGIES, INC.; DELL INC.; DELL PRODUCTS L.P.; DELL USA L.P.; DELL SOFTWARE INC.; FORCE10 NETWORKS, INC.; PEROT SYSTEMS CORPORATION; SECUREWORKS, INC.; WYSE TECHNOLOGY L.L.C.
Reel/Frame 040065/0216 →
PATENT SECURITY AGREEMENT (TERM LOAN) Recorded Jan 2, 2014
From: DELL INC.; APPASSURE SOFTWARE, INC.; ASAP SOFTWARE EXPRESS, INC.; BOOMI, INC.; COMPELLENT TECHNOLOGIES, INC.; CREDANT TECHNOLOGIES, INC.; DELL MARKETING L.P.; DELL PRODUCTS L.P.; DELL SOFTWARE INC.; DELL USA L.P.; FORCE10 NETWORKS, INC.; GALE TECHNOLOGIES, INC.; PEROT SYSTEMS CORPORATION; SECUREWORKS, INC.; WYSE TECHNOLOGY L.L.C.
To: BANK OF AMERICA, N.A., AS COLLATERAL AGENT
Reel/Frame 031899/0261 →
PATENT SECURITY AGREEMENT (ABL) Recorded Jan 2, 2014
From: DELL INC.; APPASSURE SOFTWARE, INC.; ASAP SOFTWARE EXPRESS, INC.; BOOMI, INC.; COMPELLENT TECHNOLOGIES, INC.; CREDANT TECHNOLOGIES, INC.; DELL MARKETING L.P.; DELL PRODUCTS L.P.; DELL SOFTWARE INC.; DELL USA L.P.; FORCE10 NETWORKS, INC.; GALE TECHNOLOGIES, INC.; PEROT SYSTEMS CORPORATION; SECUREWORKS, INC.; WYSE TECHNOLOGY L.L.C.
To: BANK OF AMERICA, N.A., AS ADMINISTRATIVE AGENT
Reel/Frame 031898/0001 →
PATENT SECURITY AGREEMENT (NOTES) Recorded Jan 2, 2014
From: APPASSURE SOFTWARE, INC.; ASAP SOFTWARE EXPRESS, INC.; BOOMI, INC.; COMPELLENT TECHNOLOGIES, INC.; CREDANT TECHNOLOGIES, INC.; DELL INC.; DELL MARKETING L.P.; DELL PRODUCTS L.P.; DELL SOFTWARE INC.; DELL USA L.P.; FORCE10 NETWORKS, INC.; GALE TECHNOLOGIES, INC.; PEROT SYSTEMS CORPORATION; SECUREWORKS, INC.; WYSE TECHNOLOGY L.L.C.
To: BANK OF NEW YORK MELLON TRUST COMPANY, N.A., AS FIRST LIEN COLLATERAL AGENT
Reel/Frame 031897/0348 →
CHANGE OF NAME Recorded Aug 20, 2013
From: QUEST SOFTWARE, INC.
To: DELL SOFTWARE INC.
Reel/Frame 031043/0281 →
RELEASE OF SECURITY INTEREST IN PATENT COLLATERAL Recorded Sep 28, 2012
From: WELLS FARGO CAPITAL FINANCE, LLC (FORMERLY KNOWN AS WELLS FARGO FOOTHILL, LLC)
To: QUEST SOFTWARE, INC.; AELITA SOFTWARE CORPORATION; SCRIPTLOGIC CORPORATION; VIZIONCORE, INC.; NETPRO COMPUTING, INC.
Reel/Frame 029050/0679 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded May 4, 2012
From: LIGHTHOUSE CAPITAL PARTNERS V, L.P.
To: QUEST SOFTWARE, INC.
Reel/Frame 028170/0210 →
CORRECTIVE ASSIGNMENT TO CORRECT THE CITIZENSHIP OF QUEST SOFTWARE, INC. FROM A CALIFORNIA CORPORATION TO A DELAWARE CORPORATION PREVIOUSLY RECORDED ON REEL 023094 FRAME 0353. ASSIGNOR(S) HEREBY CONFIRMS THE GRANT, ASSIGNMENT, TRANSFER, AND COVEYANCE TO AGENT OF A CONTINUING SECURITY INTEREST IN THE ADDITIONAL PATENTS. Recorded Jun 30, 2010
From: QUEST SOFTWARE, INC.; AELITA SOFTWARE CORPORATION; SCRIPTLOGIC CORPORATION; VIZIONCORE, INC.; NETPRO COMPUTING, INC.
To: WELLS FARGO FOOTHILL, LLC, AS AGENT
Reel/Frame 024611/0504 →
AMENDMENT NUMBER TWO TO PATENT SECURITY AGREEMENT Recorded Aug 13, 2009
From: QUEST SOFTWARE, INC.; AELITA SOFTWARE CORPORATION; SCRIPTLOGIC CORPORATION; VIZIONCORE, INC.; NETPRO COMPUTING, INC.
To: WELLS FARGO FOOTHILL, LLC, AS AGENT
Reel/Frame 023094/0353 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Sep 14, 2007
From: GILGUR, ALEXANDER; PERKA, MICHAEL F.
To: MONOSPHERE, INC.
Reel/Frame 019830/0490 →