database-internals
์ด 36๊ฐ์ ์ํค ยท 1 / 2 ํ์ด์ง ๐ก RSS ๐ธ๏ธ ๊ทธ๋ํ
- [DB] Transaction Isolation Levels: ์๋ฒฝ ๊ฐ์ด๋#transaction #isolation #database #acid #mvcc #postgresql #mysql
- N+1 ์ฟผ๋ฆฌ ๋ฌธ์ #orm #performance #query #n-plus-one #database
- [DB Internals] B-Tree ๋ด๋ถ: split, merge, search ์๊ณ ๋ฆฌ์ฆ#btree #database #index #algorithm #tree
- [DB Internals] B+ Tree ๋ด๋ถ: leaf linked list, range scan#btree #b-plus-tree #database #index #range-query
- [DB Internals] CHAR / VARCHAR / TEXT / JSONB: ๋ฌธ์์ด ํ์ ๋น๊ต#postgresql #mysql #string #char #varchar #text #jsonb #toast
- [DB Internals] GIN Index ๊น์ด: ๊ตฌ์กฐ, jsonb_path_ops, tsvector#gin #postgresql #index #inverted #full-text #jsonb
- [DB Internals] R-Tree: ๊ณต๊ฐ ์ธ๋ฑ์ค, MBR, split#r-tree #spatial #index #gis #postgis
- [DB Internals] Redis 8 / Valkey 9: ๋ผ์ด์ผ์ค ๋ถ๊ธฐ, ์ ๋ฐ์ดํฐ ๊ตฌ์กฐ, ์ค์ ์ด์#database #redis #valkey #cache #queue #vector-search #key-value #in-memory
- [DB] Cassandra: LSM-tree, quorum, eventually consistent#cassandra #nosql #distributed #lsm-tree #database
- [DB] DynamoDB: PK + SK, single-table design, GSI / LSI#dynamodb #nosql #aws #key-value #document
- [DB] EXPLAIN ์ฝ๊ธฐ: scan, join, sort, cost#explain #query-plan #postgresql #performance #database
- [DB] GIN / GiST / Hash / BRIN: ๋น-B-tree ์ธ๋ฑ์ค#postgresql #index #gin #gist #brin #database
- [DB] MongoDB: ๋ฌธ์ DB, WiredTiger, replica set, aggregation#mongodb #nosql #document #database
- [DB] MySQL / InnoDB: clustered index, redo log, MVCC#mysql #innodb #database #sql
- [DB] PostgreSQL: ํ๋ก์ธ์ค ๋ชจ๋ธ, MVCC, WAL, ํ์ฅ์ฑ#postgresql #database #sql #mvcc #wal
- [DB] Sharding vs Partitioning: ์ํ ํ์ฅ์ ๋ ์ผ๊ตด#sharding #partitioning #scaling #database
- [DB] SQLite: ๋จ์ผ ํ์ผ, WAL ๋ชจ๋, edge / mobile#sqlite #database #embedded #edge
- [DB] WAL: Write-Ahead Log, crash recovery, replication ์ ํ ๋#wal #durability #recovery #replication #database
- [PostgreSQL] JSONB: ์ฅ์ ๊ณผ ๋จ์ , ์ธ๋ฑ์ฑ, ์ฌ์ฉ ํจํด#postgresql #jsonb #json #schemaless #indexing
- [Redis] Bloom / Cuckoo / CMS / TopK: ํ๋ฅ ์๋ฃ๊ตฌ์กฐ#redis #data-structure #probabilistic #bloom #cuckoo #count-min #topk