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 40 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
Wow, this really help

nanny

  • Member
  • Posts: 313
Reply 3 on: Yesterday
YES! Correct, THANKS for helping me on my review

« previous next »
 

Did you know?

Chronic necrotizing aspergillosis has a slowly progressive process that, unlike invasive aspergillosis, does not spread to other organ systems or the blood vessels. It most often affects middle-aged and elderly individuals, spreading to surrounding tissue in the lungs. The disease often does not respond to conventionally successful treatments, and requires individualized therapies in order to keep it from becoming life-threatening.

Did you know?

Once thought to have neurofibromatosis, Joseph Merrick (also known as "the elephant man") is now, in retrospect, thought by clinical experts to have had Proteus syndrome. This endocrine disease causes continued and abnormal growth of the bones, muscles, skin, and so on and can become completely debilitating with severe deformities occurring anywhere on the body.

Did you know?

To maintain good kidney function, you should drink at least 3 quarts of water daily. Water dilutes urine and helps prevent concentrations of salts and minerals that can lead to kidney stone formation. Chronic dehydration is a major contributor to the development of kidney stones.

Did you know?

Alcohol acts as a diuretic. Eight ounces of water is needed to metabolize just 1 ounce of alcohol.

Did you know?

The immune system needs 9.5 hours of sleep in total darkness to recharge completely.

Posterior views of H. erectus, Neandertal, and modern H. sapiens show differences in vault shape. Posterior views of H. erectus, Neandertal, and modern H. sapiens show differences in vault shape.
Bone fractures that occur before death show signs of healing. The process of fracture healing starts Bone fractures that occur before death show signs of healing. The process of fracture healing starts
Functional MRI Scans These scans of human brains show localized average increases in neural activity Functional MRI Scans These scans of human brains show localized average increases in neural activity
Cumulative change for six personality-trait domains across the life course show distinct patterns. Cumulative change for six personality-trait domains across the life course show distinct patterns.
Testing motor function of cranial nerve VII - Show teeth Testing motor function of cranial nerve VII - Show teeth
Doty's data show a very rapid drop in late adulthood in the ability to identify smells Doty's data show a very rapid drop in late adulthood in the ability to identify smells
Video: Protein catabolism - deamination

For a complete list of videos, visit our video library