Database System Concepts, Volume 1
The new edition of this book provides improved and extensive coverage of concepts, database system internals and new tools and techniques. It is intended for a first course in databases at the junior or senior undergraduate, or first-year graduate level, and offers a complete background in the basics of database design, language and system implementations. Concepts are presented using intuitive descriptions, and important theoretical results are covered, but formal proofs are omitted. The fundamental concepts and algorithms covered are based on those used in existing commercial or experimental database systems. The authors present these concepts and algorithms in a general setting that is not tied to one particular database system.
Results 1-3 of 54
4.9.5 Transactions A transaction consists of a sequence of query and/or update
statements. The SQL standard specifies that a transaction begins implicitly when
an SQL statement is executed. One of the following SQL statements must end the
The updates carried out by the transaction have been written to disk before the
transaction completes. 2. Information about the updates carried out by the
transaction and written to disk is sufficient to enable the database to reconstruct
the aborted transaction made to the database must be undone. Once the
changes caused by an aborted transaction have been undone, we say that the
transaction has been rolled back. It is part of the responsibility of the recovery
scheme to ...
What people are saying - Write a review
LibraryThing ReviewUser Review - IvanIdris - LibraryThing
This book teaches about the inner workings, the nuts and bolts of databases without requiring a lot of prior knowledge: Data Models Relational Databases Object Based Databases and XML Data Storage and ... Read full review