Patent JPS5925474A successfully refreshed from Google Patents.
Patent US6920460B1 successfully refreshed from Google Patents.
US6920460B1
Expired / Lapsed
US
⏱️ 0.0 years remaining
Systems and methods for managing partitioned indexes that are created and maintained by user-defined indexing schemes
Assignee: Oracle International Corp
•
Filing: 2002-05-29
•
Granted: 2005-07-19
•
Expires: 2022-05-29
Abstract
Abstract Domain indexes (indexes created and maintained by user-defined indexing schemes) are managed on partitioned database objects that store data using a system-managed approach. Partition maintenance operations performed on the partitioned database objects cause corresponding partition maintenance operations to be performed on the domain indexes. Partition maintenance operations are performed on both the database objects and the indexes by a system-supplied partition manager. Changes in the partition maintenance operations or partitioning methods supplied by the database management system do not affect user-supplied code which is provided by the user-defined indexing scheme. User-supplied code is therefore partition operation-unaware.
Inventors
- 👤 Jagannathan Srinivasan
- 👤 Seema Sundara
- 👤 Nipun Agarwal
- 👤 Ying Hu
- 👤 Timothy Chorma
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-11-08 20:55
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/20; G06F16/22; G06F16/2282; G06F16/2228; G06F16/2272; Y; Y10; Y10S; Y10S707/00; Y10S707/99941; Y10S707/99943
Claims Analysis
Total Claims: 32
Claim 1
Independent Claim
146 words
A computer-implemented database management system (DBMS) adapted to manage an index associated with first data stored in a first database object, the first database object comprising a first plurality of partitions, the index comprising index data stored in a second database object, the second database object comprising a second plurality of partitions, wherein the index is created using an index scheme supplied by a user of the DBMS, the DBMS comprising: a database object generator adapted to generate the first database object, a database object populator adapted to populate the first database object with the first data, and a partition manager adapted to perform a plurality of partition maintenance operations including a first partition maintenance operation on the first database object and a second partition maintenance operation on the second database object, wherein the second partition maintenance operation is related to the first partition maintenance operation.
Claim 2
Dependent Claim
146 words
A computer-implemented database management system (DBMS) adapted to manage an index associated with first data stored in a first database object, the first database object comprising a first plurality of partitions, the index comprising index data stored in a second database object, the second database object comprising a second plurality of partitions, wherein the index is created using an index scheme supplied by a user of the DBMS, the DBMS comprising: a database object generator adapted to generate the first database object, a database object populator adapted to populate the first database object with the first data, and a partition manager adapted to perform a plurality of partition maintenance operations including a first partition maintenance operation on the first database object and a second partition maintenance operation on the second database object, wherein the second partition maintenance operation is related to the first partition maintenance operation.
Claim 3
Dependent Claim
20 words
The DBMS of claim 1 , wherein the first partition maintenance operation is equivalent to the second partition maintenance operation.
Claim 4
Dependent Claim
21 words
The DBMS of claim 2 , wherein the first partition maintenance operation and the second partition maintenance operation are the same.
Claim 5
Dependent Claim
25 words
The DBMS of claim 1 , wherein the database object generator is adapted to generate both the first database object and the second database object.
Claim 6
Dependent Claim
25 words
The DBMS of claim 1 , further comprising an index marker adapted to mark a first one of the second plurality of partitions as unusable.
Claim 7
Dependent Claim
16 words
The DBMS of claim 1 , further comprising an index generator adapted to generate the index.
Claim 8
Dependent Claim
18 words
The DBMS of claim 6 , wherein the index generator is supplied by a user of the DBMS.
Claim 9
Dependent Claim
16 words
The DBMS of claim 1 , further comprising an index rebuilder adapted to rebuild the index.
Claim 10
Dependent Claim
18 words
The DBMS of claim 8 , wherein the index rebuilder is supplied by a user of the DBMS.
Claim 11
Dependent Claim
25 words
The DBMS of claim 1 , wherein there is a one-to many relationship between the first plurality of partitions and the second plurality of partitions.
Claim 12
Dependent Claim
24 words
The DBMS of claim 10 , wherein there exists a one-to-one correspondence between the first plurality of partitions and the second plurality of partitions.
Claim 13
Dependent Claim
18 words
The DBMS of claim 1 , wherein the DBMS is adapted to support a plurality of partitioning methods.
Claim 14
Dependent Claim
24 words
The DBMS of claim 12 , wherein the first partition maintenance operation is specific to a first one of the plurality of partitioning methods.
Claim 15
Dependent Claim
24 words
The DBMS of claim 13 , wherein the second partitioning maintenance operation is specific to the first one of the plurality of partitioning methods.
Claim 16
Dependent Claim
21 words
The DBMS of claim 12 , wherein the index scheme is not dependent on any of the plurality of partitioning methods.
Claim 17
Dependent Claim
33 words
The DBMS of claim 12 , wherein the DBMS is adapted to allow a second partitioning method to be added to the plurality of partitioning methods without requiring modification of the index scheme.
Claim 18
Dependent Claim
35 words
The DBMS of claim 1 , wherein the DBMS is adapted to allow a third partition maintenance operation to be added to the plurality of partition maintenance operations without requiring modification of the index scheme.
Claim 19
Dependent Claim
143 words
A computer-implemented method of managing an index associated with first data stored in a first database object, the first database object comprising a first plurality of partitions, the index comprising index data stored in a second database object, the second database object comprising a second plurality of partitions, wherein the index is created using an index scheme supplied by a user, the method comprising: performing a first partition maintenance operation on the first database object, making a partition truncation decision regarding the second database object, performing a second partition maintenance operation on the second database object, and making a partition marking decision regarding the second database object, wherein the first partition maintenance operation and the second partition maintenance operation are both performed by one or more system-supplied modules, and wherein the second partition maintenance operation is related to the first partition maintenance operation.
Claim 20
Dependent Claim
143 words
A computer-implemented method of managing an index associated with first data stored in a first database object, the first database object comprising a first plurality of partitions, the index comprising index data stored in a second database object, the second database object comprising a second plurality of partitions, wherein the index is created using an index scheme supplied by a user, the method comprising: performing a first partition maintenance operation on the first database object, making a partition truncation decision regarding the second database object, performing a second partition maintenance operation on the second database object, and making a partition marking decision regarding the second database object, wherein the first partition maintenance operation and the second partition maintenance operation are both performed by one or more system-supplied modules, and wherein the second partition maintenance operation is related to the first partition maintenance operation.
Claim 21
Dependent Claim
25 words
The method of claim 18 , wherein making the partition truncation decision comprises deciding to truncate a first one of the second plurality of partitions.
Claim 22
Dependent Claim
24 words
The method of claim 18 , wherein making the partition truncation decision comprises deciding not to truncate any of the second plurality of partitions.
Claim 23
Dependent Claim
27 words
The method of claim 18 , wherein making the partition marking decision comprises deciding to mark a first one of the second plurality of partitions as unusable.
Claim 24
Dependent Claim
26 words
The method of claim 18 , wherein making the partition marking decision comprises deciding not to mark any of the second plurality of partitions as unusable.
Claim 25
Dependent Claim
13 words
The method of claim 21 , further comprising rebuilding the partition marked unusable.
Claim 26
Dependent Claim
23 words
The method of claim 23 , wherein rebuilding the partition marked unusable comprises rebuilding according to the index scheme supplied by the user.
Claim 27
Dependent Claim
20 words
The method of claim 18 , wherein the first partition maintenance operation is equivalent to the second partition maintenance operation.
Claim 28
Dependent Claim
21 words
The method of claim 25 , wherein the first partition maintenance operation and the second partition maintenance operation are the same.
Claim 29
Dependent Claim
25 words
The method of claim 18 , wherein there is a one-to many relationship between the first plurality of partitions and the second plurality of partitions.
Claim 30
Dependent Claim
24 words
The method of claim 27 , wherein there exists a one-to-one correspondence between the first plurality of partitions and the second plurality of partitions.
Claim 31
Dependent Claim
163 words
A computer-useable medium, the medium comprising a sequence of instructions which, when executed by a processor, causes the processor to execute a method of managing an index associated with first data stored in a first database object, the first database object comprising a first plurality of partitions, the index comprising index data stored in a second database object, the second database object comprising a second plurality of partitions, wherein the index is created using an index scheme supplied by a user, the method comprising: performing a first partition maintenance operation on the first database object, making a partition truncation decision regarding the second database object, performing a second partition maintenance operation on the second database object; and making a partition marking decision regarding the second database object, wherein the first partition maintenance operation and the second partition maintenance operation are both performed by one or more system-supplied modules, and wherein the second partition maintenance operation is related to the first partition maintenance operation.
Claim 32
Dependent Claim
163 words
A computer-useable medium, the medium comprising a sequence of instructions which, when executed by a processor, causes the processor to execute a method of managing an index associated with first data stored in a first database object, the first database object comprising a first plurality of partitions, the index comprising index data stored in a second database object, the second database object comprising a second plurality of partitions, wherein the index is created using an index scheme supplied by a user, the method comprising: performing a first partition maintenance operation on the first database object, making a partition truncation decision regarding the second database object, performing a second partition maintenance operation on the second database object; and making a partition marking decision regarding the second database object, wherein the first partition maintenance operation and the second partition maintenance operation are both performed by one or more system-supplied modules, and wherein the second partition maintenance operation is related to the first partition maintenance operation.
References Cited (Backward Citations)
US5485610A
Cited
US5524205A
Cited
US5485608A
Cited
US5742706A
Cited
US5857180A
Cited
US6439783B1
Cited
US5664172A
Cited
US6161105A
Cited
US6240410B1
Cited
US6112201A
Cited
US5731814A
Cited
US6014656A
Cited
US5920868A
Cited
US6374232B1
Cited
US5870759A
Cited
US5926816A
Cited
US5884325A
Cited
US5870765A
Cited
US5852818A
Cited
US5848408A
Cited
US6549901B1
Cited
US6272503B1
Cited
US6370529B1
Cited
US6105026A
Cited
US6240428B1
Cited
US6061690A
Cited
US6006234A
Cited
US6014614A
Cited
US6223182B1
Cited
US6606638B1
Cited
US6430571B1
Cited
US6587854B1
Cited
US6405284B1
Cited
US6530035B1
Cited
US6553369B1
Cited
US6401083B1
Cited
US6542854B2
Cited
US6505205B1
Cited
US6470344B1
Cited
US6381605B1
Cited
US6438562B1
Cited
US6665684B2
Cited
US6609131B1
Cited
US6484179B1
Cited
US6636870B2
Cited
US6502089B1
Cited
US6618822B1
Cited
US20010054034A1
Cited
US6622138B1
Cited
US6389410B1
Cited
US20020178394A1
Cited
US6574717B1
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2008-07-18 | 2009-01-17 | 2009-07-19 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2012-07-18 | 2013-01-17 | 2013-07-19 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2016-07-18 | 2017-01-17 | 2017-07-19 | $7700.00 | Window Closed / Lapsed |