2021-05-26-TIL

2021-05-26-TIL

Subquery vs Join

• https://jojoldu.tistory.com/520

MySQL Storage Engine

• https://dev-ahn.tistory.com/72

Row Store vs Column Store

• https://www.percona.com/blog/2016/12/14/row-store-and-column-store-databases/#:~:text=At%20a%20basic%20level%2C%20row,for%20a%20subset%20of%20columns.
• https://docs.microsoft.com/en-us/sql/relational-databases/indexes/columnstore-indexes-overview?view=sql-server-ver15#:~:text=Columnstore%20indexes%20are%20the%20standard,over%20traditional%20row%2Doriented%20storage.
• https://www.emoreau.com/PrintThisPage.aspx?ID=568

SSD page and block

• https://tech.kakao.com/2016/07/18/coding-for-ssd-part-6/#:~:text=NAND%20%ED%94%8C%EB%9E%98%EC%8B%9C%20%EB%B8%94%EB%A1%9D%EA%B3%BC%20%ED%8E%98%EC%9D%B4%EC%A7%80&text=%EB%98%90%ED%95%9C%20%EB%8C%80%EB%B6%80%EB%B6%84%EC%9D%98%20SSD%EC%97%90%EC%84%9C%EB%8A%94,%EC%82%AC%EC%9D%B4%EC%A6%88%EB%A5%BC%20%EA%B0%80%EC%A7%80%EA%B2%8C%20%EB%90%98%EB%8A%94%20%EA%B2%83%EC%9D%B4%EB%8B%A4.

Index in DB

• http://wiki.gurubee.net/pages/viewpage.action?pageId=29065492#:~:text=%EC%9D%B8%EB%8D%B1%EC%8A%A4%EB%8A%94%20%EB%8C%80%EC%9A%A9%EB%9F%89%20%ED%85%8C%EC%9D%B4%EB%B8%94%EC%97%90%EC%84%9C,%EC%8A%A4%EC%BA%94%EC%9D%B4%20%EC%9D%98%EB%AF%B8%ED%95%98%EB%8A%94%20%EB%B0%94%EC%9D%B4%EB%8B%A4.
• https://beelee.tistory.com/37

Clustering Index

• https://mongyang.tistory.com/75

B-tree and B+tree

• https://www.geeksforgeeks.org/difference-between-b-tree-and-b-tree/
• https://www.javatpoint.com/b-tree-vs-bplus-tree
• https://velog.io/@emplam27/%EC%9E%90%EB%A3%8C%EA%B5%AC%EC%A1%B0-%EA%B7%B8%EB%A6%BC%EC%9C%BC%EB%A1%9C-%EC%95%8C%EC%95%84%EB%B3%B4%EB%8A%94-B-Tree

LBA

• https://en.wikipedia.org/wiki/Logical_block_addressing