JPA
β JPA Java Persistence API π‘ Java JPA https://soheeparklee.github.io/posts/Spring_jpa/#-jpa ORM of JAVA Map Object and DB developer does not have to write SQL ππ» code reusa...
β JPA Java Persistence API π‘ Java JPA https://soheeparklee.github.io/posts/Spring_jpa/#-jpa ORM of JAVA Map Object and DB developer does not have to write SQL ππ» code reusa...
β Database Optmizier part of DB management system decide how to optimize DB query affect overal system performance
β MySQL ππ» open-source ππ» supported β¬οΈ ππ» easy to install ππ» community ππ» big data ππ» limited advanced functions β Oracle ππ» support advanced functions ππ» adequate for managin...
βοΈ common ground: methods for enhancing DB availability, reliability β DB Clustering distributed database system across parallel nodes by grouping interconnected servers to work as a sing...
β Table Full Scan read all blocks in table to find data used for database optimization, optimizing query ππ» can affect database performance if the table is big, query is complex β Index R...
β Schema define database structure and constraints logical representation of data shows how data in DB should be stored logically attribute: characteristic of entity entity: collectio...
β NoSQL unrelational DB not only SQL can use query language depending on API/DB/query ππ» scalability ππ» availability ππ» data is saved according to how application is used π...
β ORM Object Relational Mapping Map object and relational DB automatically save burden to code SQL Object oriented programming: use class Relational DB: use table thus, there ...
β Partitioning divide big table into small several tables ππ» improve query performace data is physically divided into seperate tables but user can access the data as if it is on ...
β λͺ¨μλ©΄μ μ€ν°λλ₯Ό μ μ²νκ³ μμνκ² λ κ³κΈ° λ€νΈμν¬ μ§μ ν₯μ λ©΄μ νλ κ°μ νμ΅μ λν κ°μ μ±, λΆλ΄ λΆμ¬ β μ€ν°λλ₯Ό λ§λ¬΄λ¦¬νλ©° μ±μ₯ν μ , λλμ κ°μ΄ 곡λΆνλ©΄ μ΄λμ λ λΆλ΄μ΄ μμ§λ§, λ κ·Έλ§νΌ μ΄μ¬ν νκ² λλ€. λλ ν¨κ» 곡λΆνλ μ΅κ΄μ΄ μ΄λμ λ κ°μ μ±λ λΆμ¬ν΄μ£Όκ³ , μ λ§λ κ² κ°λ€. β Feedba...