Source: sqlserverhelpdotcom Atomicity : Either all operations are executed or none of the operations are executed. Consistency : All the data must be in a consistent state. There should be no transaction that has adverse effect on data residing in database. Isolation : If more than 1 transactions are executing simulataneously then every transaction should be executed as if no other transaction is running. Durability: The database system should be able to sustain the updates. Even if the system fails or restarts, the updates should be applied.
It can be broken into 3 fundamental logical layers they are: User Interface Processing Data storage Types : Single Tier Architecture: Data is stored in single location. It is an application running on single computer and perform all the required tasks. Easy to manage and implement data consistency. Two Tier Architecture: The basic web architecture is two tiered and characterized by Web Client: displays information content. Web Server: transfer information to client. It separates data and business logic. It is generally data driven: Application existing entirely on local machine. Database is deployed at a specific and secure location. Limitations: As ...
Read more