System and method for constructing generic analytical database applications

• US 6,836,777 B2
• Filed: 11/14/2002
• Issued: 12/28/2004
• Est. Priority Date: 11/15/2001
• Status: Expired due to Term

• Current Assignee: Whowhatware, LLC
• Original Assignee: NCR Corporation (NCR Voyix Corporation)
• Inventors: Holle, Dan
• Primary Examiner(s): Corrielus, Jean M.
• Application Number:
  US10/295,088
• Publication Number:
  US 20030172084A1
• Time in Patent Office: 775 Days
• Field of Search: 707/104, 707/103, 707/101, 707/100, 707/2, 707/10, 715/501
• US Class Current: 1/1
• CPC Class Codes: G06Q 30/02 Marketing; Price estimation or determination; Fundraising
• CPC Class Codes: Y10S 707/99942 Manipulating data structure, e.g. compression, compaction, compilation
• CPC Class Codes: Y10S 707/99945 Object-oriented database structure processing

Abstract

Disclosed is a system and method for constructing generic analytical database applications through the automated creation of metadata to establish an application structure controlling the availability and operability of individual applications.

Claims

1. A method for categorizing data values contained within a column within a database table, said method comprising the steps of:

determining a number of distinct values contained within said database column;

creating a data category for each one of said distinct values when said number of distinct values is not greater than a predetermined maximum number of allowed value categories;

creating a data category for each one of a plurality of most common values and an additional category to include all values not included in any one of said plurality of most common values when said number of distinct values is greater than said predetermined maximum number of allowed value categories and the number of values not included in any one of said plurality of most common values is not greater than a predetermined number of allowed additional values; and

creating a plurality of data categories, each one of said data categories including one of a plurality of value ranges when said number of distinct values is greater than said first predetermined maximum number of allowed value categories and the number of values not included in any one of said plurality of most common values is greater than a predetermined number of allowed additional values.

2. The method for categorizing data values contained within a column within a database table in accordance with claim 1, said step of determining a number of distinct values contained within said database column includes the step of:

counting the number of rows contained within said database table.

3. The method for categorizing data values contained within a column within a database table in accordance with claim 1, said step of determining a number of distinct values contained within said database column includes the step of:

counting the number of distinct column values contained within said database table.

4. The method for categorizing data values contained within a column within a database table in accordance with claim 1, wherein:

said data values comprise numeric data values; and

said value ranges and corresponding data categories are determined through application of statistical functions to said the numeric data values contained within said column.

5. The method for categorizing data values contained within a column within a database table in accordance with claim 1, wherein:

said data values comprise character data values; and

said value ranges and corresponding data categories are determined by examining leading substrings included within said character data values contained within said column.