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 50 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

kswal303

  • Member
  • Posts: 316
Reply 3 on: Yesterday
Great answer, keep it coming :)

« previous next »
 

Did you know?

The FDA recognizes 118 routes of administration.

Did you know?

The National Institutes of Health have supported research into acupuncture. This has shown that acupuncture significantly reduced pain associated with osteoarthritis of the knee, when used as a complement to conventional therapies.

Did you know?

As many as 28% of hospitalized patients requiring mechanical ventilators to help them breathe (for more than 48 hours) will develop ventilator-associated pneumonia. Current therapy involves intravenous antibiotics, but new antibiotics that can be inhaled (and more directly treat the infection) are being developed.

Did you know?

The average adult has about 21 square feet of skin.

Did you know?

The first successful kidney transplant was performed in 1954 and occurred in Boston. A kidney from an identical twin was transplanted into his dying brother's body and was not rejected because it did not appear foreign to his body.

The actions of Frzb and the Frizzled receptor protein show how embryonic development represents a ba The actions of Frzb and the Frizzled receptor protein show how embryonic development represents a ba
A microsatellite locus can show linkage to a disease gene A microsatellite locus can show linkage to a disease gene
These illustrations show Ellen Craft, a slave with and without a disguise. She dressed “as a disting These illustrations show Ellen Craft, a slave with and without a disguise. She dressed “as a disting
Results from Kliegl's study show that older adults can learn complex information-processing Results from Kliegl's study show that older adults can learn complex information-processing
If CP for an ideal gas is 35.4 J/molK, which of the following is CV for this gas? If CP for an ideal gas is 35.4 J/molK, which of the following is CV for this gas?
Here we show the first three divisions of cleavage, a process that carves up a zygote’s cytoplasm. ... Here we show the first three divisions of cleavage, a process that carves up a zygote’s cytoplasm. ...
Video: Structures that affect circulation - heart and MABP

For a complete list of videos, visit our video library