Automated generation of dynamic data entry user interface for relational database management systems

• US 7,401,094 B1
• Filed: 08/16/2005
• Issued: 07/15/2008
• Est. Priority Date: 12/28/2001
• Status: Expired due to Fees

• Current Assignee: Advanced Dynamic Interfaces, LLC
• Original Assignee: Mind Concepts Technology LLC
• Inventors: Kesler, John N.
• Primary Examiner(s): Chace, Chirstian P.
• Assistant Examiner(s): Veillard, Jacques
• Application Number:
  US11/204,799
• Time in Patent Office: 1,064 Days
• Field of Search: None
• US Class Current: 707/805
• CPC Class Codes: G06F 16/252 between a Database Management System and a front-end application
• CPC Class Codes: Y10S 707/954 Relational
• CPC Class Codes: Y10S 707/99934 Query formulation, input preparation, or translation
• CPC Class Codes: Y10S 707/99935 Query augmenting and refining, e.g. inexact access
• CPC Class Codes: Y10S 707/99942 Manipulating data structure, e.g. compression, compaction, compilation
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface
• CPC Class Codes: Y10S 707/99944 Object-oriented database structure
• CPC Class Codes: Y10S 707/99945 Object-oriented database structure processing

Abstract

Computer software for, computer apparatus for, and a method of automatically generating a user interface for a relational database comprising extracting schema information from the relational database and automatically generating corresponding schema and user interface metadata, storing the metadata in a repository, and automatically developing from the metadata a user interface appropriate to the relational database.

Claims

1. Computer software for automatically generating a graphical user interface for a relational database, said software embodied in a computer readable medium having a set of computer instructions encoded thereon and comprising:

utility software extracting schema information from the relational database and automatically generating corresponding schema and graphical user interface metadata stored in a repository; and

user interface software at runtime automatically, and without compilation of code before runtime, developing from the metadata a graphical user interface appropriate to the relational database.

2. The computer software of claim 1 wherein said schema and user interface metadata comprise entities, entity fields, entity relationships, and entity search paths.

3. The computer software of claim 2 wherein said schema and user interface metadata comprise entity relationships comprising one-to-many, many-to-one, and many-to-many relationships.

4. The computer software of claim 2 wherein said schema and user interface metadata additionally comprises platform attributes for abstracting syntactic differences between database implementations.

5. The computer software of claim 3 wherein said automatically developed user interface comprises context menus specific to type of entity relationship.

6. The computer software of claim 1 additionally comprising software permitting addition of non-automatically-generated functionality to said developed user interface selected from the group consisting of scripts, external components, business rules, and triggers.

7. The computer software of claim 1 wherein said utility software refreshes said metadata after schema changes are made to the relational database.

8. Computer apparatus for automatically generating a graphical user interface for a relational database, said apparatus comprising:

means embodied in a computer readable medium having a set of computer instructions encoded thereon for extracting schema information from the relational database and automatically generating corresponding schema and graphical user interface metadata;

repository means for containing said metadata; and

means embodied in a computer readable medium having a set of computer instructions encoded thereon for at runtime automatically, and without compilation of code before runtime, developing from the metadata a graphical user interface appropriate to the relational database.

9. The computer apparatus of claim 8 wherein said schema and user interface metadata comprise entities, entity fields, entity relationships, and entity search paths.

10. The computer apparatus of claim 9 wherein said schema and user interface metadata comprise entity relationships comprising one-to-many, many-to-one, and many-to-many relationships.

11. The computer apparatus of claim 9 wherein said schema and user interface metadata additionally comprises platform attributes for abstracting syntactic differences between database implementations.

12. The computer apparatus of claim 10 wherein said automatically developed user interface comprises context menus specific to type of entity relationship.

13. The computer apparatus of claim 8 additionally comprising software permitting addition of non-automatically-generated functionality to said developed user interface selected from the group consisting of scripts, external components, business rules, and triggers.

14. The computer apparatus of claim 8 wherein said extracting means refreshes the metadata after schema changes are made to the relational database.

15. A method of automatically generating a graphical user interface for a relational database, the method comprising the steps of:

extracting schema information from the relational database and automatically generating corresponding schema and graphical user interface metadata;

storing the metadata in a repository; and

at runtime automatically, and without compilation of code before runtime, developing from the metadata a graphical user interface appropriate to the relational database.

16. The method of claim 15 wherein the schema and user interface metadata comprise entities, entity fields, entity relationships, and entity search paths.

17. The method of claim 16 wherein the schema and user interface metadata comprise entity relationships comprising one-to-many, many-to-one, and many-to-many relationships.

18. The method of claim 16 wherein the schema and user interface metadata additionally comprises platform attributes for abstracting syntactic differences between database implementations.

19. The method of claim 17 wherein the automatically developed user interface comprises context menus specific to type of entity relationship.

20. The method of claim 15 additionally comprising the step of adding non-automatically-generated functionality to the developed user interface selected from the group consisting of scripts, external components, business rules, and triggers.

21. The method of claim 15 additionally comprising the step of refreshing the metadata after schema changes are made to the relational database.