Tools for checking the structural integrity of databases, described in Verifying Structural Integrity in this chapter.īackup mechanisms, as described in the chapter “ Backup and Restore”. To compensate for such disasters, InterSystems IRIS provides the following features: In that case, the integrity of the database, WIJ and journals can become compromised.
#Dataease odbc driver download verification#
Copy link to this section Integrity Verification and Recovery MechanismsĪlthough system crashes alone cannot lead to a loss of integrity, there is always a possibility that a storage device will fail catastrophically, sustain physical damage, or be tampered with. (Other aspects of logical integrity are under the control of application code, through proper use of interlocks, transactions, and other mechanisms specific to the programming paradigm that the application employs.)Īutomatic WIJ and journal recovery are fundamental components of the InterSystems “bulletproof” database architecture that protects InterSystems IRIS databases from system failures.
Logical integrity during a system crash is maintained by InterSystems IRIS journaling (see the “ Journaling” chapter) and transaction processing. Logical integrity refers to the data represented by the globals within the database, and encompasses the self-consistency of the data created by the application, its transactional integrity, and its being up-to-date with the real world. Structural integrity during a system crash is maintained by InterSystems write image journal (WIJ) technology, as described in the chapter “ Write Image Journaling and Recovery”, and InterSystems IRIS's internal algorithms. To have structural integrity, the database blocks must be self-consistent and the globals traversable. Structural database integrity, or physical integrity, refers to the contents of the database blocks on disk. In general, there are two different levels at which integrity can be viewed: The DataCheck utility lets you compare the state of data that exists on two systems to determine whether they are consistent.Ĭopy link to this section Fundamental Data Integrity Protection
Journaling and transaction processing maintain logical integrity and used together with backup and restore enable rapid recovery from physical integrity failures. Write image journaling technology protects against structural integrity failures due to system crashes.īackup and restore strategies used together with journaling enable rapid recovery from physical integrity failures.
The remaining chapters cover the following topics:
#Dataease odbc driver download how to#
This chapter explains how structural integrity is maintained and how to verify it. Together with a backup strategy, journaling provides rapid recovery from physical integrity failures. InterSystems IRIS write image journaling technology protects against structural integrity failures, while logical integrity is maintained by InterSystems IRIS journaling and transaction processing. The integrity of the data in every InterSystems IRIS® database is protected from the consequences of instance and system failure by the features described in this guide.