Integrating tablespaces with different block sizes
AssigneeOracle International Corporation
InventorsSreedhar Mukkamalla, Arvind Nithrakashyap, Tirthankar Lahiri, Alok Pareek, Juan Loaiza, J. Lee, Gary Ngai
Life of this patent
Estimating the term…
Abstract
Provided herein is a mechanism that allows a given database system to access data blocks from another database system, where data blocks from the given database system and data blocks from the other database system have different sizes. According to an aspect of the present invention, a tablespace in the other database system contained the data blocks. The tablespace is detached from the other database system and integrated into the given database, which is capable of processing data stored in data blocks of different sizes.
Claims42
A method for database systems to access data from other database systems, the method comprising the steps of:
- a first database system storing in a buffer cache first data blocks having a first data block size, wherein said first database system includes said buffer cache and stores data blocks of multiple sizes within said buffer cache;
- concurrently with said first database system storing in said buffer cache first data blocks having a first data block size, said first database system storing in said buffer cache a copy of second data blocks in which a second database system stored second database records;
- said second data blocks having at least one data block with a second data block size different than said first data block size;
- and
- wherein each block of said first data blocks and of said second data blocks is an atomic unit of storage space allocated within a file to store one or more records of a database.
A method for database systems to access data from other database systems, the method comprising the steps of:
- a first database system directly storing first database records in first data blocks having a first data block size;
- concurrently with said first database system directly storing first database records in first data blocks having a first data block size, said first database system directly accessing a copy of second data blocks in which a second database system directly stored second database records;
- said second data blocks having at least one data block with a second data block size different than said first data block size;
- and
- wherein each block of said first data blocks and of said second data blocks is an atomic unit of storage space allocated within a file to store one or more records of a database.
A computer-readable medium carrying one or more sequences of instructions for database systems to access data from other database systems, 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:
- a first database system directly storing first database records in first data blocks having a first data block size, wherein said first database system includes a buffer cache in which said first database system stores data blocks of multiple sizes;
- concurrently with said first database system directly storing first database records in first data blocks having a first data block size, said first database system directly accessing a copy of second data blocks in which a second database system directly stored second database records;
- said second data blocks having at least one data block with a second data block size different than said first data block size;
- concurrently storing said first data blocks and said second data blocks in said buffer cache, wherein each block of said first data blocks and of said second data blocks is an atomic unit of storage space allocated within a file to store one or more records of a database.
A computer-readable medium carrying one or more sequences of instructions for database systems to access data from other database systems, 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:
- a first database system directly storing first database records in first data blocks having a first data block size;
- concurrently with said first database system directly storing first database records in first data blocks having a first data block size, said first database system directly accessing a copy of second data blocks in which a second database system directly stored second database records;
- said second data blocks having at least one data block with a second data block size different than said first data block size;
- and
- wherein each block of said first data blocks and of said second data blocks is an atomic unit of storage space allocated within a file to store one or more records of a database.
Dependencies are inferred from the claim text.