Chameleon measure and metric calculation

Details Chameleon measure and metric calculation Chameleon measure and metric calculation

2001-04-27

2004-05-04

Amsbury, Wayne (Department: 2171)

Data processing: database and file management or data structures

Database design

Data structure types

Reexamination Certificate

active

06732115

ABSTRACT:

TECHNICAL FIELD
The embodiments disclosed and claimed herein are related to computer systems, and more particularly, databases.
TECHNICAL BACKGROUND
Today's businesses have sophisticated data analysis requirements. The metrics or analyses of a business's data can be difficult to obtain. To calculate a meaningful metric, business analysts often use spreadsheets to manually analyze data. Manual analysis, of course, is a tedious and time-consuming process.
Most applications fail to deliver useful metrics that provide unique insights into an organization's performance. Useful metrics highlight significant performance measures of the business. Typically, business analysts must execute multiple queries and other time-consuming manual interventions to produce these metrics. Then, despite the time-consuming effort, analysts must start the process anew to obtain follow-up information such as an explanation of a particular anomaly in a metric.
Typically, a business's data is stored on a database or on databases. These databases are operated with associated database servers, which manage the storage and retrieval of records from the databases. Analytical servers have additionally been provided to format database queries or information requests sent from a client user interface to the database server for handling. The analytical servers can be used to improve the efficiency of the database accesses and to provide metrics of interest to the user from the retrieved records from the database.
SUMMARY
The embodiments disclosed below provide an analytical server which efficiently accesses a Relational Database Management System (“RDBMS”) comprising a database and a database server. The database in this approach includes fact and dimension tables which may be, for example, configured in a star schema having a central base fact table with surrounding dimension tables to form the star structure. Aggregate fact tables may also be provided which aggregate measures from the base fact table at a higher hierarchical level than such measures are maintained in the base fact table. Metadata is further stored in the database, where the metadata describes the organization of the various tables in the database, and specifically the metadata in the embodiments described below includes information about the hierarchical levels of various dimensions of the above-mentioned tables and star schema.
With further reference to the metadata stored in the database in the below-described embodiments, the analytical server described herein receives the metadata from the database and analyzes that metadata, including the hierarchical information, in order to provide relatively efficient access to the tables of the database in response to a query from a user. Such efficient access preferably supports calculation of complex metrics which might otherwise be difficult or impossible. Supported levels of stars are defined and analyzed in a sophisticated and efficient manner which facilitates the calculation of chameleon and allocated metrics.
The foregoing provides a number of additional advantages. A user can easily limit the data to a particular set of value(s) for a particular hierarchy level, known as slicing. The user can also view the metrics by moving up or down through a hierarchy, known as drilling. Additionally, fact level security and dimensional security are supported, as well as efficient collection and analysis of aggregate fact table usage statistics.


REFERENCES:
patent: 5884299 (1999-03-01), Ramesh et al.
patent: 5899992 (1999-05-01), Iyer et al.
patent: 5926818 (1999-07-01), Malloy
patent: 5983227 (1999-11-01), Nazem et al.
patent: 5991756 (1999-11-01), Wu
patent: 6032144 (2000-02-01), Srivastava et al.
patent: 6078926 (2000-06-01), Jensen et al.
patent: 6161103 (2000-12-01), Rauer et al.
patent: 6163774 (2000-12-01), Lore et al.
patent: 6199063 (2001-03-01), Colby et al.
patent: 6205469 (2001-03-01), Graham
patent: 6212515 (2001-04-01), Rogers
patent: 6212524 (2001-04-01), Weissman et al.
patent: 6282544 (2001-08-01), Tse et al.
patent: 6327574 (2001-12-01), Kramer et al.
patent: 6366922 (2002-04-01), Althoff
patent: 6377993 (2002-04-01), Brandt et al.
patent: 6385201 (2002-05-01), Iwata
patent: 6385604 (2002-05-01), Bakalash et al.
patent: 6434544 (2002-08-01), Bakalash et al.
patent: 6439699 (2002-08-01), Silverbrook
patent: 6446063 (2002-09-01), Chen et al.
patent: 6480836 (2002-11-01), Colby et al.
patent: 6484179 (2002-11-01), Roccaforte
patent: 6505205 (2003-01-01), Kothuri et al.
patent: 6542895 (2003-04-01), DeKimpe et al.
patent: 6556983 (2003-04-01), Alstchuler et al.
patent: 2002/0029207 (2002-03-01), Bakalash et al.
patent: 2002/0099691 (2002-07-01), Lore et al.
patent: WO9957658 (1999-11-01), None
patent: WO 99 57658 (1999-11-01), None
patent: WO0020982 (2000-04-01), None
patent: WO 00 20982 (2000-04-01), None

Affiliated with

Also associated with

Rating

Chameleon measure and metric calculation does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Chameleon measure and metric calculation, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Chameleon measure and metric calculation will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3226493