728x90

๐Ÿ“š Computer Science/CS 4

[์ปดํ“จํ„ฐ ๋ฐ‘๋ฐ”๋‹ฅ์˜ ๋น„๋ฐ€] 3์žฅ. ๋ฉ”๋ชจ๋ฆฌ Memory

3.1 ๋ฉ”๋ชจ๋ฆฌ์˜ ๋ณธ์งˆ, ํฌ์ธํ„ฐ์™€ ์ฐธ์กฐ 1bit = 0, 1 ๋”ฑ 2๊ฐ€์ง€ ์ •๋ณด๋งŒ ํ‘œํ˜„ํ•  ์ˆ˜ ์žˆ๋Š” ๋‹จ์œ„.1byte = 8bit = 2^8 = 256๊ฐ€์ง€ = 0 ~ 255 ์ˆซ์ž ํ‘œํ˜„.4byte = 2^32 = 4,294,967,297๊ฐœ12byte = intํ˜• ๋ณ€์ˆ˜ 3๊ฐœ ํ‘œํ˜„. ๊ตฌ์กฐ์ฒด. ๊ฐ์ฒด. ๋ชจ๋“  ๋ฐ”์ดํŠธ๋Š” ๋ฉ”๋ชจ๋ฆฌ ์ฃผ์†Œ๋ฅผ ๊ฐ€์ง€๊ณ  ์žˆ๋‹ค. memory address. addressing.4byte ์ •๋„๋Š” ๋˜์–ด์•ผ ์ˆซ์ž๋ฅผ ํ‘œํ˜„ํ•˜๊ธฐ์— ์ถฉ๋ถ„ํ•˜๊ธฐ์— int ํ˜• ๋ณ€์ˆ˜์˜ ํฌ๊ธฐ๊ฐ€ 4byte๋กœ ๊ณ ์ฐฉํ™” ๋˜์—ˆ๋‹ค.(int ํ˜• ๋ณ€์ˆ˜์˜ ํฌ๊ธฐ๋Š” 32bit, 64bit ์‹œ์Šคํ…œ์— ๋”ฐ๋ผ ๋‹ค๋ฅด๋‹ค.) - 8byte ํฌ๊ธฐ์˜ ๋ฉ”๋ชจ๋ฆฌ.- 0~7์ด ๋ฉ”๋ชจ๋ฆฌ ์ฃผ์†Œ.- 1+2 ์—ฐ์‚ฐ์„ ํ•˜๊ณ  ์‹ถ์„ ๋•Œ ์ˆซ์ž 1,2๋ฅผ ๋ฉ”๋ชจ๋ฆฌ์— ํ• ๋‹นํ•ด์•ผ ํ•œ๋‹ค.- ๋ฉ”๋ชจ๋ฆฌ ์ฃผ์†Œ์™€ ๊ฐ’์˜ ํ‘œํ˜„์ด ..

[SQLD ์ž๊ฒฉ์ฆ] ์ž๊ฒฉ ์˜๊ตฌ๊ฐฑ์‹  ๋ฐ ๋ณด์ˆ˜๊ต์œก ์ˆ˜๋ฃŒ ๋ฐฉ๋ฒ•

SQLD ์ž๊ฒฉ์ฆ์€ 1๋…„ 6๊ฐœ์›” ์ดํ›„๋ถ€ํ„ฐ 2๋…„ ์ด๋‚ด์— ๋ณด์ˆ˜๊ต์œก์„ ์ถ”๊ฐ€๋กœ ๋ฐ›์•„์•ผ ์œ ํšจ๊ธฐ๊ฐ„ 2๋…„ -> ์˜๊ตฌ๋กœ ์ž๊ฒฉ์„ ์œ ์ง€ํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค. ์ €๋„ 2๋…„์ด ๋‹ค๋˜์–ด๊ฐ€์„œ ๋ณด์ˆ˜๊ต์œก ๋ฐ›๊ณ  ์˜๊ตฌ ๊ฐฑ์‹ ํ–ˆ์–ด์š”. ์ž๊ฒฉ ์˜๊ตฌ๊ฐฑ์‹  ๋ฐ ๋ณด์ˆ˜๊ต์œก ์ˆ˜๋ฃŒ๋ฐฉ๋ฒ•์€ ์•„๋ž˜์™€ ๊ฐ™์Šต๋‹ˆ๋‹ค. 1. ๋ฐ์ดํ„ฐ์ž๊ฒฉ์‹œํ—˜ ์‚ฌ์ดํŠธ ๋กœ๊ทธ์ธ https://www.dataq.or.kr/ https://www.dataq.or.kr/ www.dataq.or.kr 2. ๋งˆ์ดํŽ˜์ด์ง€ > ๋ณด์ˆ˜๊ต์œก์—์„œ ํ•ด๋‹น ์ž๊ฒฉ์ฆ ๋ณด์ˆ˜๊ต์œก ์ง„ํ–‰ 3. 4์‹œ๊ฐ„์งœ๋ฆฌ ๊ฐ•์˜ ๋“ฃ๊ธฐ ์ค‘๊ฐ„์— ๋ณด๊ณ ์žˆ๋Š”์ง€ ํ™•์ธํ•˜๋Š”๊ฑฐ ์—†๊ณ  ๋„˜๊ธฐ๋Š”๊ฑฐ ์—†์–ด์„œ ๊ฑ ๋ผ๋””์˜ค์ฒ˜๋Ÿผ ํ‹€์–ด๋†“์œผ๋ฉด๋จ ํ—ฟ. 4. ๊ฐฑ์‹ ์™„~

[Diagram] ๋‹ค์ด์–ด๊ทธ๋žจ ๊ทธ๋ฆฌ๋Š” ๋ฌด๋ฃŒ ์‚ฌ์ดํŠธ ๊ณต์œ /์ถ”์ฒœ

https://app.diagrams.net/ Flowchart Maker & Online Diagram Software Flowchart Maker and Online Diagram Software diagrams.net (formerly draw.io) is free online diagram software. You can use it as a flowchart maker, network diagram software, to create UML online, as an ER diagram tool, to design database schema, to build BPM app.diagrams.net Usecase Diagram Flow Chart Class Diagram Sequence Diagra..

[Database] SQL ๋ฌธ ์ •๋ฆฌ(์ฝ”๋”ฉ ํ…Œ์ŠคํŠธ ๋Œ€๋น„)

1. SELECT(๊ฒ€์ƒ‰) 1) ํ…Œ์ด๋ธ”์˜ ํŠน์ • ์นผ๋Ÿผ์„ ๋ถˆ๋Ÿฌ์˜ฌ ๋•Œ SELECT ์นผ๋Ÿผ๋ช… FROM ํ…Œ์ด๋ธ”๋ช…; ์—ฌ๋Ÿฌ ๊ฐœ์˜ ์นผ๋Ÿผ์„ ๋ถˆ๋Ÿฌ์˜ฌ ๋•Œ๋Š” ์ฝค๋งˆ(,)๋ฅผ ์‚ฌ์šฉํ•œ๋‹ค. SELECT ์นผ๋Ÿผ๋ช…1, ์นผ๋Ÿผ๋ช…2, ์นผ๋Ÿผ๋ช…3 FROM ํ…Œ์ด๋ธ”๋ช…; ๋ชจ๋“  ์นผ๋Ÿผ์€ * ๊ธฐํ˜ธ ์‚ฌ์šฉ SELECT * FROM ํ…Œ์ด๋ธ”๋ช…; AS ๊ตฌ๋ฌธ์„ ์‚ฌ์šฉํ•˜์—ฌ ๋ณ„๋ช…(์ƒˆ๋กœ์šด ์ด๋ฆ„)์„ ๋ถ™์ผ ์ˆ˜ ์žˆ๋‹ค. SELECT ์นผ๋Ÿผ1 AS ๋ณ„๋ช…1 FROM ํ…Œ์ด๋ธ”๋ช…; ์ค‘๋ณต์„ ์ œ์™ธํ•˜๊ณ  ๊ฐ€์ ธ์˜ค๊ณ  ์‹ถ์„ ๋•Œ๋Š” DISTINCT ์—ฐ์‚ฐ์ž๋ฅผ ์“ด๋‹ค. ๋ฐ์ดํ„ฐ๋Š” ์˜ค๋ฆ„์ฐจ์ˆœ์œผ๋กœ ์ •๋ ฌ๋œ๋‹ค. SELECT DISTINCT ์นผ๋Ÿผ๋ช… FROM ํ…Œ์ด๋ธ”๋ช…; 2) ํŠน์ • ์กฐ๊ฑด์„ ๋งŒ์กฑํ•˜๋Š” ์นผ๋Ÿผ์„ ๋ถˆ๋Ÿฌ์˜ฌ ๋•Œ SELECT ์นผ๋Ÿผ๋ช… FROM ํ…Œ์ด๋ธ”๋ช… WHERE ์นผ๋Ÿผ๋ช… = ๊ฐ’; /*์กฐ๊ฑด๋น„๊ต๋Š” =, !=, , =, IS NULL ๋“ฑ์ด ..

728x90