Microsoft Word - 0621-.doc1


1 Byte = 8 bits 1 Kilo Byte(KB)= 1024 Bytes 1 Mega Byte(MB)= 1024 Kilo Bytes 1 Giga Byte(GB)= 1024 Mega Bytes 1 Targa Byte(TB)= 1024 Giga Bytes


(11101)2=1*2^4+1*2^3+1*2^2+0*2^1+1*2^0=29
(127)8=1*8^2+2*8^1+7*8^0=700

• 2

GRANT GRANT GRANT {{ SELECT | INSERT | UPDATE | DELETE | RULE | REFERENCES | TRIGGER } [,...] | ALL [ PRIVILEGES ]
| privileges [(column [ ,columnn])] [,privileges…] }
TO user_name [,user_name ...] ON table_name
privileges Books table Grant select on Books to public with grant option Books table mike david Grant select, update on Books to mike, david
REVOKE REVOKE GRANT
REVOKE { ALL [ PRIVILEGES ] | privileges [(column [ ,columnn])] [,privileges…] } ON table_name FROM user_name [,user_name ...] ON table_name
privileges david Books Revoke select, update on book from david;
DML(Data Manipulation Language ,)
SQL SELECT <attribute list> FROM <table list> [WHERE <condition>]

3
[GROUP BY <grouping attribute(s)>] [HAVING <group condition>] [ORDER BY <attribute list>]
SELECT FROM ()
WHERE GROUP BY SELECT HAVING ORDER BY
DESC
ASC (*)
DISTINCT AS IS NULL NULL
LIKE %
_ ‘+’‘-’‘*’ '/'
ANY (result set)
OR ALL (result set) AND > >ALL
>ALL(1, 2, 3) 3>ANY
>ANY(1, 2, 3) 1 UNION
{ = | <> | != | > | >= | !> | < | <= | !< }
COUNTSUMMAXMIN AVG COUNT(*) COUNT(FNAME) NULL

• 4
ACID (atomicity)
() (consistency preservation)


X Tj (Ti→Tj)
(Mutual Exclusion)
(Hold and Wait)


(Circular Wait)
5
2PL (transaction timestampTS(T))
T1 T2 TS(T1)< TS(T2) wait-die
wound-wait (redo)(undo)

T1 T2 T3 undo T4 undo T5 undo
RAID RAID
RAID (Fault-Tolerance)
RAID 6
RAID1 (Mirroring)

• 6
RAID3 RAID2 RAID4 RAID3 (Block)
RAID5 (Parity Bit)
RAID6 RAID5

(reliability)
OSI TCP/IP
Application Layer
Presentation Layer
Session Layer
Application Layer TELNET, FTP, SMTP, POP3, SNMP, NNTP, DNS,NIS, NFS, HTTP, ...
Transport Layer Transport Layer TCP , UDP , SCTP...
Network Layer Internet Layer IP , ICMP, IGMP, ARP, RARP, ...
Data Link Layer
P hysical Layer
Network Access Layer IEEE802.x ,WIFI, WIMAX, FDDI, Ethernet, ISDN, X.25,...

7
BNC RG58 AUI AUI RJ45
(Data Link Layer) (Media Access Control, MAC) CSMA/CD "(Physical Address)" "MAC (Media Access
Control Address)", windows "C/> ipconfig /all" linux "#ifconfig"
(Network Layer) (Addressing) (Routing)
(Transport Layer) (Sequence Number) (Flow Control)Host to Host (Reliability & Efficiency)
TCP UDP
(Session Layer)

(Presentation Layer)
(Application Layer)

• 8

21 FTP 25 SMTP()80
HTTP 135 RPC()
TCP 20 File Transfer [Default Date] TCP 21 File Transfer [Control] TCP 22 SSH Remote Login Protocol TCP 23 Telnet TCP 25 Simple Mail Transfer Protocol UDP 53 Domain Name Server UDP 67 Bootstrap Protocol Server UDP 68 Bootstrap Protocol Client UDP 69 Trivial File Transfer TCP 80 World Wide Web HTTP TCP 110 Post Office Protocol - Version 3 TCP 123 Network Time Protocol TCP 137 NETBIOS Name Server TCP 138 NETBIOS Datagram Server TCP 139 NETBIOS Session Server TCP 143 Internet Message Access Protocol TCP 161 Simple Network Management Protocol TCP 443 http protocol over TLS/SSL TCP 993 imap4 protocol over TLS/SSL TCP 995 pop3 protocol over TLS/SSL(wasspop3) TCP 1863 Msn protocol TCP 3306 MySOL
NATVPN DHCP
IP NAT
VPN
VPN IPSec L2TP

9
IP IP
SSL
) SSL SSL
Server CA Client Client Browser CA Server
Client IE SSL ( ) Server Client ()(
) Server Server ( )
SSL Server CA Client
PKI SET
.COM.EXESYSBATOVL (multip-partitevirus)

• 10
if 1 if() statement; 2 if() { statement1; statement2; . . . statementn; } 3 if() statement; else statement; 4 if() { statement1; statement2; . statementn; } else { statement1; statement2; . statementn; } while
}
1
(Stacks) (Push)

(infix)A + B (postfix)A B + (prefix) + A B
(Queues)

1

(Si) N P
P (B)(Ga)(In) N (P)(As)(Sb)
(T) T in σ ρ↑⇒ ↑⇒ ↑⇒ ↓ T μ σ ρ↑⇒ ↓⇒ ↓⇒ ↑
2

• 2
2ln D A bi T
i
A D
ε⋅ ⋅ − + = ⋅
3
• 4
(Early Effect)IC VCE
(FET)
5

BJT
FET
FET


• 6
7



• 8



C > B > AB > A (C ) C > B > AB > A (A ) B
( )J D JC CS SA AT P Tθ θ θ= ⋅ + + +

9


(Bias Current)
3dB

=
≥ +
• 10
= ⋅ +

RAM ROM SRAM
DRAM ROM


Y A B= ⋅
Y A B= +
1


• 2







3



• 4

mpa =
P S
()
1+⋅= YXYb () mYC ±= mYYf 2b −=

5

2 P
= bCf YY2Y −= ()
≥ ( eθ°360 )
÷ 2 P
mCYC ≠CY
()

F()=( Z / 360°)*2α*(1/2)*(Ia / a)=N*I ( Z / 360° 2α) F()=(Z/2)*(Ia/a)- F()

• 6
Vb E
E
Ia
V
E
LfS III += fSL III −=
E
E=Knψ
E= K n (ψf-ψs) Ia

7
(2 n π
=
%100 n
nn%R.S f
() 0=⇒ n ⇒ 0Eb = ()
Ra VIas =

• 8

φφ IaRa/K-VE/kn == 95% V aR φ

0 (Ward-Leonand) MV⇒1EG ( M ) GR IGF = V/RG+RGf GG E=φ
MV⇒ Mn ↓ BM Imf↓ mφ ↓ mn &
21 MGMT ηηηη ××=
(Rh) () ↓ φkRnRaIaVn /)]([ +−=
a RnRaI +× ]
↓If = V / Bn + Bf φ n φKIaRaV /−=

9

E1.11Eav E Eav E 4.44NfΦm 4.44NfBmA

• 10


V == OCV W = Poc =
OC
2O01 aGG = ( ) GV R
OCPcos =θ =⋅ OCOC IV W V A

11
A == SCI W = SCP = = 1
2 SC ReI ⋅
1 2 a
1 2 a
LV lead PV 30° LI Lag PI 30°


• 12
= ⋅
1S 2S 1AV 2AV 1puZ
2puZ

13
1 2/V V a= 1 1 1 2 2S V I V Iφ = =

A H H X XS V I V I= ⋅ = ⋅ 1 2 2 2 2 2( ) ( )AS V V I aV V I= + ⋅ = + ⋅
2 2(1 )a V I= + ⋅ 1(1 )AS a S φ= + a =
P.T 110V (V )
( l)
( l)
• 14

120° 1φ
3/2 ( 3 2TF Fm= )
( SN )
120 / ( . . ) 2 / ( . . )SN f P r p m f p r p s= =

(IM) IM
()
Nr=(1-S)Ns fr=Sf E2r=SE2 I2=(S*E2)/(√R2+SX2) Cosθ=R/Z


S=1 T R2 T R2/S S
r2/S=(R+r2) S ′ ’ Sm=r2/(x1′+x2) r2mr2T
S=1 S=0
15
2 2 2' 3CP I R=
2 2 2 2 2 2 2 2cos 1/ 1/i CP E I s I R S P Wθ= ⋅ = ⋅ = ⋅
2i2 13'P CP S ⋅=

= − = −
= −

Y-Δ Δ-Δ 3HP IS 5-8
=(1/ 3 )
TY=(1/3)TΔ
IS=(1/n) IS=(1/n)2 TS=(1/n)2

• 16


Nr=Ns Nr≠Ns Ns ( E V )

N S
17
a. b. c.

Ep= φNf44.4 =2.22Zfφ Ep=Kw4.44fNφ Kw()=Kp×Kd Kp()= / =sin(x/2) Kd()= / =sin(180/2*) / qsin(180/2**q) q ()=/(*)

cos=0.8
cos=1
cos=0.8
I
V
COS=0.8
COS=1
COS=0.8
• 18

LP P P
= + = − = −

20 10 1 1 20 2 2P f f m p f m p⇒ = − = −
2 20NS f f⇒ ⇒ ()
10 1 1 20 2 2f f m P f m P= − = −
Ia Ia*R
Ia*X V
19

E aI cosθ θ Q

Xs φ δ⋅
= =
sinT α δ δsin o90=δ T δ o90 o90sinsin <δ

V