Data model simplification through field fallout

• US 7,734,646 B2
• Filed: 01/29/2003
• Issued: 06/08/2010
• Est. Priority Date: 01/29/2003
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: International Business Machines Corporation
• Inventors: Dettinger, Richard D., Stevens, Richard J., Will, Eric W., Kulack, Frederick A.
• Primary Examiner(s): Mofiz; Apu M
• Assistant Examiner(s): Chen; Susan Y
• Application Number:
  US10/353,666
• Publication Number:
  US 20040148276A1
• Time in Patent Office: 2,687 Days
• Field of Search: 707/3, 345/792
• US Class Current: 707/779
• CPC Class Codes: G06F 16/2423 Interactive query statement specification based on a database schema
• CPC Class Codes: G06F 16/2428 Query predicate definition using graphical user interfaces, including menus and forms G06F16/2423 takes precedence

Abstract

The present invention generally provides methods, articles of manufacture and systems for simplifying a query building process by limiting the number of fields presented to a user for building queries. The number of fields presented to the user may be limited by hiding one or more logical fields from the user based on usage characteristics. For example, a logical field that is rarely used or has not been used within a predetermined period of time may be hidden from the user. For some embodiments, a fallout manager may monitor the use of logical fields in building queries, update usage characteristics, and mark logical fields as hidden based on the usage characteristics. A graphical user interface may not present to a user logical fields that have been marked as hidden.

Claims

1. A database system comprising:

a database comprising data having a particular physical representation;

a data repository abstraction layer comprising logical fields corresponding to physical entities of the database;

a query building interface allowing a user to build a query to access the database by specifying query conditions based on the logical fields; and

a fallout manager configured to control the logical fields presented to the user by the query building interface based on usage characteristics of the logical fields in building queries, wherein the usage characteristics comprise an indication of at least one of;

when a logical field was last used in building a query and a frequency with which the logical field has been used in building queries,

wherein the fallout manager is configured to control the logical fields presented by the query building interface by hiding logical fields not used in building a query within a first predetermined period of time.

2. The database system of claim 1, wherein the fallout manager is configured to control the logical fields presented by the query building interface to a particular user based on usage characteristics of the logical fields in building queries by the particular user.

3. The database system of claim 2, wherein the data repository abstraction layer further comprises a plurality of usage characteristics, each specific to a particular user, for one or more of the logical fields.

4. The database system of claim 1, wherein the logical fields in the data repository abstraction layer comprise a set of correlated logical fields and the fallout manager is configured to update usage characteristics of each of the correlated logical fields upon detecting a query has been built using any of the set of correlated logical fields.

5. The database system of claim 1, wherein the fallout manager is further configured to control the logical fields presented by the query building interface by removing, from the data repository abstraction layer, logical fields not used in building a query within a second predetermined period of time greater than the first predetermined period of time.

6. The database system of claim 5, wherein hiding a logical field comprises modifying a parameter associated with the logical field in the data repository abstraction layer.

7. The database system of claim 1, wherein the query building interface provides a user the option of displaying previously hidden logical fields.