Advanced Database Topics Flashcards Preview

CS1003 > Advanced Database Topics > Flashcards

Flashcards in Advanced Database Topics Deck (14)
Loading flashcards...
1

What does the acronym ACID stand for?

Atomicity
Consistency
Isolation
Durability

2

What does atomicity mean?

Either both operations happen or neither does

3

What does consistency mean?

Both records/accounts need to be displaying the same information

4

What does isolation mean?

Other users never see a state in which one line has been performed and not the other

5

What does durability mean?

Once the operations are acknowledged and performed, they are permanently recorded

6

What do the letters in the CAP acynonym stand for?

Consistent
Avaliable
Partition Tolerant

7

What does Brewer's theorem?

Cannot have all three in CAP at all times

8

What are BASE systems?

Basically Avaliable for requests
Soft state, change over time
Evenually consistent

9

What are the variety of CAP options?

Consistent and Avaliable (e.g. classical relational databses)
Consistent and Partition Tolerant
Avaliable and Partition Tolerant

10

What is sharding?

Sharding refers to the horizontal partitioning of a database
(different rows sit on different servers)

11

What are some disadvantages of sharding?

Queries become really complex
Reliant on server interconnection

12

What is the NoSQL movement?

Movement that realises that SQL may not always be the best choice

13

Give examples of common NoSQL data models?

Key-Value store
Column store
Document store
Object database
Graph database

14

Give an example of a database system that uses key-value store

LevelDB, Oracle NoSQL