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


Jossy

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

 

Did you know?

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

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?

People with alcoholism are at a much greater risk of malnutrition than are other people and usually exhibit low levels of most vitamins (especially folic acid). This is because alcohol often takes the place of 50% of their daily intake of calories, with little nutritional value contained in it.

Did you know?

There can actually be a 25-hour time difference between certain locations in the world. The International Date Line passes between the islands of Samoa and American Samoa. It is not a straight line, but "zig-zags" around various island chains. Therefore, Samoa and nearby islands have one date, while American Samoa and nearby islands are one day behind. Daylight saving time is used in some islands, but not in others—further shifting the hours out of sync with natural time.

Did you know?

Street names for barbiturates include reds, red devils, yellow jackets, blue heavens, Christmas trees, and rainbows. They are commonly referred to as downers.

For a complete list of videos, visit our video library