02 July 2009

🛢DBMS: Transaction Log File (Definitions)

"A system table (syslogs) in which all changes to the database are recorded." (Karen Paulsell et al, "Sybase SQL Server: Performance and Tuning Guide", 1996)

"A reserved area of the database in which all changes to the database are recorded. The transaction log is stored in the Syslogs system table and is used by SQL Server during automatic recovery." (Patrick Dalton, "Microsoft SQL Server Black Book", 1997)

"A reserved area set aside for each database on the SQL Server that records all changes diat are made to die database. This enables SQL to recover a database if system problems are encountered." (Owen Williams, "MCSE TestPrep: SQL Server 6.5 Design and Implementation", 1998)

"A file or set of files containing a record of a database's transactions." (Microsoft Corporation, "SQL Server 7.0 System Administration Training Kit", 1999)

"A file or set of files containing a record of the modifications made in a database." (Thomas Moore, "EXAM CRAM™ 2: Designing and Implementing Databases with SQL Server 2000 Enterprise Edition", 2005)

"Transactions in SQL Server are written to the transaction log before they are written to the database. This log information is used primarily for database recovery in the event of a disaster." (Joseph L Jorden & Dandy Weyn, "MCTS Microsoft SQL Server 2005: Implementation and Maintenance Study Guide - Exam 70-431", 2006)

"A file containing a record of database changes." (S. Sumathi & S. Esakkirajan, "Fundamentals of Relational Database Management Systems", 2007)

"File that records transactional changes occurring in a database, providing a basis for updating a master file and establishing an audit trail." (S. Sumathi & S. Esakkirajan, "Fundamentals of Relational Database Management Systems", 2007)

"A file-system–based, internal database construct that records data and table modifications, making it possible to restore information to its previous state should the application roll back a transaction." (Robert D. Schneider and Darril Gibson, "Microsoft SQL Server 2008 All-In-One Desk Reference For Dummies", 2008)

"A file used by the database management system to record all database transactions. The log file is used for recovery of the database in case of failures." (Paulraj Ponniah, "Data Warehousing Fundamentals for IT Professionals", 2010)

"A feature used by the DBMS to keep track of all transaction operations that update the database. The information stored in this log is used by the DBMS for recovery purposes." (Carlos Coronel et al, "Database Systems: Design, Implementation, and Management 9th Ed", 2011)

"A collection of records describing the sequence of events that occur during DBMS execution to be used for database recovery in the event of a DBMS failure." (Craig S Mullins, "Database Administration: The Complete Guide to DBA Practices and Procedures" 2nd Ed., 2012)

"A file that records transactional changes occurring in a database, providing a basis for updating a master file and establishing an audit trail." (Microsoft, "SQL Server 2012 Glossary", 2012)

"A collection of records that sequentially describes the events that occur in a system. A record of events." (Sybase, "Open Server Server-Library/C Reference Manual", 2019)

"A set of primary and secondary log files consisting of log records that record all changes to a database. The database log is used to roll back changes for units of work that are not committed and to recover a database to a consistent state." (Sybase, "Open Server Server-Library/C Reference Manual", 2019)

No comments:

Related Posts Plugin for WordPress, Blogger...

About Me

My photo
Koeln, NRW, Germany
IT Professional with more than 24 years experience in IT in the area of full life-cycle of Web/Desktop/Database Applications Development, Software Engineering, Consultancy, Data Management, Data Quality, Data Migrations, Reporting, ERP implementations & support, Team/Project/IT Management, etc.