Todo: https://www.youtube.com/watch?v=vdPALZ-GCfI&list=PLSE8ODhjZXjbj8BMuIrRcacnQh20hmY9g

F2023 #00 - Course Overview & Logistics (CMU Intro to Database Systems)

Also there is Adv Databases course

Data Models

Ref: CMU https://15445.courses.cs.cmu.edu/fall2024/slides/01-relationalmodel.pdf

Types of Databases

Selecting the right database is crucial for project success. Here’s a summary of key points:

• SQL databases offer structured data storage, SQL support, and relational capabilities.
• NoSQL databases provide flexibility, scalability, and distributed architectures.
• Specialized databases like columnar, graph, spatial, and time-series cater to specific needs.
• Evaluate key features, benefits, and providers to make an informed decision.

Vector DB

A vector database indexes and stores vector embeddings for fast retrieval and similarity search, with capabilities like CRUD operations, metadata filtering, and horizontal scaling.

A vector database stores high-dimensional vectors extracted from various unstructured data, like audio, video, image, and text. Then we can calculate the similarity among unstructured data. Typical use cases include:

• finding similar images or text
• recommending similar products
• detecting abnormalities
• temporarily store embeddings for large amounts of input

Ref: CMU https://15445.courses.cs.cmu.edu/fall2024/slides/01-relationalmodel.pdf

CAP and Databases

Ref:

• https://bikas-katwal.medium.com/mongodb-vs-cassandra-vs-rdbms-where-do-they-stand-in-the-cap-theorem-1bae779a7a15
• https://www.the-paper-trail.org/page/cap-faq/

SQL Databases

• Cloud Agnostic: Oracle, Microsoft SQL Server, IBM DB2, PostgreSQL, and MySQL
• AWS: Hosted PostgreSQL and MySQL in Relational Database Service (RDS)
• Microsoft Azure: Hosted SQL Server as Azure SQL Database
• Google Cloud: Hosted PostgreSQL and MySQL in Cloud SQL, and also horizontally scaling Cloud Spanner

Nice read about Cockroach DB https://www.cockroachlabs.com/blog/distributed-sql-key-value-store/

Ref: CMU 15-445/645: Introduction to Database Systems at Carnegie Mellon University

Scaling database

Ref: https://pages.awscloud.com/rs/112-TZM-766/images/Session%201%20-%20Intro%20to%20DDB%20and%20Use%20Cases_rev.pdf