Subject | Explanation about delta rows |
---|---|
Author | W O |
Post date | 2013-01-07T14:53:27Z |
Hello everybody
I have some doubts about delta rows.
Transaction 510 inserts a row with this values (ID=2500,
LASTNAME='Kennedy', FIRSTNAME='John', SALARY=28000)
Transaction 510 commits
Transaction 526 updates that row with this values (ID=2500, SALARY=31000)
How are in the database the rows now?
1. TRANSACTION=510, ID=2500, LASTNAME='Kennedy', FIRSTNAME='John',
SALARY=28000
TRANSACTION=526, SALARY=31000
2. TRANSACTION=526, ID=2500, LASTNAME='Kennedy', FIRSTNAME='John',
SALARY=31000
TRANSACTION=510, SALARY=28000
3. Another way
After transaction 526 commits, how are in the database the rows? Same as
before the commit or different?
Which of the rows is called the "delta" row?
Greetings.
Walter.
[Non-text portions of this message have been removed]
I have some doubts about delta rows.
Transaction 510 inserts a row with this values (ID=2500,
LASTNAME='Kennedy', FIRSTNAME='John', SALARY=28000)
Transaction 510 commits
Transaction 526 updates that row with this values (ID=2500, SALARY=31000)
How are in the database the rows now?
1. TRANSACTION=510, ID=2500, LASTNAME='Kennedy', FIRSTNAME='John',
SALARY=28000
TRANSACTION=526, SALARY=31000
2. TRANSACTION=526, ID=2500, LASTNAME='Kennedy', FIRSTNAME='John',
SALARY=31000
TRANSACTION=510, SALARY=28000
3. Another way
After transaction 526 commits, how are in the database the rows? Same as
before the commit or different?
Which of the rows is called the "delta" row?
Greetings.
Walter.
[Non-text portions of this message have been removed]