Method and system for reorganizing a tablespace in a database

Details Method and system for reorganizing a tablespace in a database Method and system for reorganizing a tablespace in a database

2007-02-13

2007-02-13

Alam, Shahid (Department: 2162)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000, C707S793000, C707S793000, C709S201000, C717S101000, C717S120000

Reexamination Certificate

active

10649393

ABSTRACT:
A method of reorganizing a tablespace in a database may include reading a row of data from the database, analyzing the row of data read out from the database, determining whether to eliminate or retain the row of data based on at least one predetermined rule, reloading the row of data into the database when it is determined that the row of data complies with the at least one predetermined rule, eliminating the row of data when it is determined that the row of data does not comply with the at least one predetermined rule, and rebuilding an index related to the database to include keys that correspond to the reloaded row of data. The determining, reloading, eliminating and rebuilding steps are repeated for each row of data in the database.

REFERENCES:
patent: 5222235 (1993-06-01), Hintz et al.
patent: 5396623 (1995-03-01), McCall et al.
patent: 5408654 (1995-04-01), Barry
patent: 5485608 (1996-01-01), Lomet et al.
patent: 5565316 (1996-10-01), Kershaw et al.
patent: 5710916 (1998-01-01), Barbara et al.
patent: 5758357 (1998-05-01), Barry et al.
patent: 5812849 (1998-09-01), Nykiel et al.
patent: 5832508 (1998-11-01), Sherman et al.
patent: 5887274 (1999-03-01), Barry et al.
patent: 5937415 (1999-08-01), Sheffield et al.
patent: 6070170 (2000-05-01), Friske et al.
patent: 6119128 (2000-09-01), Courter et al.
patent: 6122640 (2000-09-01), Pereira
patent: 6173292 (2001-01-01), Barber et al.
patent: 6351744 (2002-02-01), Landresse
Chomicki, Jan et al., “Implementing temporal integrity constraints using an active DBMS”, IEEE Transaction on Knowledge and Data Engineering, Aug. 1995 vol. 7, Issue: 4, pp. 566-582, □□.
Kim, D et al., “A temporal database management main memory prototype”, Proceeding of 1994 TENCON '94, IEEE Region 10's Ninth Annual International Conference. Theme: Frontiers of Computer Technology. Aug. 22-28, 1994. vol. 1, pp. 391-396, Aug. 1994, □□.

Affiliated with

Also associated with

Rating

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

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3862230