cs-studi / cs-study Goto Github PK
View Code? Open in Web Editor NEWπ λ©΄μ μ μν CS study
π λ©΄μ μ μν CS study
@annie1004619
μΈλ±μ€λ DBMSμ μ μ₯ μ±λ₯μ ν¬μνκ³ κ²μ μ±λ₯μ λμ΄κΈ° μν΄ λ§λ€μ΄μ§ μλ£ κ΅¬μ‘°μ΄λ€.
μΈλ±μ€μ λͺ©μ RDBMSμ κ²μ μλλ₯Ό λμ΄λλ° μλ€.
DELETE, INSERT, UPDATE 쿼리μλ ν΄λΉ μ¬νμ΄ μμΌλ©° index μ¬μ© μ μ€νλ € μ’ λλ €μ§λ€.
μ΄ λΆλΆμμ delete, insert, update 쿼리μλ indexλ₯Ό μ¬μ©νλ©΄ μ€νλ € λλ €μ§λ€λκ² μ μ΄ν΄κ° κ°μ§ μμ΅λλ€.
index μ¬μ© μ λ°μ΄ν°λ₯Ό delete, insert, updateνλ©΄ λλ €μ§λκ±°κ³ (λ°μ΄ν°λ₯Ό κ³μ μ λ ¬ν΄μ€μΌ νλκΉ + λ§μ½μ μΈλ±μ€ λ λ°μ΄ν°λ₯Ό μμ ν λλ μΈλ±μ€μλ νλκ·Έ νμ κ°μ κ±Έλ‘ μ¬μ©νμ§ μλ μΈλ±μ€μ λ³λ νμλ₯Ό νκΈ° λλ¬Έμ λ―Έμ¬μ© μΈλ±μ€κ° λμ λ μ, μ±λ₯ μμ λ¬Έμ κ° μμ μ μλ€ μ λ??)
νμ§λ§ index μμ²΄κ° κ²μ μ±λ₯μ λμ¬μ£ΌκΈ° μν΄ μ¬μ©λλ€κ³ νλ λ°μ΄ν°λ² μ΄μ€μμ λ°μ΄ν°λ₯Ό μμ (delete)λ₯Ό νλ κ²μ λ°μ΄ν°μ μμΉλ₯Ό μ‘°ν(κ²μ)νμ¬ μμ νκΈ° λλ¬Έμ deleteμ κ΄μ μμλ index μ¬μ© μ μ±λ₯μ΄ λΉ λ₯Έ νΈμ΄ μλκ°μ? ν·κ°λ¦¬λ€μ.
Array μΈμ λ€λ₯Έ μλ£ κ΅¬μ‘°λ‘λ ꡬνμ ν μ μλμ?
κ·Έλ¬λ©΄ μ Arrayλ‘ κ΅¬ννλ건κ°μ?
@guswns3371
db clusteringμμ μμ μ¬μ§(https://github.com/CS-studi/CS-study/blob/master/CS/Database/img/ClusteringReplicationShardingPartitioning/Untitled%201.png)μ νλμ λ°μ΄ν°λ² μ΄μ€λ₯Ό μ¬λ¬λ μλ²κ° 곡μ νλ κ²μ²λΌ λμμλλ° λ°μ΄ν°μ μ€λ³΅ μλ λ΄μ©οΏ½ μ€λͺ λΆλΆμ "μ¬λ¬λμ μλ²μ λ°μ΄ν°λ² μ΄μ€λ₯Ό μ€λ³΅μ μ₯νλ€" => μ΄λΆλΆμ replicationμ΄ μ μ©λ clusteringμ΄ μ΄λκ° ν΄μμ.
λ΅λ³μ£Όμλ©΄ κ°μ¬νκ² μ΅λλ€.
λ°μ΄ν°λ₯Ό μ‘°ν κ°λ₯ μμ μ΄ λ©λͺ¨λ¦¬μ μ¬λΌκ°κ³ λμμΈμ§, disk io μμ μ¬λΌκ°κ³ λμμΈμ§?
<details>
<summary>μ λͺ©</summary>
λ΄μ©
</details>
λͺ¨μ λ©΄μ μ§λ¬Έ μ€ λ΅λ³νμ§ λͺ»ν λ΄μ© νΉμ μ 맀νκ² λ΅λ³μ νλ λ΄μ©μ λ€μ μ 볡νλ€.π
[μ£Όμ ]
...
[μ§λ¬Έ]
...
보μ λ΄μ©
REST(Representational State Transfer)λ ν¨μ¨μ , μμ μ μ΄λ©° νμ₯κ°λ₯ν λΆμ°μμ€ν μ κ°μ Έμ¬ μ μλ μννΈμ¨μ΄ μν€ν μ² λμμΈ μ μ½μ λͺ¨μμ λ§νλλ° μ¬λ¬ λΈλ‘κ·Έμμ RESTμ λ¨μ μΌλ‘ 'point-to-point ν΅μ λͺ¨λΈμ κ°μ νλ―λ‘ λ μ΄μμΌλ‘ μνΈμμ©νλ λΆμ°νκ²½μλ μ μ©νμ§ μλ€.' λΌλ λ¬Έμ₯μ΄ λ§μ΄ μ νμλλ° μ΄λ€ λΆμ° νκ²½μ μ΄μΌκΈ° νλμ§ μ΄ν΄κ° μλ©λλ€.
A declarative, efficient, and flexible JavaScript library for building user interfaces.
π Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. πππ
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google β€οΈ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.