database

Question 1

Type of Database

Answer 1

relational databases (e.g. Postgres) and NoSQL databases (e.g. DynamoDB)

Question 2

when to choose relational databases

Answer 2

often used for transactional data (e.g. user records, order records, etc)

Question 3

relational database features

Answer 3

SQL Joins, Indexes, RDBMS Transactions

Question 4

what is RDBMS Transactions

Answer 4

a way of grouping multiple operations together into a single atomic operation

Question 5

NoSQL Databases

Answer 5

a broad category of databases designed to accommodate a wide range of data models, including key-value, document, column-family, and graph formats. Unlike relational databases, NoSQL databases do not use a traditional table-based structure and are often schema-less.

Question 6

nosql is good for…

Answer 6

Flexible Data Models: Your data model is evolving or you need to store different types of data structures without a fixed schema.
Scalability: Your application needs to scale horizontally (across many servers) to accommodate large amounts of data or high user loads.
Handling Big Data and Real-Time Web Apps: You have applications dealing with large volumes of data, especially unstructured data, or applications requiring real-time data processing and analytics.

Question 7

Data Models of NoSQL

Answer 7

NoSQL databases come in many different flavors, each with its own data model. The most common types of NoSQL databases are key-value stores, document stores, column-family stores, and graph databases.

Question 8

Scalability of NoSQL databases

Answer 8

NoSQL databases scale horizontally by using consistent hashing and/or sharding to distribute data across many servers.

Question 9

Blob Storage

Answer 9

These platforms are specifically designed for handling large blobs of data, and are much more cost effective than a traditional database.

Question 10

blob storage features

Answer 10

Durable, Scalable, low Cost, Secure

Question 11

what is Search Optimized Database

Answer 11

designed to handle full-text search. They use techniques like indexing, tokenization, and stemming to make search queries fast and efficient

Question 12

feature of Search Optimized Database

Answer 12

Inverted Indexes (data structure that maps from words to the documents that contain them), Tokenization (breaking a piece of text into individual words), Stemming (reducing words to their root form), Fuzzy Search (ability to find results that are similar to a given search term)

Question 13

Examples of blob storage services

Answer 13

Amazon S3, Google Cloud Storage, and Azure Blob