Chapter 5.8, Problem 5.8ARQ

Explanation of Solution

Increase of database data that will affect the business Intelligence and Security:

The increase of database data will affect the business Intelligence and security in the following ways:

• Increases the threat of data theft.
• Data mishandling.
• Data being lost.
• Data leaks.

Two major requirements of the Internet database application created:

The two major requirements of the Internet database application created are:

• Code to process the data that are to process the internet application that are developed.
  • The data that are created needs to be stored for the future purpose that needs to follow ACID properties of the transaction.
• Power to handle the data that are generated using the internet application that are created.
  • The data that are generated are stored based on the requirements not following ACID Properties of the Transaction.

These two requirements made the evolution of three databases namely “No SQL”, “New SQL”, and “in-memory” databases.

Characteristics of ACID properties in processing the Transaction:

The main characteristic properties of ACID in processing the transaction are discussed below:

“ACID” stands for “Atomicity”, “Consistency”, “Isolated” and “Durable”.

Atomicity:

In processing a transaction, a transaction needs to be processed completely or should not contain anything in it.

• Example: If an account is credited by amount the amount must be either added to overall balance or should not happen at all.

Consistency:

A transaction that is established needs to be processed in a similar way throughout the transaction.

• Example: If an account is credited by amount that amount must be either added to overall balance or should not happen at all and it should at the same time with the account holder and with the bank database.

Isolated:

The transaction that is happening needs to processed is separate unit such that another transaction should not affect the current process.

• Example: Consider an online transaction that is happening simultaneously, any processing made with the one should not affect another processing the same process.

Durable:

The transaction that is processed needs to be established completely or should be aborted in case of failure...