dbTalk Databases Forums  

Distributed Transactions

comp.databases.theory comp.databases.theory


Discuss Distributed Transactions in the comp.databases.theory forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Sherif Fadel
 
Posts: n/a

Default Distributed Transactions - 03-31-2008 , 06:36 AM






Hi,

I am new to the field so I apologize if this question seems trivial. I am
currently working on distributed software transactional memory (STM). Since
database transactions are the semantic inspiration for STM, I was wondering
about the level of concurrency of distributed database transactions.

Specifically, are subtransactions concurrent or are they sequential? If they
are sequential, doesn't this prolong the duration of the transaction and
hence increase the chances of conflicts and hence retries? Has this problem,
possible "retry thrashing", if you will, been considered in the literature?
Again I apologize if this question seems trivial, but I am relatively new to
the field.



Reply With Quote
  #2  
Old   
Cimode
 
Posts: n/a

Default Re: Distributed Transactions - 03-31-2008 , 08:27 PM






On 31 mar, 11:36, "Sherif Fadel" <fa... (AT) vt (DOT) edu> wrote:
Quote:
Hi,

I am new to the field so I apologize if this question seems trivial. I am
currently working on distributed software transactional memory (STM). Since
database transactions are the semantic inspiration for STM, I was wondering
about the level of concurrency of distributed database transactions.

Specifically, are subtransactions concurrent or are they sequential? If they
are sequential, doesn't this prolong the duration of the transaction and
hence increase the chances of conflicts and hence retries? Has this problem,
possible "retry thrashing", if you will, been considered in the literature?
Again I apologize if this question seems trivial, but I am relatively new to
the field.
How sweet...Rediscovery that concurrency is better handled at database
level and.
talking about reinventing square wheels...

Concurrency handling (serialization) is purely platform dependent.
You will not have the same rules if you are using ORACLE SQL Server or
DB2. Most transactional concurrency mechanisms are much more complex
than a simplystic serialized/concurrent dichotomy.


Reply With Quote
  #3  
Old   
Cimode
 
Posts: n/a

Default Re: Distributed Transactions - 03-31-2008 , 08:27 PM



On 31 mar, 11:36, "Sherif Fadel" <fa... (AT) vt (DOT) edu> wrote:
Quote:
Hi,

I am new to the field so I apologize if this question seems trivial. I am
currently working on distributed software transactional memory (STM). Since
database transactions are the semantic inspiration for STM, I was wondering
about the level of concurrency of distributed database transactions.

Specifically, are subtransactions concurrent or are they sequential? If they
are sequential, doesn't this prolong the duration of the transaction and
hence increase the chances of conflicts and hence retries? Has this problem,
possible "retry thrashing", if you will, been considered in the literature?
Again I apologize if this question seems trivial, but I am relatively new to
the field.
How sweet...Rediscovery that concurrency is better handled at database
level and.
talking about reinventing square wheels...

Concurrency handling (serialization) is purely platform dependent.
You will not have the same rules if you are using ORACLE SQL Server or
DB2. Most transactional concurrency mechanisms are much more complex
than a simplystic serialized/concurrent dichotomy.


Reply With Quote
  #4  
Old   
Cimode
 
Posts: n/a

Default Re: Distributed Transactions - 03-31-2008 , 08:27 PM



On 31 mar, 11:36, "Sherif Fadel" <fa... (AT) vt (DOT) edu> wrote:
Quote:
Hi,

I am new to the field so I apologize if this question seems trivial. I am
currently working on distributed software transactional memory (STM). Since
database transactions are the semantic inspiration for STM, I was wondering
about the level of concurrency of distributed database transactions.

Specifically, are subtransactions concurrent or are they sequential? If they
are sequential, doesn't this prolong the duration of the transaction and
hence increase the chances of conflicts and hence retries? Has this problem,
possible "retry thrashing", if you will, been considered in the literature?
Again I apologize if this question seems trivial, but I am relatively new to
the field.
How sweet...Rediscovery that concurrency is better handled at database
level and.
talking about reinventing square wheels...

Concurrency handling (serialization) is purely platform dependent.
You will not have the same rules if you are using ORACLE SQL Server or
DB2. Most transactional concurrency mechanisms are much more complex
than a simplystic serialized/concurrent dichotomy.


Reply With Quote
  #5  
Old   
Cimode
 
Posts: n/a

Default Re: Distributed Transactions - 03-31-2008 , 08:27 PM



On 31 mar, 11:36, "Sherif Fadel" <fa... (AT) vt (DOT) edu> wrote:
Quote:
Hi,

I am new to the field so I apologize if this question seems trivial. I am
currently working on distributed software transactional memory (STM). Since
database transactions are the semantic inspiration for STM, I was wondering
about the level of concurrency of distributed database transactions.

Specifically, are subtransactions concurrent or are they sequential? If they
are sequential, doesn't this prolong the duration of the transaction and
hence increase the chances of conflicts and hence retries? Has this problem,
possible "retry thrashing", if you will, been considered in the literature?
Again I apologize if this question seems trivial, but I am relatively new to
the field.
How sweet...Rediscovery that concurrency is better handled at database
level and.
talking about reinventing square wheels...

Concurrency handling (serialization) is purely platform dependent.
You will not have the same rules if you are using ORACLE SQL Server or
DB2. Most transactional concurrency mechanisms are much more complex
than a simplystic serialized/concurrent dichotomy.


Reply With Quote
  #6  
Old   
Cimode
 
Posts: n/a

Default Re: Distributed Transactions - 03-31-2008 , 08:27 PM



On 31 mar, 11:36, "Sherif Fadel" <fa... (AT) vt (DOT) edu> wrote:
Quote:
Hi,

I am new to the field so I apologize if this question seems trivial. I am
currently working on distributed software transactional memory (STM). Since
database transactions are the semantic inspiration for STM, I was wondering
about the level of concurrency of distributed database transactions.

Specifically, are subtransactions concurrent or are they sequential? If they
are sequential, doesn't this prolong the duration of the transaction and
hence increase the chances of conflicts and hence retries? Has this problem,
possible "retry thrashing", if you will, been considered in the literature?
Again I apologize if this question seems trivial, but I am relatively new to
the field.
How sweet...Rediscovery that concurrency is better handled at database
level and.
talking about reinventing square wheels...

Concurrency handling (serialization) is purely platform dependent.
You will not have the same rules if you are using ORACLE SQL Server or
DB2. Most transactional concurrency mechanisms are much more complex
than a simplystic serialized/concurrent dichotomy.


Reply With Quote
  #7  
Old   
Cimode
 
Posts: n/a

Default Re: Distributed Transactions - 03-31-2008 , 08:27 PM



On 31 mar, 11:36, "Sherif Fadel" <fa... (AT) vt (DOT) edu> wrote:
Quote:
Hi,

I am new to the field so I apologize if this question seems trivial. I am
currently working on distributed software transactional memory (STM). Since
database transactions are the semantic inspiration for STM, I was wondering
about the level of concurrency of distributed database transactions.

Specifically, are subtransactions concurrent or are they sequential? If they
are sequential, doesn't this prolong the duration of the transaction and
hence increase the chances of conflicts and hence retries? Has this problem,
possible "retry thrashing", if you will, been considered in the literature?
Again I apologize if this question seems trivial, but I am relatively new to
the field.
How sweet...Rediscovery that concurrency is better handled at database
level and.
talking about reinventing square wheels...

Concurrency handling (serialization) is purely platform dependent.
You will not have the same rules if you are using ORACLE SQL Server or
DB2. Most transactional concurrency mechanisms are much more complex
than a simplystic serialized/concurrent dichotomy.


Reply With Quote
  #8  
Old   
Cimode
 
Posts: n/a

Default Re: Distributed Transactions - 03-31-2008 , 08:27 PM



On 31 mar, 11:36, "Sherif Fadel" <fa... (AT) vt (DOT) edu> wrote:
Quote:
Hi,

I am new to the field so I apologize if this question seems trivial. I am
currently working on distributed software transactional memory (STM). Since
database transactions are the semantic inspiration for STM, I was wondering
about the level of concurrency of distributed database transactions.

Specifically, are subtransactions concurrent or are they sequential? If they
are sequential, doesn't this prolong the duration of the transaction and
hence increase the chances of conflicts and hence retries? Has this problem,
possible "retry thrashing", if you will, been considered in the literature?
Again I apologize if this question seems trivial, but I am relatively new to
the field.
How sweet...Rediscovery that concurrency is better handled at database
level and.
talking about reinventing square wheels...

Concurrency handling (serialization) is purely platform dependent.
You will not have the same rules if you are using ORACLE SQL Server or
DB2. Most transactional concurrency mechanisms are much more complex
than a simplystic serialized/concurrent dichotomy.


Reply With Quote
  #9  
Old   
Cimode
 
Posts: n/a

Default Re: Distributed Transactions - 03-31-2008 , 08:27 PM



On 31 mar, 11:36, "Sherif Fadel" <fa... (AT) vt (DOT) edu> wrote:
Quote:
Hi,

I am new to the field so I apologize if this question seems trivial. I am
currently working on distributed software transactional memory (STM). Since
database transactions are the semantic inspiration for STM, I was wondering
about the level of concurrency of distributed database transactions.

Specifically, are subtransactions concurrent or are they sequential? If they
are sequential, doesn't this prolong the duration of the transaction and
hence increase the chances of conflicts and hence retries? Has this problem,
possible "retry thrashing", if you will, been considered in the literature?
Again I apologize if this question seems trivial, but I am relatively new to
the field.
How sweet...Rediscovery that concurrency is better handled at database
level and.
talking about reinventing square wheels...

Concurrency handling (serialization) is purely platform dependent.
You will not have the same rules if you are using ORACLE SQL Server or
DB2. Most transactional concurrency mechanisms are much more complex
than a simplystic serialized/concurrent dichotomy.


Reply With Quote
  #10  
Old   
Cimode
 
Posts: n/a

Default Re: Distributed Transactions - 03-31-2008 , 08:27 PM



On 31 mar, 11:36, "Sherif Fadel" <fa... (AT) vt (DOT) edu> wrote:
Quote:
Hi,

I am new to the field so I apologize if this question seems trivial. I am
currently working on distributed software transactional memory (STM). Since
database transactions are the semantic inspiration for STM, I was wondering
about the level of concurrency of distributed database transactions.

Specifically, are subtransactions concurrent or are they sequential? If they
are sequential, doesn't this prolong the duration of the transaction and
hence increase the chances of conflicts and hence retries? Has this problem,
possible "retry thrashing", if you will, been considered in the literature?
Again I apologize if this question seems trivial, but I am relatively new to
the field.
How sweet...Rediscovery that concurrency is better handled at database
level and.
talking about reinventing square wheels...

Concurrency handling (serialization) is purely platform dependent.
You will not have the same rules if you are using ORACLE SQL Server or
DB2. Most transactional concurrency mechanisms are much more complex
than a simplystic serialized/concurrent dichotomy.


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.