The goal in concurrent database is to allow multiple users to access the database simultaneously without interfering with each other. To control data, first a concept is needed to allow us to encapsulate database accesses . Such encapsulation is called a 'Transaction'.
Transactional data is information that can be updated at random intervals with an expiration constraint, which is driven by data inputs and outputs of the record.
data transaction languagedata transaction languagedata transaction language data transaction languagedata transaction language
Like transaction in banks there are transactions in a database system too like deleting data is also a transaction. Transaction can be recovered using rollback and save point.
once one transaction is accessing the data, no other transaction is made to modify the data
once one transaction is accessing the data, no other transaction is made to modify the data
data entry
Database integrity refers to the safety of data. For example a transaction is made from an account of rs 500 and in between of transaction there is an abrupt , then integrity of data will be maintained and transaction will not occur.
·A nested transaction is a transaction that is logically decomposed into a hierarchy of sub transaction. A distributed transaction is logically a flat, indivisible transaction that operates on distributed data.
is data different from information?
transaction data
transaction processing, refers to a class of systems that facilitate and manage transaction-oriented applications, typically for data entry and retrieval
Auto recovery data may help recover the data in 1 or 2 ways. First is to recreate lost transaction using current transaction log file and copy of the company file. The other is to recreate all but the last few hours of transaction with the copy of both the company file and transaction log file.
What is canned transaction? Canned transactions: Standardized queries and updates with carefully programmed data validity checking.