[์ปดํจํฐ๋คํธ์ํฌ] CH2. Application Layer (#1)
Network Application network application email, web, text messaging, remote login, P2P file sharing, multi-user network games, streaming stored video, voice over IP, real-time video conferencing, social networking, search etc... Creating a Network Application ์๋ก ๋ค๋ฅธ end systems ์์ ์๋ํ๊ณ network๋ฅผ ํตํด ํต์ ํ๋ ํ๋ก๊ทธ๋จ network-core devices ์์๋ ํ์ ์์. ๊ฑ๋ค๋ user application ์คํ ์ํจ. Client-server paradigm 1. Appli..
[๋ฐ์ดํฐ๋ฒ ์ด์ค] CH3. Introduction to SQL
Overview 1. History SQL Parts DML DDL Domain Types in SQL : ์คํค๋ง๋ฅผ ๊ตฌ์ฑํ๋ attribute ์ ๊ฐ๋ฅํ type๋ค!! char(n) : ๊ธธ์ด๊ฐ n์ผ๋ก ๊ณ ์ ๋ ๋ฌธ์์ด varchar(n) : ์ต๋ ๊ธธ์ด๊ฐ n์ธ ๊ฐ๋ณ์ ์ธ ๋ฌธ์์ด int : ์ ์ smallint : ์์ ์ ์ numeric(p,d) : ์ ์ฒด ์๋ฆฌ์๊ฐ p, ์์ซ์ ์๋ ์๋ฆฌ์๊ฐ d์ธ ์ค์ ex) numeric(3,1)์ด๋ฉด 44.5 (0) 3.12(X) 444.5(X) real, double, precision float(n) 1. Create Table Construct create table r (A1 D1, A2 D2, ... , An Dn, (integrity-constraint1), ... ..