Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
1999-08-30
2004-07-27
Breene, John (Department: 2177)
Data processing: database and file management or data structures
Database design
Data structure types
C707S793000, C711S163000, C711S173000
Reexamination Certificate
active
06768985
ABSTRACT:
FIELD OF THE INVENTION
The present invention generally relates to database management systems, and more particularly, to administering a partitioned database.
BACKGROUND OF THE INVENTION
A database is partitioned primarily for administrative purposes, wherein a partition is defined in terms of a range of keys, either primary or secondary, to records in a table. Partitions allow a database administrator (DBA) to add, delete, or change information for a range of records in a table. For example, if some data within a partition of the table is no longer valid, the DBA can remove the partition that contains invalid data and then restore the valid data to the partition. Without partitions, the DBA would have to remove the entire table and restore the valid data, thereby making the entire database inaccessible to users. The partitions allow a user to continue to access some portions of a table while another portion of it has been removed for maintenance.
For some database applications, such as a data warehouse, users are typically limited to selecting records according to user-specified selection criteria. Thus, users are not permitted to insert, update, or delete records from the data warehouse. Data warehouses also tend to have very large storage requirements, often in the terabyte range. The large storage requirements can lead to more active administration of the partitions of the database. That is, partition ranges may need to be actively managed.
Removing a partition for administrative purposes may be appropriate in some circumstances, for example, when the partition contains invalid data. Since the data is invalid, user visibility of the data is undesirable. In other circumstances, however, removing a partition may be undesirable since user visibility of the data is important. For example, if an administrator is realigning partitions, in a data warehouse, users may require continued visibility of the records in the subject partitions.
A method and apparatus that addresses the aforementioned problems, as well as other related problems, are therefore desirable.
SUMMARY OF THE INVENTION
A method and apparatus for managing a database having a plurality of partitions are provided in various embodiments. The database is managed by users of a first user class and accessible to users of a second user class. Respective partition states are established for the partitions of the database, and access is provided to users of the first user class to partitions having a first partition state. Users of the second user class are denied access to partitions having the first partition state, and users of the second user class are provided access to partitions having a second partition state.
In accordance with another embodiment of the invention, a computer program product is provided to be operable to manage a database having a plurality of partitions, wherein the database is managed by users of a first user class and accessible to users of a second user class The above summary of the present invention is not intended to describe each disclosed embodiment of the present invention. The figures and detailed description that follow provide additional example embodiments and aspects of the present invention.
REFERENCES:
patent: 5659756 (1997-08-01), Hefferon et al.
patent: 5678041 (1997-10-01), Baker et al.
patent: 5713018 (1998-01-01), Chan
patent: 5751949 (1998-05-01), Thomson et al.
patent: 5768519 (1998-06-01), Swift et al.
patent: 5784560 (1998-07-01), Kingdon et al.
patent: 5813012 (1998-09-01), Chase et al.
patent: 5835755 (1998-11-01), Stellwagen, Jr.
patent: 5960426 (1999-09-01), Pirahesh et al.
patent: 5974567 (1999-10-01), Dickson, Jr. et al.
patent: 5991879 (1999-11-01), Still
patent: 6016394 (2000-01-01), Walker
patent: 6088451 (2000-07-01), He et al.
patent: 6236996 (2001-05-01), Bapat et al.
patent: 6275852 (2001-08-01), Filepp et al.
patent: 6281894 (2001-08-01), Rive
patent: 6330555 (2001-12-01), Weber
patent: 6349310 (2002-02-01), Klein et al.
patent: 6401098 (2002-06-01), Moulin
patent: 6449643 (2002-09-01), Hyndman et al.
patent: 6457003 (2002-09-01), Gajda et al.
Plasek James M.
Rust John C.
Breene John
Crawford & Maunu PLLC
Johnson Charles A.
Lewis Cheryl
Starr Mark T.
LandOfFree
Method and apparatus for administration of database partitions does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Method and apparatus for administration of database partitions, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method and apparatus for administration of database partitions will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-3216149