____ embodies the “share-nothing” architecture and essentially involves breaking a large database into several
smaller databases. Common ways to split a database include 1) splitting tables that are not joined in the same
query onto different hosts or 2) duplicating a table across multiple hosts and then using a hashing algorithm to
determine which host receives a given update.
A.
Sharding
B.
Failure recovery
C.
Federation
D.
DDL operations
Explanation:
Sharing embodies the “share-nothing” architecture and essentially just involves breaking a larger database up
into smaller databases. Common ways to split a database are:
Splitting tables that are not joined in the same query onto different hosts. Duplicating a table across multiple
hosts and then splitting where a row goes. More detailed information on the pros and cons of sharing can be
found at the following sites:
http://technoroy.blogspot.com/2008/07/shard-database-design.html http://www.hibernate.org/subprojects/
shards.html
How Amazon RDS Helps With Sharing Maintenance Overhead
A:Sharding is a type of database partitioning that separates very large databases the into smaller, faster, more easily managed parts called data shards. The word shard means a small part of a whole.
https://www.google.co.za/search?q=Sharding&oq=Sharding&aqs=chrome..69i57&sourceid=chrome&ie=UTF-8
0
0