Databases Flashcards
What is a popular relational database?
MySQL
What is a popular key-value store database?
Dynamo
What is a popular document database?
MongoDB
What is a popular wide-column database?
Cassandra
What is a popular graph database?
Neo4J
Can you alter a SQL/relational DB schema?
Yes, but requires modifying the entire DB and going offline
When can you add columns to a NoSQL schema?
On the fly
In a NoSQL DB, does each entity need to contain data for each column?
No
What type of DB has more powerful querying?
SQL/Relational
How do you scale a relational DB?
Vertically by increasing horsepower of hardware like higher memory, CPU
What is the downside of scaling a (relational) DB vertically?
Expensive
Can you scale a relational DB across multiple servers?
Yes, but challenging and time consuming
How do you scale a non-relational DB?
Horizontally by adding more servers
What type of DB is cheaper to scale
Non-relational
What type of DB is better for ACID compliancy and data reliability
Relational
Non-relational DBs sacrifice ACID compliance for what?
Performance and scalability
What kind of DB is preferred for ecommerce/finance?
SQL
Why would ecommerce and finance prefer SQL DBs?
ACID compliance
When you do not want data to be the bottleneck, which type of DB to choose?
NoSQL
When storing large volumes of data that have little to no structure, which DB?
NoSQL
Which DB when you want to easily and cheaply scale
NoSQL
Which DB is better for rapid development?
NoSQL
