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 12 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
Thanks for the timely response, appreciate it

kthug

  • Member
  • Posts: 332
Reply 3 on: Yesterday
:D TYSM

« previous next »
 

Did you know?

For high blood pressure (hypertension), a new class of drug, called a vasopeptidase blocker (inhibitor), has been developed. It decreases blood pressure by simultaneously dilating the peripheral arteries and increasing the body's loss of salt.

Did you know?

It is widely believed that giving a daily oral dose of aspirin to heart attack patients improves their chances of survival because the aspirin blocks the formation of new blood clots.

Did you know?

Malaria mortality rates are falling. Increased malaria prevention and control measures have greatly improved these rates. Since 2000, malaria mortality rates have fallen globally by 60% among all age groups, and by 65% among children under age 5.

Did you know?

People about to have surgery must tell their health care providers about all supplements they take.

Did you know?

Of the estimated 2 million heroin users in the United States, 600,000–800,000 are considered hardcore addicts. Heroin addiction is considered to be one of the hardest addictions to recover from.

The structural formulas show the state of ionization that would predominate at pH 7.0 The structural formulas show the state of ionization that would predominate at pH 7.0
Why would anyone decorate herself like this? Among the many reasons, one is to show solidarity ... Why would anyone decorate herself like this? Among the many reasons, one is to show solidarity ...
Rank-order correlations show that differential consistency remains high from childhood through late ... Rank-order correlations show that differential consistency remains high from childhood through late ...
Answer the following short answer, please show your steps and include the formulas used Answer the following short answer, please show your steps and include the formulas used
How to visualize division in the Odds form of Bayes's Theorem? How to visualize division in the Odds form of Bayes's Theorem?
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: Contraction cycle of a sarcomere

For a complete list of videos, visit our video library