Patent US2432698A successfully refreshed from Google Patents.
Patent US5452456A successfully refreshed from Google Patents.
Patent US2826097A successfully refreshed from Google Patents.
Patent US2499183A successfully refreshed from Google Patents.
US6711571B2
Expired / Lapsed
US
⏱️ 0.0 years remaining
Partitioning ownership of a database among different database servers to control access to the database
Assignee: Oracle International Corp
•
Filing: 2001-06-28
•
Granted: 2004-03-23
•
Expires: 2021-06-28
Abstract
Abstract A database or some portion thereof is partitioned into ownership groups. Each ownership group is assigned one or more database servers as owners of the ownership group. The database servers that are assigned as owners of an ownership group are treated as the owners of all data items that belong to the ownership group. That is, they are allowed to directly access the data items within the ownership group, while other database servers are not allowed to directly access those data items. Accordingly, a database system is provided which includes one or more persistent storage devices having a database stored thereon, and a plurality of database servers executing on a plurality of nodes. Each node has direct access to the persistent storage devices. At least a portion of the database is partitioned into a plurality of ownership groups. Each ownership group is assigned an owner set. Only processes that are executing on database servers that are members of the owner set of an ownership group are allowed to directly access data within the ownership group. Each ownership group is designated as either a shared nothing ownership group or a shared disk ownership group. Each shared nothing ownership group is assigned an owner from among the database servers. Only the owner of each shared nothing ownership group is allowed to directly access data within the shared nothing ownership group. Each of the database servers is allowed to directly access data within ownership groups that are designated as shared disk ownership groups.
Inventors
- 👤 Gianfranco Putzolu
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-11-04 17:59
CPC Classifications
G; G06; G06F; G06F21/00; G06F21/60; G06F21/62; G06F21/6218; G06F21/6227; G06F16/00; G06F16/20; G06F16/27; Y; Y10; Y10S; Y10S707/00; Y10S707/99931; Y10S707/99938; Y10S707/99939; Y10S707/99951; Y10S707/99952; Y10S707/99953; Y10S707/99956
Claims Analysis
Total Claims: 153
Claim 1
Independent Claim
100 words
A system comprising: a plurality of nodes that have direct access to a database; the database including: a first set of data that each node of the plurality of nodes is allowed to directly access; and a second set of data that only a subset of the plurality of nodes is allowed to directly access; wherein nodes that do not belong to the subset are configured to send requests to nodes that belong to the subset when the nodes that do not belong to the subset are requested to perform operations that involve data within said second set of data.
Claim 2
Independent Claim
100 words
A system comprising: a plurality of nodes that have direct access to a database; the database including: a first set of data that each node of the plurality of nodes is allowed to directly access; and a second set of data that only a subset of the plurality of nodes is allowed to directly access; wherein nodes that do not belong to the subset are configured to send requests to nodes that belong to the subset when the nodes that do not belong to the subset are requested to perform operations that involve data within said second set of data.
Claim 3
Dependent Claim
27 words
The system of claim 1 , wherein: said subset has a single node; and all access to said second set of data is through the single node.
Claim 4
Dependent Claim
46 words
The system of claim 1 , wherein: said subset is a first subset; the database includes a third set of data that only a second subset of the plurality of nodes is allowed to directly access; and said first subset is different from said second subset.
Claim 5
Dependent Claim
26 words
The system of claim 3 , wherein at least one node of the plurality of nodes belongs to both said first subset and said second subset.
Claim 6
Dependent Claim
19 words
The system of claim 1 , further comprising: a mechanism for changing the nodes that belong to said subset.
Claim 7
Dependent Claim
33 words
The system of claim 1 , further comprising: a mechanism for automatically changing the nodes that belong to the subset in response to a failure of a node that belongs to the subset.
Claim 8
Dependent Claim
58 words
The system of claim 1 , wherein the database includes a plurality of data items, wherein the first set of data includes one or more data items of the plurality of data items, and the system further comprising: a mechanism for changing which data items of the plurality of data items are in the first set of data.
Claim 9
Dependent Claim
58 words
The system of claim 1 , wherein the database includes a plurality of data items, wherein the second set of data includes one or more data items of the plurality of data items, and the system further comprising: a mechanism for changing which data items of the plurality of data items are in the second set of data.
Claim 10
Dependent Claim
28 words
The system of claim 1 , wherein the first set of data is a first ownership group and the second set of data is a second ownership group.
Claim 11
Dependent Claim
13 words
The system of claim 1 , wherein the subset is an owner set.
Claim 12
Dependent Claim
90 words
A database system including: a database; a plurality of database servers; wherein each database server of said plurality of database servers has direct access to said database; wherein at least a portion of said database is partitioned into a plurality of ownership groups; wherein at least one ownership group of said plurality of ownership groups is assigned an owner set; and wherein processes that are executing on database servers that are members of the owner set of an ownership group are allowed to directly access data within said ownership group.
Claim 13
Dependent Claim
90 words
A database system including: a database; a plurality of database servers; wherein each database server of said plurality of database servers has direct access to said database; wherein at least a portion of said database is partitioned into a plurality of ownership groups; wherein at least one ownership group of said plurality of ownership groups is assigned an owner set; and wherein processes that are executing on database servers that are members of the owner set of an ownership group are allowed to directly access data within said ownership group.
Claim 14
Dependent Claim
22 words
The database system of claim 11 , wherein each ownership group of said plurality of ownership groups is assigned an owner set.
Claim 15
Dependent Claim
37 words
The database system of claim 11 , wherein only processes that are executing on database servers that are members of the owner set of an ownership group are allowed to directly access data within said ownership group.
Claim 16
Dependent Claim
24 words
The database system of claim 11 , wherein at least one ownership group of said plurality of ownership groups includes one or more tablespaces.
Claim 17
Dependent Claim
23 words
The database system of claim 14 , wherein at least one tablespace of the one or more tablespaces is a collection of datafiles.
Claim 18
Dependent Claim
66 words
The database system of claim 11 wherein: at least one ownership group of said plurality of ownership groups is designated as a shared nothing ownership group; at least one shared nothing ownership group is assigned an owner from among said plurality of database servers; and only the owner of each shared nothing ownership group is allowed to directly access data within said shared nothing ownership group.
Claim 19
Dependent Claim
51 words
The database system of claim 11 wherein: at least one ownership group of said plurality of ownership groups is designated as a shared disk ownership group; and each of said plurality of database servers are allowed to directly access data within ownership groups that are designated as shared disk ownership groups.
Claim 20
Dependent Claim
49 words
The database system of claim 11 wherein: each ownership group of said plurality of ownership groups is designated as either a shared nothing ownership group or a shared disk ownership group; and each shared nothing ownership group is assigned a single owner from among said plurality of database servers.
Claim 21
Dependent Claim
36 words
The database system of claim 11 , wherein at least one ownership group of said plurality of ownership groups is designated as a particular type of ownership group of a plurality of types of ownership groups.
Claim 22
Dependent Claim
22 words
The database system of claim 19 , further including a mechanism for changing the particular type of ownership group that is designated.
Claim 23
Dependent Claim
65 words
The database system of claim 19 , wherein: at least one ownership group of the plurality of ownership groups is designated as a first type of ownership group of the plurality of types of ownership groups; and at least one ownership group of the plurality of ownership groups is designated as a second type of ownership group of the plurality of types of ownership groups.
Claim 24
Dependent Claim
33 words
The database system of claim 21 , wherein: the first type of ownership group is a shared nothing ownership group; and the second type of ownership group is a shared disk ownership group.
Claim 25
Dependent Claim
31 words
The database system of claim 22 , wherein each ownership group of said plurality of ownership groups is designated as either as shared nothing ownership group or shared disk ownership group.
Claim 26
Dependent Claim
56 words
The database system of claim 19 , wherein for at least one type of ownership group of the plurality of types of ownership groups, only one database server of the plurality of database servers is allowed in the owner set for each ownership group that is designated as the at least one type of ownership group.
Claim 27
Dependent Claim
55 words
The database system of claim 19 , wherein for at least one type of ownership group of the plurality of types of ownership groups, each database server of the plurality of database servers is included in the owner set for each ownership group that is designated as the at least one type of ownership group.
Claim 28
Dependent Claim
63 words
The database system of claim 19 , wherein for at least one type of ownership group of the plurality of types of ownership groups, at least two database servers but fewer than all database servers of the plurality of database servers are included in the owner set for each ownership group that is designated as the at least one type of ownership group.
Claim 29
Dependent Claim
112 words
The database system of claim 11 , further comprising: a first database server of the plurality of database servers, wherein the first database server desires data that is included in a particular ownership group assigned to a particular owner set; wherein, if the first database server is included in the particular owner set, a process executing on the first database server directly retrieves the data; and wherein, if the first database server is not included in the particular owner set, the process executing on the first database server requests and receives the data from a second database server, of the plurality of database servers, that is included in the particular owner set.
Claim 30
Dependent Claim
41 words
The database system of claim 27 , wherein the particular ownership group is a shared disk ownership group, the particular owner set includes the plurality of database servers, and the process executing on the first database server directly retrieves the data.
Claim 31
Dependent Claim
39 words
The database system of claim 27 , wherein the particular ownership group is a shared nothing ownership group and the second database server of the plurality of database servers is the only database server in the particular owner set.
Claim 32
Dependent Claim
39 words
The database system of claim 27 , wherein the particular ownership group is a shared nothing ownership group and the first database server of the plurality of database servers is the only database server in the particular owner set.
Claim 33
Dependent Claim
72 words
The database system of claim 11 , wherein at least one ownership group of the plurality of ownership groups is assigned an owner from among said plurality of database servers, and wherein the database system further includes: a mechanism for reassigning the owner for the at least one ownership group from a first database server of the plurality of database servers to a second database server of the plurality of database servers.
Claim 34
Dependent Claim
20 words
The database system of claim 31 , wherein the at least one ownership group is a shared nothing ownership group.
Claim 35
Dependent Claim
28 words
The database system of claim 31 , wherein the mechanism is configured to reassign the owner for the at least one ownership group in response to a request.
Claim 36
Dependent Claim
34 words
The database system of claim 31 , wherein the mechanism is configured to reassign the owner for the at least one ownership group automatically in response to a failure of the first database server.
Claim 37
Dependent Claim
95 words
The database system of claim 11 , further including: a mechanism for transitioning a particular ownership group from a first owner set to a second owner set, wherein the mechanism is configured to: instruct the plurality of database servers to cease creating new versions of data within the particular ownership group; and when all transactions that are accessing said data through said first owner set have either committed or aborted, change data that indicates ownership of the particular ownership group to indicate that the second owner set is the owner of the particular ownership group.
Claim 38
Dependent Claim
113 words
The database system of claim 35 , wherein in response to a failure of the mechanism to transition the particular ownership group from the first owner set to the second owner set, the mechanism is further configured to: determine whether the failure occurred prior to changing the data that indicates ownership of the particular ownership group; if the failure occurred before changing the data that indicates ownership of the particular ownership group, restore the first owner set as owner of the particular ownership group; and if the failure occurred after changing the data that indicates ownership of the particular ownership group, retain the second owner set as owner of the particular ownership group.
Claim 39
Dependent Claim
87 words
The database system of claim 11 , further comprising: a mechanism for transitioning a particular ownership group from a first owner set to a second owner set; and a query that is included in the database, wherein the query is associated with an execution plan that refers to the first owner set, and wherein after the particular ownership group is transitioned by the mechanism from the first owner set to the second owner set, a new execution plan is generated that refers to the second owner set.
Claim 40
Dependent Claim
83 words
The database system of claim 11 , further including: a mechanism to reassign a data item from a first ownership group to a second ownership group, wherein the mechanism is configured to: disable access by the plurality of database servers to the data item; and when all transactions that are accessing said data item have either committed or aborted, change data that indicates to which ownership group the data item belongs to indicate that the data item belongs to the second ownership group.
Claim 41
Dependent Claim
46 words
The database system of claim 38 , wherein the mechanism is further configured to: change first data to indicate to which ownership group the data item belongs; and before changing the first data, change second data to indicate to which ownership group the data item belongs.
Claim 42
Dependent Claim
25 words
The database system of claim 39 , wherein the first data is in a control file and the second data is in a data dictionary.
Claim 43
Dependent Claim
94 words
The database system of claim 39 , wherein in response to a failure of the mechanism to reassign the data item from the first ownership group to the second ownership group, the mechanism is further configured to: determine whether the failure occurred before changing the second data; if the failure occurred before changing the second data, restore the data item to the first ownership group; and if the failure occurred after changing second data, complete reassigning the data item from the first ownership group to the second ownership group by changing the first data.
Claim 44
Dependent Claim
43 words
The database system of claim 38 , wherein the mechanism is further configured to: determine whether the second ownership group is undergoing an ownership change; and if the second ownership group is undergoing an ownership change, mark the data item as move delayed.
Claim 45
Independent Claim
163 words
A system for transitioning ownership of a data item from a first owner set to a second owner set, the system comprising: a plurality of database servers; a database that includes the data item; a mechanism for managing access to the data item; wherein said plurality of database servers are informed that the data item is being transitioned from the first owner set to the second owner set; wherein the mechanism is configured to allow members of said first owner set and members of said second owner set to directly access said data item, after said plurality of database servers are informed; wherein data is stored that indicates that the second owner set is the exclusive owner of the data item; and wherein the mechanism is configured to allow only members of said second owner set to directly access the data item, after detecting that all transactions that are accessing said data item through said first owner set have either committed or aborted.
Claim 46
Independent Claim
163 words
A system for transitioning ownership of a data item from a first owner set to a second owner set, the system comprising: a plurality of database servers; a database that includes the data item; a mechanism for managing access to the data item; wherein said plurality of database servers are informed that the data item is being transitioned from the first owner set to the second owner set; wherein the mechanism is configured to allow members of said first owner set and members of said second owner set to directly access said data item, after said plurality of database servers are informed; wherein data is stored that indicates that the second owner set is the exclusive owner of the data item; and wherein the mechanism is configured to allow only members of said second owner set to directly access the data item, after detecting that all transactions that are accessing said data item through said first owner set have either committed or aborted.
Claim 47
Dependent Claim
42 words
The system of claim 43 , wherein all transactions that are accessing said data item through said first owner set have either committed or aborted when all transactions that began execution prior to the step of informing have either committed or aborted.
Claim 48
Dependent Claim
28 words
The system of claim 43 , wherein the plurality of database servers are informed by a refresh cache message that is sent to the plurality of database servers.
Claim 49
Dependent Claim
42 words
The system of claim 43 , wherein prior to the plurality of database servers being informed, data is stored that identifies the first owner set, the second owner set, and that indicates that the owner of the data item is in transition.
Claim 50
Dependent Claim
111 words
The system of claim 43 , wherein: if a particular database server of the plurality of database servers begins a transaction prior to being informed that the data item is being transitioned from the first owner set to the second owner set, the transaction is processed as if the first owner set is the owner of the data item; and if the particular database server of the plurality of database servers begins the transaction after being informed that the data item is being transitioned from the first owner set to the second owner set, the transaction is processed as if the second owner set is the owner of the data item.
Claim 51
Dependent Claim
15 words
The system of claim 43 , wherein the mechanism is a shared disk locking mechanism.
Claim 52
Independent Claim
128 words
A method for managing access to a database by a plurality of nodes having direct access to the database, the method comprising the steps of: partitioning at least a first portion of the database into a first set of data that each node of the plurality of nodes is allowed to directly access; and partitioning at least a second portion of the database into a second set of data that only a subset of the plurality of nodes is allowed to directly access; wherein nodes that do not belong to the subset are configured to send requests to nodes that belong to the subset when the nodes that do not belong to the subset are requested to perform operations that involve data within said second set of data.
Claim 53
Independent Claim
128 words
A method for managing access to a database by a plurality of nodes having direct access to the database, the method comprising the steps of: partitioning at least a first portion of the database into a first set of data that each node of the plurality of nodes is allowed to directly access; and partitioning at least a second portion of the database into a second set of data that only a subset of the plurality of nodes is allowed to directly access; wherein nodes that do not belong to the subset are configured to send requests to nodes that belong to the subset when the nodes that do not belong to the subset are requested to perform operations that involve data within said second set of data.
Claim 54
Dependent Claim
27 words
The method of claim 49 , wherein: said subset has a single node; and all access to said second set of data is through the single node.
Claim 55
Dependent Claim
62 words
The method of claim 49 , wherein said subset is a first subset, and wherein the method further comprises the step of: partitioning at least a third portion of the database into a third set of data that only a second subset of the plurality of nodes is allowed to directly access, wherein said first subset is different from said second subset.
Claim 56
Dependent Claim
26 words
The method of claim 51 , wherein at least one node of the plurality of nodes belongs to both said first subset and said second subset.
Claim 57
Dependent Claim
19 words
The method of claim 49 , further comprising the step of: changing the nodes that belong to said subset.
Claim 58
Dependent Claim
33 words
The method of claim 49 , further comprising the step of: automatically changing the nodes that belong to the subset in response to a failure of a node that belongs to the subset.
Claim 59
Dependent Claim
59 words
The method of claim 49 , wherein the database includes a plurality of data items, wherein the first set of data includes one or more data items of the plurality of data items, and wherein the method further comprises the step of: changing which data items of the plurality of data items are in the first set of data.
Claim 60
Dependent Claim
59 words
The method of claim 49 , wherein the database includes a plurality of data items, wherein the second set of data includes one or more data items of the plurality of data items, and wherein the method further comprises the step of: changing which data items of the plurality of data items are in the second set of data.
Claim 61
Dependent Claim
28 words
The method of claim 49 , wherein the first set of data is a first ownership group and the second set of data is a second ownership group.
Claim 62
Dependent Claim
13 words
The method of claim 49 , wherein the subset is an owner set.
Claim 63
Independent Claim
79 words
A method for managing access to a database that is directly accessible by a plurality of database servers, the method including the steps of: partitioning at least a portion of said database into a plurality of ownership groups; assigning an owner set to at least one ownership group of said plurality of ownership groups; and allowing processes executing in database servers that belong to the owner set of each ownership group to directly access data within each ownership group.
Claim 64
Independent Claim
79 words
A method for managing access to a database that is directly accessible by a plurality of database servers, the method including the steps of: partitioning at least a portion of said database into a plurality of ownership groups; assigning an owner set to at least one ownership group of said plurality of ownership groups; and allowing processes executing in database servers that belong to the owner set of each ownership group to directly access data within each ownership group.
Claim 65
Dependent Claim
25 words
The method of claim 59 , further comprising the step of: assigning one owner set to each ownership group of said plurality of ownership groups.
Claim 66
Dependent Claim
41 words
The method of claim 59 , further comprising the step of: allowing only processes that are executing on database servers that are members of the owner set of a particular ownership group to directly access data within the particular ownership group.
Claim 67
Dependent Claim
23 words
The method of claim 59 , wherein at least one ownership group of said plurality of ownership groups includes one or more tablespaces.
Claim 68
Dependent Claim
22 words
The method of claim 62 , wherein at least one tablespace of the one or more tablespaces is a collection of datafiles.
Claim 69
Dependent Claim
67 words
The method of claim 59 , further comprising the steps of: designating at least one ownership group of said plurality of ownership groups as a shared nothing ownership group; assigning at least one shared nothing ownership group an owner from among said plurality of database servers; and allowing only the owner of each shared nothing ownership group to directly access data within said shared nothing ownership group.
Claim 70
Dependent Claim
53 words
The method of claim 59 , further comprising the steps of: designating at least one ownership group of said plurality of ownership groups as a shared disk ownership group; and allowing each of said plurality of database servers to directly access data within ownership groups that are designated as shared disk ownership groups.
Claim 71
Dependent Claim
50 words
The method of claim 59 , further comprising the steps of: designating each ownership group of said plurality of ownership groups as either a shared nothing ownership group or a shared disk ownership group; and assigning each shared nothing ownership a single owner from among said plurality of database servers.
Claim 72
Dependent Claim
38 words
The method of claim 59 , further comprising the step of: designating at least one ownership group of said plurality of ownership groups as a particular type of ownership group of a plurality of types of ownership groups.
Claim 73
Dependent Claim
20 words
The method of claim 67 , further comprising the step of: changing the type of ownership group that is designated.
Claim 74
Dependent Claim
66 words
The method of claim 67 , further comprising the steps of: designating at least one ownership group of the plurality of ownership groups as a first type of ownership group of the plurality of types of ownership groups; and designating at least one ownership group of the plurality of ownership groups as a second type of ownership group of the plurality of types of ownership groups.
Claim 75
Dependent Claim
32 words
The method of claim 69 , wherein: the first type of ownership group is a shared nothing ownership group; and the second type of ownership group is a shared disk ownership group.
Claim 76
Dependent Claim
33 words
The method of claim 70 , further comprising the step of: designating each ownership group of said plurality of ownership groups as either as shared nothing ownership group or shared disk ownership group.
Claim 77
Dependent Claim
58 words
The method of claim 67 , further comprising the step of: for at least one type of ownership group of the plurality of types of ownership groups, allowing only one database server of the plurality of database servers in the owner set for each ownership group that is designated as the at least one type of ownership group.
Claim 78
Dependent Claim
57 words
The method of claim 67 , further comprising the step of: for at least one type of ownership group of the plurality of types of ownership groups, including each database server of the plurality of database servers in the owner set for each ownership group that is designated as the at least one type of ownership group.
Claim 79
Dependent Claim
65 words
The method of claim 67 , further comprising the step of: for at least one type of ownership group of the plurality of types of ownership groups, including at least two database servers but fewer than all database servers of the plurality of database servers in the owner set for each ownership group that is designated as the at least one type of ownership group.
Claim 80
Dependent Claim
103 words
The method of claim 59 , wherein: a first database server of the plurality of database servers desires data that is included in a particular ownership group assigned to a particular owner set; if the first database server is included in the particular owner set, a process executing on the first database server directly retrieves the data; and if the first database server is not included in the particular owner set, the process executing on the first database server requests and receives the data from a second database server, of the plurality of database servers, that is included in the particular owner set.
Claim 81
Dependent Claim
40 words
The method of claim 75 , wherein the particular ownership group is a shared disk ownership group, the particular owner set includes the plurality of database servers, and the process executing on the first database server directly retrieves the data.
Claim 82
Dependent Claim
38 words
The method of claim 75 , wherein the particular ownership group is a shared nothing ownership group and the second database server of the plurality of database servers is the only database server in the particular owner set.
Claim 83
Dependent Claim
38 words
The method of claim 75 , wherein the particular ownership group is a shared nothing ownership group and the first database server of the plurality of database servers is the only database server in the particular owner set.
Claim 84
Dependent Claim
65 words
The method of claim 59 , further comprising the steps of: assigning at least one ownership group of the plurality of ownership groups an owner from among said plurality of database servers; and reassigning the owner for the at least one ownership group from a first database server of the plurality of database servers to a second database server of the plurality of database servers.
Claim 85
Dependent Claim
19 words
The method of claim 79 , wherein the at least one ownership group is a shared nothing ownership group.
Claim 86
Dependent Claim
28 words
The method of claim 79 , wherein the step of reassigning the owner set for the at least one ownership group is performed in response to a request.
Claim 87
Dependent Claim
34 words
The method of claim 79 , wherein the step of reassigning the owner set for the at least one ownership group is performed automatically in response to a failure of the first database server.
Claim 88
Dependent Claim
93 words
The method of claim 59 , further comprising the step of: transitioning a particular ownership group from a first owner set to a second owner set by performing the steps of: instructing the plurality of database servers to cease creating new versions of data within the particular ownership group; and when all transactions that are accessing said data through said first owner set have either committed or aborted, changing data that indicates ownership of the particular ownership group to indicate that the second owner set is the owner of the particular ownership group.
Claim 89
Dependent Claim
107 words
The method of claim 83 , further comprising the steps of: in response to a failure in transitioning the particular ownership group from the first owner set to the second owner set, determining whether the failure occurred prior to changing the data that indicates ownership of the particular ownership group; if the failure occurred before changing the data that indicates ownership of the particular ownership group, restoring the first owner set as owner of the particular ownership group; and if the failure occurred after changing the data that indicates ownership of the particular ownership group, retaining the second owner set as owner of the particular ownership group.
Claim 90
Dependent Claim
83 words
The method of claim 59 , wherein a query is included in the database, wherein the query is associated with an execution plan that refers to a first owner set, and wherein the method further comprises the steps of: transitioning a particular ownership group from the first owner set to a second owner set; and after transitioning the particular ownership group from the first owner set to the second owner set, generating a new execution plan that refers to the second owner set.
Claim 91
Dependent Claim
81 words
The method of claim 59 , further comprising the steps of: reassigning a data item from a first ownership group to a second ownership group by performing the steps of: disabling access by the plurality of database servers to the data item; and when all transactions that are accessing said data item have either committed or aborted, changing data that indicates to which ownership group the data item belongs to indicate that the data item belongs to the second ownership group.
Claim 92
Dependent Claim
43 words
The method of claim 86 , further comprising the steps of: changing first data to indicate to which ownership group the data item belongs; and before changing the first data, changing second data to indicate to which ownership group the data item belongs.
Claim 93
Dependent Claim
24 words
The method of claim 87 , wherein the first data is in a control file and the second data is in a data dictionary.
Claim 94
Dependent Claim
90 words
The method of claim 87 , further comprising the steps of: in response to a failure of reassigning the data item from the first ownership group to the second ownership group, determining whether the failure occurred before changing the second data; if the failure occurred before changing the second data, restoring the data item to the first ownership group; and if the failure occurred after changing second data, completing the reassignment of the data item from the first ownership group to the second ownership group by changing the first data.
Claim 95
Dependent Claim
40 words
The method of claim 86 , further comprising the steps of: determining whether the second ownership group is undergoing an ownership change; and if the second ownership group is undergoing an ownership change, marking the data item as move delayed.
Claim 96
Independent Claim
153 words
A method for transitioning ownership of a data item from a first owner set to a second owner set, the method comprising the steps of: informing a plurality of database servers that the data item is being transitioned from the first owner set to the second owner set; after informing said plurality of database servers, allowing members of said first owner set and members of said second owner set to directly access said data item; detecting when all transactions that are accessing said data item through said first owner set have either committed or aborted; and after detecting when all transactions that are accessing said data item through said first owner set have either committed or aborted, performing the steps of: storing data that indicates that the second owner set is the exclusive owner of the data item; and allowing only members of said second owner set to directly access said data item.
Claim 97
Independent Claim
153 words
A method for transitioning ownership of a data item from a first owner set to a second owner set, the method comprising the steps of: informing a plurality of database servers that the data item is being transitioned from the first owner set to the second owner set; after informing said plurality of database servers, allowing members of said first owner set and members of said second owner set to directly access said data item; detecting when all transactions that are accessing said data item through said first owner set have either committed or aborted; and after detecting when all transactions that are accessing said data item through said first owner set have either committed or aborted, performing the steps of: storing data that indicates that the second owner set is the exclusive owner of the data item; and allowing only members of said second owner set to directly access said data item.
Claim 98
Dependent Claim
52 words
The method of claim 91 , wherein the step of detecting when all transactions that are accessing said data item through said first owner set have either committed or aborted includes the step of: detecting when all transactions that began execution prior to the step of informing have either committed or aborted.
Claim 99
Dependent Claim
48 words
The method of claim 91 , wherein the step of informing the plurality of database servers that the data item is being transitioned from the first owner set to the second owner set includes the step of: sending a refresh cache message to the plurality of database servers.
Claim 100
Dependent Claim
47 words
The method of claim 91 , wherein prior to the step of informing the plurality of database servers, performing the step of: storing data that identifies the first owner set, the second owner set, and that indicates that the owner of the data item is in transition.
Claim 101
Dependent Claim
134 words
The method of claim 91 , wherein the step of allowing members of said first owner set and said second owner set to directly access said data item includes the steps of: if a particular database server of the plurality of database servers begins a transaction prior to being informed that the data item is being transitioned from the first owner set to the second owner set, processing the transaction as if the first owner set is the owner of the data item; and if the particular database server of the plurality of database servers begins the transaction after being informed that the data item is being transitioned from the first owner set to the second owner set, processing the transaction as if the second owner set is the owner of the data item.
Claim 102
Dependent Claim
51 words
The method of claim 91 , wherein a shared disk locking mechanism performs the steps of: allowing members of said first owner set and members of said second owner set to directly access said data item; and allowing only members of said second owner set to directly access said data item.
Claim 103
Dependent Claim
156 words
A computer-readable medium carrying one or more sequences of instructions for managing access to a database by a plurality of nodes having direct access to the database, 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: partitioning at least a first portion of the database into a first set of data that each node of the plurality of nodes is allowed to directly access; and partitioning at least a second portion of the database into a second set of data that only a subset of the plurality of nodes is allowed to directly access; wherein nodes that do not belong to the subset are configured to send requests to nodes that belong to the subset when the nodes that do not belong to the subset are requested to perform operations that involve data within said second set of data.
Claim 104
Dependent Claim
156 words
A computer-readable medium carrying one or more sequences of instructions for managing access to a database by a plurality of nodes having direct access to the database, 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: partitioning at least a first portion of the database into a first set of data that each node of the plurality of nodes is allowed to directly access; and partitioning at least a second portion of the database into a second set of data that only a subset of the plurality of nodes is allowed to directly access; wherein nodes that do not belong to the subset are configured to send requests to nodes that belong to the subset when the nodes that do not belong to the subset are requested to perform operations that involve data within said second set of data.
Claim 105
Dependent Claim
28 words
The computer-readable medium of claim 97 , wherein: said subset has a single node; and all access to said second set of data is through the single node.
Claim 106
Dependent Claim
79 words
The computer-readable medium of claim 97 , wherein said subset is a first subset, and further comprising instructions which, when executed by the one or more processors, cause the one or more processors to carry out the step of: partitioning at least a third portion of the database into a third set of data that only a second subset of the plurality of nodes is allowed to directly access, wherein said first subset is different from said second subset.
Claim 107
Dependent Claim
27 words
The computer-readable medium of claim 99 , wherein at least one node of the plurality of nodes belongs to both said first subset and said second subset.
Claim 108
Dependent Claim
39 words
The computer-readable medium of claim 97 , further comprising instructions which, when executed by the one or more processors, cause the one or more processors to carry out the step of: changing the nodes that belong to said subset.
Claim 109
Dependent Claim
53 words
The computer-readable medium of claim 97 , further comprising instructions which, when executed by the one or more processors, cause the one or more processors to carry out the step of: automatically changing the nodes that belong to said subset in response to a failure of a node that belongs to said subset.
Claim 110
Dependent Claim
76 words
The computer-readable medium of claim 97 , wherein the database includes a plurality of data items, wherein the first set of data includes one or more data items of the plurality of data items, and further comprising instructions which, when executed by the one or more processors, cause the one or more processors to carry out the step of: changing which data items of the plurality of data items are in the first set of data.
Claim 111
Dependent Claim
76 words
The computer-readable medium of claim 97 , wherein the database includes a plurality of data items, wherein the first set of data includes one or more data items of the plurality of data items, and further comprising instructions which, when executed by the one or more processors, cause the one or more processors to carry out the step of: changing which data items of the plurality of data items are in the second set of data.
Claim 112
Dependent Claim
29 words
The computer-readable medium of claim 97 , wherein the first set of data is a first ownership group and the second set of data is a second ownership group.
Claim 113
Dependent Claim
14 words
The computer-readable medium of claim 97 , wherein the subset is an owner set.
Claim 114
Dependent Claim
107 words
A computer-readable medium carrying one or more sequences of instructions for managing access to a database that is directly accessible by a plurality of database servers, 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: partitioning at least a portion of said database into a plurality of ownership groups; assigning an owner set to at least one ownership group of said plurality of ownership groups; and allowing processes executing in database servers that belong to the owner set of each ownership group to directly access data within each ownership group.
Claim 115
Dependent Claim
107 words
A computer-readable medium carrying one or more sequences of instructions for managing access to a database that is directly accessible by a plurality of database servers, 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: partitioning at least a portion of said database into a plurality of ownership groups; assigning an owner set to at least one ownership group of said plurality of ownership groups; and allowing processes executing in database servers that belong to the owner set of each ownership group to directly access data within each ownership group.
Claim 116
Dependent Claim
45 words
The computer-readable medium of claim 107 , further comprising instructions which, when executed by the one or more processors, cause the one or more processors to carry out the step of: assigning one owner set to each ownership group of said plurality of ownership groups.
Claim 117
Dependent Claim
61 words
The computer-readable medium of claim 107 , further comprising instructions which, when executed by the one or more processors, cause the one or more processors to carry out the step of: allowing only processes that are executing on database servers that are members of the owner set of a particular ownership group to directly access data within the particular ownership group.
Claim 118
Dependent Claim
24 words
The computer-readable medium of claim 107 , wherein at least one ownership group of said plurality of ownership groups includes one or more tablespaces.
Claim 119
Dependent Claim
23 words
The computer-readable medium of claim 110 , wherein at least one tablespace of the one or more tablespaces is a collection of datafiles.
Claim 120
Dependent Claim
87 words
The computer-readable medium of claim 107 , further comprising instructions which, when executed by the one or more processors, cause the one or more processors to carry out the steps of: designating at least one ownership group of said plurality of ownership groups as a shared nothing ownership group; assigning at least one shared nothing ownership group an owner from among said plurality of database servers; and allowing only the owner of each shared nothing ownership group to directly access data within said shared nothing ownership group.
Claim 121
Dependent Claim
73 words
The computer-readable medium of claim 107 , further comprising instructions which, when executed by the one or more processors, cause the one or more processors to carry out the steps of: designating at least one ownership group of said plurality of ownership groups as a shared disk ownership group; and allowing each of said plurality of database servers to directly access data within ownership groups that are designated as shared disk ownership groups.
Claim 122
Dependent Claim
70 words
The computer-readable medium of claim 107 , further comprising instructions which, when executed by the one or more processors, cause the one or more processors to carry out the steps of: designating each ownership group of said plurality of ownership groups as either a shared nothing ownership group or a shared disk ownership group; and assigning each shared nothing ownership a single owner from among said plurality of database servers.
Claim 123
Dependent Claim
58 words
The computer-readable medium of claim 107 , further comprising instructions which, when executed by the one or more processors, cause the one or more processors to carry out the steps of: designating at least one ownership group of said plurality of ownership groups as a particular type of ownership group of a plurality of types of ownership groups.
Claim 124
Dependent Claim
40 words
The computer-readable medium of claim 115 , further comprising instructions which, when executed by the one or more processors, cause the one or more processors to carry out the step of: changing the type of ownership group that is designated.
Claim 125
Dependent Claim
86 words
The computer-readable medium of claim 115 , further comprising instructions which, when executed by the one or more processors, cause the one or more processors to carry out the steps of: designating at least one ownership group of the plurality of ownership groups as a first type of ownership group of the plurality of types of ownership groups; and designating at least one ownership group of the plurality of ownership groups as a second type of ownership group of the plurality of types of ownership groups.
Claim 126
Dependent Claim
33 words
The computer-readable medium of claim 117 , wherein: the first type of ownership group is a shared nothing ownership group; and the second type of ownership group is a shared disk ownership group.
Claim 127
Dependent Claim
53 words
The computer-readable medium of claim 118 , further comprising instructions which, when executed by the one or more processors, cause the one or more processors to carry out the step of: designating each ownership group of said plurality of ownership groups as either as shared nothing ownership group or shared disk ownership group.
Claim 128
Dependent Claim
78 words
The computer-readable medium of claim 115 , further comprising instructions which, when executed by the one or more processors, cause the one or more processors to carry out the step of: for at least one type of ownership group of the plurality of types of ownership groups, allowing only one database server of the plurality of database servers in the owner set for each ownership group that is designated as the at least one type of ownership group.
Claim 129
Dependent Claim
77 words
The computer-readable medium of claim 115 , further comprising instructions which, when executed by the one or more processors, cause the one or more processors to carry out the step of: for at least one type of ownership group of the plurality of types of ownership groups, including each database server of the plurality of database servers in the owner set for each ownership group that is designated as the at least one type of ownership group.
Claim 130
Dependent Claim
85 words
The computer-readable medium of claim 115 , further comprising instructions which, when executed by the one or more processors, cause the one or more processors to carry out the step of: for at least one type of ownership group of the plurality of types of ownership groups, including at least two database servers but fewer than all database servers of the plurality of database servers in the owner set for each ownership group that is designated as the at least one type of ownership group.
Claim 131
Dependent Claim
104 words
The computer-readable medium of claim 107 , wherein: a first database server of the plurality of database servers desires data that is included in a particular ownership group assigned to a particular owner set; if the first database server is included in the particular owner set, a process executing on the first database server directly retrieves the data; and if the first database server is not included in the particular owner set, the process executing on the first database server requests and receives the data from a second database server, of the plurality of database servers, that is included in the particular owner set.
Claim 132
Dependent Claim
41 words
The computer-readable medium of claim 123 , wherein the particular ownership group is a shared disk ownership group, the particular owner set includes the plurality of database servers, and the process executing on the first database server directly retrieves the data.
Claim 133
Dependent Claim
39 words
The computer-readable medium of claim 123 , wherein the particular ownership group is a shared nothing ownership group and the second database server of the plurality of database servers is the only database server in the particular owner set.
Claim 134
Dependent Claim
39 words
The computer-readable medium of claim 123 , wherein the particular ownership group is a shared nothing ownership group and the first database server of the plurality of database servers is the only database server in the particular owner set.
Claim 135
Dependent Claim
85 words
The computer-readable medium of claim 107 , further comprising instructions which, when executed by the one or more processors, cause the one or more processors to carry out the steps of: assigning at least one ownership group of the plurality of ownership groups an owner from among said plurality of database servers; and reassigning the owner for the at least one ownership group from a first database server of the plurality of database servers to a second database server of the plurality of database servers.
Claim 136
Dependent Claim
20 words
The computer-readable medium of claim 127 , wherein the at least one ownership group is a shared nothing ownership group.
Claim 137
Dependent Claim
29 words
The computer-readable medium of claim 127 , wherein the step of reassigning the owner set for the at least one ownership group is performed in response to a request.
Claim 138
Dependent Claim
35 words
The computer-readable medium of claim 127 , wherein the step of reassigning the owner set for the at least one ownership group is performed automatically in response to a failure of the first database server.
Claim 139
Dependent Claim
113 words
The computer-readable medium of claim 107 , further comprising instructions which, when executed by the one or more processors, cause the one or more processors to carry out the steps of: transitioning a particular ownership group from a first owner set to a second owner set by performing the steps of: instructing the plurality of database servers to cease creating new versions of data within the particular ownership group; and when all transactions that are accessing said data through said first owner set have either committed or aborted, changing data that indicates ownership of the particular ownership group to indicate that the second owner set is the owner of the particular ownership group.
Claim 140
Dependent Claim
127 words
The computer-readable medium of claim 131 , further comprising instructions which, when executed by the one or more processors, cause the one or more processors to carry out the steps of: in response to a failure in transitioning the particular ownership group from the first owner set to the second owner set, determining whether the failure occurred prior to changing the data that indicates ownership of the particular ownership group; if the failure occurred before changing the data that indicates ownership of the particular ownership group, restoring the first owner set as owner of the particular ownership group; and if the failure occurred after changing the data that indicates ownership of the particular ownership group, retaining the second owner set as owner of the particular ownership group.
Claim 141
Dependent Claim
100 words
The computer-readable medium of claim 107 , wherein a query is included in the database, wherein the query is associated with an execution plan that refers to a first owner set, and further comprising instructions which, when executed by the one or more processors, cause the one or more processors to carry out the steps of: transitioning a particular ownership group from the first owner set to a second owner set; and after transitioning the particular ownership group from the first owner set to the second owner set, generating a new execution plan that refers to the second owner set.
Claim 142
Dependent Claim
101 words
The computer-readable medium of claim 107 , further comprising instructions which, when executed by the one or more processors, cause the one or more processors to carry out the steps of: reassigning a data item from a first ownership group to a second ownership group by performing the steps of: disabling access by the plurality of database servers to the data item; and when all transactions that are accessing said data item have either committed or aborted, changing data that indicates to which ownership group the data item belongs to indicate that the data item belongs to the second ownership group.
Claim 143
Dependent Claim
63 words
The computer-readable medium of claim 134 , further comprising instructions which, when executed by the one or more processors, cause the one or more processors to carry out the steps of: changing first data to indicate to which ownership group the data item belongs; and before changing the first data, changing second data to indicate to which ownership group the data item belongs.
Claim 144
Dependent Claim
25 words
The computer-readable medium of claim 135 , wherein the first data is in a control file and the second data is in a data dictionary.
Claim 145
Dependent Claim
110 words
The computer-readable medium of claim 135 , further comprising instructions which, when executed by the one or more processors, cause the one or more processors to carry out the steps of: in response to a failure of reassigning the data item from the first ownership group to the second ownership group, determining whether the failure occurred before changing the second data; if the failure occurred before changing the second data, restoring the data item to the first ownership group; and if the failure occurred after changing second data, completing the reassignment of the data item from the first ownership group to the second ownership group by changing the first data.
Claim 146
Dependent Claim
60 words
The computer-readable medium of claim 134 , further comprising instructions which, when executed by the one or more processors, cause the one or more processors to carry out the steps of: determining whether the second ownership group is undergoing an ownership change; and if the second ownership group is undergoing an ownership change, marking the data item as move delayed.
Claim 147
Dependent Claim
181 words
A computer-readable medium carrying one or more sequences of instructions for transitioning ownership of a data item from a first owner set to a second owner set, 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: informing a plurality of database servers that the data item is being transitioned from the first owner set to the second owner set; after informing said plurality of database servers, allowing members of said first owner set and members of said second owner set to directly access said data item; detecting when all transactions that are accessing said data item through said first owner set have either committed or aborted; and after detecting when all transactions that are accessing said data item through said first owner set have either committed or aborted, performing the steps of: storing data that indicates that the second owner set is the exclusive owner of the data item; and allowing only members of said second owner set to directly access said data item.
Claim 148
Dependent Claim
181 words
A computer-readable medium carrying one or more sequences of instructions for transitioning ownership of a data item from a first owner set to a second owner set, 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: informing a plurality of database servers that the data item is being transitioned from the first owner set to the second owner set; after informing said plurality of database servers, allowing members of said first owner set and members of said second owner set to directly access said data item; detecting when all transactions that are accessing said data item through said first owner set have either committed or aborted; and after detecting when all transactions that are accessing said data item through said first owner set have either committed or aborted, performing the steps of: storing data that indicates that the second owner set is the exclusive owner of the data item; and allowing only members of said second owner set to directly access said data item.
Claim 149
Dependent Claim
72 words
The computer-readable medium of claim 139 , wherein the instructions for detecting when all transactions that are accessing said data item through said first owner set have either committed or aborted further comprise instructions which, when executed by one or more processors, cause the one or more processors to carry out the step of: detecting when all transactions that began execution prior to the step of informing have either committed or aborted.
Claim 150
Dependent Claim
68 words
The computer-readable medium of claim 139 , wherein the instructions for informing the plurality of database servers that the data item is being transitioned from the first owner set to the second owner set further comprise instructions which, when executed by one or more processors, cause the one or more processors to carry out the step of: sending a refresh cache message to the plurality of database servers.
Claim 151
Dependent Claim
64 words
The computer-readable medium of claim 139 , further comprising instructions which, when executed by the one or more processors, cause the one or more processors to carry out the step of: prior to informing the plurality of database servers, storing data that identifies the first owner set, the second owner set, and that indicates that the owner of the data item is in transition.
Claim 152
Dependent Claim
154 words
The computer-readable medium of claim 139 , wherein the instructions for allowing members of said first owner set and said second owner set to directly access said data item further comprise instructions which, when executed by one or more processors, cause the one or more processors to carry out the steps of: if a particular database server of the plurality of database servers begins a transaction prior to being informed that the data item is being transitioned from the first owner set to the second owner set, processing the transaction as if the first owner set is the owner of the data item; and if the particular database server of the plurality of database servers begins the transaction after being informed that the data item is being transitioned from the first owner set to the second owner set, processing the transaction as if the second owner set is the owner of the data item.
Claim 153
Dependent Claim
52 words
The computer-readable medium of claim 139 , wherein a shared disk locking mechanism performs the steps of: allowing members of said first owner set and members of said second owner set to directly access said data item; and allowing only members of said second owner set to directly access said data item.
References Cited (Backward Citations)
US4853843A
Cited
US5333313A
Cited
US5448727A
Cited
US5640556A
Cited
US5794229A
Cited
US5546575A
Cited
US5625811A
Cited
US5675791A
Cited
US6101495A
Cited
US20020124082A1
Cited
US5717919A
Cited
US5710915A
Cited
US5761500A
Cited
US5907849A
Cited
US6092062A
Cited
US6240417B1
Cited
US6078990A
Cited
US6594698B1
Cited
US6321238B1
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2007-03-23 | 2007-09-22 | 2008-03-23 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2011-03-23 | 2011-09-22 | 2012-03-23 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2015-03-23 | 2015-09-22 | 2016-03-23 | $7700.00 | Window Closed / Lapsed |