Search

Database

๐Ÿ”
Navigation

Requirements

๐Ÿ“Œ
To follow this course, it is required to know following โ€ฆ
โ€ข
No Requirements

Database

Database
Transactions (ACID vs BASE)
Index
7 Vโ€™s of Big Data
SQL Constraints
Data Mining

SQL Database

SQL Databases
Keys

NoSQL Database

NoSQL Databases

Upcoming

Relationships
Normalization
Join
View
Scaling
Sharding
Logs
CAP

QnA

Whatโ€™s the difference between Index and Cache?
Do we use normalization in NoSQL?
Whatโ€™s the differnece between sharding and partitioning?
Whatโ€™s the difference between TRUNCATE and DELETE?
Does NoSQL provide ACID?

Reference

Floppy Disk free icons designed by Freepik
Free vector icon. Download thousands of free icons of computer in SVG, PSD, PNG, EPS format or as ICON FONT #flaticon #icon #save #saving #floppydisk
https://www.flaticon.com/free-icon/floppy-disk_3067443?term=save&page=1&position=11&origin=search&related_id=3067443
SQL | DDL, DQL, DML, DCL and TCL Commands - GeeksforGeeks
A Computer Science portal for geeks. It contains well written, well thought and well explained computer science and programming articles, quizzes and practice/competitive programming/company interview Questions.
https://www.geeksforgeeks.org/sql-ddl-dql-dml-dcl-tcl-commands/
TRUNCATE TABLE vs. DELETE vs. DROP TABLE: Removing Tables and Data in SQL
Whatโ€™s the difference between DROP TABLE, TRUNCATE TABLE, and DELETE in SQL? Weโ€™ll look at the syntax of each operation and discuss their usage, details, and differences.
https://learnsql.com/blog/difference-between-truncate-delete-and-drop-table-in-sql/#:~:text=TRUNCATE
Database - ์ƒค๋”ฉ์ด๋ž€ ๋ฌด์—‡์ธ๊ฐ€?! (+ ์ƒค๋”ฉ์˜ ๋‹ค์–‘ํ•œ ๊ธฐ๋ฒ•, ๊ฐ ๊ธฐ๋ฒ• ๋น„๊ต)
์„œ๋น„์Šค ์˜คํ”ˆ์ „์— J๊ณก์„  ๊ทธ๋ž˜ํ”„๋ฅผ ํƒ€๋ฉด์„œ ์„ฑ์žฅํ•˜๊ธธ ๋ฐ”๋ผ๋Š” ๋งˆ์Œ์€ ๋ชจ๋‘ ๊ฐ™์„ ๊ฒƒ์ด๋‹ค. ๊ทธ๋Ÿฐ ์ค‘์š”ํ•œ ์ˆœ๊ฐ„์— ์„œ๋ฒ„๊ฐ€ ๋ฐ”ํ‹€๋„ฅ์ด ๋˜์–ด ๋ฐœ๋ชฉ์„ ์žก์œผ๋ฉด ์•ˆ๋œ๋‹ค. ๊ทธ๋ž˜์„œ ์˜ˆ์ธก ๊ฐ€๋Šฅํ•œ ์„œ๋ฒ„ ํ™•์žฅ ๋ฐฉ์•ˆ์— ๋Œ€ํ•ด์„œ ์‚ฌ์ „์— ์ค€๋น„๋ฅผ ํ•ด๋‘ฌ์•ผ ํ•œ๋‹ค. DB ์ƒค๋”ฉ์€ ๋ฐ์ดํ„ฐ๊ฐ€ ๊ธ‰๊ฒฉํžˆ ์ฆ๊ฐ€ํ•˜๊ฒŒ ๋˜๊ฑฐ๋‚˜ ํŠธ๋ž˜ํ”ฝ์ด ํŠน์ • DB๋กœ ๋ชฐ๋ฆฌ๋Š” ์ƒํ™ฉ์„ ๋Œ€๋น„ํ•ด์„œ ๋น ๋ฅด๊ณ  ์œ ์—ฐํ•˜๊ณ  ์•ˆ์ „ํ•˜๊ฒŒ DB๋ฅผ ์ฆ์„คํ•  ์ˆ˜ ์žˆ๊ฒŒ ํ•œ๋‹ค. ์ƒค๋”ฉ์— ๋Œ€ํ•ด ์•Œ์•„๋ณด์ž. ์ƒค๋”ฉ ์ƒค๋”ฉ(Sharding)์€ DB ํŠธ๋ž˜ํ”ฝ์„ ๋ถ„์‚ฐํ•  ์ˆ˜ ์žˆ๋Š” ์ค‘์š”ํ•œ ์ˆ˜๋‹จ์ด๋‹ค. ์ถ”๊ฐ€์ ์œผ๋กœ ํŠน์ • DB์˜ ์žฅ์• ๊ฐ€ ์ „๋ฉด ์žฅ์• ๋กœ ์ด์–ด์ง€์ง€ ์•Š๊ฒŒ ํ•˜๋Š” ์—ญํ• ๋„ ํ•œ๋‹ค. ์ƒค๋”ฉ์€ ๊ฐ DB ์„œ๋ฒ„์—์„œ ๋ฐ์ดํ„ฐ๋ฅผ ๋ถ„ํ• ํ•˜์—ฌ ์ €์žฅํ•˜๋Š” ๋ฐฉ์‹์ด๋‹ค. ํ•ด๋‹น ๋ฐ์ดํ„ฐ์— ์ ‘๊ทผํ•  ๋•Œ๋Š” ์ƒค๋”ฉํ‚ค๋ฅผ ์‚ฌ์šฉํ•˜์—ฌ ๋™์ ์œผ๋กœ DB ์„œ๋ฒ„๋ฅผ ๋งคํ•‘ํ•˜๋Š” ๊ณผ์ •์ด ํ•„์š”ํ•˜๋‹ค. ์ƒค๋”ฉ๊ณผ ์ˆ˜ํ‰์ ..
https://jaehoney.tistory.com/245
Significance of ACID vs BASE vs CAP Philosophy in Data Science
There are 3 popular types of properties or theorems are associated with various database systems that are characterised by differentโ€ฆ
https://medium.com/analytics-vidhya/significance-of-acid-vs-base-vs-cap-philosophy-in-data-science-2cd1f78200ce
๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค Archives > ๋„๋ฆฌ์˜ ๋””์ง€ํ„ธ๋ผ์ดํ”„
http://blog.skby.net/category/์ปดํ“จํ„ฐ์‹œ์Šคํ…œ/๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค/
Made with Oopy