Forecasting system and method using change data based database storage for efficient ASP and web application
First Claim
Patent Images
1. A system comprising:
- one or more computer systems that include one or more processors coupled to one or more memories that include code executable by the one or more processors to configure the one or more computer systems into one or more machines comprising;
an identification server to receive access requests from multiple client computer systems and provide a segregated system that directs users of 1 through N customers to respective 1 through N customer databases, wherein N is an integer greater than 1;
an analysis server comprising a processor and memory, coupled to the processor, wherein the memory includes code that is executable by the processor to configure the analysis server into a machine to;
receive forecast data and updates of the forecast data from multiple client computers;
segregate the data and updates of the data among the N customer databases so that each database contains data and updates of the data associated with one customer;
include an analytics and aggregation unit that includes an online analytical processing (OLAP) cube to automatically process real-time the data and updates of the data for each of the N databases to analyze and update information in partitions of the multiple customer databases, wherein the information analyzed and updated in the first partition of the multiple customer databases includes forecast data and received updates to the forecast data, and the forecast data includes at least one estimated future value; and
receive forecast data analysis requests from multiple customers; and
for each data analysis request for each customer, access the segregated customer database associated with the customer and provide the requested forecast data analysis request to the customer.
3 Assignments
0 Petitions
Accused Products
Abstract
In one embodiment, a system is provided. The system includes a first client. The system also includes an analysis server coupled to the first client. The system further includes a first customer database of information coupled to the analysis server. The first customer database is to embody forecast data and to receive essentially real-time updates to the forecast data. The first customer database supports an OLAP cube associated with the analysis server.
38 Citations
32 Claims
-
1. A system comprising:
-
one or more computer systems that include one or more processors coupled to one or more memories that include code executable by the one or more processors to configure the one or more computer systems into one or more machines comprising; an identification server to receive access requests from multiple client computer systems and provide a segregated system that directs users of 1 through N customers to respective 1 through N customer databases, wherein N is an integer greater than 1; an analysis server comprising a processor and memory, coupled to the processor, wherein the memory includes code that is executable by the processor to configure the analysis server into a machine to; receive forecast data and updates of the forecast data from multiple client computers; segregate the data and updates of the data among the N customer databases so that each database contains data and updates of the data associated with one customer; include an analytics and aggregation unit that includes an online analytical processing (OLAP) cube to automatically process real-time the data and updates of the data for each of the N databases to analyze and update information in partitions of the multiple customer databases, wherein the information analyzed and updated in the first partition of the multiple customer databases includes forecast data and received updates to the forecast data, and the forecast data includes at least one estimated future value; and receive forecast data analysis requests from multiple customers; and for each data analysis request for each customer, access the segregated customer database associated with the customer and provide the requested forecast data analysis request to the customer. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21)
-
-
22. A method comprising:
executing code executable by one or more processors or one or more computer systems to configure the one or more computer systems into one or more machines to perform; communicating data between an analysis server and at least an external first client and to the first customer database; segregating data and updates of the data among N customer databases so that each database contains data and updates of the data associated with one customer, wherein N is an integer greater than 1; receiving access requests from multiple client computer systems and provide a segregated system that directs users of 1 through N customers to the respective 1 through N customer databases; receiving with the analysis server a query request from the external first client; analyzing and updating information in multiple customer databases including a first of the N customer databases with an analytics and aggregation unit that includes an online analytical processing (OLAP) cube to automatically process real-time the data and updates of the data for each of the N databases, wherein the information analyzed in the first customer database includes forecast data and received updates to the forecast data, and the forecast data includes at least one estimated future value; and operating the analytics and aggregation unit to aggregate only changed information into a change partition of the first customer database and to analyze and update the information on the basis of the changed data in the change partition; receiving forecast data analysis requests from multiple customers; and for each data analysis request for each customer, accessing the segregated customer database associated with the customer and provide the requested forecast data analysis request to the customer. - View Dependent Claims (23, 24, 25, 26, 27, 28, 29, 30, 31, 32)
Specification