System for querying databases

• US 20060026143A1
• Filed: 06/23/2005
• Published: 02/02/2006
• Est. Priority Date: 08/02/2004
• Status: Abandoned Application

• Current Assignee: SAP SE
• Original Assignee: SAP SE
• Inventors: Hirth, Gerhard A.
• Application Number:
  US11/166,464
• Publication Number:
  US 20060026143A1
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/24552 Database cache management

Abstract

System and methods, including computer program products for querying at least one database, the system comprising: calculation means for evaluating queries concerning availability based on data in the at least one database; user interface means comprising user input means and display means; wherein the calculation means and the user interface means are coupled to transfer user data from the user interface means to the calculation means and to transfer result data from the calculation means to the user interface means; wherein the result data comprise at least one intermediate and/or final result of a query concerning availability; wherein the user input means is configured to acquire user data about a query concerning availability, requested by a user to be evaluated by the calculation means; wherein the display means is configured to display result data.

Claims

1. A system for querying at least one database, the system comprising:

calculation means for evaluating queries concerning availability based on data in the at least one database;

user interface means comprising user input means and display means;

wherein the user input means is configured to acquire user data comprising a query concerning availability, requested by a user to be evaluated by the calculation means;

wherein the calculation means and the user interface means are coupled to transfer user data from the user interface means to the calculation means and to transfer result data from the calculation means to the user interface means;

wherein the calculation means is configured to be operable according to user data determining quality and volume of the result data;

wherein the result data comprise at least one intermediate and/or final result of a query concerning availability; and

wherein the display means is configured to display result data.

2. The system according to claim 1, wherein the display means is further configured to identify in the display of result data at least one attribute exerting an effect on the at least one result or a combination of results of a query concerning availability.

3. The system according to claim 2, wherein the effect exerted on the at least one result or a combination of results is a constraining effect.

4. The system according to claim 2, wherein the effect exerted on the at least one result or a combination of results is visualized by color.

5. The system according to claim 4, wherein the effect exerted on the at least one result or a combination of results is further visualized numerically.

6. A method for querying at least one database using calculation means and display means coupled to each other for data transfer, the method comprising:

acquiring user data comprising a query concerning availability, requested by a user;

transferring user data to the calculation means;

evaluating the query in the calculation means based on data in the at least one database to obtain result data, the result data comprising at least one intermediate and/or final result;

transferring the result data to the display means;

displaying the result data in the display means; and

wherein evaluating the query is performed according to user data determining quality and volume of the result data.

7. The method according to claim 6, wherein displaying the result data further comprises:

identifying in the display of result data at least one attribute exerting an effect on the at least one result or a combination of results of a query concerning availability.

8. The method according to claim 7, wherein the effect exerted on the at least one result or a combination of results is a constraining effect.

9. The method according to claim 7 further comprising:

visualizing the effect exerted on the at least one result or a combination of results by color.

10. The method according to claim 9 further comprising:

visualizing the effect exerted on the at least one result or a combination of results numerically.

11. A machine-accessible medium containing instructions that when executed cause a member to provide available-to-promise checks by:

acquiring user data comprising a query concerning availability, requested by a user;

transferring user data to the calculation means;

evaluating the query in the calculation means based on data in the at least one database to obtain result data, the result data comprising at least one intermediate and/or final result;

transferring the result data to the display means;

displaying the result data in the display means; and

wherein evaluating the query is performed according to user data determining quality and volume of the result data.

12. The machine accessible median of claim 11, wherein instructions further cause the machine to:

identify in the display of result data at least one attribute exerting an effect on the at least one result or a combination of results of a query concerning availability.

13. The machine accessible median of claim 11, wherein the effect exerted on the at least one result or a combination of results is a constraining effect.

14. The machine accessible median of claim 11, wherein instructions further cause the machine to:

visualize the effect exerted on the at least one result or a combination of results by color.

15. The machine accessible median of claim 14, wherein instructions further cause the machine to:

further visualize the effect exerted on the at least one result or a combination of results numerically.