Method and apparatus for insuring database data integrity without data recovery logging

Apparatus for use in a computer system having a non-volatile storage and capable of processing a transaction which modifies one or more database pages comprising:

• a flushing mechanism which writes all modified, unwritten database pages to non-volatile storage before committing the transaction;
• a monitor which checks for errors all write operations which write modified pages to the non-volatile storage;
• and
• an updater which commits the transaction if no errors are detected by the monitor and rolls back the transaction if errors are detected by the monitor.

A computer program product for use in a computer system having a non-volatile storage and capable of processing a transaction which modifies one or more database pages, the computer program product comprising a computer usable medium having computer readable program code thereon, including:

• program code for writing all modified, unwritten database pages to non-volatile storage before committing the transaction;
• program code for monitoring for errors all write operations which write modified pages to the non-volatile storage;
• and
• program code for committing the transaction if no errors are detected by the monitoring program code and rolling back the transaction if errors are detected by the monitoring program code.

A method for use in a computer system having a non-volatile storage and capable of processing a transaction which modifies one or more database pages comprising:

• (a) disabling data recovery logging for the database;
• (b) inserting the large object into the database and logging resulting changes to the space allocation map in a recovery log;
• (c) writing all modified, unwritten database pages to non-volatile storage before committing the large object insertion;
• (d) monitoring for errors all write operations which write modified pages to the non-volatile storage;
• and
• (e) committing the large object insertion if no errors are detected in step (d) and rolling back the large object insertion if errors are detected in step (d).

A method for use in a computer system having a non-volatile storage and capable of processing a transaction which modifies one or more database pages comprising:

• (a) disabling data recovery logging for the database;
• (b) deleting the large object from the database and logging resulting changes to the space allocation map in a recovery log;
• (c) writing all modified, unwritten database pages to non-volatile storage before committing the large object deletion;
• (d) monitoring for errors all write operations which write modified pages to the non-volatile storage;
• and
• (e) committing the large object deletion if no errors are detected in step (d) and rolling back the large object deletion if errors are detected in step (d).