Systems and methods for managing partitioned indexes that...

Details Systems and methods for managing partitioned indexes that... Systems and methods for managing partitioned indexes that...

2005-07-19

2005-07-19

Mizrahi, Diane D. (Department: 2165)

Data processing: database and file management or data structures

Database design

Data structure types

Reexamination Certificate

active

06920460

ABSTRACT:
Domain indexes (indexes created and maintained by user-defined indexing schemes) are managed on partitioned database objects that store data using a system-managed approach. Partition maintenance operations performed on the partitioned database objects cause corresponding partition maintenance operations to be performed on the domain indexes. Partition maintenance operations are performed on both the database objects and the indexes by a system-supplied partition manager. Changes in the partition maintenance operations or partitioning methods supplied by the database management system do not affect user-supplied code which is provided by the user-defined indexing scheme. User-supplied code is therefore partition operation-unaware.

REFERENCES:
patent: 5485608 (1996-01-01), Lomet et al.
patent: 5485610 (1996-01-01), Gioielli et al.
patent: 5524205 (1996-06-01), Lomet et al.
patent: 5664172 (1997-09-01), Antoshenkov
patent: 5731814 (1998-03-01), Bala
patent: 5742706 (1998-04-01), Yu
patent: 5848408 (1998-12-01), Jakobsson et al.
patent: 5852818 (1998-12-01), Guay et al.
patent: 5857180 (1999-01-01), Hallmark et al.
patent: 5870759 (1999-02-01), Bauer et al.
patent: 5870765 (1999-02-01), Bauer et al.
patent: 5884325 (1999-03-01), Bauer et al.
patent: 5920868 (1999-07-01), Fowlow et al.
patent: 5926816 (1999-07-01), Bauer et al.
patent: 6006234 (1999-12-01), Govindarajan et al.
patent: 6014614 (2000-01-01), Herring et al.
patent: 6014656 (2000-01-01), Hallmark et al.
patent: 6061690 (2000-05-01), Nori et al.
patent: 6105026 (2000-08-01), Kruglikov et al.
patent: 6112201 (2000-08-01), Wical
patent: 6161105 (2000-12-01), Keighan et al.
patent: 6223182 (2001-04-01), Agarwal et al.
patent: 6240410 (2001-05-01), Wical
patent: 6240428 (2001-05-01), Yeung et al.
patent: 6272503 (2001-08-01), Bridge, Jr. et al.
patent: 6370529 (2002-04-01), Kruglikov et al.
patent: 6374232 (2002-04-01), Dageville et al.
patent: 6381605 (2002-04-01), Kothuri et al.
patent: 6389410 (2002-05-01), Gupta
patent: 6401083 (2002-06-01), Agarwal et al.
patent: 6405284 (2002-06-01), Bridge
patent: 6430571 (2002-08-01), Doan et al.
patent: 6438562 (2002-08-01), Gupta et al.
patent: 6439783 (2002-08-01), Antoshenkov
patent: 6470344 (2002-10-01), Kothuri et al.
patent: 6484179 (2002-11-01), Roccaforte
patent: 6502089 (2002-12-01), Amundsen et al.
patent: 6505205 (2003-01-01), Kothuri et al.
patent: 6530035 (2003-03-01), Bridge
patent: 6542854 (2003-04-01), Yang et al.
patent: 6549901 (2003-04-01), Loaiza et al.
patent: 6553369 (2003-04-01), Guay et al.
patent: 6574717 (2003-06-01), Ngai et al.
patent: 6587854 (2003-07-01), Guthrie et al.
patent: 6606638 (2003-08-01), Tarin
patent: 6609131 (2003-08-01), Zait et al.
patent: 6618822 (2003-09-01), Loaiza et al.
patent: 6622138 (2003-09-01), Bellamkonda et al.
patent: 6636870 (2003-10-01), Roccaforte
patent: 6665684 (2003-12-01), Zait et al.
patent: 2001/0054034 (2001-12-01), Arning et al.
patent: 2002/0178394 (2002-11-01), Bamberger et al.
Sanjay Agrawal et al., Integrating vertical and horizontal partitioning into autmated physical database design, 2004, ACM Press, Proc. of 2004 ACM SIGMOD confer., pp. 359-370.
R. Gisli et al., Speeding up construction of PMR quadtree-based spatial indexes, Oct. 2002, Springer-Verlag New York, Inc., vol. 11, issue 2, pp. 109-137.
Leverenz, Lefty et al.; “Partitioned Tables and Indexes”; Oracle8 Server Concepts; Release 8; Jun., 1997; Chapter 8, pp. 8-1 to 8-40.

Affiliated with

Also associated with

Rating

Systems and methods for managing partitioned indexes that... does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Systems and methods for managing partitioned indexes that..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Systems and methods for managing partitioned indexes that... will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3397119