This topic contains a solution. Click here to go to the answer

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

jessicacav

  • Hero Member
  • *****
  • Posts: 558
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
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
Thanks for the timely response, appreciate it


kusterl

  • Member
  • Posts: 315
Reply 3 on: Yesterday
Wow, this really help

 

Did you know?

Atropine was named after the Greek goddess Atropos, the oldest and ugliest of the three sisters known as the Fates, who controlled the destiny of men.

Did you know?

Earwax has antimicrobial properties that reduce the viability of bacteria and fungus in the human ear.

Did you know?

Blood is approximately twice as thick as water because of the cells and other components found in it.

Did you know?

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

Did you know?

The calories found in one piece of cherry cheesecake could light a 60-watt light bulb for 1.5 hours.

For a complete list of videos, visit our video library