This topic contains a solution. Click here to go to the answer
« previous next »

Author Question: What is the CAP theorem, and what does it show? What will be an ideal ... (Read 53 times)

jessicacav

  • Hero Member
  • *****
  • Posts: 558
on: Jul 7, 2018
What is the CAP theorem, and what does it show?
 
  What will be an ideal response?

Question 2

The SQL CREATE TABLE statement is used to name a new table and describe the table's columns.
 
  Indicate whether the statement is true or false


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

uniquea123

  • Sr. Member
  • ****
  • Posts: 311
Reply #1 on: Jul 7, 2018
Answer to Question 1

The CAP theorem, which was first proposed by Eric Brewer in 2000, and then proven as a theorem by Seth Gilbert and Nancy Lynch in 2002, basically states that there are three properties of distributed database systems, and a DBMS system cannot guarantee that all three properties will be satisfied at the same time. At least one of the properties will be at least somewhat compromised. The three properties are:
 Consistencyall the database partition replicas see the same data at any given point in time.
 Availabilityunless a node has failed, it will respond to a request.
 Partition tolerancethe distributed database is doing its job, and therefore if we can't get to the data on one partition, it will be available on another.

Answer to Question 2

TRUE


jessicacav

  • Member
  • Posts: 558
Reply 2 on: Jul 7, 2018
YES! Correct, THANKS for helping me on my review

Dominic

  • Member
  • Posts: 328
Reply 3 on: Yesterday
Excellent

« previous next »
 

Did you know?

A cataract is a clouding of the eyes' natural lens. As we age, some clouding of the lens may occur. The first sign of a cataract is usually blurry vision. Although glasses and other visual aids may at first help a person with cataracts, surgery may become inevitable. Cataract surgery is very successful in restoring vision, and it is the most frequently performed surgery in the United States.

Did you know?

It is believed that the Incas used anesthesia. Evidence supports the theory that shamans chewed cocoa leaves and drilled holes into the heads of patients (letting evil spirits escape), spitting into the wounds they made. The mixture of cocaine, saliva, and resin numbed the site enough to allow hours of drilling.

Did you know?

There are approximately 3 million unintended pregnancies in the United States each year.

Did you know?

In ancient Rome, many of the richer people in the population had lead-induced gout. The reason for this is unclear. Lead poisoning has also been linked to madness.

Did you know?

Pubic lice (crabs) are usually spread through sexual contact. You cannot catch them by using a public toilet.

A microsatellite locus can show linkage to a disease gene A microsatellite locus can show linkage to a disease gene
Some drug labels show the USP symbol; others do not. Some drug labels show the USP symbol; others do not.
If you want to show differences between items at the same time, a bar graph is more effective than a If you want to show differences between items at the same time, a bar graph is more effective than a
Age Differences in Attention to a Puppet Show Video Age Differences in Attention to a Puppet Show Video
The upper panel shows that scores of four diverse samples of boys on a moral reasoning test show a ... The upper panel shows that scores of four diverse samples of boys on a moral reasoning test show a ...
The results of a cytogenetic survey of over 4,000 miscarriages show a wide variation in how often sp The results of a cytogenetic survey of over 4,000 miscarriages show a wide variation in how often sp
Video: Role of the urinary system - acidosis and alkalosis

For a complete list of videos, visit our video library