Using transportable tablespaces for hosting data of multiple users
AssigneeOracle Corporation
InventorsJuan R. Loaiza, Hasan Rizvi, J. William Lee, William H. Bridge, Jr., Jonathan D. Klein, Alex Tsukerman, Gianfranco Putzolu
Life of this patent
Estimating the term…
Abstract
Provided are mechanisms that may be used to support efficient exportation of user data stored in a database system. According to an aspect of the present invention, a database system is configured to store data for users in separate repositories referred to as tablespaces. To store data in this manner, a database system may be configured in variety of ways.
Claims26
A method of managing data stored in a database system for a plurality of users, the
- method comprising the steps of:
- generating metadata that defines:
- one or more tables spaces for said database system, and
- an association between said one or more tablespaces and said plurality of users;
- selecting which tablespaces to use to store data for each of user of said plurality of users based on said association between said one or more tablespaces and said plurality of users;
- and
- exporting to another database system said data associated with a particular user, wherein the step of exporting includes generating a binary copy of a subset of one or more tablespaces of said one or more tablespaces, wherein said subset of one or more tablespaces were selected to store data for said particular user.
A computer-readable medium carrying one or more sequences of instructions for managing data stored in a database system for a plurality of users, 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:
- generating metadata that defines:
- one or more tables spaces for said database system, and
- an association between said one or more tablespaces and said plurality of users;
- selecting which tablespaces to use to store data for each of user of said plurality of users based on said association between said one or more tablespaces and said plurality of users;
- and
- exporting to another database system said data associated with a particular user, wherein the step of exporting includes generating a binary copy of a subset of one or more tablespaces of said one or more tablespaces, wherein said subset of one or more tablespaces were selected to store data for said particular user.
A computer system, comprising:
- a database system that stores data for a plurality of users in one or more tablespaces;
- said database system including metadata that defines an association between said one or more tablespaces and said plurality of users;
- and
- said database system configured to select which tablespaces to use to store data for each user of said plurality of users based on said association between said one or more tablespaces and said plurality of users;
- and
- said database system configured to export to another database system said data associated with a particular user by performing steps that include generating a binary copy of a subset of one or more tablespaces of said one or more tablespaces, wherein said subset of one or more tablespaces were selected to store data for said particular user.
A method of plugging in a pluggable set of tablespaces having a plurality of disk pointers into a target database, comprising the computer-implemented steps of:
- incorporating metadata into said target database, said metadata describing said tablespace and data therein;
- 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.
Dependencies are inferred from the claim text.