Page 35 - Demo

» Consistency: The completion of any transaction brings the database from one valid state to another valid state.
» Isolation: Concurrent transactions do not contend for access to the data and are run as if each transaction executed sequentially.
» Durability: After a transaction is committed, it remains committed.
Data consumers also benefit by receiving immediate access to only the shared data without having to scan the data provider’s entire data warehouse to look for the data they need.
Unlimited concurrency
With modern data sharing, shared data can be accessed by large numbers of concurrent data consumers, as shown in Figure 4-5. In contrast, the architecture of traditional data warehouses forces all users to compete for resources, creating a struggle to deliver optimum performance and consistency. Automatic scaling of concurrency takes simultaneous query processing even further in modern data sharing by automating the scaling of additional warehouse compute engines without manual intervention.
FIGURE 4-5: Unlimited concurrency with a modern data sharing architecture.
CHAPTER4 EnablingLiveDataSharingwithaModernCloudDataWarehouseArchitecture 29 These materials are © 2018 John Wiley & Sons, Inc. Any dissemination, distribution, or unauthorized use is strictly prohibited.