Interaction between databases and graphical user interfaces

• US 5,761,656 A
• Filed: 06/26/1995
• Issued: 06/02/1998
• Est. Priority Date: 06/26/1995
• Status: Expired due to Term

• Current Assignee: Oracle America, Inc. (Oracle Corporation)
• Original Assignee: NetDynamics, Inc. (Oracle Corporation)
• Inventors: Ben-Shachar, Ofer
• Primary Examiner(s): Black, Thomas G.
• Assistant Examiner(s): VON BUHR, MARIA N
• Application Number:
  US08/494,753
• Time in Patent Office: 1,072 Days
• Field of Search: 395/604, 395/326, 395/334, 395/339, 395/348, 395/680-684, 345/335, 345/348, 345/356, 345/357, 345/968, 707/4, 707/103
• US Class Current: 1/1
• CPC Class Codes: G06F 16/252 between a Database Management System and a front-end application
• CPC Class Codes: G06F 16/258 Data format conversion from or to a database
• CPC Class Codes: Y10S 707/99934 Query formulation, input preparation, or translation
• CPC Class Codes: Y10S 715/968 interface for database querying and retrieval

Abstract

To provide an interface between a computer application and a database, a user invokes the application and another program, called "link manager". The user "drags and drops" GUI objects from the application window to the link manager window to command the link manager to associate parameters of the GUI objects (e.g., object names) with input and output fields of database operations. The link manager records these associations in a mapping file. When later the application is executed, a program, called "execution manager", reads the mapping file. When the application issues a request to the database, the execution manager uses the mapping file to translate the request to the database format, converting values of parameters of GUI objects to input values of a database operation as defined by the mapping file. The execution manager translates the database response to the application format, converting output values of the response to values of application GUI parameters as defined by the mapping file.

Claims

1. A method for creating a mapping between a database and a graphical user interface (GUI) of a computer application, the method comprising:

executing the application in a computer system so that the application displays one or more GUI objects;

for each of one or more of the displayed GUI objects, instructing the computer system to associate a parameter of the GUI object with a corresponding input field of a request to be provided to the database to indicate that a value of the parameter is to be inserted in the input field when the request is to be provided from the application to the database; and

for each of one or more GUI objects, recording by the computer system, in a computer storage, a mapping between a parameter of the GUI object and the corresponding input field of the database request.

2. The method of claim 1 wherein the instructing process comprises:

displaying a representation of an input field of a database request;

pointing to a GUI object OBJ1 with a pointer device; and

dragging, with the pointer device, the object OBJ1 to the representation of the input field.

3. The method of claim 1 wherein the database request is a query.

4. The method of claim 1 wherein association of a parameter of the GUI object with an input field of the request to the database, and the recording process, are performed by a computer program executed in the computer system, and wherein the computer program comprises information on formats of requests that can be generated by the application for a database and on formats of responses accepted by the application in response to the requests, so that the computer program is able to perform the association and the recording process for any application having predetermined formats of requests generated for a database and of responses accepted.

5. The method of claim 1 wherein at least one GUI object is an HTML object.

6. The method of claim 1 wherein the application comprises an HTML browser.

7. The method of claim 1 wherein the database comprises a relational database.

8. The method of claim 1 wherein the database comprises an object oriented database.

9. The method of claim 1 wherein at least one GUI object is displayed by an X-windows server.

10. The method of claim 1 wherein the instructing and the recording are performed for each of a plurality of the displayed GUI objects.

11. The method of claim 1 further comprising:

for each of one or more of the displayed GUI objects, instructing the computer system to associate a parameter of the GUI object with a corresponding output field of a response to be generated by the database, to indicate that a value in the output field is to be provided to the application as a value of the parameter; and

for each of one or more GUI objects, recording by the computer system, in a computer storage, a mapping between a parameter of the GUI object and the corresponding output field of the database response.

12. The method of claim 3 wherein the query is SQL query.

13. A method for creating a mapping between a database and a graphical user interface (GUI) of a computer application, the method comprising:

executing the application in a computer system so that the application displays one or more GUI objects;

for each of one or more of the displayed GUI objects, instructing the computer system to associate a parameter of the GUI object with a corresponding output field of a response to be generated by the database, to indicate that a value in the output field is to be provided to the application as a value of the parameter; and

for each of one or more GUI objects, recording by the computer system, in a computer storage, a mapping between a parameter of the GUI object and the corresponding output field of the database response.

14. The method of claim 13 wherein the instructing process comprises:

displaying a representation of an output field of the database response;

pointing to a GUI object with a pointer device; and

dragging, with the pointer device, the GUI object to the representation of the output field.

15. The method of claim 13 wherein association of a parameter of the GUI object with an output field of the database response, and the recording process, are performed by a computer program executed in the computer system, and wherein the computer program comprises information on formats of requests that can be generated by the application for a database and formats of responses accepted by the application in response to the requests, so that the computer program is able to perform the association and the recording process for any application having predetermined formats of requests generated for a database and of responses accepted.

16. The method of claim 13 wherein at least one GUI object is an HTML object.

17. The method of claim 13 wherein the application comprises an HTML browser.

18. The method of claim 13 wherein the database comprises a relational database.

19. The method of claim 13 wherein the database comprises an object oriented database.

20. The method of claim 13 wherein at least one GUI object is displayed by an X-windows server.

21. The method of claim 13 wherein the instructing and the recording are performed for each of a plurality of the displayed GUI objects.

22. A computer-implemented structure for creating a mapping between a database and a graphical user interface (GUI) of a computer application, the structure comprising:

means for receiving from the computer application a parameter of a GUI object;

means for receiving information about an input field of a request to be provided to the database; and

means for recording in a computer storage a mapping between the parameter and the input field to indicate that a value of the parameter is to be inserted in the input field when the request is to be provided to the database.

23. The computer-implemented structure of claim 22 wherein at least one GUI object is an HTML object.

24. The computer-implemented structure of claim 22 wherein the application comprises an HTML browser.

25. The computer-implemented structure of claim 22 wherein the database comprises a relational database.

26. The computer-implemented structure of claim 22 wherein the database comprises an object oriented database.

27. The computer-implemented structure of claim 22 wherein the structure comprises (1) a computer system comprising the computer storage and (2) a program loaded into the computer system, the computer system and the program comprising each of said means.

28. The computer-implemented structure of claim 22 wherein the structure is a computer readable medium and wherein each means comprises one or more computer instructions, computer readable data, or a combination of one or more instructions and data.

29. A computer-implemented structure for creating a mapping between a database and a graphical user interface (GUI) of a computer application, the structure comprising:

means for identifying an output field of a response to be generated by the database;

means for receiving from the application a parameter of a GUI object; and

means for recording in a computer storage a mapping between the output field and the parameter to indicate that a value in the output field is to be provided to the application as a value of the parameter.

30. The computer-implemented structure of claim 29 wherein at least one GUI object is an HTML object.

31. The computer-implemented structure of claim 29 wherein the application comprises an HTML browser.

32. The computer-implemented structure of claim 29 wherein the database comprises a relational database.

33. The computer-implemented structure of claim 29 wherein the database comprises an object oriented database.

34. The computer-implemented structure of claim 29 wherein the structure comprises (1) a computer system comprising the computer storage and (2) a program loaded into the computer system, the computer system and the program comprising each of said means.

35. The computer-implemented structure of claim 29 wherein the structure is a computer readable medium and wherein each means comprises one or more computer instructions, computer readable data, or a combination of one or more instructions and data.

36. A method for providing a computer interface between a computer application and a computer database, the method comprising:

receiving from the application, by a computer program being executed in a computer system, a request R1 for the database, the request R1 comprising one or more values each of which is a value of a parameter of a graphical user interface (GUI) of the application;

creating in the computer system, by the computer program, a database request R2 corresponding to the request R1 and having a format suitable for sending the request R2 to the database, the request R2 having one or more input fields each of which has a value corresponding to a parameter value in the request R1; and

sending, by the computer program, the request R2 to the computer database,

wherein the computer program comprises information on formats of requests that can be generated by the application for a database and formats of responses accepted by the application in response to the requests to a database, so that the computer program is able to perform the recited processes for any computer application having predetermined formats of requests that can be generated by the application for a database and of responses accepted,

wherein the creating process comprises;

reading, by the computer program, first data defining a format of the request R2 and also defining a mapping between (1) one or more parameters of the application GUI and (2) one or more corresponding input fields of the request R2 such that an input field is mapped into a parameter whose value is to be provided in the input field; and

creating the request R2 so that the request R2 has the format defined by the first data and so that one or more input fields of the request R2 have values corresponding to the request R1 values of the corresponding parameters;

wherein the first data comprise one or more self-describing object fields each of which defines a format of a computer value, and

wherein the first data define;

for each of one or more parameters whose values are present in the request R1, a mapping from the parameter to a corresponding self-describing object field; and

for each self-describing object field corresponding to a parameter a mapping from the self-describing object field to a request R2 input field corresponding to the same parameter.

37. The method of claim 36 wherein at least one of the parameters is a name of an object of the application GUI.

38. The method of claim 36 wherein at least one of the parameters is a name of an attribute of an object of the application GUI.

39. The method of claim 36 wherein the first data contain no information about the application except information (1) on objects of the application GUI, (2) on formats of requests that can be generated by the application for a database, and (3) on formats of requests that the database can accept.

40. The method of claim 36 wherein the request R1 is received over a hypertext transfer protocol (HTTP).

41. The method of claim 36 wherein the application generates the request R1 using the PDF interface rules.

42. The method of claim 36 wherein the database comprises a relational database.

43. The method of claim 36 wherein the database comprises an object oriented database.

44. A method for providing a computer interface between a computer application and a computer database, the method comprising:

receiving from the database, by a computer program being executed in a computer system, a response R1 to a request, the response R1 including one or more values of database objects;

creating in the computer system, by the computer program, a response R2 corresponding to the response R1 and having a format suitable for sending the response R2 to the application, the response R2 having one or more output fields each of which is to have a value of a parameter of a graphical user interface (GUI) of the application, and providing, in each of one or more of the output fields, a value corresponding to a database object value from the response R1; and

sending, by the computer program, the response R2 to the application,

wherein the computer program comprises information on formats of requests that can be generated by the application to a database and formats of responses accepted by the application in response to the requests to a database, so that the computer program is able to perform the recited processes for any application having predetermined formats of requests that can be generated by the application for a database and of responses accepted,

wherein the creating process comprises;

reading, by the computer program, first data defining a format of the response R2 and also defining a mapping between (1) one or more database objects and (2) one or more corresponding output fields of the response R2; and

creating the response R2 so that the response R2 has the format defined by the first data and so that one or more output fields of the response R2 have values corresponding to the response R1 values of the corresponding database objects;

wherein the first data comprise one or more self-describing object fields each of which defines a format of a computer value, and

wherein the first data define;

for each of one or more data objects whose values are present in the response R1, a mapping from the database object to a corresponding self-describing object field; and

for each self-describing object field corresponding to a database object, a mapping from the self-describing object field to a response R2 output field corresponding to the same database object.

45. The method of claim 44 wherein at least one of the parameters is a name of an object of the application GUI.

46. The method of claim 44 wherein at least one of the parameters is a name of an attribute of an object of the application GUI.

47. The method of claim 44 wherein the first data contain no information about the application except information (1) on objects of the application GUI, (2) on formats of requests that can be generated by the application for a database, and (3) on formats of requests that the database can accept.

48. The method of claim 44 wherein the response R2 is sent to the application over an HTTP protocol.

49. The method of claim 44 wherein the application receives the response R2 according to the PDF interface rules.

50. The method of claim 44 wherein the database comprises a relational database.

51. The method of claim 44 wherein the database comprises an object oriented database.

52. A computer-implemented structure for providing a computer interface between a computer application and a computer database, the structure comprising:

means for receiving from the application, by a computer program being executed in a computer system, a request R1 for the database, the request R1 comprising one or more values each of which is a value of a parameter of a graphical user interface (GUI) of the application;

means for creating in the computer system, by the computer program, a database request R2 corresponding to the request R1 and having a format suitable for sending the request R2 to the database, the request R2 having one or more input fields each of which has a value corresponding to a parameter value in the request R1; and

means for sending, by the computer program, the request R2 to the computer database,

wherein the computer program comprises information on formats of requests that can be generated by the application for a database and formats of responses accepted by the application in response to the requests to a database, so that the computer program is able to perform the recited processes for any computer application having predetermined formats of requests that can be generated by the application for a database and of responses accepted,

wherein the means for creating comprises;

means for reading by the computer program, first data defining a format of the request R2 and also defining a mapping between (1) one or more parameters of the application GUI and (2) one or more corresponding input fields of the request R2 such that an input field is mapped into a parameter whose value is to be provided in the input fields; and

means for creating the request R2 so that the request R2 has the format defined by the first data and so that one or more input fields of the request R2 have values corresponding to the request R1 values of the corresponding parameters;

wherein the first data comprise one or more self-describing object fields each of which defines a format of a computer value; and

wherein the first data define;

for each of one or more parameters whose values are present in the request R1, a mapping from the parameter to the corresponding self-describing object field; and

for each self-describing object field correspond to a parameter, a mapping from the self-describing object field to the request R2 input field corresponding to the same parameter.

53. The computer-implemented structure of claim 52 wherein the structure comprises a computer system and a program loaded into the computer system, the computer system and the program comprising each of said means.

54. The computer-implemented structure of claim 52 wherein the structure is a computer readable medium and wherein each means comprises one or more computer instructions, computer readable data, or a combination of one or more instructions and data.

55. The computer-implemented structure of claim 52 wherein the means for receiving is to receive the request R1 over an HTTP protocol.

56. The computer-implemented structure of claim 52 wherein the request R1 conforms to the PDF interface rules.

57. The computer-implemented structure of claim 52 wherein the database comprises a relational database.

58. The computer-implemented structure of claim 52 wherein the database comprises an object oriented database.

59. A computer-implemented structure for providing a computer interface between a computer application and a computer database, the structure comprising:

means for receiving from the database, by a computer program being executed in a computer system, a response R1 to a request, the response R1 including one or more values of database objects;

means for creating in the computer system, by the computer program, a response R2 corresponding to the response R1 and having a format suitable for sending the response R2 to the application, the response R2 having one or more output fields each of which is to have a value of a parameter of a graphical user interface (GUI) of the application, and for providing, in each of one or more of the output fields, a value corresponding to a database object value from the response R1; and

means for sending, by the computer program, the response R2 to the application,

wherein the computer program comprises information on formats of requests that can be generated by the application to a database and formats of responses accepted by the application in response to the requests to a database, so that the computer program is able to perform the recited processes for any application having predetermined formats of requests that can be generated by the application for a database and of responses accepted,

wherein the means for creating comprises;

means for reading, by the computer program, first data defining a format of the response R2 and also defining a mapping between (1) one or more database objects and (2) one or more corresponding output fields of the response R2; and

means for creating the response R2 so that the response R2 has the format defined by the first data and so that one or more output fields of the response R2 have values corresponding to the response R1 values of the corresponding database objects;

wherein the first data comprising one or more self-describing object fields each of which defines a format of a computer value; and

wherein the first data define;

for each one or more data objects whose values are present in the response R1, a mapping from the database object to a corresponding self-describing object field; and

for each self-describing object field corresponding to a database object, a mapping from the self-describing object field to response R2 output field corresponding to the same database object.

60. The computer-implemented structure of claim 59 wherein the structure comprises a computer system and a program loaded into the computer system, the computer system and the program comprising each of said means.

61. The computer-implemented structure of claim 59 wherein the structure is a computer readable medium and wherein each means comprises one or more computer instructions, computer readable data, or a combination of one or more instructions and data.

62. The computer-implemented structure of claim 59 wherein the means for sending is to send the response R2 over HTTP protocol.

63. The computer-implemented structure of claim 59 wherein the response R2 conforms to the PDF interface rules.

64. The computer-implemented structure of claim 59 wherein the database comprises a relational database.

65. The computer-implemented structure of claim 59 wherein the database comprises an object oriented database.