| "Informix Guide to SQL Reference", Informix Software Inc, February 1998. |
.... (some RDBMS will perform this rearranging automatically) Other systems put blob management under the control of the user, for example Informix allows blobs to be stored in blobspace, a separate disk area reserved for blobs, with the main table holding only a descriptor for the blobspace entry [45]. This is a hybrid form of in table storage and Postgres95 s external storage which is described below, and is used to circumvent the problem that storing blobs directly in the main table requires (at least in the Informix implementation) interspersing blob data blocks with table row data blocks, ....
"Informix Guide to SQL Reference", Informix Software Inc, February 1998.
....in a highly available system. Therefore fuzzy checkpoints are used. However, action consistent checkpoints and transaction consistent checkpoints can be achieved by using a combination of fuzzy checkpoints and logging of physical page updates. This is performed in INFORMIX OnLine Dynamic Server [Informix94] and in Dali [DALI97] Fuzzy checkpoints are created by first writing a checkpoint log record, then writing one data page at a time to disk; this means that when all data pages have been written to disk, all transactions preceding the checkpoint log record have been flushed to disk. If a crash ....
....Conclusion The conclusion is that it is necessary to use Location and Replication Independent Log Records of all updates to the database. The internal updates on pages are logged in a local log. Previous implementations of this concept have used local logs in combination with an UNDO REDO log [Informix94][Dali97] Tor96] We will, however, use No UNDO REDO through the use of new ideas on tuple storage. By using No UNDO REDO without semantically rich locking schemes, the updates are also idempotent and thereby updates can be performed several times on a record without risk of inconsistency. This ....
[Article contains additional citation context not shown here]
INFORMIX-OnLine Dynamic Server, Database Server, Informix Software Inc., Dec 1994.
Online articles have much greater impact More about CiteSeer.IST Add search form to your site Submit documents Feedback
CiteSeer.IST - Copyright Penn State and NEC