SQL, noSQL Flashcards
What databases have you worked on ?
- MongoDB
- Cassandra
- Neo 4J
- Redis
- Elastic Search
What did you use MongoDB for ?
JSON Storage (document storage), good read/write balance
What did you use Cassandra for ?
- Large data storage
- Very good write performances and scalability
What did you use Redis for ?
- For Caching mostly
What did you use Elastic Search for ?
- Index of metadatas for Operator UI
- Logging and monitoring with Graphana, Kibana
Which database needs pre-defined schemas ?
SQL Databases
Which database requires data to follow the same structure ?
SQL Databases
Which DBs are vertically scalable ?
SQL Databases
Define vertically scalable
Can increase load on a single server with increase of CPU, RAM, SSD.
Give me SQL Databases ?
- My SQL
- Oracle
What is a nonSQL database ?
- Dynamic schema for unstructured data
- can be column oriented
- can be document oriented
- can be graph based
- can be key-value
Give 4 advantages of nonSQL databases ?
- Can create documents without having to define their structure first ?
- Each document can have its own unique architecture
- Syntax can vary from database to database
- Can add fields as you go
How scalable are non-SQL databases ?
Horizontally Scalable
Define Horizontally Scalable
- You can handle more by shardig
- you can add more servers
Why is Mongo DB a good choice for businesses ?
- It can scale easily for rapid growths
- it can handle no clear schema definition for dynamic data handling
- if you cannot define a schema for your dv
- if your schema continues to change
What is the main difference between REDIS and MongoDB ?
- Redis is a key/value storage
- Mongo is a document store
What is the main advantage of MongoDB ?
Best at structuring or modeling information with relations between them
What is the main advantage of Redis ?
It’s awesome at storing unrelated pieces of information with rapidly changing data
What is etcd ?
Its a general substrate for large scale distributed systems
Whad are the advantages of the etcd cluster ?
- key-value storage with stability
- scalability
- performances
Give me 3 examples of best Redis Usage ?
- Real-time analytics
- Leaderboards
- Real time communications
What format are data stored in Mongo DB ?
JSON
What replication is MongoDB built on ?
Master/Slave replication with auto failover
Which DB uses javascript expressions as queries ?
MongoDB
What is Mongo best usage ?
- CRM systems
- simple CMS systems
Does MongoDB manage versioning ?
Yes
