rel:: [[Software Engineering]] # Databases - https://dbdb.io - [database startups](https://transactional.blog/blog/2024-database-startups) ## terms - OLAP - Online Analytical Processing ^bae0d4 - OLTP - Online Transaction Processing ## storage - [[Durability - Cloud Applications]] - [IO Devices and Latency](https://planetscale.com/blog/io-devices-and-latency) ## algorithms ### probabilistic - [[Ribbon Filters]] ### caching - [[Adaptive Replacement Cache]] ## architecture ### DynamoDB - [[Amazon DynamoDB - A Scalable, Predictably Performant, and Fully Managed NoSQL Database Service-Akshat Vig|Amazon DynamoDB - A Scalable, Predictably Performant, and Fully Managed NoSQL Database Service]] ### ETL Patterns - [Data Challenges in Big Data](x-devonthink-item://D6889FDC-6C90-4AF7-A696-E013ED42A966) - [Change Data Capture](x-devonthink-item://025B4766-2D46-4BF5-9E57-ED0CD96B67D2) viewing a source-of-truth DB as stream of atomic, serialized, updates ### multi-tenant - [Multi-tenant, serverless architecture for CockroachDB](x-devonthink-item://D1936DDF-5339-4300-B02D-2BFE39E9F6D8) - key is fast-provisioning, dedicated query pods for individual tenants ## engines - https://dbdb.io - [[SQLite]] - [[PostgreSQL]] - [[RocksDB]] - [[MS Access]] - [[OpenZFS]] - [[AWS S3]] - [[#DynamoDB|AWS DynamoDB]] - [[Apache Pinot]] - [[TigerBeetle]] - [[DuckDB]] ## Languages - [[SQL]]