Unlock instant, AI-driven research and patent intelligence for your innovation.

Partitioning ownership of a database among different database servers to control access to the database

An ownership and database technology, applied in the field of database systems, to solve problems such as unbalanced workload conditions in shared-nothing systems

Inactive Publication Date: 2009-07-22
ORACLE INT CORP
View PDF5 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, shared-nothing systems are most susceptible to unbalanced workload conditions

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Partitioning ownership of a database among different database servers to control access to the database
  • Partitioning ownership of a database among different database servers to control access to the database
  • Partitioning ownership of a database among different database servers to control access to the database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0026] A method is described here for dividing ownership of a database among different database servers in order to control database access. In the following description, for purposes of explanation, numerous details are set forth in order to provide a thorough understanding of the invention. It will be apparent, however, to one skilled in the art that the present invention may be practiced without these specific details. In order to avoid unnecessarily obscuring the present invention, other examples, well-known structures and devices are shown in block diagram form.

[0027] hardware overview

[0028] Figure 1 is a block diagram depicting a computer system 100 on which one embodiment of the present invention may be implemented. Computer system 100 includes a bus 102 or other communication structure for communicating information, and includes a processor 104 coupled with bus 102 for processing information. Computer system 100 also includes a main memory 106 , such as random...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

At least a portion of the database (250) is divided into ownership groups (230, 232, 234, 236), each of which has been assigned one or more database servers (208, 210, 212) as owners. The database server (208, 210, 212) assigned as the owner (s208, s210, s121) is considered to be the owner of all data items in this ownership group. That is, they are allowed to directly access data items in the ownership group, while other database servers are not allowed to directly access these data items. A database system includes one or more persistent storage devices (214, 216) holding a database (250), and a plurality of nodes (202, 204, 206) running on a plurality of nodes (202, 204, 206) that can directly access the persistent storage devices (214, 216) multiple database servers (208, 210, 212). At least a portion of the database (250) is divided into a plurality of ownership groups (230, 232, 234, 236), where each ownership group is assigned a set of owners. Only processes running on database servers that belong to an owner set are granted direct access to data within that ownership group.

Description

[0001] related application [0002] This application is related to prior U.S. application 09 / 222,577, filed December 28, 1998, entitled "Hybrid Shared Nothing / Shared Disk Database System," by Gianfranco Putzolu, and to U.S. application filed concurrently with this application 09 / 896,373, entitled "Partitioning Ownership of a Database Among Different Database Servers to Control Access to the Database," and its inventor is Gianfranco Putzolu. technical field [0003] The invention relates to a database system, in particular to a database ownership division between different database servers to control access to the database. Background technique [0004] Multiprocessing computer systems are those systems that include multiple processing units capable of executing instructions in parallel, relative to each other. To take advantage of parallel processing capabilities, different aspects of a task can be assigned to different processing units. Here, the different aspects of a ta...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Patents(China)
IPC IPC(8): G06F17/30G06F9/50G06F11/00G06F11/14G06F12/00G06F12/14G06F21/62
CPCG06F21/6227G06F9/5083G06F21/6209G06F11/00G06F17/30575G06F2221/2117G06F2221/2145G06F2221/2149G06F2221/2141G06F16/27
Inventor 詹弗兰科·普措卢
Owner ORACLE INT CORP