De?ne data atomicity as it relates to the de?nition of relational databases. Contrast data atomicity with transaction atomicity as used in a transaction processing system.

What will be an ideal response?


These concepts are not related. Data atomicity means that the relational model does not specify any means for looking into the internal structure of the values, so they appear as indivisible to the relational operators. Transaction atomicity means that the system must ensure that either the transaction runs to completion or, if it does not complete, it has no e?ect at all. It does not mean that the transaction must be indivisible, but it is a type of all-or-none execution.

Computer Science & Information Technology

You might also like to view...

The variable used to keep a running total in a loop is called a(n) __________.

a. accumulator b. sentinel c. summation d. integer

Computer Science & Information Technology

A drive is an area of storage that is formatted with a file system compatible with an operating system and is identified by a letter

Indicate whether the statement is true or false

Computer Science & Information Technology

Before you can open and edit a compressed file, you must uncompress it, or ____ it.

A. extract B. dearchive C. explore D. unlock

Computer Science & Information Technology

In the figure above, the three links in the Assets panel are ____ links.

A. related pages B. internal C. ?external D. ?relative path 

Computer Science & Information Technology