Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
2005-11-15
2005-11-15
Amsbury, Wayne (Department: 2161)
Data processing: database and file management or data structures
Database design
Data structure types
Reexamination Certificate
active
06965899
ABSTRACT:
Techniques are provided for allowing the reorganization and/or redefinition of data in a relational database with minimal or no downtime by allowing “online” reorganization/redefinition of the data. According to one aspect of the invention, an empty revised table is created in the same schema as the target table. The revised table is created with the attributes that are desired for the reorganization/redefinition of the target table. Triggers, constraints, grants and indexes that are associated with the target table are replicated for the revised table. The reorganization/redefinition is performed by using an underlying mechanism that involves using incrementally maintainable materialized views.According to one feature, the revised table is initialized and periodically synchronized with the target table. After the reorganization and/or redefinition is complete on the revised table, the revised table and the target table switch identities such that the revised table is now the target table and the target table becomes the revised table.
REFERENCES:
patent: 5440743 (1995-08-01), Yokota et al.
patent: 5448727 (1995-09-01), Annevelink
patent: 5555388 (1996-09-01), Shaughnessy
patent: 5608903 (1997-03-01), Prasad et al.
patent: 5978426 (1999-11-01), Glover et al.
patent: 6016497 (2000-01-01), Suver
patent: 6122630 (2000-09-01), Strickler et al.
patent: 6173313 (2001-01-01), Klots et al.
patent: 6268850 (2001-07-01), Ng
patent: 6304867 (2001-10-01), Schmidt
patent: 6363387 (2002-03-01), Ponnekanti et al.
patent: 6460055 (2002-10-01), Midgley et al.
patent: 6519613 (2003-02-01), Friske et al.
patent: 6598059 (2003-07-01), Vasudevan et al.
patent: 6611848 (2003-08-01), Bradley
patent: 6633870 (2003-10-01), Bradley
patent: 6633883 (2003-10-01), Koskas
patent: 6681225 (2004-01-01), Uceda-Sosa et al.
patent: 6745209 (2004-06-01), Holenstein et al.
patent: 6801983 (2004-10-01), Abe et al.
patent: 6834290 (2004-12-01), Pugh et al.
Lassen et al. Experiences with object oriented development in PL/SQL, Center for Object Technology COT/4-18-V1.4, 2000.
Object Cache Navigation, Oracle Call Interface PRogrammer's Guide, Release 2 (9.2), Part No. A96584-10, 1996, 2002.
Date et al, A Guide to SQL/DS, 1989, Addison-Wesley, Chapter 10.
Quest Software, Inc., LiveReorg®, “Reorganization for the 24×7 Database,” 2001.
Loaiza Joan
Subramaniam Mahesh
Amsbury Wayne
Hickman Palermo & Truong & Becker LLP
Oracle International Corporation
LandOfFree
Online reorganization and redefinition of relational... does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Online reorganization and redefinition of relational..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Online reorganization and redefinition of relational... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-3507442