US5890167A
Expired / Lapsed
US
⏱️ 0.0 years remaining
Pluggable tablespaces for database systems
Assignee: Oracle International Corp
•
Filing: 1997-05-08
•
Granted: 1999-03-30
•
Expires: 2017-05-08
Abstract
Abstract A pluggable tablespace is enabled by logically partitioning a database into a set of tablespaces and storing all of the tablespaces disk pointers in tablespace-relative format. A pluggable set of tablespaces is unplugged by exporting the associated metadata, and making a binary copy of the tablespaces. The pluggable set of tablespaces is plugged into a target database by making the pluggable set accessible to the target database and importing the associated metadata, without patching any of the disk pointers.
Inventors
- 👤 William H. Bridge, Jr.
- 👤 Jonathan D. Klein
- 👤 J. William Lee
- 👤 Juan R. Loaiza
- 👤 Alex Tsukerman
- 👤 Gianfranco Putzolu
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-11-04 00:33
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/20; G06F16/22; G06F16/2282; Y; Y10; Y10S; Y10S707/00; Y10S707/99941; Y10S707/99942; Y10S707/99951; Y10S707/99952; Y10S707/99953; Y10S707/99955
Claims Analysis
Total Claims: 29
Claim 1
Independent Claim
96 words
A method for unplugging a set of tablespaces, associated with metadata and having a plurality of disk pointers, from a source database to a memory, comprising the computer-implemented steps of: storing said plurality of disk pointers in tablespace-relative format; saving said metadata into a metadata file; and making a binary copy of said set of tablespaces and said metadata file to said memory wherein said plurality of disk pointers with said binary copy, when plugged into a target database, is capable of being used for locating associated data items without patching said plurality of disk pointers.
Claim 2
Independent Claim
96 words
A method for unplugging a set of tablespaces, associated with metadata and having a plurality of disk pointers, from a source database to a memory, comprising the computer-implemented steps of: storing said plurality of disk pointers in tablespace-relative format; saving said metadata into a metadata file; and making a binary copy of said set of tablespaces and said metadata file to said memory wherein said plurality of disk pointers with said binary copy, when plugged into a target database, is capable of being used for locating associated data items without patching said plurality of disk pointers.
Claim 3
Dependent Claim
27 words
The method of claim 1, wherein the step of saving said metadata into a metadata file includes the step of exporting said metadata into the metadata file.
Claim 4
Dependent Claim
55 words
The method of claim 2, wherein the step of exporting said metadata into the metadata file includes the steps of: determining whether said set of tablespaces is self-contained; if said set of tablespaces is not self-contained, then dropping objects in said set of tablespace that refer to objects not present in said set of tablespaces.
Claim 5
Dependent Claim
51 words
The method of claim 2, wherein the step of exporting said metadata into the metadata file includes the steps of: determining whether said set of tablespaces is self-contained; if said set of tablespaces is not self-contained, then outputting a message to a user that said set of tablespaces is not self-contained.
Claim 6
Dependent Claim
31 words
The method of claim 4, further comprising the step of outputting a second message identifying which tablespaces of said set of tablespace causes said set of tablespaces to be not self-contained.
Claim 7
Dependent Claim
59 words
The method of claim 1, further comprising the step of locating a data item within a datafile contained in said tablespace by performing the steps of: reading a tablespace-relative disk pointer associated with said data item; determining an identity of said tablespace; and locating said data item based on said tablespace-relative disk pointer and said identity of said tablespace.
Claim 8
Independent Claim
75 words
A method of plugging in a pluggable set of tablespaces having a plurality of disk pointers and saved metadata, into a target database, comprising the computer-implemented steps of: incorporating said saved metadata into said target database; copying each tablespace of said pluggable set of tablespaces into said target database; and locating a data item associated with any one of said plurality of disk pointers without patching any disk pointer of said plurality of disk pointers.
Claim 9
Independent Claim
75 words
A method of plugging in a pluggable set of tablespaces having a plurality of disk pointers and saved metadata, into a target database, comprising the computer-implemented steps of: incorporating said saved metadata into said target database; copying each tablespace of said pluggable set of tablespaces into said target database; and locating a data item associated with any one of said plurality of disk pointers without patching any disk pointer of said plurality of disk pointers.
Claim 10
Dependent Claim
29 words
The method of claim 7, wherein the step of incorporating said saved metadata into said target database, includes the step of importing said saved metadata into said target database.
Claim 11
Dependent Claim
41 words
The method of claim 7, further comprising the step of assigning a new tablespace number to each tablespace in said pluggable set of tablespaces, wherein each new tablespace number is unique within said target database and said pluggable set of tablespaces.
Claim 12
Dependent Claim
65 words
The method of claim 7, further comprising the steps of: determining whether an external name of an object contained in said pluggable set of tablespaces exists in said target database; if said external name of said object contained in said pluggable set of tablespaces exists in said target database, then prompting the user to rename an object within said target database having said external name.
Claim 13
Dependent Claim
41 words
The method of claim 7, further comprising the step of automatically assigning a new internal name to an object within said pluggable set of tablespaces, wherein said internal name is unique within said target database and said pluggable set of tablespaces.
Claim 14
Independent Claim
102 words
A method of transferring a tablespace, associated with metadata and having a plurality of disk pointers, from a first database to a second database, comprising the steps of: storing said plurality of disk pointers in tablespace-relative format at first database; saving said metadata into a metadata file; making a binary copy of said tablespace and said metadata file; causing said binary copy to be available to said second database; incorporating said metadata from said binary copy into said second database; and locating a data item associated with any one of said plurality of disk pointers without patching said plurality of disk pointers.
Claim 15
Independent Claim
102 words
A method of transferring a tablespace, associated with metadata and having a plurality of disk pointers, from a first database to a second database, comprising the steps of: storing said plurality of disk pointers in tablespace-relative format at first database; saving said metadata into a metadata file; making a binary copy of said tablespace and said metadata file; causing said binary copy to be available to said second database; incorporating said metadata from said binary copy into said second database; and locating a data item associated with any one of said plurality of disk pointers without patching said plurality of disk pointers.
Claim 16
Dependent Claim
27 words
The method of claim 12, wherein the step of saving said metadata into a metadata file includes the step of exporting said metadata into the metadata file.
Claim 17
Dependent Claim
55 words
The method of claim 13, wherein the step of exporting said metadata into the metadata file includes the steps of: determining whether said set of tablespaces is self-contained; if said set of tablespaces is not self-contained, then dropping objects in said set of tablespace that refer to objects not present in said set of tablespaces.
Claim 18
Dependent Claim
51 words
The method of claim 13, wherein the step of exporting said metadata into the metadata file includes the steps of: determining whether said set of tablespaces is self-contained; if said set of tablespaces is not self-contained, then outputting a message to a user that said set of tablespaces is not self-contained.
Claim 19
Dependent Claim
31 words
The method of claim 15, further comprising the step of outputting a second message identifying which tablespaces of said set of tablespace causes said set of tablespaces to be not self-contained.
Claim 20
Dependent Claim
29 words
The method of claim 12, wherein the step of incorporating said saved metadata into said second database, includes the step of importing said saved metadata into said second database.
Claim 21
Dependent Claim
41 words
The method of claim 12, further comprising the step of assigning a new tablespace number to each tablespace in said pluggable set of tablespaces, wherein each new tablespace number is unique within said second database and said pluggable set of tablespaces.
Claim 22
Dependent Claim
65 words
The method of claim 12, further comprising the steps of: determining whether an external name of an object contained in said pluggable set of tablespaces exists in said second database; if said external name of said object contained in said pluggable set of tablespaces exists in said second database, then prompting the user to rename an object within said second database having said external name.
Claim 23
Dependent Claim
41 words
The method of claim 12, further comprising the step of automatically assigning a new internal name to an object within said pluggable set of tablespaces, wherein said internal name is unique within said target database and said pluggable set of tablespaces.
Claim 24
Dependent Claim
106 words
A computer readable medium, having stored thereon sequences of instructions for unplugging a tablespace, associated with metadata and having a plurality of disk pointers, from a source database to a memory, said sequence of instructions including instructions for performing the steps of: storing said plurality of disk pointers in tablespace-relative format; saving said metadata into a metadata file; and making a binary copy of said tablespace and said metadata file to said memory wherein said plurality of disk pointers with said binary copy, when plugged into a target database, is capable of being used for locating associated data items without patching said plurality of disk pointers.
Claim 25
Dependent Claim
106 words
A computer readable medium, having stored thereon sequences of instructions for unplugging a tablespace, associated with metadata and having a plurality of disk pointers, from a source database to a memory, said sequence of instructions including instructions for performing the steps of: storing said plurality of disk pointers in tablespace-relative format; saving said metadata into a metadata file; and making a binary copy of said tablespace and said metadata file to said memory wherein said plurality of disk pointers with said binary copy, when plugged into a target database, is capable of being used for locating associated data items without patching said plurality of disk pointers.
Claim 26
Dependent Claim
26 words
The computer readable medium of claim 21, further including instructions for performing the step of exporting said metadata into a metadata datafile contained in said tablespace.
Claim 27
Dependent Claim
82 words
A computer readable medium, having stored thereon sequences of instructions for plugging in a tablespace, containing saved metadata and a plurality of disk pointers, into a target database, said sequence of instructions including instructions for performing the steps of: making said unplugged tablespace stored in said memory available to said target database; incorporating said saved metadata into said target database; and locating a data item associated with any one of said plurality of disk pointers without patching said plurality of disk pointers.
Claim 28
Dependent Claim
82 words
A computer readable medium, having stored thereon sequences of instructions for plugging in a tablespace, containing saved metadata and a plurality of disk pointers, into a target database, said sequence of instructions including instructions for performing the steps of: making said unplugged tablespace stored in said memory available to said target database; incorporating said saved metadata into said target database; and locating a data item associated with any one of said plurality of disk pointers without patching said plurality of disk pointers.
Claim 29
Dependent Claim
26 words
The computer readable medium of claim 23, further including instructions for performing the step of importing said metadata from a metadata datafile contained in said tablespace.
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) | 2002-03-29 | 2002-09-28 | 2003-03-30 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2006-03-29 | 2006-09-28 | 2007-03-30 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2010-03-29 | 2010-09-28 | 2011-03-30 | $7700.00 | Window Closed / Lapsed |