Data model simplification through field fallout

• US 8,122,052 B2
• Filed: 04/28/2010
• Issued: 02/21/2012
• Est. Priority Date: 01/29/2003
• Status: Expired due to Term

• Current Assignee: SAP SE
• Original Assignee: International Business Machines Corporation
• Inventors: Dettinger, Richard D., Kulack, Frederick A., Stevens, Richard J., Will, Eric W.
• Primary Examiner(s): Chen, Susan
• Application Number:
  US12/769,527
• Publication Number:
  US 20100211586A1
• Time in Patent Office: 664 Days
• Field of Search: 717/105
• 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

Methods, articles of manufacture and systems are provided 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 computer-implemented method of providing access to data, comprising:

providing an interface configured for use in building a database query based on a plurality of fields;

monitoring use of the fields in building queries to record, for at least some of the fields, when the fields were last used in building a query; and

limiting fields presented in the interface based on the monitored use of the fields in building queries by hiding fields not used in building queries for a predetermined period of time, the limiting being performed by the execution of one or more computer processors.

2. The computer-implemented method of claim 1, wherein limiting the fields presented to the user in the interface comprises hiding, from the user, fields based on a frequency in which the fields are used in building queries.

3. The computer-implemented method of claim 1, comprising, upon user request, presenting to the user previously hidden fields in the interface.

4. The computer-implemented method of claim 1, wherein monitoring use of fields comprises updating usage characteristics for a set of correlated fields when any of the set of correlated fields is used in building a query.

5. The computer-implemented method of claim 1, wherein monitoring use of the fields in building queries comprises:

monitoring use, by a plurality of users, of the fields in building queries; and

storing one or more usage characteristics for each of the plurality of users.

6. The computer-implemented method of claim 5, comprising:

presenting a first set of logical fields to a first user, based on one or more usage characteristics for the first user; and

presenting a second set of logical fields to a second user, based on one or more usage characteristics for the seconds user, wherein the first set of logical fields and the second set of logical fields are different.

7. A non-transitory computer-readable medium containing a fallout manager program which, when executed by a processor, performs an operation for providing access to data, comprising:

providing an interface configured for use in building a database query based on a plurality of fields;

monitoring use of the fields in building queries to record, for at least some of the fields, when the fields were last used in building a query; and

limiting fields presented in the interface based on the monitored use of the fields in building queries by hiding fields not used in building queries for a predetermined period of time.

8. The non-transitory computer-readable medium of claim 7, wherein limiting the fields presented to the user in the interface comprises hiding, from the user, fields based on a frequency in which the fields are used in building queries.

9. The non-transitory computer-readable medium of claim 7, comprising, upon user request, presenting to the user previously hidden fields in the interface.

10. The non-transitory computer-readable medium of claim 7, wherein monitoring use of fields comprises updating usage characteristics for a set of correlated fields when any of the set of correlated fields is used in building a query.

11. The non-transitory computer-readable medium of claim 7, wherein monitoring use of the fields in building queries comprises:

monitoring use, by a plurality of users, of the fields in building queries; and

storing one or more usage characteristics for each of the plurality of users.

12. The non-transitory computer-readable medium of claim 11, comprising:

presenting a first set of logical fields to a first user, based on one or more usage characteristics for the first user; and

presenting a second set of logical fields to a second user, based on one or more usage characteristics for the seconds user, wherein the first set of logical fields and the second set of logical fields are different.

13. A computer, comprising:

a memory containing a fallout manager program for providing access to data having a particular physical data representation;

a processor which, when executing the fallout manager program, performs an operation comprising;

providing an interface configured for use in building a database query based on a plurality of fields;

monitoring use of the fields in building queries to record, for at least some of the fields, when the fields were last used in building a query; and

limiting fields presented in the interface based on the monitored use of the fields in building queries by hiding fields not used in building queries for a predetermined period of time.

14. The computer of claim 13, wherein limiting the fields presented to the user in the interface further comprises:

hiding, from the user, fields based on a frequency in which the fields are used in building queries.

15. The computer of claim 13, wherein monitoring use of fields comprises updating usage characteristics for a set of correlated fields when any of the set of correlated fields is used in building a query.