DATA MODEL SIMPLIFICATION THROUGH FIELD FALLOUT

• US 20100211586A1
• Filed: 04/28/2010
• Published: 08/19/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.
• Granted Patent: US 8,122,052 B2
• Time in Patent Office: Days
• US Class Current: 707/766
• 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 allowing a user to build a database query based on a plurality of fields;

monitoring use of the fields in building queries; and

limiting fields presented to the user in the interface based on the monitored use of the fields in building queries, 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 not used in building queries for a predetermined period of time.

3. 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.

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

5. The computer-implemented method of claim 1, wherein monitoring use of fields comprises, for at least some fields, recording when the fields were last used in building a query.

6. 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.

7. 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.

8. The computer-implemented method of claim 7, 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.

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

providing an interface allowing a user to build a database query based on a plurality of fields;

monitoring use of the fields in building queries; and

limiting fields presented to the user in the interface based on the monitored use of the fields in building queries, the limiting being performed by the execution of one or more computer processors.

10. The computer-readable storage medium of claim 9, wherein limiting the fields presented to the user in the interface comprises hiding, from the user, fields not used in building queries for a predetermined period of time.

11. The computer-readable storage medium of claim 9, 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.

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

13. The computer-readable storage medium of claim 9, wherein monitoring use of fields comprises, for at least some fields, recording when the fields were last used in building a query.

14. The computer-readable storage medium of claim 9, 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.

15. The computer-readable storage medium of claim 9, 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.

16. The computer-readable storage medium of claim 15, 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.

17. 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 allowing a user to build a database query based on a plurality of fields;

monitoring use of the fields in building queries; and

limiting fields presented to the user in the interface based on the monitored use of the fields in building queries.

18. The computer of claim 17, wherein limiting the fields presented to the user in the interface comprises one of:

hiding, from the user, fields not used in building queries for a predetermined period of time; and

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

19. The computer of claim 17, wherein monitoring use of fields comprises, for at least some fields, recording when the fields were last used in building a query.

20. The computer of claim 17, 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.