Accessing domain object data stored in a relational database system

• US 6,484,180 B1
• Filed: 08/02/1999
• Issued: 11/19/2002
• Est. Priority Date: 08/02/1999
• Status: Expired due to Term

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle Corporation
• Inventors: Lyons, Liza, Harris, Larry, Lind, Barry, Broadbent, Christopher
• Primary Examiner(s): Breene, John
• Assistant Examiner(s): Ali, Mohammad
• Application Number:
  US09/365,663
• Time in Patent Office: 1,205 Days
• Field of Search: 707/102-103, 707/3, 707/6, 705/79, 705/34, 705/27, 705/7, 705/34.7, 709/215, 709/218, 709/249, 709/217, 709/201-203, 717/1, 706/46.61
• US Class Current: 1/1
• CPC Class Codes: G06F 16/284 Relational databases
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching
• CPC Class Codes: Y10S 707/99944 Object-oriented database structure

Abstract

A method and apparatus are provided for supplying data to users through “query objects”, where the data corresponds to attributes of domain objects and is stored in a relational database. The query objects create a bridge between the information the user wants to see (as expressed in the user interface presented to the user), the object model in which domain logic is implemented, and the relational model in which the data is stored. Thus, data used to populate the user interface is queried directly from the data model and returned in the shape required by the user interface. As the query results are read into memory, objects that model the data using object-oriented techniques are instantiated. Subsequent manipulation of the data is redirected to those objects, thereby preserving data encapsulation and allowing reuse of existing logic.

Claims

1. A method for accessing domain object data stored in a relational database system, the method comprising the steps of:

supplying to a client one or more data items that are attributes of one or more domain objects in a manner that circumvents the one or more domain objects by retrieving the one or more data items directly from one or more relational structures that contain the one or more data items; and

responding to manipulations of said one or more data items at said client by invoking methods of said one or more domain objects.

2. The method of claim 1 further comprising the step of, in response to retrieving the one or more data items directly from the one or more relational structures, instantiating said one or more domain objects without automatically fully populating said one or more domain objects.

3. The method of claim 2 wherein the step of instantiating said one or more domain objects includes initially populating only those attributes of said one or more domain objects that correspond to said one or more data items.

4. The method of claim 1 further comprising the step of responding to an invocation of a method of said one or more domain objects by retrieving from said relational database system values for only those attributes of said one or more domain objects that:

are required to execute said method; and

have not already been populated.

5. The method of claim 1 wherein:

the client is connected to a server over a network;

the method further comprises the step of, in response to retrieving the one or more data items directly from the one or more relational structures, instantiating said one or more domain objects on said server; and

the step of supplying to said client one or more data items is performed by sending, from said server to said client over said network, data for only those attributes of said one or more domain objects that are required by a user interface presented by said client.

6. The method of claim 2 further comprising the steps of:

retrieving a first set of primary keys associated with said one or more data items;

receiving a subsequent request from said client for a second set of one or more data items;

retrieving a second set of primary keys associated with said second set of one or more data items;

determining, based on said first set of primary keys and said second set of primary keys, whether domain objects corresponding to said second set of one or more data items have already been instantiated; and

instantiating the domain objects that correspond to said second set of one or more data items and that have not already been instantiated.

7. A computer-readable medium carrying one or more sequences of instructions for accessing domain object data stored in a relational database system, wherein execution of the one or more sequences of instructions by one or more processors causes the one or more processors to perform the steps of:

supplying to a client one or more data items that are attributes of one or more domain objects in a manner that circumvents the one or more domain objects by retrieving the one or more data items directly from one or more relational structures that contain the one or more data items; and

responding to manipulations of said one or more data items at said client by invoking methods of said one or more domain objects.

8. The computer-readable medium of claim 7 further comprising instructions for the step of, in response to retrieving the one or more data items directly from the one or more relational structures, instantiating said one or more domain objects without automatically fully populating said one or more domain objects.

9. The computer-readable medium of claim 8 wherein the step of instantiating said one or more domain objects includes initially populating only those attributes of said one or more domain objects that correspond to said one or more data items.

10. The computer-readable medium of claim 7 further comprising instructions for the step of responding to an invocation of a method of said one or more domain objects by retrieving from said relational database system values for only those attributes of said one or more domain objects that:

are required to execute said method; and

have not already been populated.

11. The computer-readable medium of claim 7 wherein:

the client is connected to a server over a network;

the computer-readable medium further comprises instructions for the step of, in response to retrieving the one or more data items directly from the one or more relational structures, instantiating said one or more domain objects on said server; and

the step of supplying to said client one or more data items is performed by sending, from said server to said client over said network, data for only those attributes of said one or more domain objects that are required by a user interface presented by said client.

12. The computer-readable medium of claim 8 further comprising the instructions for the steps of:

retrieving a first set of primary keys associated with said one or more data items;

receiving a subsequent request from said client for a second set of one or more data items;

retrieving a second set of primary keys associated with said second set of one or more data items;

determining, based on said first set of primary keys and said second set of primary keys, whether domain objects corresponding to said second set of one or more data items have already been instantiated; and

instantiating the domain objects that correspond to said second set of one or more data items and that have not already been instantiated.

13. A method for accessing a set of data items stored in a relational database system that are required by a user interface displayed by a client, wherein the set of data items correspond to a set of attributes that belong to one or more domain objects, the method comprising the steps of:

retrieving said set of data items to populate said user interface without invoking methods of said domain objects by issuing to a server a query that selects said set of data items; and

responding to manipulations of said set of data items at said client by calling methods provided by said domain objects.

14. The method of claim 13 further comprising the step of, in response to retrieving said set of data items, instantiating said one or more domain objects without automatically fully populating said one or more domain objects.

15. The method of claim 14 wherein the step of instantiating said one or more domain objects includes initially populating only those attributes of said one or more domain objects that correspond to said set of data items.

16. The method of claim 13 further comprising the step of responding to an invocation of a method of said one or more domain objects by retrieving from said relational database system values for only those attributes of said one or more domain objects that:

are required to execute said method; and

have not already been populated.

17. The method of claim 13 wherein:

the client is connected to the server over a network;

the method further comprises the step of, in response to retrieving said set of data items, instantiating said one or more domain objects on said server; and

said set of data items are supplied to said client by sending, from said server to said client over said network, data for only those attributes of said one or more domain objects that are required by said user interface.

18. A computer-readable medium carrying one or more sequences of instructions for accessing a set of data items stored in a relational database system that are required by a user interface displayed by a client, wherein execution of the one or more sequences of instructions by one or more processors causes the one or more processors to perform the steps of:

retrieving said set of data items to populate said user interface without invoking methods of said domain objects by issuing to a server a query that selects said set of data items; and

responding to manipulations of said set of data items at said client by calling methods provided by said domain objects.

19. The computer-readable medium of claim 18 wherein the steps further comprise the step of, in response to retrieving said set of data items, instantiating said one or more domain objects without automatically fully populating said one or more domain objects.

20. The computer-readable medium of claim 19 wherein the step of instantiating said one or more domain objects includes initially populating only those attributes of said one or more domain objects that correspond to said set of data items.

21. The computer-readable medium of claim 18 wherein the steps further comprise the step of responding to an invocation of a method of said one or more domain objects by retrieving from said relational database system values for only those attributes of said one or more domain objects that:

are required to execute said method; and

have not already been populated.

22. The computer-readable medium of claim 18 wherein:

the client is connected to the server over a network;

wherein the steps further comprise the step of, in response to retrieving said set of data items, instantiating said one or more domain objects on said server; and

said set of data items are supplied to said client by sending, from said server to said client over said network, data for only those attributes of said one or more domain objects that are required by said user interface.

23. A computer system for accessing domain object data stored in a relational database system, the computer system being configured to perform the following steps:

supplying to a client one or more data items that are attributes of one or more domain objects in a manner that circumvents the one or more domain objects by retrieving the one or more data items directly from one or more relational structures that contain the one or more data items; and

responding to manipulations of said one or more data items at said client by invoking methods of said one or more domain objects.

24. The computer system of claim 23 where the steps further comprise, in response to retrieving the one or more data items directly from the one or more relational structures, instantiating said one or more domain objects without automatically fully populating said one or more domain objects.

25. The computer system of claim 24 wherein the step of instantiating said one or more domain objects includes initially populating only those attributes of said one or more domain objects that correspond to said one or more data items.

26. The computer system of claim 23, wherein the steps further comprise responding to an invocation of a method of said one or more domain objects by retrieving from said relational database system values for only those attributes of said one or more domain objects that:

are required to execute said method; and

have not already been populated.

27. The computer system of claim 23 wherein:

the client is connected to a server over a network;

the steps further comprise the step of, in response to retrieving the one or more data items directly from the one or more relational structures, instantiating said one or more domain objects on said server; and

the step of supplying to said client one or more data items is performed by sending, from said server to said client over said network, data for only those attributes of said one or more domain objects that are required by a user interface presented by said client.

28. The computer system of claim 24, wherein the steps further comprise:

retrieving a first set of primary keys associated with said one or more data items;

receiving a subsequent request from said client for a second set of one or more data items;

retrieving a second set of primary keys associated with said second set of one or more data items;

determining, based on said first set of primary keys and said second set of primary keys, whether domain objects corresponding to said second set of one or more data items have already been instantiated; and

instantiating the domain objects that correspond to said second set of one or more data items and that have not already been instantiated.

29. A computer system for accessing a set of data items stored in a relational database system that are required by a user interface displayed by a client, wherein the set of data items correspond to a set of attributes that belong to one or more domain objects, said computer system configured to perform the steps of:

retrieving said set of data items to populate said user interface without invoking methods of said domain objects by issuing to a server a query that selects said set of data items; and

responding to manipulations of said set of data items at said client by calling methods provided by said domain objects.

30. The computer system of claim 29, wherein the steps further comprise the step of, in response to retrieving said set of data items, instantiating said one or more domain objects without automatically fully populating said one or more domain objects.

31. The computer system of claim 30, wherein the step of instantiating said one or more domain objects includes initially populating only those attributes of said one or more domain objects that correspond to said set of data items.

32. The computer system of claim 29, wherein the steps further comprise responding to an invocation of a method of said one or more domain objects by retrieving from said relational database system values for only those attributes of said one or more domain objects that:

are required to execute said method; and

have not already been populated.

33. The computer system of claim 29 wherein:

the client is connected to the server over a network;

the steps further comprise the step of, in response to retrieving said set of data items, instantiating said one or more domain objects on said server; and

said set of data items are supplied to said client by sending, from said server to said client over said network, data for only those attributes of said one or more domain objects that are required by said user interface.