FACTOID # 110: Around 80% of all livejournal users are from the United States of America.
 
 Home   Encyclopedia   Statistics   Countries A-Z   Flags   Maps   Education   Forum   FAQ   About 
 
 
 
WHAT'S NEW
RECENT ARTICLES
More Recent Articles »
 

SEARCH ALL

FACTS & STATISTICS    Advanced view

Search encyclopedia, statistics and forums:

 

 

(* = Graphable)

 

 


Encyclopedia > Database consistency

In database systems, a consistent transaction is one that does not violate any integrity contraints during its execution. If a transaction leaves the database in an illegal state, it is aborted and a error is reported.


Consistency is one of the ACID properties.


See also


  Results from FactBites:
 
Transaction Logging Concepts (5515 words)
Logical consistency, on the other hand, is managed both by the database manager, through mechanisms such as validation rules, triggers, integrity constraints, etc., and by the actions of the application.
Because database changes are buffered in memory and are written back to disk only when it becomes necessary to do so, as more and more database changes are made, the disk-resident copy of the database becomes more and more out of date.
To recover the database, the roll-forward process combines a backup copy of the database with the records in the after-image log to redo all the changes that were made since the backup was created.
DNR Coastal Management PermitTrak System (340 words)
The information contained in the database is also used extensively by other state and federal natural resource agencies, local governments, university researchers, environmental and community associations, and various industry groups including oil and gas production and transmission; developers, realtors and builders; and dredging and navigation.
Consistency applications are submitted for projects by Federal Agencies, funded by federal monies, or occurring on Federal lands.
The consistency database contains similar information to permits but many of the data fields are different, due to the different procedure to process consistencies.
  More results at FactBites »


 
 

COMMENTARY     


Share your thoughts, questions and commentary here
Your name
Your comments

Want to know more?
Search encyclopedia, statistics and forums:

 


Lesson Plans | Student Area | Student FAQ | Reviews | Press Releases |  Feeds | Contact
The Wikipedia article included on this page is licensed under the GFDL.
Images may be subject to relevant owners' copyright.
All other elements are (c) copyright NationMaster.com 2003-5. All Rights Reserved.
Usage implies agreement with terms, 1022, m