close
This essay has been submitted by a student. This is not an example of the work written by professional essay writers.

Transaction as a Group of SQL (dml) Statements

  • Category: Business
  • Subcategory: Industry
  • Topic: Trade
  • Page: 1
  • Words: 471
  • Published: 17 December 2018
  • Downloads: 35
downloadDownload printPrint

Pssst… we can write an original essay just for you.

Any subject. Any type of essay.

We’ll even meet a 3-hour deadline.

Get your price

121 writers online

blank-ico
Download PDF

Transaction

Transaction is a group of sql (DML) statements which are used to perform certain combination of operations like write, update etc. into one unit to make the consistency of data. They are used to perform multiple actions if and only if all the operations can be performed else none of the action or operation should not be done and the database should not affect i.e; the transaction is Rollback. If all the operations are performed successfully than it will be save to database by issuing the Commit command. There is a Transaction log which are used to make the database to original state in case of failure occurs. With transactions supports ACID properties. The real scenarios where Transactions are used are Bank data base for money transactions, railway reservation etc. Transaction is an automatic work with respect to recovery and consistency.

Transaction Processing

Transaction processing gives a scheme which is used to check the progress and controls the execution of transaction programs. Transaction processing mainly used in mission-critical applications which requires large amount of parallel users with minimum downtime. Proper use of Transaction Processing results the controlling the execution of several applications which are executing parallel. Transaction processing ensures the ACID properties over different databases this can be done by using two-phase COMMIT. Transaction processing system is best used if an application requires online access and also if there is a modification on different databases.

Local Transaction: When the transaction is limited to only single database or resource is called Local Transaction and all the operations will commit at the end of the transaction.

Distributed Transaction: Unlike to local transaction which are limited to single resource distributed transactions extend across multiple databases or resources. It is also similar to local transaction where at the end the transaction should be either committed or roll backed. If we have a situation where network failure occurs then but unfortunately in place of rollback all the transactions the data in one of the database or resource is committing this can happen due to many reasons to minimize these type of risk distributed transaction uses TWO –PHASE COMMIT process.

Implicit transaction contains only one statement of either INSERT, UPDATE, DELETE etc. After connecting to the database then if we perform or execute any DML statements then changes are made and saved to database automatically. This happens since the connection is in auto commit transaction mode. If you don’t want to save any changes until unless you specifies the COMMIT or ROLLBACK then we can use Implicit Transaction. Using Implicit Transaction the transactions remains in effect until the user issues the COMMIT or ROLLBACK commands.

Explicit transaction contains multiple statements with BEGIN indicates start the transaction and END indicates end the transaction. Using explicit transaction user is controlling when to start the transaction and end the transaction. These are also called user-defined transactions.

infoRemember: This is just a sample from a fellow student.

Your time is important. Let us write you an essay from scratch

100% plagiarism-free

Sources and citations are provided

Find Free Essays

We provide you with original essay samples, perfect formatting and styling

Cite this Essay

To export a reference to this article please select a referencing style below:

Transaction as a Group of SQL (DML) Statements. (2018, December 17). GradesFixer. Retrieved June 16, 2021, from https://gradesfixer.com/free-essay-examples/transaction-as-a-group-of-sql-dml-statements/
“Transaction as a Group of SQL (DML) Statements.” GradesFixer, 17 Dec. 2018, gradesfixer.com/free-essay-examples/transaction-as-a-group-of-sql-dml-statements/
Transaction as a Group of SQL (DML) Statements. [online]. Available at: <https://gradesfixer.com/free-essay-examples/transaction-as-a-group-of-sql-dml-statements/> [Accessed 16 Jun. 2021].
Transaction as a Group of SQL (DML) Statements [Internet]. GradesFixer. 2018 Dec 17 [cited 2021 Jun 16]. Available from: https://gradesfixer.com/free-essay-examples/transaction-as-a-group-of-sql-dml-statements/
copy to clipboard
close

Sorry, copying is not allowed on our website. If you’d like this or any other sample, we’ll happily email it to you.

    By clicking “Send”, you agree to our Terms of service and Privacy statement. We will occasionally send you account related emails.

    close

    Attention! This essay is not unique. You can get a 100% Plagiarism-FREE one in 30 sec

    Receive a 100% plagiarism-free essay on your email just for $4.99
    get unique paper
    *Public papers are open and may contain not unique content
    download public sample
    close

    Sorry, we could not paraphrase this essay. Our professional writers can rewrite it and get you a unique paper.

    close

    Thanks!

    Your essay sample has been sent.

    Want us to write one just for you? We can custom edit this essay into an original, 100% plagiarism free essay.

    thanks-icon Order now
    boy

    Hi there!

    Are you interested in getting a customized paper?

    Check it out!
    Having trouble finding the perfect essay? We’ve got you covered. Hire a writer
    exit-popup-close

    Haven't found the right essay?

    Get an expert to write you the one you need!

    exit-popup-print

    Professional writers and researchers

    exit-popup-quotes

    Sources and citation are provided

    exit-popup-clock

    3 hour delivery

    exit-popup-persone