System, method, and computer program product for processing and visualization of information

Patent metadata

Field	Value
Publication number	US-9710815-B2
Application number	US-1081008-A
Country	US
Kind code	B2
Filing date	Jan 30, 2008
Priority date	Oct 11, 2001
Publication date	Jul 18, 2017
Grant date	Jul 18, 2017

Abstract

Systems and methods for processing and reporting information and data, such as business information, and more particularly, to systems, software, hardware, products, and processes for use by businesses, individuals and other organizations to collect, process, distribute, analyze and visualize information, including, but not limited to, business intelligence, data visualization, data warehousing, and data mining. Real-time monitoring of web site interactions allows users to modify and fine-tune their websites to maximize value realized.

First claim

The invention claimed is:

1. A computer system for evaluating business data stored in a database and grouped by dimension, the computer system comprising:
a query engine configured to:
generate, at compile time, a plurality of operation chains, wherein each of the operation chains comprises a sequence of selected ones of a plurality of atomic operations configured to operate on the business data, wherein the atomic operations of the sequence are selected from atomic operations implementing one or more dimensions, atomic operations implementing one or more metrics, and atomic operations implementing one or more filters such that each respective operation chain is configured to implement a selected combination of dimensions, metrics and/or filters on the business data stored in the database;
select, at run time, one or more of the plurality of operation chains generated; and
evaluate, using the one or more operation chains selected at run time, the business data to generate processed data output for display to a user.

2. The computer system of claim 1 , wherein the query engine is configured to repeatedly output the processed data in real-time.

3. The computer system of claim 1 , wherein the metrics include any of: visits, value events, conversions, return, value, count and sum.

4. The computer system of claim 1 , wherein the query engine has been implemented with any of expression templates and dynamic dispatch.

5. The computer system of claim 1 , wherein the computer program module is configured to implement one of the plurality of operation chains as a linked list.

6. The computer system of claim 1 , wherein the filters include any of a bitfilter, a slice filter, and a drill-down filter.

7. The computer system of claim 1 , wherein the computer program module is configured to implement any of cache warming and prefetching.

8. The computer system of claim 1 , wherein the operations include any operation configured to operate on any of a row and a column.

9. The computer system of claim 1 , wherein the computer program module is configured to implement any of: a record weight operation, a hypothetical scenario operation and an incremental hypothesis change operation.

10. A computer-implemented method of evaluating business data stored in a database and grouped by dimension, comprising:
performing by one or more computers:
generating, at compile time, a plurality of operation chains, wherein each of the operation chains comprises a sequence of selected ones of a plurality of atomic operations configured to operate on the business data, wherein the atomic operations of the sequence are selected from atomic operations implementing one or more dimensions, atomic operations implementing one or more metrics, and atomic operations implementing one or more filters such that each respective operation chain is configured to implement a selected combination of dimensions, metrics and/or filters on the business data stored in the database; and
selecting, at run time, one or more of the plurality of operation chains generated; and
evaluating, using the one or more operation chains selected at run time, the business data to generate processed data output for display to a user.

11. The computer-implemented method of claim 10 , further comprising repeatedly outputting the processed data in real time.

12. The computer-implemented method of claim 10 , wherein the metrics comprise any of: visits, value events, conversions, return, value, count and sum.

13. The computer-implemented method of claim 10 , further comprising executing any of expression templates and dynamic dispatch.

14. The computer-implemented method of claim 10 , further comprising implementing any of the plurality of operation chains as a linked list.

15. The computer-implemented method of claim 10 , wherein the filters comprise any of a bitfilter, a slice filter and a drill-down filter.

16. The computer-implemented method of claim 10 , further comprising any of cache warming and prefetching.

17. The computer-implemented method of claim 10 , wherein the plurality of atomic operations comprises at least one operation configured to operate on any of a row and a column.

18. The computer-implemented method of claim 10 , further comprising implementing any of: a record weight operation, a hypothetical scenario operation and an incremental hypothesis change operation.

19. The computer-implemented method of claim 10 , further comprising determining whether to extend one of the plurality of operations chains.

20. The computer-implemented method of claim 10 , further comprises determining whether to invoke dynamic implementation.

21. The computer-implemented method of claim 10 , further comprising implementing the plurality of atomic operations using calling functions.

22. The computer-implemented method of claim 21 , further comprising optimizing the calling functions.

23. The computer-implemented method of claim 22 , wherein the calling functions are anyone of optimized inline and optimized statically.

24. A computer program product for evaluating business data stored in a database and grouped by dimension, comprising:
a computer readable storage medium;
computer readable instructions stored on the computer readable storage medium, that, when executed, cause a computer to:
generate, at compile time, a plurality of operation chains, wherein each of the operation chains comprises a sequence of selected ones of a plurality of atomic operations configured to operate on the business data, wherein the atomic operations of the sequence are selected from atomic operations implementing one or more dimensions, atomic operations implementing one or more metrics, and atomic operations implementing one or more filters such that each respective operation chain is configured to implement a selected combination of dimensions, metrics and/or filters on the business data stored in the database; and
select, at run time, one or more of the plurality of operation chains generated; and
evaluate, using the one or more operation chains selected at run time, the business data to generate processed data output for display to a user.

25. The computer program product of claim 24 , wherein the instructions further cause the computer to repeatedly output the processed data in real-time.

26. The computer program product of claim 24 , wherein the metrics comprise any of: visits, value events, conversions, return, value, count and sum.

27. The computer program product of claim 24 , wherein the instructions further cause the computer to execute any of expression templates and dynamic dispatch.

28. The computer program product of claim 24 , wherein the instructions further cause the computer to implement any of the plurality of operation chains as a linked list.

29. The computer program product of claim 24 , wherein the filters comprise any a bitfilter, a slice filter and a drill-down filter.

30. The computer program product of claim 24 , wherein the instructions further cause the computer to any of cache warm and prefetch.

31. The computer program product of claim 24 , wherein the plurality of atomic operations comprise at least one operation configured to operate on any of a row and a column.

32. The computer program product of claim 24 , wherein the instructio

Assignees

• Macintyre James W
• Scherer David
• Rosenthal David Alan
• Adobe Systems Inc

Inventors

• Macintyre James W
• Scherer David
• Rosenthal David Alan

Classifications

• G06Q30/0201

  Market modelling; Market analysis; Collecting market data · CPC title

• G06F16/2462

  Approximate or statistical queries · CPC title

• G06Q10/0639

  Performance analysis of employees; Performance analysis of enterprise or organisation operations · CPC title

• G06F16/248

  Presentation of query results · CPC title

• G06Q10/0637

  Strategic management or analysis, e.g. setting a goal or target of an organisation; Planning actions based on goals; Analysis or evaluation of effectiveness of goals · CPC title