US Patent No: 6,711,571
Number of patents in Portfolio can not be more than 2000
Partitioning ownership of a database among different database servers to control access to the database
Stats
-
Mar 23, 2004
Issued date -
Jun 28, 2001
filing date -
09/896,373
serial no -
In Force
status
Importance
Loading Importance Indicators...
Abstract
A database or some portion thereof is partitioned into ownership groups. Each ownership group is assigned one or more database servers as owners of the ownership group. The database servers that are assigned as owners of an ownership group are treated as the owners of all data items that belong to the ownership group. That is, they are allowed to directly access the data items within the ownership group, while other database servers are not allowed to directly access those data items. Accordingly, a database system is provided which includes one or more persistent storage devices having a database stored thereon, and a plurality of database servers executing on a plurality of nodes. Each node has direct access to the persistent storage devices. At least a portion of the database is partitioned into a plurality of ownership groups. Each ownership group is assigned an owner set. Only processes that are executing on database servers that are members of the owner set of an ownership group are allowed to directly access data within the ownership group. Each ownership group is designated as either a shared nothing ownership group or a shared disk ownership group. Each shared nothing ownership group is assigned an owner from among the database servers. Only the owner of each shared nothing ownership group is allowed to directly access data within the shared nothing ownership group. Each of the database servers is allowed to directly access data within ownership groups that are designated as shared disk ownership groups.
Loading the Abstract Image...
First Claim
Related Publications
Loading Related Publications...
International Classification(s)
- [Classification Symbol]
- [Patents Count]
Cited Art
| Patent Info | (Count) | # Cites | Year |
|---|---|---|---|
|
|
|||
| 5,625,811 Method and system for database load balancing | 25 | 1994 | |
| 5,675,791 Method and system for database load balancing | 78 | 1996 | |
| 5,907,849 Method and system for recovery in a partitioned shared nothing database system using virtual share disks | 23 | 1997 | |
| 6,092,062 Relational database query optimization to perform query evaluation plan, pruning based on the partition properties | 93 | 1997 | |
|
|
|||
| 5,717,919 Database system with methods for appending data records by partitioning an object into multiple page chains | 94 | 1995 | |
| 5,794,229 Database system with methodology for storing a database table by vertically partitioning all columns of the table | 170 | 1995 | |
|
|
|||
| 6,078,990 Volume set configuration using a single operational view | 132 | 1998 | |
| 6,594,698 Protocol for dynamic binding of shared resources | 61 | 1998 | |
|
|
|||
| 6,240,417 Integration of legacy database management systems with ODBC-compliant application programs | 73 | 1999 | |
|
|
|||
| 5,546,575 Encoding method for compressing a tabular database by selecting effective compression routines for each field and structure of partitions of equal sized records | 54 | 1994 | |
|
|
|||
| 5,333,313 Method and apparatus for compressing a dictionary database by partitioning a master dictionary database into a plurality of functional parts and applying an optimum compression technique to each part | 41 | 1990 | |
|
|
|||
| 5,640,556 Synchronous/asynchronous client server access based upon database file record attribute | 29 | 1996 | |
|
|
|||
| 5,448,727 Domain based partitioning and reclustering of relations in object-oriented relational database management systems | 144 | 1991 | |
|
|
|||
| 5,710,915 Method for accelerating access to a database clustered partitioning | 121 | 1995 | |
|
|
|||
| 6,101,495 Method of executing partition operations in a parallel database system | 49 | 1998 | |
|
|
|||
| 5,761,500 Multi-site data communications network database partitioned by network elements | 75 | 1996 | |
|
|
|||
| 6,321,238 Hybrid shared nothing/shared disk database system | 22 | 1998 | |
|
|
|||
| 4,853,843 System for merging virtual partitions of a distributed database | 255 | 1987 | |
Patent Citation Ranking
Maintenance Fees
| Fee | Large entity fee | small entity fee | micro entity fee | due date |
|---|---|---|---|---|
| 11.5 Year Payment | $7400.00 | $3700.00 | $1850.00 | Sep 23, 2015 |
| Fee | Large entity fee | small entity fee | micro entity fee |
|---|---|---|---|
| Surcharge - 11.5 year - Late payment within 6 months | $160.00 | $80.00 | $40.00 |
| Surcharge after expiration - Late payment is unavoidable | $700.00 | $350.00 | $175.00 |
| Surcharge after expiration - Late payment is unintentional | $1,640.00 | $820.00 | $410.00 |