PrepAway - Latest Free Exam Questions & Answers

Which embodies the “share-nothing” architecture and essentially involves breaking a large database

____________ 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.

PrepAway - Latest Free Exam Questions & Answers

A.
Sharding

B.
Failure recovery

C.
Federation

D.
DDL operations

5 Comments on “Which embodies the “share-nothing” architecture and essentially involves breaking a large database

  1. Srinivasu Muchcherla says:

    Sharding
    Sharding 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 sharding 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 Sharding
    Maintenance Overhead




    0



    0

Leave a Reply

Your email address will not be published. Required fields are marked *