Notice
Recent Posts
Recent Comments
Link
| 일 | 월 | 화 | 수 | 목 | 금 | 토 |
|---|---|---|---|---|---|---|
| 1 | 2 | 3 | ||||
| 4 | 5 | 6 | 7 | 8 | 9 | 10 |
| 11 | 12 | 13 | 14 | 15 | 16 | 17 |
| 18 | 19 | 20 | 21 | 22 | 23 | 24 |
| 25 | 26 | 27 | 28 | 29 | 30 | 31 |
Tags
- Subquery
- structural hazard
- ISA
- dependence
- transactional memory
- nonblocking cache
- cache coherence
- branch prediction
- store conditional
- theta join
- pipelined cache
- register renaming
- way prediction
- speculative execution
- sequential consistency
- cache optimization
- sql
- moesi
- atomic exchange
- directory based coherence protocol
- relational model
- dynamic scheduling
- load linked
- multibanekd cache
- pipelined
- pipline hazards
- cache coherence miss
- mesi
- Cache
- 관계형 모델
Archives
- Today
- Total
목록outer join (1)
공대생의 공부흔적
[SQL#6] 서브쿼리(Subquery) (2) - join, natural join, outer join
참고: Database Systems: The Complete Book (2nd edition) - 6.3 Subqueries 이번 글에서는 서브쿼리 중 SQL의 join에 대해 알아볼 것이다. 두 개의 relation은 product, theta join, natural join, outerjoin으로 join될 수 있다. 예시를 바탕으로 하나씩 알아보자. Movies(title, year, length) StarsIn(movieTitle, movieYear, starName) Movies title year length StarsIn movieTitle movieYear starName t1 y1 l1 t1 y1 s1 t1 y2 l2 t2 y2 s2 Cross Join (product) 가장 간단한 ..
Database & Big Data/SQL
2024. 3. 16. 00:17