SQL – What ACID stands in the Database? – Contest to Win 24 Amazon Gift Cards and Joes 2 Pros 2012 Kit

We love puzzles. One of the brain’s main task is to solve puzzles. Sometime puzzles are very complicated (e.g Solving Rubik Cube or Sodoku)  and sometimes the puzzles are very simple (multiplying 4 by 8 or finding the shortest route while driving). It is always to solve puzzle and it creates an experience which humans are not able to forget easily. The best puzzles are the one where one has to do multiple things to reach to the final goal. Let us do something similar today. We will have a contest where you can participate and win something interesting.

Contest

This contest have two parts.

Question 1: What ACID stands in the Database?

This question seems very easy but here is the twist. Your answer should explain minimum one of the properties of the ACID in detail. If you wish you can explain all the four properties of the ACID but to qualify you need to explain minimum of the one properties.

Question 2: What is the size of the installation file of NuoDB for any specific platform.

You can answer this question following format – NuoDB installation file is of size __ MB for ___ Platform.

Click on the Download the Link and download your installation file for NuoDB. You can post figure out the file size from the properties of the file.

SQL - What ACID stands in the Database? - Contest to Win 24 Amazon Gift Cards and Joes 2 Pros 2012 Kit nuodbdownloadlink

We have exciting content prizes for the winners.

Prizes

1) 24 Amazon Gift Cards of USD 10 for next 24 hours. One card at every hour. (Open anywhere in the world)

SQL - What ACID stands in the Database? - Contest to Win 24 Amazon Gift Cards and Joes 2 Pros 2012 Kit amazoncard

2) One grand winner will get Joes 2 Pros SQL Server 2012 Training Kit worth USD 249. (Open where Amazon ship books).

SQL - What ACID stands in the Database? - Contest to Win 24 Amazon Gift Cards and Joes 2 Pros 2012 Kit combo

Amazon | 1 | 2 | 3 | 4 | 5 

Rules

The contest will be open till July 21, 2013. All the valid comments will be hidden till the result is announced.

The winners will be announced on July 24, 2013.

Hint: Download NuoDB 

Reference: Pinal Dave (https://blog.sqlauthority.com)

Previous Post
SQL SERVER – Drivers for PHP, JDBC, ODBC and OLE DB
Next Post
SQL – Difference Between INNER JOIN and JOIN

Related Posts

No results found.

47 Comments. Leave new

  • Martin Flores
    July 15, 2013 7:39 am

    ACID stands for: atomicity, consistency, isolation and durability.
    Consistency: Once the data has been successfully applied, or rolled back to the original state, all the data must remain in a consistent state, and the data must still maintain its integrity.
    NuoDB installation file is of size 153 MB for Windows Platform.

    Reply
  • RevelingSeven
    July 15, 2013 9:27 am

    Atomicity dictates that all database transactions must fully succeed or the entire transaction fails.

    Consistency ensures that the database only accepts valid data. The rule of consistency will enforce transaction integrity or roll back the transaction of any portion of the data does not adhere to the database specifications.

    Isolation ensures that one transaction is unable to case a consistency issue from the data set of another.

    Durability protects the database from data loss. It covers the ability to do database backups and transaction log backups.

    NuoDB installation file is of size 153 MB for Windows Platform

    Reply
  • Please find my answers to questions below:

    Q1:

    ACID in database can be quoted as: (Ä)nyone (C)onsistent (I)n (D)eveloping Durable E-R driven databases.

    Actually, ACID stands for Atomic, Consistent, Isolated, Durable for a database.

    Q2:

    NuoDB installation file is of size 153 MB for x64 Platform.

    Reply
  • Sanjay Monpara
    July 15, 2013 11:20 am

    Question 1: What ACID stands in the Database?

    Answer 1:
    ACID properties are an important concept for databases. The acronym stands for Atomicity,
    Consistency, Isolation, and Durability.

    The ACID properties of a DBMS allow safe sharing of data. Without these ACID properties,
    everyday occurrences such using computer systems to buy products would be difficult
    and the potential for inaccuracy would be huge. Imagine more than one person trying
    to buy the same size and color of a sweater at the same time — a regular occurrence.
    The ACID properties make it possible for the merchant to keep these sweater purchasing
    transactions from overlapping each other — saving the merchant from erroneous inventory
    and account balances.

    Atomicity

    The phrase “all or nothing” succinctly describes the first ACID property of atomicity.
    When an update occurs to a database, either all or none of the update becomes available
    to anyone beyond the user or application performing the update. This update to the
    database is called a transaction and it either commits or aborts. This means that
    only a fragment of the update cannot be placed into the database, should a problem
    occur with either the hardware or the software involved. Features to consider for
    atomicity:
    a transaction is a unit of operation – either all the transaction’s actions are
    completed or none are
    atomicity is maintained in the presence of deadlocks
    atomicity is maintained in the presence of database software failures
    atomicity is maintained in the presence of application software failures
    atomicity is maintained in the presence of CPU failures
    atomicity is maintained in the presence of disk failures
    atomicity can be turned off at the system level
    atomicity can be turned off at the session level

    Consistency

    Consistency is the ACID property that ensures that any changes to values in an instance
    are consistent with changes to other values in the same instance. A consistency constraint
    is a predicate on data which server as a precondition, post-condition, and transformation
    condition on any transaction.

    Isolation

    The isolation portion of the ACID properties is needed when there are concurrent
    transactions. Concurrent transactions are transactions that occur at the same time,
    such as shared multiple users accessing shared objects. This situation is illustrated
    at the top of the figure as activities occurring over time. The safeguards used by
    a DBMS to prevent conflicts between concurrent transactions are a concept referred
    to as isolation.

    Degrees of isolation¹:
    degree 0 – a transaction does not overwrite data updated by another user or process
    (“dirty data”) of other transactions
    degree 1 – degree 0 plus a transaction does not commit any writes until it completes
    all its writes (until the end of transaction)
    degree 2 – degree 1 plus a transaction does not read dirty data from other transactions

    degree 3 – degree 2 plus other transactions do not dirty data read by a transaction
    before the transaction commits
    These were originally described as degrees of consistency by Jim Gray.

    Durability

    Maintaining updates of committed transactions is critical. These updates must never
    be lost. The ACID property of durability addresses this need. Durability refers to
    the ability of the system to recover committed transaction updates if either the
    system or the storage media fails. Features to consider for durability:
    recovery to the most recent successful commit after a database software failure
    recovery to the most recent successful commit after an application software failure
    recovery to the most recent successful commit after a CPU failure
    recovery to the most recent successful backup after a disk failure
    recovery to the most recent successful commit after a data disk failure.
    –#######################################################

    Question 2: What is the size of the installation file of NuoDB for any specific platform.

    Answer 2:
    NuoDB installation file is of size 78.2 MB for [MacOS 10.7 or higher] Platform.
    NuoDB installation file is of size 153 MB for [Windows (64-bit) Inc/32-bit clients] Platform.
    NuoDB installation file is of size 110 MB for [RHEL 5.9 & 6.x (64-bit) SuSe Linux Enterprise Server 11 sp2 (64-bit) openSuSe 12.x (64-bit) Amazon Basic EC2 (64-bit)] Platform.
    NuoDB installation file is of size 110 MB for [Ubuntu 11.10 & 12.x (64-bit)] Platform.
    NuoDB installation file is of size 110 MB for [RHEL 5.9 & 6.x (64-bit) SuSe Linux Enterprise Server 11 sp2 (64-bit) openSuSe 12.x (64-bit) Amazon Basic EC2 (64-bit) Ubuntu 11.10 & 12.x (64-bit)] Platform.
    NuoDB installation file is of size 53.1 MB for [Solaris 11 (x64) Joyent Smart OS (Supported Release: 1.0.1)] Platform.

    Reply
  • Saravana Kumar
    July 15, 2013 11:34 am

    Answer 1
    ACID stands for Atomicity, Consistency, Isolation and Durability.
    Consistency: This property ensures that only valid data will be written to the database. If, for some reason, a transaction is executed that violates the database’s consistency rules, the entire transaction will be rolled back and the database will be restored to a state consistent with those rules.
    Answer 2
    NuoDB installation file is of size 153MB forWindows Platform.

    Reply
  • ACID – Atomicity, Consistency, Isolation, Durability
    Atomicity – During a set of SQL transaction, if one of the queries fail then the whole transaction must stop and the database must rollback to a state before the transaction begun.

    NuoDB v1.1.1 installation file is of size 153MB for the Windows Platform.

    Reply
  • Answer1:
    ACID properties:
    ACID stands for Atomic, Consistent, Isolation and Durable. The one line definition of a transaction is “a sequence of operations performed as a single logical unit of work.” To be considered a “transaction,” a single logical unit of work must exhibit the ACID properties.
    1) Atomicity – A transaction must be an atomic unit of work where either all of its modifications are made, or none of them are made.
    Quote: “ALL-or-NONE” / “DO-or-DIE”
    Example: A transaction to transfer funds from one account to another involves making a withdrawal operation from the first account and a deposit operation on the second. If the deposit operation failed, you don’t want the withdrawal operation to happen either.
    2) Consistency – When finished a transaction must leave all data in a consistent state. In this case “consistent state” means that all rules, or constraints, are applied to a transaction’s modifications. In other words, each successful transaction by definition commits only legal results.
    Quote: “A completed unit of work must maintain data integrity by leaving all data in the database in a consistent state”
    3) Isolation – If multiple transactions executing concurrently, each transaction must execute without affecting the execution of any other concurrent transactions. It allows a transaction to make modifications to data without other transactions trying to modify the same data at the same time.
    Example: A teller looking up a balance must be isolated from a concurrent transaction involving a withdrawal from the same account. Only when the withdrawal transaction commits successfully and the teller looks at the balance again will the new balance be reported.
    4) Durability -Once a transaction has been completed and has committed its results to the database, the system must guarantee that these results survive any subsequent malfunctions.”
    Quote: “A transaction is considered to be durable when the results of the operation performed by the transaction are permanently applied within the database”

    Answer2: NuoDB installation file is of size 153 MB for Windows Platform

    Reply
  • ACID stands for Atomicity, Consistency, Isolation and Durability.
    Atomicity : is an all or none rule for database modifications
    Consistency : guarantees that a transaction never leaves the database in a half finished state.
    Isolation : keeps transactions separated from each other until they are finished.
    Durability : guarantees that the database will keep track of pending changes in such a way that the server can recover from an abnormal termination and committed data will not be lost.

    Reply
  • Vikas Penubelli
    July 15, 2013 12:19 pm

    1)
    A – Atomocity
    C – Consistency
    I – Isolation
    D – Durability

    Atomicity is the state which helps the user to maintain the changes made using a transaction to be either everything or nothing. This is the property which guarantees the user that if there is any transaction that encounters a situation where the transaction is stopped half way through its execution, it will bring back the database to the state before the transaction was kicked off. Only if the transaction is complete the changes are saved to the database.

    2) NuoDB installation file is of size 153 MB for Windows Platform.

    Reply
  • Rajani Ghatge
    July 15, 2013 12:30 pm

    1. ACID stands for Atomicity, Consistency, Isolation, Durability.
    Atomicity means each transaction is either all or nothing.That means if any part of the transaction fails the whole transaction is rolled back and database state is left unchanged.
    The consistency property ensures that any transaction will bring the database from one valid state to another.
    The isolation property ensures that the concurrent execution of transactions results in a system state that would be obtained if transactions were executed serially, i.e. one after the other.
    Durability means that once a transaction has been committed, it will remain so, even in the event of power loss, crashes, or errors.

    2. NuoDB installation file is of size 78.3 MB for Mac Platform.
    NuoDB installation file is of size 153 MB for windows Platform.
    NuoDB installation file is of size 110 MB for Linux Platform.
    NuoDB installation file is of size 53.1MB for Solaris Platform.

    Reply
  • In Database, ACID refers to the ACID properties of a transaction i.e Atomicity, Consistency, Isolation and Durability.
    Atomicity refers to the entire transaction as “all or nothing”
    Consistency guarantees that a transaction never leaves your database in a half-finished state.
    Isolation keeps your transaction seperate from other concurrent transactions
    Durability means that the transaction should be reflected once it gets commited even in case of any circumstances.

    Download Size of NuoDB installation file: 153MB

    Reply
  • yash pal sharma
    July 15, 2013 1:16 pm

    Hi Pinal,
    here are the answers :

    1.Database ACID (Atomicity, Consistency, Isolation, Durability) Properties

    There are a set of properties that guarantee that database transactions are processed reliably, referred to as ACID (Atomicity, Consistency, Isolation, Durability).

    Atomicity

    Atomicity refers to the ability of the database to guarantee that either all of the tasks of a transaction are performed or none of them are. Database modifications must follow an all or nothing rule. Each transaction is said to be atomic if when one part of the transaction fails, the entire transaction fails.

    Consistency

    The consistency property ensures that the database remains in a consistent state before the start of the transaction and after the transaction is over (whether successful or not). For example, in a storefront there is an inconsistent view of what is truly available for purchase if inventory is allowed to fall below 0, making it impossible to provide more than an intent to complete a transaction at checkout time. An example in a double-entry accounting system illustrates the concept of a true transaction. Every debit requires an associated credit. Both of these happen or neither happen.

    A distributed data system is either strongly consistent or has some form of weak consistency. Once again, using the storefront example, a database needs to provide consistency and isolation, so that when one customer is reducing an item in stock and in parallel is increasing the basket by one, this is isolated from another customer who will have to wait while the data store catches up. At the other end of the spectrum is BASE (Basically Available Soft-state Eventual consistency).

    Weak consistency is sometimes referred to as eventual consistency, the database eventually reaches a consistent state. Weak consistency systems are usually ones where data is replicated; the latest version is sitting somewhere in the cluster, older versions are still out there. Eventually all nodes will see the latest version.

    Isolation

    Isolation refers to the requirement that other operations cannot access or see the data in an intermediate state during a transaction. This constraint is required to maintain the performance as well as the consistency between transactions in a database. Thus, each transaction is unaware of another transactions executing concurrently in the system.

    Durability

    Durability refers to the guarantee that once the user has been notified of success, the transaction will persist, and not be undone. This means it will survive system failure, and that the database system has checked the integrity constraints and won’t need to abort the transaction. Many databases implement durability by writing all transactions into a transaction log that can be played back to recreate the system state right before a failure. A transaction can only be deemed committed after it is safely in the log.

    Durability does not imply a permanent state of the database. Another transaction may overwrite any changes made by the current transaction without hindering durability.

    2.NuoDB installation file is of size 150.7021484375 MB for Windows Platform.

    Reply
  • Prageet Surheley
    July 15, 2013 1:26 pm

    ACID stands for:-
    A: – Atomicity
    C: – Consistency
    I: – Isolation
    D: – Durability
    Atomicity means that all the effects of the transaction must complete successfully or the changes are rolled back. Best example is withdrawal of money from ATM machines. The machine must both dispense the cash and debit your bank account.

    Consistency ensures that the transaction cannot break the integrity rule of the database i.e it must leave the database in a consistent state.

    Isolation refers to keeping the change of incomplete transaction running at the same time separate from one another. Each transaction must be entirely self-contained & changes it makes must not be readable by any other transaction.

    Durability means once the transaction is committed it must persist even if there is a system failure i.e it must be durable. In SQL Server the information needed to replay changes made in a transaction is written to the transaction log before the transaction is considered to be committed. Durability guarantees that the database will keep track of pending changes in such a way that the server can recover from an abnormal termination.

    NuoDB installation file is of size 153.04 MB for Windows (64-Bit) Platform

    Reply
  • QUESTION 1

    ACID is the acronym for Atomicity Consistency Isolation Durability: these are the 4 properties that should carachterize each transaction in a database.
    Atomicity means that each transaction must be processed as an atomic unit that starts with a BOT (Begin Of Transaction) and ends with a EOT (End Of Transaction). Two are the possible results: commit work, in which the changes that the transaction made are written permanently on the DB, and rollback work: in this case, every change made by the transaction is undone until the DB returns to the state preceding the BOT.
    Consistency means the transaction must not violate the integrity constraints of the DB.
    Isolation means that every transaction is processed as if it were the only active transaction in the db.
    Durability means that the changes made by the transactions that end in commit work must be written permanently in the db.

    QUESTION 2

    NuoDB installation file is of size 78,2 MB for MacOS Platform.
    NuoDB installation file is of size 153 MB for Windows Platform.
    NuoDB installation file is of size 110 MB for Red Hat based Platform.
    NuoDB installation file is of size 110 MB for Ubuntu Platform.
    NuoDB installation file is of size 110 MB for Red hat based and Ubuntu Platform.
    NuoDB installation file is of size 53,1 MB for Solaris Platform.

    Reply
  • Answer1:

    The four key properties of a transaction: atomicity, consistency, isolation, and durability. In simple terms,

    Atomic = all changes are made (commit), or none (rollback).
    Consistent = transaction won’t violate declared system integrity constraints
    Isolated = results independent of concurrent transactions.
    Durable = committed changes survive various classes of hardware failure.
    Atomicity
    All changes to data are performed as if they are a single operation. That is, all the changes are performed, or none of them are.

    For example, in an application that transfers funds from one account to another, the atomicity property ensures that, if a debit is made successfully from one account, the corresponding credit is made to the other account.

    Example:

    BEGIN TRY
    BEGIN TRAN
    — Check the balance of accounts (10032, 10033)
    select balance from Account where Account_Number=’10032′;
    select balance from Account where Account_Number=’10033′;

    –Debit 900 from account num (10032)
    update Account set balance=balance-900 where Account_Number=’10032′ ;

    — credit 900 which is deboted from first account to account num(10033)
    update Account set balance=balance+900 where Account_Number=’10033′ ;

    –if all above sql queries succeeded
    commit;
    END TRY
    BEGIN CATCH
    rollback; –if any of above Sql queries failed or error
    END CATCH

    Consistency
    Data is in a consistent state when a transaction starts and when it ends.

    For example, in an application that transfers funds from one account to another, the consistency property ensures that the total value of funds in both the accounts is the same at the start and end of each transaction.

    Isolation
    The intermediate state of a transaction is invisible to other transactions. As a result, transactions that run concurrently appear to be serialized.

    For example, in an application that transfers funds from one account to another, the isolation property ensures that another transaction sees the transferred funds in one account or the other, but not in both, nor in neither.

    Durability
    After a transaction successfully completes, changes to data persist and are not undone, even in the event of a system failure.

    For example, in an application that transfers funds from one account to another, the durability property ensures that the changes made to each account will not be reversed.

    Answer2:
    NuoDB installation file is of size 153 MB for Windows Platform.

    Reply
  • Thank you so much for participating in the contest. We never know who will be the first one and will get the award.

    Reply
    • Vikas Penubelli
      July 15, 2013 3:29 pm

      Hi, in the Rules section I see the below.
      Rules

      The contest will be open till July 21, 2013. All the valid comments will be hidden till the result is announced.

      The winners will be announced on July 24, 2013.

      But, my comment is visible to me as of now… will it be visible to others as well?

      Reply
  • Q1: ACID stands for Atomicity, Consistency, Isolation, Durability.

    Durability means that once a transaction has been committed, it will remain so, even in the event of power loss, crashes, or errors. In a relational database, for instance, once a group of SQL statements execute, the results need to be stored permanently (even if the database crashes immediately thereafter). To defend against power loss, transactions (or their effects) must be recorded in a non-volatile memory.

    Q2: NuoDB installation file is of size 153 MB for Windows Platform.

    Reply
  • Hina Handicraft
    July 15, 2013 3:38 pm

    Hina Heritage Handicrafts leading Wooden Furniture , Wooden Handicrafts , Onyx and Marble Handicrafts and Salt Products Manufacturer and Exporter.Pakistan Onyx Marble offers the biggest choice of stylish products for your home, and office.We offer Bedroom Furniture , Kitchen Furniture, Children’s Bedroom Furniture, Dining Room, Swing, Room Divider, Kansool, Devan, Sofa set, Jhrooka, Dining Tables, Chesters, Flower Stand, Lamp, Tea Tralley, Doors, Almari, Decoration and Living Room Furniture at the highest quality and also at discount prices that you can afford. Hina Heritage Handicrafts in London UK |chess set in London UK |onyx chess set in UK london | marble chess set in UK London | leather chess set in UK London |backgammon in UK London | Rosewood handicrafts in UK london|furniture in UK | himalyan rock salt in UK London

    Best Chess Set In UK
    Best Chess Set In LONDON
    Best Handicraft
    Best Handicraft in uk
    Leather Chess Set
    Stylish Home Handicrafts

    Website:

    Reply
  • Efraya (@d347hm4n)
    July 15, 2013 7:47 pm

    ACID in database terms, stands for: Atomicity, Consistency, Isolation, Durability

    Atomicity is all or nothing, either the transaction will fail completely and not continue or it will succeed 100%

    Consistency means that after each transaction the Database will be left in a valid state.

    Isolation implies that each transaction doesn’t rely on any other transaction that may be occuring at the same time.

    Durability: Once a transaction has finished and power is lost after success, the data will still be there.

    NuoDB installation file is of size 153 MB for Windows x64 Platform

    Ef.

    Reply
  • Ramkrishna Panda
    July 15, 2013 10:26 pm

    Question 1: What ACID stands in the Database?

    Answer: ACID (an acronymn for Atomicity Consistency Isolation Durability) is a concept that Database Professionals generally look for when evaluating databases and application architectures. For a reliable database all this four attributes should be achieved.

    Atomicity is an all-or-none proposition.

    Consistency guarantees that a transaction never leaves your database in a half-finished state.

    Isolation keeps transactions separated from each other until they’re finished.

    Durability guarantees that the database will keep track of pending changes in such a way that the server can recover from an abnormal termination.

    Question 2: What is the size of the installation file of NuoDB for any specific platform,

    Answer: NuoDB installation file is of size 153 MB for Windows(64-bits) Inc/32-bit clients Platform.

    Reply

Leave a Reply

Menu