Advantages of autonomous transactions, Biology

Assignment Help:

Advantages of Autonomous Transactions

An autonomous transaction, once started is fully independent. It shares no locks, resources, or commit-dependency with the main transaction. Therefore, you can log the events, increment retry counters, and so on, even when the main transaction rolls back. Most important, the autonomous transactions help you to build modular, and reuse the software components. For illustration, the stored procedures can start and finish the autonomous transactions on their own. The calling applications do not require to know about a procedure's autonomous operations and the procedure do not require knowing about the application's transaction context. It makes the autonomous transactions less error-prone than the regular transactions and easier to use.

Moreover, autonomous transactions have all the functionality of a regular transaction. They permit parallel queries, distributed processing, & all the transaction control statements including the SET TRANSACTION.


Related Discussions:- Advantages of autonomous transactions

Epidemiology, Endocarditis usually occurrs more frequently in men, gender d...

Endocarditis usually occurrs more frequently in men, gender derived ratios range from 1.6 to 2.5. The age specific incidence of endocarditis increased progressively after 30 years

Define reagents for preparation of phosphate buffers, Define Reagents for P...

Define Reagents for Preparation of Phosphate Buffers? Buffer solutions of pH4, pH7 and pH 9.18 phosphate buffer solution: 0.1 M disodium hydrogen phosphate or Na 2 HPO 4

Cold chain system, Cold Chain System Vaccines are sensitive to heat. ...

Cold Chain System Vaccines are sensitive to heat. On exposure to heat their potency is lost. Once a vaccine has lost its potency it cannot be regained, so it is important

Explain functional property of gelation/viscosity, Explain Functional prope...

Explain Functional property of Gelation/Viscosity  Mode of action  Protein-protein interactions produce matrix formations and setting Food system Salad dressings,

What is the reduction of stress on the implant, Reduction of stress on the ...

Reduction of stress on the implant - Removal of prosthesis when it is in the non aesthetic areas - Occlusal adjustment - Reducing Cantilever length - Occlusal splint

Thymus gland, THYMU S GLAND Flat, bilobed gland located in the medi...

THYMU S GLAND Flat, bilobed gland located in the mediastinal space in front of heart. Well developed in new born child and grows upto puberty but starts degenerating the

Define uses isolated soybean proteins, Define uses isolated soybean protein...

Define uses isolated soybean proteins? Partially hydrolysed soy proteins possess good foam stabilization properties and can be used as whipping agents in combination with egg a

Explain exposure assessment, Exposure  assessment Estimates of dietary...

Exposure  assessment Estimates of dietary intakes of food additives, residues of pesticides and veterinary drugs and contaminants require information on the consumption of rele

Explain about the complete proteins, Explain about the Complete proteins? ...

Explain about the Complete proteins? We now know that proteins are composed of amino acids and that proteins differ in their amino acid make-up. Proteins lacking in one or more

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd