Method for presenting information on display devices of varying sizes

• US 5,848,406 A
• Filed: 09/03/1996
• Issued: 12/08/1998
• Est. Priority Date: 09/03/1996
• Status: Expired due to Term

• Current Assignee: Matsushita Electric Industrial Company Limited (Panasonic Holdings Corporation)
• Original Assignee: Matsushita Electric Industrial Company Limited (Panasonic Holdings Corporation)
• Inventors: Mani, Viswanthan Subra, Alonso, Rafael
• Primary Examiner(s): Black, Thomas G.
• Assistant Examiner(s): Choules, Jack M.
• Application Number:
  US08/707,214
• Time in Patent Office: 826 Days
• Field of Search: 707/2, 707/5, 707/1, 1/1
• US Class Current: 1/1
• CPC Class Codes: G06F 16/2423 Interactive query statement specification based on a database schema
• CPC Class Codes: G06F 16/248 Presentation of query results
• CPC Class Codes: Y10S 707/99932 Access augmentation or optimizing
• CPC Class Codes: Y10S 707/99935 Query augmenting and refining, e.g. inexact access

Abstract

A method for presenting information on display devices of varying sizes. The method processes a query of a database and determines which tables are most likely to contain information which the user wishes to primarily view. The join relationships between tables of the database are used to determine the priority for displaying tables. Those join relationships which were used more frequently in previous queries are accorded higher weight scores and correspondingly have a greater chance of being prioritized to be displayed on the computer screen. Also, a user may select a particular table to be focused upon. In that situation, the method displays not only the focused table but also the tables with a direct relationship to it.

Claims

1. A method for sending data from a database to a computer output device, said database including a plurality of tables for holding said data, said database having a schema indicative of relationships between said tables, said tables having attributes, said attributes containing said data, the method comprising:

processing a query of said database, said query containing query tables;

determining weights for each pair of query tables, said weights being indicative of occurrence of said query table pairs in previous queries;

determining sets of said query table pairs based on said weights; and

sending to said computer output device one of said sets which contains query tables specified in said query.

2. The method of claim 1 wherein said relationships are join relationships between said query tables.

3. The method of claim 1 wherein said computer output device is a computer screen.

4. The method of claim 3 wherein the set of said sending step is substantially displayed within display size of the computer output device.

5. The method of claim 4 wherein size of said computer screen is smaller than size of a standard desktop computer screen.

6. The method of claim 1 wherein said computer output device is a printer.

7. The method of claim 1 wherein said computer output device receives said set of said sending step through a network.

8. The method of claim 1 further comprising the step of:

grouping said query tables whose said weights satisfy a grouping threshold level.

9. The method of claim 8 wherein said grouping threshold level is based upon display size of the computer output device so that each said set of said sending step can be substantially displayed within display size of the computer output device.

10. The method of claim 1 wherein the database contains said tables located on a plurality of computers.

11. The method of claim 1 further comprising the step of:

selecting one of said query tables for a focused display on said computer output device, said focused display providing for displaying all attributes of said selected query table and all attributes of neighbors of said selected query table on said computer output device, said neighbors being tables having at least one of said relationships with said selected query table.

12. The method of claim 11 further comprising the step of:

scrolling through the display of the computer output device for viewing said focused display.

13. An apparatus for sending data from a database to a computer output device, said database including a plurality of tables for holding said data, said database having a schema indicative of relationships between said tables, said tables having attributes, said attributes containing said data, comprising:

means for processing a query of said database, said query containing query tables;

means for determining weights for each pair of query tables, said weights being indicative of occurrence of said query table pairs in previous queries;

means for determining sets of said query table pairs based on said weights; and

means for sending to said computer output device one of said sets which contains query tables specified in said query.

14. The apparatus of claim 13 wherein said relationships are join relationships between said query tables.

15. The apparatus of claim 13 wherein said computer output device is a computer screen.

16. The apparatus of claim 15 wherein the set of said sending means is substantially displayed within display size of the computer output device.

17. The apparatus of claim 16 wherein size of said computer screen is smaller than size of a standard desktop computer screen.

18. The apparatus of claim 13 wherein said computer output device is a printer.

19. The apparatus of claim 13 wherein said computer output device receives said set of said sending means through a network.

20. The apparatus of claim 13 further comprising:

means for grouping said query tables whose said weights satisfy a grouping threshold level.

21. The apparatus of claim 20 wherein said grouping threshold level is based upon display size of the computer output device so that each said set of said sending means can be substantially displayed within display size of the computer output device.

22. The apparatus of claim 13 wherein the database contains said tables located on a plurality of computers.

23. The apparatus of claim 13 further comprising:

means for selecting one of said query tables for a focused display on said computer output device, said focused display providing for displaying all attributes of said selected query table and all attributes of neighbors of said selected query table on said computer output device, said neighbors being tables having at least one of said relationships with said selected query table.

24. The apparatus of claim 23 further comprising:

means for scrolling through the display of the computer output device for viewing said focused display.