\uc2a4\ud504\ub9c1 \ubd80\ud2b8 \ubc31\uc5d4\ub4dc \uac1c\ubc1c \uac15\uc88c\uc5d0 \uc624\uc2e0 \uac83\uc744 \ud658\uc601\ud569\ub2c8\ub2e4. \ubcf8 \uac15\uc88c\uc758 \uc8fc\uc81c \uc911 \ud558\ub098\ub294 ‘\ub370\uc774\ud130\ubca0\uc774\uc2a4’\uc785\ub2c8\ub2e4. \uc6f9 \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc744 \uac1c\ubc1c\ud560 \ub54c \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub294 \ud544\uc218\uc801\uc778 \uc694\uc18c\uc774\uba70, \ubaa8\ub4e0 \ub370\uc774\ud130\ub294 \uc800\uc7a5\ud558\uace0 \uad00\ub9ac\ud574\uc57c \ud569\ub2c8\ub2e4. \uc774\ubc88 \ud3ec\uc2a4\ud305\uc5d0\uc11c\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uae30\ubcf8 \uac1c\ub150\ubd80\ud130 \uc2dc\uc791\ud558\uc5ec, \ub2e4\uc591\ud55c \uc720\ud615, \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc124\uacc4, \uc2a4\ud504\ub9c1 \ubd80\ud2b8\uc640\uc758 \ud1b5\ud569 \ubc29\ubc95, SQL \uc0ac\uc6a9\ubc95\uae4c\uc9c0 \uc790\uc138\ud788 \uc54c\uc544\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n
\ub370\uc774\ud130\ubca0\uc774\uc2a4\ub294 \uc815\ubcf4\ub97c \uad6c\uc870\uc801\uc73c\ub85c \uc800\uc7a5\ud558\uace0 \uad00\ub9ac\ud560 \uc218 \uc788\ub3c4\ub85d \ub3d5\ub294 \uc2dc\uc2a4\ud15c\uc785\ub2c8\ub2e4. \uc0ac\uc6a9\uc790\ub294 \ub370\uc774\ud130\ub97c \uc785\ub825, \uc218\uc815, \uc0ad\uc81c, \uc870\ud68c\ud558\ub294 \ub2e4\uc591\ud55c \uc791\uc5c5\uc744 \uc218\ud589\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub294 \uc77c\ubc18\uc801\uc73c\ub85c \ub370\uc774\ud130\uc758 \ud6a8\uc728\uc801\uc778 \uc800\uc7a5, \uac80\uc0c9, \uad00\ub9ac, \ubcf4\ud638\ub97c \uc704\ud574 \ud544\uc694\ud569\ub2c8\ub2e4. \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \ud1b5\ud574 \uc5ec\ub7ec \uc0ac\uc6a9\uc790\uac00 \ub3d9\uc2dc\uc5d0 \ub370\uc774\ud130\uc5d0 \uc811\uadfc\ud560 \uc218 \uc788\uc73c\uba70, \ub370\uc774\ud130\uc758 \ubb34\uacb0\uc131\uc744 \ubcf4\uc7a5\ud569\ub2c8\ub2e4.<\/p>\n
\ub370\uc774\ud130\ubca0\uc774\uc2a4\ub294 \ub9ce\uc740 \uc774\uc720\ub85c \ud544\uc694\ud569\ub2c8\ub2e4. \uc5ec\uae30\uc5d0\ub294 \ub2e4\uc74c\uacfc \uac19\uc740 \uc694\uc18c\uac00 \ud3ec\ud568\ub429\ub2c8\ub2e4:<\/p>\n
\ub370\uc774\ud130\ubca0\uc774\uc2a4\ub294 \uc8fc\ub85c \ub2e4\uc74c\uacfc \uac19\uc774 \ubd84\ub958\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4:<\/p>\n
\uad00\uacc4\ud615 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub294 \ub370\uc774\ud130\ub97c \ud45c \ud615\uc2dd\uc73c\ub85c \uc800\uc7a5\ud569\ub2c8\ub2e4. \uac01 \ud45c\ub294 \ud589\uacfc \uc5f4\ub85c \uad6c\uc131\ub418\uc5b4 \uc788\uc73c\uba70, \uc774\ub4e4 \uac04\uc758 \uad00\uacc4\ub294 \uc678\ub798 \ud0a4\ub97c \ud1b5\ud574 \uc815\uc758\ub429\ub2c8\ub2e4. \ub300\ud45c\uc801\uc778 \uad00\uacc4\ud615 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uad00\ub9ac \uc2dc\uc2a4\ud15c(RDBMS)\uc5d0\ub294 MySQL, PostgreSQL, Oracle \ub4f1\uc774 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
\ube44\uad00\uacc4\ud615 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub294 \ube44\uc815\ud615 \ub370\uc774\ud130\ub97c \uc800\uc7a5 \ubc0f \uad00\ub9ac\ud558\ub294 \ub370 \uc801\ud569\ud569\ub2c8\ub2e4. \uc774\ub294 JSON, XML, \ubb38\uc11c \ubc0f \ud0a4-\uac12 \ud615\ud0dc\ub85c \ub370\uc774\ud130\ub97c \uc800\uc7a5\ud560 \uc218 \uc788\uc73c\uba70, \uc720\uc5f0\ud55c \uc2a4\ud0a4\ub9c8\ub97c \uac16\uace0 \uc788\uc2b5\ub2c8\ub2e4. \ub300\ud45c\uc801\uc778 \ube44\uad00\uacc4\ud615 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0\ub294 MongoDB, Cassandra, Redis \ub4f1\uc774 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
\uadf8\ub798\ud504 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub294 \ub370\uc774\ud130 \uac04\uc758 \uad00\uacc4\ub97c \ubaa8\ub378\ub9c1\ud558\ub294 \ub370 \ucd5c\uc801\ud654\ub418\uc5b4 \uc788\uc2b5\ub2c8\ub2e4. \ub178\ub4dc\uc640 \uc5e3\uc9c0\ub97c \uc0ac\uc6a9\ud558\uc5ec \ub370\uc774\ud130\ub97c \uc800\uc7a5\ud558\uba70, \ubcf5\uc7a1\ud55c \uad00\uacc4\ub97c \uc2dc\uac01\uc801\uc73c\ub85c \ud45c\ud604\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. Neo4j\uac00 \uadf8\ub798\ud504 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \ub300\ud45c\uc801\uc778 \uc608\uc785\ub2c8\ub2e4.<\/p>\n
\ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc124\uacc4\ub294 \ud6a8\uc728\uc801\uc778 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uad6c\ucd95\uc744 \uc704\ud574 \ud544\uc218\uc801\uc785\ub2c8\ub2e4. \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc124\uacc4 \ub2e8\uacc4\uc5d0\ub294 \uc694\uad6c\uc0ac\ud56d \ubd84\uc11d, \uac1c\ub150\uc801 \uc124\uacc4, \ub17c\ub9ac\uc801 \uc124\uacc4, \ubb3c\ub9ac\uc801 \uc124\uacc4\uac00 \ud3ec\ud568\ub429\ub2c8\ub2e4.<\/p>\n
\ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc124\uacc4\uc758 \uccab \ub2e8\uacc4\ub294 \uc694\uad6c\uc0ac\ud56d \ubd84\uc11d\uc785\ub2c8\ub2e4. \uc5ec\uae30\uc5d0\uc11c\ub294 \uc0ac\uc6a9\uc790\uac00 \ud544\uc694\ub85c \ud558\ub294 \uc815\ubcf4\uc640 \ube44\uc988\ub2c8\uc2a4 \uc694\uad6c\uc0ac\ud56d\uc744 \ud30c\uc545\ud569\ub2c8\ub2e4.<\/p>\n
\uac1c\ub150\uc801 \uc124\uacc4 \ub2e8\uacc4\uc5d0\uc11c\ub294 ER \ub2e4\uc774\uc5b4\uadf8\ub7a8\uc744 \ud1b5\ud574 \ub370\uc774\ud130\uc758 \uac1c\ub150\uc801 \uad6c\uc870\ub97c \uc815\uc758\ud569\ub2c8\ub2e4. \uc5ec\uae30\uc11c ‘\uac1c\uccb4’, ‘\uc18d\uc131’, ‘\uad00\uacc4’\ub97c \uc2dd\ubcc4\ud569\ub2c8\ub2e4.<\/p>\n
\ub17c\ub9ac\uc801 \uc124\uacc4 \ub2e8\uacc4\uc5d0\uc11c\ub294 \uac1c\ub150\uc801 \uc124\uacc4\ub97c \ubc14\ud0d5\uc73c\ub85c \ub370\uc774\ud130 \ubaa8\ub378(\uc77c\ubc18\uc801\uc73c\ub85c \uad00\uacc4\ud615 \ubaa8\ub378)\ub85c \ubcc0\ud658\ud569\ub2c8\ub2e4. \uc774\ub54c \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uc2a4\ud0a4\ub9c8\ub97c \uacb0\uc815\ud558\uac8c \ub429\ub2c8\ub2e4.<\/p>\n
\ub9c8\uc9c0\ub9c9\uc73c\ub85c \ubb3c\ub9ac\uc801 \uc124\uacc4 \ub2e8\uacc4\uc5d0\uc11c\ub294 \ub17c\ub9ac\uc801 \uc124\uacc4\ub97c \uc2e4\uc81c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc2dc\uc2a4\ud15c\uc5d0 \ub9de\uac8c \uad6c\uccb4\ud654\ud569\ub2c8\ub2e4. \uc774 \uacfc\uc815\uc5d0\uc11c\ub294 \uc778\ub371\uc2a4, \ud30c\ud2f0\uc154\ub2dd \ub4f1 \uc131\ub2a5 \ub4f1\uc744 \uace0\ub824\ud55c \ucd5c\uc801\ud654\uac00 \uc774\ub8e8\uc5b4\uc9d1\ub2c8\ub2e4.<\/p>\n
\uc2a4\ud504\ub9c1 \ubd80\ud2b8\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc640\uc758 \ud1b5\ud569\uc744 \uc27d\uac8c \ud574\uc8fc\ub294 \ub2e4\uc591\ud55c \uae30\ub2a5\uc744 \uc81c\uacf5\ud569\ub2c8\ub2e4. \uc2a4\ud504\ub9c1 \ubd80\ud2b8\ub97c \uc774\uc6a9\ud558\uc5ec \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc5f0\uacb0\ud558\ub294 \uacfc\uc815\uc5d0\ub294 \uc758\uc874\uc131 \uad00\ub9ac, \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc124\uc815, \uc5d4\ud2f0\ud2f0 \ud074\ub798\uc2a4 \uc815\uc758, Repository \uc778\ud130\ud398\uc774\uc2a4 \uc0dd\uc131 \ub4f1\uc774 \ud3ec\ud568\ub429\ub2c8\ub2e4.<\/p>\n
\uc2a4\ud504\ub9c1 \ubd80\ud2b8\uc5d0\uc11c \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc640 \ud1b5\uc2e0\ud558\uae30 \uc704\ud574\uc11c\ub294 \uc801\uc808\ud55c \uc758\uc874\uc131\uc744 \ucd94\uac00\ud574\uc57c \ud569\ub2c8\ub2e4. Maven\uc744 \uc0ac\uc6a9\ud558\ub294 \uacbd\uc6b0 `pom.xml` \ud30c\uc77c\uc5d0 \ub2e4\uc74c\uacfc \uac19\uc740 \uc758\uc874\uc131\uc744 \ucd94\uac00\ud574\uc57c \ud569\ub2c8\ub2e4:<\/p>\n
\n\n\n org.springframework.boot<\/groupid>\n spring-boot-starter-data-jpa<\/artifactid>\n<\/dependency>\n\n com.h2database<\/groupid>\n h2<\/artifactid>\n runtime<\/scope>\n<\/dependency>\n<\/code>\n<\/pre>\n4.2 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc124\uc815<\/h3>\n
\uc2a4\ud504\ub9c1 \ubd80\ud2b8\uc5d0\uc11c \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc124\uc815\ud558\uae30 \uc704\ud574\uc11c\ub294 `application.properties` \ud30c\uc77c\uc744 \uc218\uc815\ud574\uc57c \ud569\ub2c8\ub2e4. \ub2e4\uc74c\uc740 H2 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc124\uc815 \uc608\uc2dc\uc785\ub2c8\ub2e4:<\/p>\n
\n\nspring.datasource.url=jdbc:h2:mem:testdb\nspring.datasource.driver-class-name=org.h2.Driver\nspring.datasource.username=sa\nspring.datasource.password=\nspring.h2.console.enabled=true\nspring.jpa.hibernate.ddl-auto=update\n<\/code>\n<\/pre>\n4.3 \uc5d4\ud2f0\ud2f0 \ud074\ub798\uc2a4 \uc815\uc758<\/h3>\n
\uc2a4\ud504\ub9c1 \ubd80\ud2b8\uc5d0\uc11c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ud14c\uc774\ube14\uacfc \ub9e4\ud551\ub418\ub294 \uc5d4\ud2f0\ud2f0 \ud074\ub798\uc2a4\ub97c \uc815\uc758\ud574\uc57c \ud569\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, \uc0ac\uc6a9\uc790 \uc815\ubcf4\ub97c \uc800\uc7a5\ud558\ub294 `User` \uc5d4\ud2f0\ud2f0\ub294 \ub2e4\uc74c\uacfc \uac19\uc774 \uc815\uc758\ub420 \uc218 \uc788\uc2b5\ub2c8\ub2e4:<\/p>\n
\n\nimport javax.persistence.Entity;\nimport javax.persistence.GeneratedValue;\nimport javax.persistence.GenerationType;\nimport javax.persistence.Id;\n\n@Entity\npublic class User {\n\n @Id\n @GeneratedValue(strategy = GenerationType.AUTO)\n private Long id;\n private String name;\n private String email;\n\n \/\/ getters and setters\n}\n<\/code>\n<\/pre>\n4.4 Repository \uc778\ud130\ud398\uc774\uc2a4 \uc0dd\uc131<\/h3>\n
Repository \uc778\ud130\ud398\uc774\uc2a4\ub97c \ud1b5\ud574 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc640 \uc0c1\ud638\uc791\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. `UserRepository`\ub294 \ub2e4\uc74c\uacfc \uac19\uc774 \uc815\uc758\ub429\ub2c8\ub2e4:<\/p>\n
\n\nimport org.springframework.data.jpa.repository.JpaRepository;\n\npublic interface UserRepository extends JpaRepository {\n}\n<\/user,><\/code>\n<\/pre>\n5. SQL \uc0ac\uc6a9\ubc95<\/h2>\n
SQL(Structured Query Language)\uc740 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc640 \uc0c1\ud638\uc791\uc6a9\ud558\uae30 \uc704\ud574 \uc0ac\uc6a9\ub418\ub294 \ud45c\uc900 \uc5b8\uc5b4\uc785\ub2c8\ub2e4. SQL\uc744 \ud1b5\ud574 \ub370\uc774\ud130\ub97c \uc870\ud68c\ud558\uace0, \uc0bd\uc785\ud558\uba70, \uc218\uc815\ud558\uace0, \uc0ad\uc81c\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uae30\ubcf8\uc801\uc778 SQL \ubb38\ubc95\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4:<\/p>\n
5.1 \ub370\uc774\ud130 \uc870\ud68c: SELECT<\/h3>\n\n\nSELECT * FROM users; \n<\/code>\n<\/pre>\n5.2 \ub370\uc774\ud130 \uc0bd\uc785: INSERT<\/h3>\n\n\nINSERT INTO users (name, email) VALUES ('John Doe', 'john.doe@example.com'); \n<\/code>\n<\/pre>\n5.3 \ub370\uc774\ud130 \uc218\uc815: UPDATE<\/h3>\n\n\nUPDATE users SET email = 'john.new@example.com' WHERE id = 1; \n<\/code>\n<\/pre>\n5.4 \ub370\uc774\ud130 \uc0ad\uc81c: DELETE<\/h3>\n\n\nDELETE FROM users WHERE id = 1; \n<\/code>\n<\/pre>\n\uacb0\ub860<\/h2>\n
\uc774\ubc88 \ud3ec\uc2a4\ud305\uc5d0\uc11c\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uae30\ubcf8 \uac1c\ub150\uacfc \uc885\ub958, \uc124\uacc4 \ubc29\ubc95 \ubc0f \uc2a4\ud504\ub9c1 \ubd80\ud2b8\uc640\uc758 \ud1b5\ud569 \ubc29\ubc95\uc5d0 \ub300\ud574 \uc54c\uc544\ubcf4\uc558\uc2b5\ub2c8\ub2e4. \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub294 \ubc31\uc5d4\ub4dc \uac1c\ubc1c\uc5d0\uc11c \uc911\uc694\ud55c \uc5ed\ud560\uc744 \ud558\ubbc0\ub85c, \uae30\ubcf8\uc801\uc778 \uc774\ud574\uc640 \uc2e4\uc81c \uc0ac\uc6a9 \ubc29\ubc95\uc744 \uc775\ud600\ub450\ub294 \uac83\uc774 \uc911\uc694\ud569\ub2c8\ub2e4. \uc55e\uc73c\ub85c\uc758 \uc9c4\ud589 \uac15\uc88c\uc5d0\uc11c\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc640 \uad00\ub828\ub41c \ub354 \ub2e4\uc591\ud55c \uc8fc\uc81c\ub97c \ub2e4\ub8f0 \uc608\uc815\uc774\ubbc0\ub85c \ub9ce\uc740 \uae30\ub300 \ubd80\ud0c1\ub4dc\ub9bd\ub2c8\ub2e4.<\/p>\n
<\/body><\/p>\n","protected":false},"excerpt":{"rendered":"