Atomicity & Aggregation in Database Management System

Let's use this thread to understand the concepts of atomicity and aggregation in DBMS.

Try to explain in simple words with examples.


  • PraveenKumar Purushothaman
    PraveenKumar Purushothaman
    Atomicity - An atom cannot be subdivided further. So should be the transaction.
    Consider a bank transfer account. In that, A transfers 10 to B. So, database'ically',
    Operation #1: 10 is subtracted from A.
    Operation #2: 10 is added to B.
    Atomicity is both these two operations should happen or none should happen. It cannot be only Operation #1 happened or Operation #2 happened. 😀 Both the operations happened is called a Transaction. 😀
  • PraveenKumar Purushothaman
    PraveenKumar Purushothaman
    Aggregation: There are 7 functions in aggregation in databases. All these can be performed only on multiple rows / data.
    AVG()   - Returns the average value
    COUNT() - Returns the number of rows
    FIRST() - Returns the first value
    LAST()  - Returns the last value
    MAX()   - Returns the largest value
    MIN()   - Returns the smallest value
    SUM()   - Returns the sum

You are reading an archived discussion.

Related Posts

Let the creative juices flow.. Come up with a script of your own, direct your friends to act and produce a film with your mobile camera on site- the DSK...
CEans, We're in the final phases of CE Grand Quiz. The following one shouldn't bother your heads for long time. Go! Crack It & Win 20 CE Coins 😀 Image...
Ng Beng Kiat's Min7.1 Blazes Through 2011 All Japan Micromouse Competition - and following video shows how you will have hard time believing your own eyes. [video=youtube;CLwICJKV4dw][/video]
Here comes the conquering King! Super K Nothing less. ​Super K | Movie Feature - Yahoo! Movies India
Hello to the great minds at CE. I work alot with pumps. How would a stainless steel impeller or shaft stand up in salt water conditions? I have soem idea...