System and method for automatic transmission of on-line analytical ...

(54) SYSTEM AND METHOD FOR AUTOMATIC TRANSMISSION OF ON-LINE ANALYTICAL PROCESSING SYSTEM REPORT OUTPUT

(75) Inventors: Kyle N. Yost, Arlington, VA (US);

Peter G. Wilding, Denver, CO (US);
Robert G. Trenkamp, Washington, DC
(US)

(73) Assignee: Microstrategy, Inc., Vienna, VA (US)

( * ) Notice: Under 35 U.S.C. 154(b), the term of this patent shall be extended for 0 days.

(21) Appl. No.: 09/343,563

(22) Filed: Jun. 30, 1999

Related U.S. Application Data

(60) Provisional application No. 60/126,055, filed on Mar. 23, 1999.

(51) Int. CI. G06F 15/16

(52) U.S. CI 709/201; 709/202; 709/229

(58) Field of Search 709/200, 202,

709/217, 218, 229, 223, 225, 246; 705/10, 14, 35, 37; 707/1, 2, 3, 4, 100; 345/329,

330, 331

(56) References Cited

U.S. PATENT DOCUMENTS

5,692,181 * 11/1997 Anand et al 707/102

5,765,028 * 6/1998 Gladden 706/25

5,852,819 12/1998 Beller .

5,893,905 * 4/1999 Main et al 705/11

5,918,225 6/1999 White et al. .

5,918,232 * 6/1999 Pouschine et al 707/103

5,940,818 * 8/1999 Malloy et al 707/2

5,956,693 * 9/1999 Geerlings 705/14

5,974,441 * 10/1999 Rogers et al 709/200

6,012,066 1/2000 Discount et al. .

(List continued on next page.)

OTHER PUBLICATIONS

Ho et al., "Partial -Sum Queries in OLAP Data Cubes Using Covering Codes", ACM 0-89791-910-6, pp. 228-237, 1997.*

Gupta et al, "Index Selection for OLAP", IEEE 1063-6382, pp. 208-219, 1997.*

Avnur et al., "CONTROL: Continuous Output and Navigation Technology with Refinement On-Line", ACM 0-89791-995-5, pp. 567-569, 1998.* Liang et al., "Computing Multidimensional Aggregates in Parallel", IEEE 0-8186-8603-0, pp. 92-99, 1998.* Lehn, R, et al., Data warehousing tool's architecture: from multidimensional analysis to data mining, pp. 636-643, Database and Expert Systems Applications, 1997.

(List continued on next page.)

Primary Examiner—Mark Rinehart

Assistant Examiner—-Jason D. Cardone

(74) Attorney, Agent, or Firm—-James G. Gatto; Brian M.

Buroker; Hunton & Williams

A system for automatically generating output from an on-line analytical processing system based on scheduled services specified by subscribers of the system. The system processes scheduled services in an on-line analytical processing system with each service comprising at least one query to be performed by the on-line analytical processing system. The system then automatically forwards output from the services to one or more subscriber output devices specified for that service. Users may define new services, including the schedule of the services and the type, such as alert services or scheduled services, and may also subscriber to the services provided by the system. If an alert service is processed, the system may forward output only when one or more alert criteria are satisfied. Subscribers may be specified by a dynamic recipient list that is resolved each time the service is processed to determine recipients of the service output. The output devices the system may forward output to may comprise electronic mailbox, facsimile, printer, mobile phone, telephone, PDA or pager.

19 Claims, 4 Drawing Sheets

U.S. PATENT DOCUMENTS

6,012,083 * 1/2000 Savitzky et al 709/202

6,038,561 * 3/2000 Snyder et al 707/6

OTHER PUBLICATIONS

Zaiane, O.R., et al., Discovering Web access patterns and trends by applying OLAP and data mining technology on Web logs, pp. 19-29, Research and Technology Advances in Digital Libraries, 1998.

Kurz, A., et al., Data warehousing within intranet: prototype of a web-based executive information system, pp. 627-632, Database and Expert Systems Applications, 1997.

Ewen, Edward E, et al., Data warehousing in an integrated health system: building the business case, pp. 47-563, Conference on Information and Knowledge Management, Nov. 3-7, 1998.

* cited by examiner