Patent FR935310A successfully refreshed from Google Patents.
Patent US4321601A successfully refreshed from Google Patents.
Patent US5560005A successfully refreshed from Google Patents.
US5560005A
Expired / Lapsed
US
⏱️ 0.0 years remaining
Methods and systems for object-based relational distributed databases
Assignee: Change Healthcare Holdings LLC
•
Filing: 1994-02-25
•
Granted: 1996-09-24
•
Expires: 2014-02-25
Abstract
Abstract An object-based relational distributed database system and associated methods of operation that transforms data stored in a plurality of remote, heterogeneous user databases into a homogeneous data model is disclosed. Data stored in distributed, heterogeneous user database structures is homogenized by mapping into object attributes of predetermined instances of objects forming to a conceptual model that relates the various heterogeneous databases. The object attributes are stored in remote databases at client sites, which can be separate computer systems from the heterogeneous user databases or separate processes running on a computer system that maintains the heterogeneous user databases. The system stores location information and status information relating to the homogenized data in a centralized object broker for object management, thereby facilitating location and retrieval of data items from one or more of the remote, heterogeneous user databases.
Inventors
- 👤 Michael K. Hoover
- 👤 Barrick H. Miller
- 👤 Kurt Schurenberg
- 👤 Richard A. Daigle
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-11-05 02:59
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/20; G06F16/27; G06F16/24; G06F16/245
Claims Analysis
Total Claims: 89
Claim 1
Independent Claim
283 words
A method of operating a distributed data processing system including a plurality of independent remotely located user computers that process user data in user databases and at least one object broker computer, the user computers being interconnected with the object broker computer by data communication hardware over a data communication network, the user computers being operative to perform data operations of storing, updating, and retrieving user data items in response to user commands, comprising the steps of: (a) for a subject at one of the user computers for which data is to be processed in the system, creating an object instance by assigning a unique object identifier to data items associated with the subject by: (a1) providing a global object identification address space corresponding to a range of object identifiers for association with a plurality of subjects; and (a2) allocating a predetermined range of object identifiers within the global object identification address space to each remotely located user computer; (b) storing the data items associated with the subject at the user computer in association with the object identifier; (c) at the object broker computer, storing the locations of the user computers in a mapping table in association with object identifiers; (d) in response to a query to the object broker computer for data relating to a particular subject in question, retrieving a selected object identifier for the subject in question; (e) in response to retrieval of an object identifier for the subject in question in the preceding step, retrieving the location of a remote user computer associated with the selected object identifier; and (f) retrieving data stored at the remote user computer associated with the selected object identifier via the data communication network.
Claim 2
Independent Claim
283 words
A method of operating a distributed data processing system including a plurality of independent remotely located user computers that process user data in user databases and at least one object broker computer, the user computers being interconnected with the object broker computer by data communication hardware over a data communication network, the user computers being operative to perform data operations of storing, updating, and retrieving user data items in response to user commands, comprising the steps of: (a) for a subject at one of the user computers for which data is to be processed in the system, creating an object instance by assigning a unique object identifier to data items associated with the subject by: (a1) providing a global object identification address space corresponding to a range of object identifiers for association with a plurality of subjects; and (a2) allocating a predetermined range of object identifiers within the global object identification address space to each remotely located user computer; (b) storing the data items associated with the subject at the user computer in association with the object identifier; (c) at the object broker computer, storing the locations of the user computers in a mapping table in association with object identifiers; (d) in response to a query to the object broker computer for data relating to a particular subject in question, retrieving a selected object identifier for the subject in question; (e) in response to retrieval of an object identifier for the subject in question in the preceding step, retrieving the location of a remote user computer associated with the selected object identifier; and (f) retrieving data stored at the remote user computer associated with the selected object identifier via the data communication network.
Claim 3
Dependent Claim
68 words
The method of claim 1, wherein each of the remotely located user computers comprises a heterogeneous data structure, and further comprising the steps of: at the user computers, mapping predetermined data items stored in the user computers to corresponding object attributes associated with a predetermined instance of an object; storing the object attributes in an object attribute table in the remote user computers in association with object identifiers.
Claim 4
Dependent Claim
52 words
The method of claim 1, wherein the step of allocating a predetermined range of object identifiers is carried out at the object broker computer, and wherein a new object instance is created by assigning a unique object identifier from a predetermined range of object identifiers is carried out at the user computers.
Claim 5
Dependent Claim
65 words
The method of claim 1, wherein the query to the object broker originates at a first user computer, and the data associated with the selected object identifier is stored at a second user computer, and further comprising the step of communicating data retrieved, associated with the selected object identifier, to the object broker and then to the first user computer via the data communication network.
Claim 6
Dependent Claim
31 words
The method of claim 1, wherein the data items associated with the subject stored at the user computer in association with the object identifier are stored in an object attribute table.
Claim 7
Dependent Claim
37 words
The method of claim 5, wherein the remotely located user computers include at least one customer database and at least one remote database associated therewith, and wherein the object attribute table is stored in the remote database.
Claim 8
Dependent Claim
34 words
The method of claim 1, further comprising the step of maintaining an object index table at the object broker computer for relating at least one predetermined search term to at least one object identifier.
Claim 9
Dependent Claim
60 words
The method of claim 7, wherein the object index table for relating at least one predetermined search term to at least one object identifier is a relational base table, and further comprising the step of maintaining a junction index table relating object identifiers corresponding to a first class of objects to object identifiers corresponding to a second class of objects.
Claim 10
Dependent Claim
73 words
The method of claim 1, wherein the user computers are located at a user computer site including at least one customer database and at least one remote database associated therewith, the at least one remote database storing an object attribute table for relating object attributes to object identifiers, and wherein the object broker computer stores an object index table for relating at least one predetermined search term to at least one object identifier.
Claim 11
Dependent Claim
145 words
The method of claim 9, further comprising the steps of: in response to an add request at one of the user computers to add a subject to the system, providing selected data items associated with the subject to be added from the customer database to the remote database; at the remote database, carrying out the step of creating new object instance by assigning a new object identifier to data items associated with the subject; communicating information relating the new object identifier to at least one corresponding search term to the object broker computer; at the object broker computer, updating the object index table to reflect the association of the new object identifier, the corresponding search term; at the object broker computer, updating the mapping table to reflect the location of the user computer that added the new object instance identified by the new object identifier.
Claim 12
Dependent Claim
110 words
The method of claim 9, further comprising the steps of: in response to a search request at a querying one of the user computers to determine whether an object exists corresponding to a selected search term, communicating the selected search term to the object broker computer; at the object broker computer, consulting the object index table to determine whether there is an object identifier associated with the selected search term; in response to a determination that there is an object identifier associated with the selected search term, retrieving the corresponding object identifier; providing a message to the querying user computer via the data communication network including the corresponding object identifier.
Claim 13
Dependent Claim
146 words
The method of claim 9, further comprising the steps of: in response to a get request at a requesting one of the user computers based on a particular object identifier, communicating the particular object identifier to the object broker computer; at the object broker computer, consulting the mapping table based on the particular object identifier to identify a particular remote database at a particular user computer site; communicating a get message to the particular remote database at the particular user computer site including the particular object identifier; at the particular remote database, consulting an object attribute table index to obtain retrieval information corresponding to the particular object identifier in the particular object attribute table; retrieving object attributes associated with the particular object identifier from the particular object attribute table; and communicating retrieved object attributes to the object broker computer and thence to the requesting user computer.
Claim 14
Dependent Claim
219 words
The method of claim 9, further comprising the steps of: in response to a get all request at a requesting one of the user computers based on a particular object identifier that is related to one or more related object identifiers, communicating the particular object identifier to the object broker computer; at the object broker computer, consulting an object index table that relates object identifiers of a first type to object identifiers of a second type to retrieve one or more related object identifiers associated with the particular object identifier; at the object broker computer, consulting the mapping table based on retrieved related object identifiers to identify a one or more object attribute tables at one or more particular remote databases at one or more user computer sites containing data on the related object identifiers; communicating a get message to the one or more remote databases including the related object identifiers; at the one or more particular remote databases, consulting one or more object attribute table indexes to obtain retrieval information corresponding to the related object identifiers in the one or more object attribute tables; retrieving object attributes associated with the related object identifiers from the one or more object attribute tables; and communicating retrieved object attributes to the object broker computer and thence to the requesting user computer.
Claim 15
Dependent Claim
214 words
The method of claim 9, further comprising the steps of: in response to an update request at an updating one of the user computers based on a particular object identifier for which one or more object attributes are to be updated, communicating the particular object identifier to the object broker computer together with the one or more object attributes to be updated; at the object broker computer, consulting the mapping table based the particular object identifier to identify an object attribute table at a particular remote database at a user computer site containing the most current data corresponding to the particular object identifier; communicating a get message to the particular remote database including the particular object identifier; at the particular remote database, consulting an object attribute table index to obtain retrieval information corresponding to the particular object identifier in the object attribute table; retrieving object attributes associated with the particular object identifier from the object attribute table; communicating retrieved object attributes to the object broker computer; at the object broker computer, updating the retrieved object attributes with the one or more object attributes to be updated, to obtain updated object attributes associated with the particular object attribute; communicating the updated object attributes to the updating user computer for storage in the associated remote database.
Claim 16
Dependent Claim
42 words
The method of claim 14, further comprising the step of updating the mapping table and object index tables at the object broker computer to reflect that the updating user computer now has the most current information associated with the particular object identifier.
Claim 17
Dependent Claim
29 words
The method of claim 14, wherein the updating user computer is the same as the particular remote database containing the most current data corresponding to the particular object identifier.
Claim 18
Dependent Claim
52 words
The method of claim 14, wherein the remote database at the updating user computer did previously contain object attributes associated with the particular object identifier in an object attribute table, and further comprising the step of updating selected updated object attributes in the object attribute table associated with the particular object identifier.
Claim 19
Dependent Claim
32 words
The method of claim 14, wherein the updating user computer is at a different user site as the particular remote database containing the most current data corresponding to the particular object identifier.
Claim 20
Dependent Claim
56 words
The method of claim 18, wherein the remote database at the updating user computer did not previously contain any object attributes associated with the particular object identifier, and further comprising the step of adding the updated object attributes to an object attribute table associated with the updating user computer in association with the particular object identifier.
Claim 21
Dependent Claim
19 words
The method of claim 1, wherein the mapping table stores information relating object identifiers, status information, and location information.
Claim 22
Dependent Claim
54 words
The method of claim 20, wherein the user computers are located at a user computer site including at least one customer database and at least one remote database associated therewith, and wherein the location information relates to a data communications location for a remote database that stores data items in association with object identifiers.
Claim 23
Dependent Claim
50 words
The method of claim 21, wherein data items comprise at least one object attribute stored in at least one object attribute table maintained in the at least one remote database, and wherein the location information comprises information identifying at least one object attribute table in at least one remote database.
Claim 24
Dependent Claim
30 words
The method of claim 22, wherein the status information comprises date information identifying which one of a possible pluralities of occurrences of a selected object identifier is the most current.
Claim 25
Dependent Claim
32 words
The method of claim 1, wherein each of the user computers are located at a user computer site including at least one customer database and at least one remote database associated therewith.
Claim 26
Dependent Claim
44 words
The method of claim 24, wherein at least one customer database is a heterogeneous database structure relative to at least one other computer system in the distributed system, and wherein the at least one remote database is homogeneous relative to the object broker computer.
Claim 27
Dependent Claim
30 words
The method of claim 24, wherein the at least one customer database runs on a different computer system than a computer system that runs the at least one remote database.
Claim 28
Dependent Claim
25 words
The method of claim 24, wherein the at least one customer database runs on the same computer system as the at least one remote database.
Claim 29
Dependent Claim
61 words
The method of claim 24, wherein at least one user computer in the distributed data processing system includes a customer database of a first database structure, and at least one other user computer in the distributed data processing system includes a customer database of a second database structure different from the first database structure so that such database structures are heterogeneous.
Claim 30
Dependent Claim
56 words
The method of claim 24, wherein the remote database associated with each user computer site is operative for performing the steps of creating a new object instance, storing data items in association with the object identifier, and retrieving data stored at the remote user computer associated with an object identifier provided by the object broker computer.
Claim 31
Dependent Claim
30 words
The method of claim 29, wherein the remote database is further operative for communicating location information and related object identifiers to the object broker computer via the data communications network.
Claim 32
Dependent Claim
64 words
The method of claim 24, wherein the step of storing the data items associated with the subject at the user computer in association with the object identifier comprises the steps of: importing data items from a customer database into an associated remote database as selected data attributes associated with a particular object identifier, and communicating the particular object identifier to the object broker computer.
Claim 33
Dependent Claim
35 words
The method of claim 31, wherein the step of communicating the particular object identifier to the object broker computer includes communicating predetermined search terms associated with the selected data attributes to the object broker computer.
Claim 34
Dependent Claim
61 words
The method of claim 32, further comprising the step of storing the predetermined search terms in an object attribute index stored at the object broker computer, the object attribute index relating object identifiers and search terms, and storing location information and status information indicative of the source and status of the object attributes and the object identifier in the mapping table.
Claim 35
Dependent Claim
77 words
The method of claim 31, wherein the step of importing data items from the customer database comprises the steps of: importing a first set of data items from the customer database as object attributes associated with a first object identifier; determining that the first object identifier is related to at least one additional second object identifier; and importing a second set of data items from the customer database as object attributes associated with the second object identifier.
Claim 36
Dependent Claim
45 words
The method of claim 34, wherein the steps of importing comprise importing object attributes associated with the second object identifier that are in a dependent relationship to object attributes associated with the first object identifier in a predetermined order so as to preserve dependency relationships.
Claim 37
Dependent Claim
118 words
The method of claim 34, further comprising the steps of: storing object attributes associated with the first object identifier in a first object attribute table; storing the first object identifier and the second object identifier in a junction table relating object identifiers to each other; storing object attributes associated with the second object identifier in a second object attribute table; in response to a determination that the storing of object attributes for the second object identifier calls for information corresponding to the first object identifier, storing the, first object identifier in a corresponding field in the second object attribute table, whereby reference to the second object identifier causes referral to the first object identifier for selected object attributes.
Claim 38
Dependent Claim
38 words
The method of claim 24, wherein each remote database at each user computer site comprises a homogeneous data structure, and further comprising the step of importing selected data items from an associated customer database into the remote database.
Claim 39
Dependent Claim
48 words
The method of claim 37, wherein the step of importing selected data items from an associated customer database into the remote database comprises the step of mapping data items in a heterogeneous data structure on a customer database into predetermined object attributes stored in the associated remote database.
Claim 40
Dependent Claim
27 words
The method of claim 38, wherein the step of importing occurs in response to a put request message provided by a user at a user computer site.
Claim 41
Dependent Claim
30 words
The method of claim 38, wherein the step of importing comprises entering data items from the heterogeneous data structure into an object attribute table maintained at the associated remote database.
Claim 42
Dependent Claim
39 words
The method of claim 40, further comprising the step of maintaining an object attribute table index at the remote database to allow rapid searching for particular object attributes stored in an object attribute table in the respective remote database.
Claim 43
Dependent Claim
29 words
The method of claim 41, wherein the object attribute table index comprises a table relating an object identifier to one or more data items associated with the object identifier.
Claim 44
Independent Claim
321 words
A method of operating a distributed data processing system including a plurality of independent remotely located user computers that process user data in user databases, the user computers being interconnected for data communications by data communication hardware over a data communication network, the user computers being operative to perform data operations of storing, updating, and retrieving user data items in response to user commands, comprising the steps of: (a) providing a location service storing information relating object identifiers and location information associated with subsets of data items stored in the plurality of user computers; (b) associating a first object identifier with a selected first set of user data items relating to a first logical object; (c) associating a second object identifier with a selected second set of user data items relating to a second logical object; (d) associating a third object identifier with a third set of user data items relating to a third logical object, the third set of user data items including particular data items corresponding to the first logical object and the second logical object; (e) in response to a selected search term relating to the third logical object originating at one of the user computers, searching an object index relating search terms to the object identifiers to obtain the third object identifier; (f) consulting the location service based on the third object identifier to obtain the related first object identifier and second object identifier; (g) determining selected locations of a user computer storing data items associated with the first object identifier and a user computer storing data items associated with the second object identifier; (h) retrieving data items associated with the first object identifier and the second object identifier from the selected user computers; and (i) joining the retrieved selected data items associated with the first object identifier and the second object identifier to obtain a complete set of data items associated with the third object identifier.
Claim 45
Independent Claim
321 words
A method of operating a distributed data processing system including a plurality of independent remotely located user computers that process user data in user databases, the user computers being interconnected for data communications by data communication hardware over a data communication network, the user computers being operative to perform data operations of storing, updating, and retrieving user data items in response to user commands, comprising the steps of: (a) providing a location service storing information relating object identifiers and location information associated with subsets of data items stored in the plurality of user computers; (b) associating a first object identifier with a selected first set of user data items relating to a first logical object; (c) associating a second object identifier with a selected second set of user data items relating to a second logical object; (d) associating a third object identifier with a third set of user data items relating to a third logical object, the third set of user data items including particular data items corresponding to the first logical object and the second logical object; (e) in response to a selected search term relating to the third logical object originating at one of the user computers, searching an object index relating search terms to the object identifiers to obtain the third object identifier; (f) consulting the location service based on the third object identifier to obtain the related first object identifier and second object identifier; (g) determining selected locations of a user computer storing data items associated with the first object identifier and a user computer storing data items associated with the second object identifier; (h) retrieving data items associated with the first object identifier and the second object identifier from the selected user computers; and (i) joining the retrieved selected data items associated with the first object identifier and the second object identifier to obtain a complete set of data items associated with the third object identifier.
Claim 46
Dependent Claim
40 words
The method of claim 43, wherein the distributed data processing system includes at least one central computer operative for providing the location service, the object index, and issuing requests to user computers to retrieve data items corresponding to object identifiers.
Claim 47
Dependent Claim
18 words
The method of claim 43, wherein each of the remotely located user computers comprises a heterogeneous data structure.
Claim 48
Dependent Claim
57 words
The method of claim 43, wherein each of the remotely located user computers are located at a user site including at least one customer database and at least one remote database associated therewith, wherein said at least one customer database is a heterogeneous database structure relative to at least one other computer system in the distributed system.
Claim 49
Independent Claim
470 words
A method of operating a distributed data processing system including a plurality of independent remotely located user computers that process user data in user databases and at least one object broker computer, the user computers being interconnected with the object broker computer by data communication hardware over a data communication network, the user computers being located at a user computer site including at least one customer database and at least one remote database associated therewith, the user computers being operative to perform data operations of storing, updating, and retrieving user data items in response to user commands, comprising the steps of: (a) for a subject at one of the user computers for which data is to be processed in the system, creating an object instance by assigning a unique object identifier to data items associated with the subject; (b) storing the data items associated with the subject at the user computer in association with the object identifier by: (b1) importing data items from a customer database into an associated remote database as selected data attributes associated with a particular object identifier by: (b1a) importing a first set of data items from the customer database as object attributes associated with a first object identifier; (b1b) determining that the first object identifier is related to at least one additional second object identifier; and (b1c) importing a second set of data items from the customer database as object attributes associated with the second object identifier; and (b2) communicating the particular object identifier to the object broker computer; (c) at the object broker computer, storing the locations of the user computers in a mapping table in association with object identifiers; (d) in response to a query to the object broker computer for data relating to a particular subject in question, retrieving a selected object identifier for the subject in question; (e) in response to retrieval of an object identifier for the subject in question in the preceding step, retrieving the location of a remote user computer associated with the selected object identifier; (f) retrieving data stored at the remote user computer associated with the selected object identifier via the data communication network; (g) storing object attributes associated with the first object identifier in a first object attribute table; (h) storing the first object identifier and the second object identifier in a junction table relating object identifiers to each other; (i) storing object attributes associated with the second object identifier in a second object attribute table; (j) in response to a determination that the storing of object attributes for the second object identifier calls for information corresponding to the first object identifier, storing the first object identifier in a corresponding field in the second object attribute table, whereby reference to the second object identifier causes referral to the first object identifier for selected object attributes.
Claim 50
Independent Claim
470 words
A method of operating a distributed data processing system including a plurality of independent remotely located user computers that process user data in user databases and at least one object broker computer, the user computers being interconnected with the object broker computer by data communication hardware over a data communication network, the user computers being located at a user computer site including at least one customer database and at least one remote database associated therewith, the user computers being operative to perform data operations of storing, updating, and retrieving user data items in response to user commands, comprising the steps of: (a) for a subject at one of the user computers for which data is to be processed in the system, creating an object instance by assigning a unique object identifier to data items associated with the subject; (b) storing the data items associated with the subject at the user computer in association with the object identifier by: (b1) importing data items from a customer database into an associated remote database as selected data attributes associated with a particular object identifier by: (b1a) importing a first set of data items from the customer database as object attributes associated with a first object identifier; (b1b) determining that the first object identifier is related to at least one additional second object identifier; and (b1c) importing a second set of data items from the customer database as object attributes associated with the second object identifier; and (b2) communicating the particular object identifier to the object broker computer; (c) at the object broker computer, storing the locations of the user computers in a mapping table in association with object identifiers; (d) in response to a query to the object broker computer for data relating to a particular subject in question, retrieving a selected object identifier for the subject in question; (e) in response to retrieval of an object identifier for the subject in question in the preceding step, retrieving the location of a remote user computer associated with the selected object identifier; (f) retrieving data stored at the remote user computer associated with the selected object identifier via the data communication network; (g) storing object attributes associated with the first object identifier in a first object attribute table; (h) storing the first object identifier and the second object identifier in a junction table relating object identifiers to each other; (i) storing object attributes associated with the second object identifier in a second object attribute table; (j) in response to a determination that the storing of object attributes for the second object identifier calls for information corresponding to the first object identifier, storing the first object identifier in a corresponding field in the second object attribute table, whereby reference to the second object identifier causes referral to the first object identifier for selected object attributes.
Claim 51
Dependent Claim
68 words
The method of claim 47, wherein each of the remotely located user computers comprises a heterogeneous data structure, and further comprising the steps of: at the user computers, mapping predetermined data items stored in the user computers to corresponding object attributes associated with a predetermined instance of an object; storing the object attributes in an object attribute table in the remote user computers in association with object identifiers.
Claim 52
Dependent Claim
44 words
The method of claim 47, wherein at least one customer database is a heterogeneous database structure relative to at least one other computer system in the distributed system, and wherein the at least one remote database is homogeneous relative to the object broker computer.
Claim 53
Dependent Claim
30 words
The method of claim 47, wherein the at least one customer database runs on a different computer system than a computer system that runs the at least one remote database.
Claim 54
Dependent Claim
25 words
The method of claim 47, wherein the at least one customer database runs on the same computer system as the at least one remote database.
Claim 55
Dependent Claim
73 words
The method of claim 47, wherein the user computers are located at a user computer site including at least one customer database and at least one remote database associated therewith, the at least one remote database storing an object attribute table for relating object attributes to object identifiers, and wherein the object broker computer stores an object index table for relating at least one predetermined search term to at least one object identifier.
Claim 56
Dependent Claim
145 words
The method of claim 52, further comprising the steps of: in response to an add request at one of the user computers to add a subject to the system, providing selected data items associated with the subject to be added from the customer database to the remote database; at the remote database, carrying out the step of creating new object instance by assigning a new object identifier to data items associated with the subject; communicating information relating the new object identifier to at least one corresponding search term to the object broker computer; at the object broker computer, updating the object index table to reflect the association of the new object identifier, the corresponding search term; at the object broker computer, updating the mapping table to reflect the location of the user computer that added the new object instance identified by the new object identifier.
Claim 57
Dependent Claim
146 words
The method of claim 52, further comprising the steps of: in response to a get request at a requesting one of the user computers based on a particular object identifier, communicating the particular object identifier to the object broker computer; at the object broker computer, consulting the mapping table based on the particular object identifier to identify a particular remote database at a particular user computer site; communicating a get message to the particular remote database at the particular user computer site including the particular object identifier; at the particular remote database, consulting an object attribute table index to obtain retrieval information corresponding to the particular object identifier in the particular object attribute table; retrieving object attributes associated with the particular object identifier from the particular object attribute table; and communicating retrieved object attributes to the object broker computer and thence to the requesting user computer.
Claim 58
Dependent Claim
219 words
The method of claim 52, further comprising the steps of: in response to a get all request at a requesting one of the user computers based on a particular object identifier that is related to one or more related object identifiers, communicating the particular object identifier to the object broker computer; at the object broker computer, consulting an object index table that relates object identifiers of a first type to object identifiers of a second type to retrieve one or more related object identifiers associated with the particular object identifier; at the object broker computer, consulting the mapping table based on retrieved related object identifiers to identify a one or more object attribute tables at one or more particular remote databases at one or more user computer sites containing data on the related object identifiers; communicating a get message to the one or more remote databases including the related object identifiers; at the one or more particular remote databases, consulting one or more object attribute table indexes to obtain retrieval information corresponding to the related object identifiers in the one or more object attribute tables; retrieving object attributes associated with the related object identifiers from the one or more object attribute tables; and communicating retrieved object attributes to the object broker computer and thence to the requesting user computer.
Claim 59
Dependent Claim
214 words
The method of claim 52, further comprising the steps of: in response to an update request at an updating one of the user computers based on a particular object identifier for which one or more object attributes are to be updated, communicating the particular object identifier to the object broker computer together with the one or more object attributes to be updated; at the object broker computer, consulting the mapping table based the particular object identifier to identify an object attribute table at a particular remote database at a user computer site containing the most current data corresponding to the particular object identifier; communicating a get message to the particular remote database including the particular object identifier; at the particular remote database, consulting an object attribute table index to obtain retrieval information corresponding to the particular object identifier in the object attribute table; retrieving object attributes associated with the particular object identifier from the object attribute table; communicating retrieved object attributes to the object broker computer; at the object broker computer, updating the retrieved object attributes with the one or more object attributes to be updated, to obtain updated object attributes associated with the particular object attribute; communicating the updated object attributes to the updating user computer for storage in the associated remote database.
Claim 60
Independent Claim
314 words
A method of operating a distributed data processing system including a plurality of independent remotely located user computers that process user data in user databases and at least one object broker computer, the user computers being interconnected with the object broker computer by data communication hardware over a data communication network, the user computers being operative to perform data operations of storing, updating, and retrieving user data items in response to user commands, comprising the steps of: (a) for a subject at one of the user computers for which data is to be processed in the system, creating an object instance by assigning a unique object identifier to data items associated with the subject; (b) storing the data items associated with the subject at the user computer in association with the object identifier; (c) at the object broker computer, storing the locations of the user computers in a mapping table in association with object identifiers; (d) in response to a query to the object broker computer for data relating to a particular subject in question, retrieving a selected object identifier for the subject in question; (e) in response to retrieval of an object identifier for the subject in question in the preceding step, retrieving the location of a remote user computer associated with the selected object identifier; (f) retrieving data stored at the remote user computer associated with the selected object identifier via the data communication network; (g) maintaining an object index table at the object broker computer for relating at least one predetermined search term to at least one object identifier, wherein the object index table for relating at least one predetermined search term to at least one object identifier is a relational data base table; and (h) maintaining a junction index table relating object identifiers corresponding to a first class of objects to object identifiers corresponding to a second class of objects.
Claim 61
Independent Claim
314 words
A method of operating a distributed data processing system including a plurality of independent remotely located user computers that process user data in user databases and at least one object broker computer, the user computers being interconnected with the object broker computer by data communication hardware over a data communication network, the user computers being operative to perform data operations of storing, updating, and retrieving user data items in response to user commands, comprising the steps of: (a) for a subject at one of the user computers for which data is to be processed in the system, creating an object instance by assigning a unique object identifier to data items associated with the subject; (b) storing the data items associated with the subject at the user computer in association with the object identifier; (c) at the object broker computer, storing the locations of the user computers in a mapping table in association with object identifiers; (d) in response to a query to the object broker computer for data relating to a particular subject in question, retrieving a selected object identifier for the subject in question; (e) in response to retrieval of an object identifier for the subject in question in the preceding step, retrieving the location of a remote user computer associated with the selected object identifier; (f) retrieving data stored at the remote user computer associated with the selected object identifier via the data communication network; (g) maintaining an object index table at the object broker computer for relating at least one predetermined search term to at least one object identifier, wherein the object index table for relating at least one predetermined search term to at least one object identifier is a relational data base table; and (h) maintaining a junction index table relating object identifiers corresponding to a first class of objects to object identifiers corresponding to a second class of objects.
Claim 62
Dependent Claim
68 words
The method of claim 57, wherein each of the remotely located user computers comprises a heterogeneous data structure, and further comprising the steps of: at the user computers, mapping predetermined data items stored in the user computers to corresponding object attributes associated with a predetermined instance of an object; storing the object attributes in an object attribute table in the remote user computers in association with object identifiers.
Claim 63
Dependent Claim
19 words
The method of claim 57, wherein the mapping table stores information relating object identifiers, status information, and location information.
Claim 64
Dependent Claim
65 words
The method of claim 57, wherein the query to the object broker originates at a first user computer, and the data associated with the selected object identifier is stored at a second user computer, and further comprising the step of communicating data retrieved, associated with the selected object identifier, to the object broker and then to the first user computer via the data communication network.
Claim 65
Dependent Claim
31 words
The method of claim 57, wherein the data items associated with the subject stored at the user computer in association with the object identifier are stored in an object attribute table.
Claim 66
Dependent Claim
37 words
The method of claim 61, wherein the remotely located user computers include at least one customer database and at least one remote database associated therewith, and wherein the object attribute table is stored in the remote database.
Claim 67
Dependent Claim
66 words
The method of claim 57, wherein the step of assigning a unique object identifier to data items associated with a subject comprises the steps of: providing a global object identification address space corresponding to a range of object identifiers for association with a plurality of subjects; allocating a predetermined range of object identifiers within the global object identification address space to each remotely located user computer.
Claim 68
Dependent Claim
52 words
The method of claim 63, wherein the step of allocating a predetermined range of object identifiers is carried out at the object broker computer, and wherein a new object instance is created by assigning a unique object identifier from a predetermined range of object identifiers is carried out at the user computers.
Claim 69
Dependent Claim
73 words
The method of claim 57, wherein the user computers are located at a user computer site including at least one customer database and at least one remote database associated therewith, the at least one remote database storing an object attribute table for relating object attributes to object identifiers, and wherein the object broker computer stores an object index table for relating at least one predetermined search term to at least one object identifier.
Claim 70
Dependent Claim
145 words
The method of claim 65, further comprising the steps of: in response to an add request at one of the user computers to add a subject to the system, providing selected data items associated with the subject to be added from the customer database to the remote database; at the remote database, carrying out the step of creating new object instance by assigning a new object identifier to data items associated with the subject; communicating information relating the new object identifier to at least one corresponding search term to the object broker computer; at the object broker computer, updating the object index table to reflect the association of the new object identifier, the corresponding search term; at the object broker computer, updating the mapping table to reflect the location of the user computer that added the new object instance identified by the new object identifier.
Claim 71
Dependent Claim
110 words
The method of claim 65, further comprising the steps of: in response to a search request at a querying one of the user computers to determine whether an object exists corresponding to a selected search term, communicating the selected search term to the object broker computer; at the object broker computer, consulting the object index table to determine whether there is an object identifier associated with the selected search term; in response to a determination that there is an object identifier associated with the selected search term, retrieving the corresponding object identifier; providing a message to the querying user computer via the data communication network including the corresponding object identifier.
Claim 72
Dependent Claim
146 words
The method of claim 65, further comprising the steps of: in response to a get request at a requesting one of the user computers based on a particular object identifier, communicating the particular object identifier to the object broker computer; at the object broker computer, consulting the mapping table based on the particular object identifier to identify a particular remote database at a particular user computer site; communicating a get message to the particular remote database at the particular user computer site including the particular object identifier; at the particular remote database, consulting an object attribute table index to obtain retrieval information corresponding to the particular object identifier in the particular object attribute table; retrieving object attributes associated with the particular object identifier from the particular object attribute table; and communicating retrieved object attributes to the object broker computer and thence to the requesting user computer.
Claim 73
Dependent Claim
219 words
The method of claim 65, further comprising the steps of: in response to a get all request at a requesting one of the user computers based on a particular object identifier that is related to one or more related object identifiers, communicating the particular object identifier to the object broker computer; at the object broker computer, consulting an object index table that relates object identifiers of a first type to object identifiers of a second type to retrieve one or more related object identifiers associated with the particular object identifier; at the object broker computer, consulting the mapping table based on retrieved related object identifiers to identify a one or more object attribute tables at one or more particular remote databases at one or more user computer sites containing data on the related object identifiers; communicating a get message to the one or more remote databases including the related object identifiers; at the one or more particular remote databases, consulting one or more object attribute table indexes to obtain retrieval information corresponding to the related object identifiers in the one or more object attribute tables; retrieving object attributes associated with the related object identifiers from the one or more object attribute tables; and communicating retrieved object attributes to the object broker computer and thence to the requesting user computer.
Claim 74
Dependent Claim
214 words
The method of claim 65, further comprising the steps of: in response to an update request at an updating one of the user computers based on a particular object identifier for which one or more object attributes are to be updated, communicating the particular object identifier to the object broker computer together with the one or more object attributes to be updated; at the object broker computer, consulting the mapping table based the particular object identifier to identify an object attribute table at a particular remote database at a user computer site containing the most current data corresponding to the particular object identifier; communicating a get message to the particular remote database including the particular object identifier; at the particular remote database, consulting an object attribute table index to obtain retrieval information corresponding to the particular object identifier in the object attribute table; retrieving object attributes associated with the particular object identifier from the object attribute table; communicating retrieved object attributes to the object broker computer; at the object broker computer, updating the retrieved object attributes with the one or more object attributes to be updated, to obtain updated object attributes associated with the particular object attribute; communicating the updated object attributes to the updating user computer for storage in the associated remote database.
Claim 75
Dependent Claim
32 words
The method of claim 57, wherein each of the user computers are located at a user computer site including at least one customer database and at least one remote database associated therewith.
Claim 76
Dependent Claim
44 words
The method of claim 71, wherein at least one customer database is a heterogeneous database structure relative to at least one other computer system in the distributed system, and wherein the at least one remote database is homogeneous relative to the object broker computer.
Claim 77
Dependent Claim
30 words
The method of claim 71, wherein the at least one customer database runs on a different computer system than a computer system that runs the at least one remote database.
Claim 78
Dependent Claim
25 words
The method of claim 71, wherein the at least one customer database runs on the same computer system as the at least one remote database.
Claim 79
Dependent Claim
56 words
The method of claim 71, wherein the remote database associated with each user computer site is operative for performing the steps of creating a new object instance, storing data items in association with the object identifier, and retrieving data stored at the remote user computer associated with an object identifier provided by the object broker computer.
Claim 80
Dependent Claim
64 words
The method of claim 71, wherein the step of storing the data items associated with the subject at the user computer in association with the object identifier comprises the steps of: importing data items from a customer database into an associated remote database as selected data attributes associated with a particular object identifier, and communicating the particular object identifier to the object broker computer.
Claim 81
Dependent Claim
35 words
The method of claim 76, wherein the step of communicating the particular object identifier to the object broker computer includes communicating predetermined search terms associated with the selected data attributes to the object broker computer.
Claim 82
Dependent Claim
61 words
The method of claim 77, further comprising the step of storing the predetermined search terms in an object attribute index stored at the object broker computer, the object attribute index relating object identifiers and search terms, and storing location information and status information indicative of the source and status of the object attributes and the object identifier in the mapping table.
Claim 83
Dependent Claim
77 words
The method of claim 76, wherein the step of importing data items from the customer database comprises the steps of: importing a first set of data items from the customer database as object attributes associated with a first object identifier; determining that the first object identifier is related to at least one additional second object identifier; and importing a second set of data items from the customer database as object attributes associated with the second object identifier.
Claim 84
Dependent Claim
118 words
The method of claim 79, further comprising the steps of: storing object attributes associated with the first object identifier in a first object attribute table; storing the first object identifier and the second object identifier in a junction table relating object identifiers to each other; storing object attributes associated with the second object identifier in a second object attribute table; in response to a determination that the storing of object attributes for the second object identifier calls for information corresponding to the first object identifier, storing the first object identifier in a corresponding field in the second object attribute table, whereby reference to the second object identifier causes referral to the first object identifier for selected object attributes.
Claim 85
Dependent Claim
61 words
The method of claim 71, wherein at least one user computer in the distributed data processing system includes a customer database of a first database structure, and at least one other user computer in the distributed data processing system includes a customer database of a second database structure different from the first database structure so that such database structures are heterogeneous.
Claim 86
Dependent Claim
38 words
The method of claim 81, wherein each remote database at each user computer site comprises a homogeneous data structure, and further comprising the step of importing selected data items from an associated customer database into the remote database.
Claim 87
Dependent Claim
48 words
The method of claim 82, wherein the step of importing selected data items from an associated customer database into the remote database comprises the step of mapping data items in a heterogeneous data structure on a customer database into predetermined object attributes stored in the associated remote database.
Claim 88
Dependent Claim
27 words
The method of claim 83, wherein the step of importing occurs in response to a put request message provided by a user at a user computer site.
Claim 89
Dependent Claim
30 words
The method of claim 83, wherein the step of importing comprises entering data items from the heterogeneous data structure into an object attribute table maintained at the associated remote database.
References Cited (Backward Citations)
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 1999-09-24 | 2000-03-25 | 2000-09-24 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2003-09-24 | 2004-03-25 | 2004-09-24 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2007-09-24 | 2008-03-25 | 2008-09-24 | $7700.00 | Window Closed / Lapsed |