System and method for switching a data partition

Data processing: database and file management or data structures – Database design – Data structure types

Reexamination Certificate

Rate now

  [ 0.00 ] – not rated yet Voters 0   Comments 0

Details

C707S793000, C707S793000

Reexamination Certificate

active

07624120

ABSTRACT:
A method of mapping data into a table includes identifying pointers of a source portion and target portion and switching the metadata pointers of the target portion to be those of the source portion. Upon switching the metadata pointers, the data of the source portion is mapped into the target portion of the table. The method of mapping exhibits the advantage of performing the mapping operation by moving metadata and not table content data. The method may be used on any portion of a database including files, tables, partitions, and indexes. In one embodiment, the switching of pointers includes copying the target portion metadata into temporary storage, copying source portion metadata into the target portion metadata, and copying metadata from the temporary storage into the source portion metadata.

REFERENCES:
patent: 5625815 (1997-04-01), Maier et al.
patent: 5806065 (1998-09-01), Lomet
patent: 6029168 (2000-02-01), Frey
patent: 6058401 (2000-05-01), Stamos et al.
patent: 6219675 (2001-04-01), Pal et al.
patent: 6353821 (2002-03-01), Gray
patent: 7043491 (2006-05-01), Gong
patent: 7334002 (2008-02-01), Byrne
patent: 7464100 (2008-12-01), Schreter
patent: 2001/0047360 (2001-11-01), Huras et al.
patent: 2003/0149702 (2003-08-01), Saffer et al.
Wiebe, Edward. http://climate.uvic.ca/people/stone/cmg—idl—lib/swap.pro (Web archived date Sep. 4, 2003).
Brunstrom, A. et al., “Experimental Evaluation of Dynamic Data Allocation Strategies in a Distributed Database with Changing Workloads”,Conference on Information and Knowledge Management, Proceedings of the 4thInternational Conference on Information and Knowledge Management, 1995, 395-402.
Hernandez, M.A. et al., “The Merge/Purge Problem for Large Databases”,International Conference on Management of Data and Symposium on Principles of Database Systems, Proceedings of the 1995 ACM SIGMOD International Conference on Management of Data, 1995, 127-138.

LandOfFree

Say what you really think

Search LandOfFree.com for the USA inventors and patents. Rate them and share your experience with other people.

Rating

System and method for switching a data partition does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with System and method for switching a data partition, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and System and method for switching a data partition will most certainly appreciate the feedback.

Rate now

     

Profile ID: LFUS-PAI-O-4102289

  Search
All data on this website is collected from public sources. Our data reflects the most accurate information available at the time of publication.