CrazyEngineers
CrazyEngineers

  • Atomicity & Aggregation in Database Management System

    Ankita Katdare

    Administrator

    Updated: Oct 22, 2024
    Views: 10.4K
    Let's use this thread to understand the concepts of atomicity and aggregation in DBMS.

    Try to explain in simple words with examples.
    0
    Replies
Howdy guest!
Dear guest, you must be logged-in to participate on CrazyEngineers. We would love to have you as a member of our community. Consider creating an account or login.
Replies

  • PraveenKumar Purushothaman

    Member • Dec 21, 2011

    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. 😀
    Are you sure? This action cannot be undone.
    Cancel

  • PraveenKumar Purushothaman

    Member • Dec 21, 2011

    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
    Are you sure? This action cannot be undone.
    Cancel
Home Channels Search Login Register