Systems and methods for reorganizing a database object

Details Systems and methods for reorganizing a database object Systems and methods for reorganizing a database object

2011-06-28

2011-06-28

Le, Debbie (Department: 2168)

Data processing: database and file management or data structures

Data integrity

Concurrent read/write management using locks

C707S638000, C707S639000

Reexamination Certificate

active

07970748

ABSTRACT:
The invention is a reorganization system having a reorganization application, a database management system, and one or more database files. The reorganization application communicates with the database management system and the one or more database files to reorganize an object, such as, for example, a table or index, while providing one or more clients substantially continuous access to the object. The reorganization application employs one or more trigger locks to synchronize the data in an original table and a reorganized table. The one or more trigger locks block select data modification operations while allowing one or more read-only operations and structural modification operations.

REFERENCES:
patent: 4130867 (1978-12-01), Bachman et al.
patent: 4648031 (1987-03-01), Jenner
patent: 4665520 (1987-05-01), Strom et al.
patent: 5222235 (1993-06-01), Hintz et al.
patent: 5297279 (1994-03-01), Bannon et al.
patent: 5325505 (1994-06-01), Hoffecker et al.
patent: 5333314 (1994-07-01), Masai et al.
patent: 5422979 (1995-06-01), Eichfeld et al.
patent: 5423037 (1995-06-01), Hvasshovd
patent: 5455945 (1995-10-01), VanderDrift
patent: 5530855 (1996-06-01), Satoh et al.
patent: 5551020 (1996-08-01), Flax et al.
patent: 5553303 (1996-09-01), Hayashi et al.
patent: 5596747 (1997-01-01), Katabami et al.
patent: 5634052 (1997-05-01), Morris
patent: 5640561 (1997-06-01), Satoh et al.
patent: 5655081 (1997-08-01), Bonnell et al.
patent: 5721915 (1998-02-01), Sockut et al.
patent: 5758356 (1998-05-01), Hara et al.
patent: 5761667 (1998-06-01), Koeppen
patent: 5761677 (1998-06-01), Senator et al.
patent: 5774717 (1998-06-01), Porcaro
patent: 5778377 (1998-07-01), Marlin et al.
patent: 5778392 (1998-07-01), Stockman et al.
patent: 5796934 (1998-08-01), Bhanot et al.
patent: 5799322 (1998-08-01), Mosher, Jr.
patent: 5822780 (1998-10-01), Schutzman
patent: 5848416 (1998-12-01), Tikkanen
patent: 5893924 (1999-04-01), Bahls et al.
patent: 5933818 (1999-08-01), Kasravi et al.
patent: 5933820 (1999-08-01), Beier et al.
patent: 5940832 (1999-08-01), Hamada et al.
patent: 5943677 (1999-08-01), Hicks
patent: 5948108 (1999-09-01), Lu et al.
patent: 5951694 (1999-09-01), Choquier et al.
patent: 5951695 (1999-09-01), Kolovson
patent: 5956489 (1999-09-01), San Andres et al.
patent: 5956504 (1999-09-01), Jagadish et al.
patent: 5978594 (1999-11-01), Bonnell et al.
patent: 5983239 (1999-11-01), Cannon
patent: 5991761 (1999-11-01), Mahoney et al.
patent: 5995958 (1999-11-01), Xu
patent: 6003022 (1999-12-01), Eberhard et al.
patent: 6016497 (2000-01-01), Suver
patent: 6026412 (2000-02-01), Sockut et al.
patent: 6029195 (2000-02-01), Herz
patent: 6067545 (2000-05-01), Wolff
patent: 6070170 (2000-05-01), Friske et al.
patent: 6119128 (2000-09-01), Courter et al.
patent: 6122640 (2000-09-01), Pereira
patent: 6151607 (2000-11-01), Lomet
patent: 6157932 (2000-12-01), Klein et al.
patent: 6161607 (2000-12-01), de Kimpe et al.
patent: 6185699 (2001-02-01), Haderle et al.
patent: 6243715 (2001-06-01), Bogantz et al.
patent: 6253212 (2001-06-01), Loaiza et al.
patent: 6289357 (2001-09-01), Parker
patent: 6343296 (2002-01-01), Lakhamraju et al.
patent: 6363387 (2002-03-01), Ponnekanti et al.
patent: 6411964 (2002-06-01), Iyer et al.
patent: 6460048 (2002-10-01), Teng et al.
patent: 6470344 (2002-10-01), Kothuri et al.
patent: 6477535 (2002-11-01), Mirzadeh
patent: 6499033 (2002-12-01), Vagnozzi
patent: 6499039 (2002-12-01), Venkatesh et al.
patent: 6519613 (2003-02-01), Friske et al.
patent: 6523035 (2003-02-01), Fleming et al.
patent: 6584474 (2003-06-01), Pereira
patent: 6606626 (2003-08-01), Ponnekanti
patent: 6631478 (2003-10-01), Wang et al.
patent: 6671721 (2003-12-01), Branson et al.
patent: 6691139 (2004-02-01), Ganesh et al.
patent: 6721742 (2004-04-01), Uceda-Sosa et al.
patent: 6728780 (2004-04-01), Hebert
patent: 6834290 (2004-12-01), Pugh et al.
patent: 6950834 (2005-09-01), Huras et al.
patent: 7065538 (2006-06-01), Aronoff et al.
patent: 7461103 (2008-12-01), Aronoff et al.
patent: 7805423 (2010-09-01), Romine et al.
U.S. Appl. No. 09/713,479, filed Nov. 15, 2000, Romine et al.
Space Management and Reorganization: Challenges and Solutions, http://quest.com/whitepapers/space—manager—wp.doc, published on or around Dec. 21, 1999.
“Top Five Tips for Space Management and Reorganization,” believed to be published after Jul. 21, 1998.
“Quest SharePlex for Oracle,” Brochure, Quest Software, Inc., Nov. 1999, 4 pages.
K. Loney, et al., “Oracle8i, DB Handbook,”Oracle Press, 2000, pp. 20.
L. Leverenz, et al., “Oracle8i Concepts,” Oracle Corp., vol. 2, Release 8.1.5, 1999, pp. 20-3.
Oracle: Introduction to PL/SQL, Power Point Presentation Regarding Triggers, slides 4, 6-7, 11, 14-17, 28, and 51, http://training.ntsource.com/dpec/COURSES/PL1/, 10 pages downloaded and printed from the World Wide Web on Oct. 20, 2000.
Computer Associates, “Platinum Tsreorg Automates Tablespace Reorganizations, Customer Story”, http://platinum.com/products/custstor/tsreorg.htm, 2 pages downloaded and printed from the World Wide Web on Nov. 30, 1999.
Computer Associates, “Platinum OnlineReorg Technical Overview, Online Reorg”, http://platinum.com/products/dba/onreo—to.htm, 5 pages downloaded and printed from the World Wide Web on Nov. 30, 1999.
Computer Associates, “ProVision Tsreorg for Oracle, Brochure, Database Utilities Tsreorg for Oracle”http://platinum.com/products/brochure/provis/pv—dr.htm, 4 pages downloaded and printed from the World Wide Web on Nov. 30, 1999.
Computer Associates, “Rapid Reorg for DB2 for OS/390, Brochure”, http://platinum.com/products/brochure/dm/b—rrd.htm, 3 pages downloaded and printed from the World Wide Web on Nov. 30, 1999.
Joseph Pagano, Microsoft Exchange Server, 1996.

Affiliated with

Also associated with

Rating

Systems and methods for reorganizing a database object 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 reorganizing a database object, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Systems and methods for reorganizing a database object will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-2742470