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 45 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
Gracias!

bimper21

  • Member
  • Posts: 309
Reply 3 on: Yesterday
Thanks for the timely response, appreciate it

« previous next »
 

Did you know?

There used to be a metric calendar, as well as metric clocks. The metric calendar, or "French Republican Calendar" divided the year into 12 months, but each month was divided into three 10-day weeks. Each day had 10 decimal hours. Each hour had 100 decimal minutes. Due to lack of popularity, the metric clocks and calendars were ended in 1795, three years after they had been first marketed.

Did you know?

People with high total cholesterol have about two times the risk for heart disease as people with ideal levels.

Did you know?

Fewer than 10% of babies are born on their exact due dates, 50% are born within 1 week of the due date, and 90% are born within 2 weeks of the date.

Did you know?

A recent study has found that following a diet rich in berries may slow down the aging process of the brain. This diet apparently helps to keep dopamine levels much higher than are seen in normal individuals who do not eat berries as a regular part of their diet as they enter their later years.

Did you know?

According to the FDA, adverse drug events harmed or killed approximately 1,200,000 people in the United States in the year 2015.

Morotopithecus is the earliest fossil ape to show postcranial adaptations similar to those of the li Morotopithecus is the earliest fossil ape to show postcranial adaptations similar to those of the li
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
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 ...
The scan tool can display various voltage but will often show 3.3 volts because the PCM is ... The scan tool can display various voltage but will often show 3.3 volts because the PCM is ...
Food webs show feeding relationships and energy flow Food webs show feeding relationships and energy flow
A very light ideal spring stretches by when it is used to hang a 135-N object. What is the ... A very light ideal spring stretches by when it is used to hang a 135-N object. What is the ...
Video: Fermentation pathways

For a complete list of videos, visit our video library