profile
growth, achievement and success๐ŸŒฑ

SQL๋ฌธ

2021๋…„ 4์›” 22์ผ
ยท
0๊ฐœ์˜ ๋Œ“๊ธ€

mysql ์—๋Ÿฌ

Error executing DDL "alter table product_in_cart add constraint FKmbb9ii8dfmagbt971nh30ikcm foreign key (product_id) references product (id)"sql์„ ์ˆ˜ํ–‰ํ•˜

2021๋…„ 4์›” 7์ผ
ยท
0๊ฐœ์˜ ๋Œ“๊ธ€

MongoDB, Oracle

์‹ค๋ฌด์—์„œ๋Š” ์˜ค๋ผํด์ด๋‚˜ mysql๊ณผ ๊ฐ™์€ ๊ด€๊ณ„ํ˜• ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค๋ฅผ ๋งŽ์ด ์‚ฌ์šฉํ•œ๋‹ค.๊ทธ๋Ÿฌ๋‚˜, ์ตœ๊ทผ ๋ช‡ ๋…„ ์‚ฌ์ด์— ๋น„๊ด€๊ณ„ํ˜• ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค๋ฅผ ์ ์šฉํ•˜๋Š” ๊ณณ์ด ๋Š˜๊ณ  ์žˆ๋‹ค๊ณ  ํ•˜๋ฉฐ ์ด๋Ÿฌํ•œ ์‹œ์Šคํ…œ์„ NoSQL ๋˜๋Š” Not Only SQL ์ด๋ผ๊ณ  ํ•œ๋‹ค.๊ด€๊ณ„ํ˜• ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค๊ฐ€ ํŽธํ•œ๋ฐ ์™œ NoSQL

2021๋…„ 2์›” 25์ผ
ยท
0๊ฐœ์˜ ๋Œ“๊ธ€

DBMS

๊ณตํ†ต์  : ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ๊ด€๋ฆฌ ์‹œ์Šคํ…œ(DBMS)MongoDB์™€ Oracle์„ ๋‹จ์ˆœํžˆ ๋น„๊ตํ•˜๊ธฐ ์ „์—,RDBMS์™€ NoSQL์— ๋Œ€ํ•ด์„œ ์•Œ์•„์•ผํ•œ๋‹ค.RDBMS(Relational DataBase Management System): ๊ด€๊ณ„ํ˜• ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ๊ด€๋ฆฌ ์‹œ์Šคํ…œ๋Œ€ํ‘œ์ ์œผ๋กœ ์˜ค๋ผํด

2021๋…„ 2์›” 25์ผ
ยท
0๊ฐœ์˜ ๋Œ“๊ธ€