| Integrating tablespaces with different block sizes -> Monitor Keywords |
|
|
 
Integrating tablespaces with different block sizesRelated Patent Categories: Data Processing: Database And File Management Or Data Structures, Database Or File Accessing, Distributed Or Remote AccessIntegrating tablespaces with different block sizes description/claimsThe Patent Description & Claims data below is from USPTO Patent Application 20060143187, Integrating tablespaces with different block sizes. Brief Patent Description - Full Patent Description - Patent Application Claims
RELATED APPLICATIONS [0001] The present application is a continuation of and claims priority to U.S. application Ser. No. 09/871,476 entitled "Integrating Tablespaces with Different Block Sizes", filed May 30, 2001, by Sreedhar Mukkamalla, et al., which is (1) a continuation-in-part of U.S. application Ser. No. 08/865,693, now U.S. Pat. No. 6,272,503 B1, entitled "Tablespace-Relative Database Pointers", filed on May 30, 1997 by William H. Bridge, Jr., et al., and (2) a continuation-in-part of U.S. application Ser. No. 09/675,195, now U.S. Pat. No. 6,549,901 B1 entitled "Using Transportable Tablespaces for Hosting Data of Multiple Users", filed on Sep. 29, 2000, by Juan R. Loaiza, et al. The present application hereby claims priority to and the benefit of the application filing dates for each application listed above, the contents of which are each fully incorporated herein by reference. [0002] The present application is related to U.S. application Ser. No. 08/852,968, now U.S. Pat. No. 5,890,167 entitled "Pluggable Tablespaces", filed on May 8, 1997, by William H. Bridge Jr., et al., the contents of which are herein incorporated by reference and referred to as Pluggable Tablespaces. FIELD OF THE INVENTION [0003] The present invention relates to database systems, and in particular, to techniques for efficiently moving data between database systems. BACKGROUND OF THE INVENTION [0004] The ability to store and retrieve large amounts of data are some of the most important functions of computers in today's society. To carry out these functions, database systems are typically used to retrieve and store data in databases. Database systems have performed these functions very successfully, creating for society the ability to retrieve data at speeds and quantities previously unimagined, and bestowing onto society an unprecedented level of access to information. The success of database systems has unleashed an insatiable demand for even faster and more efficient database systems that process even greater quantities of data. [0005] One mechanism that provides efficient access to large amounts of data is a data warehouse. A data warehouse represents a transformation of raw data. The raw data used by the warehouse typically comes from a "source" database system, such as an online transaction processing ("OLTP") database. The OLTP database system is oriented towards the "real time" operation of a business, while the data warehouse is oriented toward answering longer range, management oriented, questions about the business. To stay current, the data warehouse house is periodically updated with information from the OLTP database system. These updates entail transfers of large quantities of data. [0006] A conventional technique for transferring data is the command generation technique. Under the command generation technique, an "exporting" database system generates a file of insert commands. The insert commands conform to a database language, such as the structured query language ("SQL"). For each record being exported, an insert command specifies the creation of a record with the values needed to generate a copy of the record being exported. To import the data, an "importing" database system, which is capable of executing commands written in the database language, scans the file, executing each insert command. [0007] Executing an insert command for each record to export is typically a slow process, one which may span days for larger databases. While data is being exported, access to the data is restricted. Consequently, the database user, who requires access to the data, may be significantly impacted. Thus, conventional techniques for exporting data may be significantly burdensome. [0008] Another conventional technique for moving data into a data warehouse involves the use of tools available in applications used to manage data warehouses. These tools transfer data between a source database and a data warehouse using a process that has three stages: extracting data from the source database system, transforming the extracted data, and loading the transformed data into the data warehouse. These stages are referred to collectively as ETL, which stands for extraction, transformation, and loading. In general, ETL tools extract data from a source database system by issuing queries to the source database system to retrieve data. ETL tools load data in the data warehouse by issuing insert commands to the data warehouse to load the data retrieved from the source database system. While the use of ETL tools may be more efficient than the command generation technique, the process of transferring data may still require undesirably long periods of time. [0009] A novel technique that is much more efficient than the conventional techniques for transferring data is referred to as transportable tablespaces. A tablespace is a collection of storage containers (e.g. data files) used to store data for database objects. Database objects are objects managed by a database system. Transportable tablespaces is a technique that allows tablespaces to be copied and integrated into another database system, or in other words, "plugged into" the other database system. This capability allows data to be copied using operating system utilities for copying files, which run much faster than the process of extracting and loading data by executing queries and insert statements. [0010] Unfortunately, it is not always possible to plug in a tablespace from one database system to another because the database systems may not be configured to handle the same data block size. A data block is an atomic unit of storage space allocated to store one or more database records (e.g. rows). Typically, a database system is configured to operate upon a database composed of data blocks of one particular size. In some systems, the particular size may be configured by a user when a database is created. Once a database is created, however, the data block size may not be changed. Consequently, a tablespace composed of data blocks of a given size may not be plugged into a database system that expects data blocks of a different block size. [0011] It is possible to overcome this limitation by managing the data block sizes of both the data warehouse and its source database systems. The source database system and the data warehouse may be configured for the same data block size. However, for purposes of efficiency, it is usually desirable to have larger block sizes for data warehouses and smaller block sizes for OLTP systems. For this reason, data warehouses typically have larger block sizes than OLTP systems. [0012] Based on the foregoing, it is clearly desirable to provide a mechanism that allows a tablespace or any collection of data blocks of a given size to be plugged into a database system that operates on data blocks of a different size. SUMMARY OF THE INVENTION [0013] Described herein is a mechanism that allows a given database system to access data blocks from another database system, where the 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, the data blocks in the other database system are contained in a tablespace. 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. BRIEF DESCRIPTION OF THE DRAWINGS [0014] The present invention is illustrated by way of example, and not by way of limitation, in the figures of the accompanying drawings and in which like reference numerals refer to similar elements and in which: [0015] FIG. 1 is a block diagram of a database system used to illustrate an embodiment of the present invention; [0016] FIG. 2 is a block diagram of tablespaces and data structures used to support a relative addressing scheme according to an embodiment of the present invention; [0017] FIG. 3 is a block diagram of structures used to support a buffer cache system that handles multiple size data blocks according to an embodiment of the present invention; [0018] FIG. 4 is a flow chart depicting a process for integrating a tablespace into a database system, where data blocks in the tablespace and data blocks in the database system have different block sizes according to an embodiment of the present invention; and [0019] FIG. 5 is a block diagram depicting a computer system that may be used to implement an embodiment of the present invention. Continue reading about Integrating tablespaces with different block sizes... Full patent description for Integrating tablespaces with different block sizes Brief Patent Description - Full Patent Description - Patent Application Claims Click on the above for other options relating to this Integrating tablespaces with different block sizes patent application. ###  How KEYWORD MONITOR works... a FREE service from FreshPatents1. Sign up (takes 30 seconds). 2. Fill in the keywords to be monitored. 3. Each week you receive an email with patent applications related to your keywords. Start now! - Receive info on patent apps like Integrating tablespaces with different block sizes or other areas of interest. ### Previous Patent Application: Device, data processing method, and program Next Patent Application: Method and apparatus for simplified access to online services Industry Class: Data processing: database and file management or data structures ### FreshPatents.com Support Thank you for viewing the Integrating tablespaces with different block sizes patent info. IP-related news and info Results in 0.18583 seconds Other interesting Feshpatents.com categories: Novartis , Pfizer , Philips , Polaroid , Procter & Gamble , 174 |
 * Protect your Inventions * US Patent Office filing 
PATENT INFO |
|
