Enterprise Application Architecture with .NET Core

Increasing storage performance

Every business application uses a relational database as a backend persistence for data. When we talk about relational databases, we cannot exclude database servers such as Microsoft SQL Server, Oracle, IBM Derby, and so on, used to create the databases, tables, stored procedures, and other useful objects. Relational databases also exhibit properties known as the acronym ACID (Atomicity, Consistency, Isolation, and Durability):

• Atomicity: Multiple operations can be done on a database as a unified transaction which can either succeed or fail. On failure, all the operations will be rolled back to the previous state.
• Consistent: Avoid inconsistencies in results, like keeping the atomicity and avoiding partial ...