logo

Will Percey - Knowledge Base
Version: 2.0.0

homelanguagearticleimageclinical_notes

Data

Home > DataUpdated Dec 2025
storage

Databases

database
DatabasesSQL, NoSQL, NewSQL

Relational, document, key-value, wide-column, and graph databases

PostgreSQLMongoDBRedisCassandra
hub
Vector DatabasesEmbeddings & Similarity

Specialized databases for storing and querying vector embeddings

PineconeWeaviateMilvusQdrant
pattern
Database PatternsAccess & Query Patterns

Repository, Data Mapper, Active Record, Unit of Work patterns

RepositoryDAOORMQuery Object
account_tree

Data Architecture

schema
Data ArchitectureLakes, Warehouses & Governance

Data lakes, warehouses, lakehouses, governance, and lifecycle management

Data LakeWarehouseLakehouseGovernance
grid_view
Dimensional ModelingFacts, Dimensions & Grain

Kimball methodology, fact tables, dimensions, SCDs, and measures

Star SchemaFact TablesSCDGrain
trending_up
Database ScalingPerformance & Distribution

Indexing, sharding, replication, caching, and vertical scaling

ShardingReplicationIndexingCaching
analytics

Big Data & Analytics

data_thresholding
Big DataWarehouses & Processing

Data warehouses, OLAP databases, and analytics platforms for large-scale data

SnowflakeBigQuerySparkRedshift