Method for efficient maintenance of XML indexes

Details Method for efficient maintenance of XML indexes Method for efficient maintenance of XML indexes

2005-06-30

2009-12-22

Alam, Hosain T (Department: 2166)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000, C715S234000

Reexamination Certificate

active

07636739

ABSTRACT:
An update to a primary table is received. The primary table is read to determine the set of rows to be updated. The primary table is updated and XML objects stored in XML columns are overwritten according to the update. A pre-update node table comprising the nodes corresponding to the updated rows is created from an XML index table corresponding to the primary table. A post-update node table is created by shredding the updated XML objects. The post-update table and the pre-update table are merged according to their node identifiers. The resulting merged table can be inspected to determine which nodes have been, added, deleted, or updated. Based on this inspection, the necessary additions and deletions can be efficiently made to the XML index table.

REFERENCES:
patent: 6889226 (2005-05-01), O'Neil et al.
patent: 6892210 (2005-05-01), Erickson et al.
patent: 2002/0133484 (2002-09-01), Chau et al.
patent: 2004/0034616 (2004-02-01), Witkowski et al.
patent: 2004/0044959 (2004-03-01), Shanmugasundaram et al.
patent: 2005/0165866 (2005-07-01), Bohannon et al.
patent: 2005/0223325 (2005-10-01), Naitou
patent: 2005/0228786 (2005-10-01), Murthy et al.
patent: 2007/0192348 (2007-08-01), Brodersen et al.

Affiliated with

Also associated with

Rating

Method for efficient maintenance of XML indexes 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 for efficient maintenance of XML indexes, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method for efficient maintenance of XML indexes will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-4123389