λ³Έλ¬Έ λ°”λ‘œκ°€κΈ°
Computer Science/Database

1 Data, Database, DBMS

by Dowon Kang 2023. 12. 22.

Data

λ°μ΄ν„°λŠ” μ–΄λ– ν•œ 값을 ν¬ν•¨ν•˜κ³  μžˆλŠ” κ°€κ³΅λ˜μ§€ μ•Šμ€ 1μ°¨ 자료둜 μ •λ³΄μ˜ ν˜•νƒœλ‘œ ν‘œν˜„λ  수 μžˆλŠ” λͺ¨λ“  것을 λ‚˜νƒ€λƒ…λ‹ˆλ‹€. λ°μ΄ν„°λŠ” 뢄석, 해석, μ €μž₯, 전솑 λ“± λ‹€μ–‘ν•œ λͺ©μ μ„ μœ„ν•΄ κ°€κ³΅λ˜μ–΄ 정보(Information)둜 λ³€ν™˜λ˜λŠ” 과정을 κ±°μΉ©λ‹ˆλ‹€. 컴퓨터 μ„Έκ³„μ—μ„œ λ°μ΄ν„°λŠ” μ΄μ§„μˆ˜λ‘œ ν‘œν˜„λ˜μ–΄ μ €μž₯λ©λ‹ˆλ‹€. 

 

즉, λ°μ΄ν„°λŠ” μ •λ³΄μ˜ μ›μ²œμ΄λ©°, 이λ₯Ό 효과적으둜 μˆ˜μ§‘, μ €μž₯, μ²˜λ¦¬ν•˜κ³  λΆ„μ„ν•¨μœΌλ‘œμ¨ κ°€μΉ˜ μžˆλŠ” 톡찰λ ₯을 얻을 수 μžˆμŠ΅λ‹ˆλ‹€. 또 ν•œ, λ°μ΄ν„°λŠ” ν˜„λŒ€ μ‚¬νšŒμ—μ„œ κΈ°μ—…, μ •λΆ€, ν•™λ¬Έ, μ˜ν•™, 기술 λ“± λ‹€μ–‘ν•œ λΆ„μ•Όμ—μ„œ 핡심 μžμ›μœΌλ‘œ μΈμ‹λ˜μ–΄ ν™œμš©λ˜κ³  μžˆμŠ΅λ‹ˆλ‹€.

 

 


 

 

Database 

λ°μ΄ν„°λ² μ΄μŠ€(Database)λŠ” μ „μžμ μœΌλ‘œ μ²΄κ³„μ μœΌλ‘œ 쑰직된 κ΄€λ ¨μžˆλŠ” λ°μ΄ν„°λ“€μ˜ 집합이며, 데이터듀을 효과적으둜 검색, μ €μž₯ 및 관리할 수 μžˆλ„λ‘ κ΅¬μ‘°ν™”λ˜μ–΄ μžˆμŠ΅λ‹ˆλ‹€.

λ°μ΄ν„°λ² μ΄μŠ€λŠ” 정보λ₯Ό 효율적으둜 κ΄€λ¦¬ν•˜κ³  μ €μž₯ν•˜κΈ° μœ„ν•΄ μ‚¬μš©λ©λ‹ˆλ‹€. 이λ₯Ό 톡해 μ‚¬μš©μžλŠ” ν•„μš”ν•œ 정보에 λΉ λ₯΄κ²Œ μ ‘κ·Όν•˜κ³ , λ°μ΄ν„°μ˜ 무결성과 일관성을 μœ μ§€ν•  수 μžˆμŠ΅λ‹ˆλ‹€.

 

 


 

 

Database Management System 

DBMS(λ°μ΄ν„°λ² μ΄μŠ€ κ΄€λ¦¬ μ‹œμŠ€ν…œ)λŠ” λ°μ΄ν„°λ² μ΄μŠ€λ₯Ό μƒμ„±, μœ μ§€, μ‘°μž‘ν•˜κ³ , λ°μ΄ν„°λ² μ΄μŠ€μ™€ μ‚¬μš©μž κ°„μ˜ μƒν˜Έ μž‘μš©μ„ κ΄€λ¦¬ν•˜λŠ” μ†Œν”„νŠΈμ›¨μ–΄μž…λ‹ˆλ‹€. DBMSλŠ” λ°μ΄ν„°λ² μ΄μŠ€μ˜ κ΅¬μ‘°λ₯Ό μ •μ˜ν•˜κ³ , λ°μ΄ν„°μ˜ μ‚½μž…, κ°±μ‹ , μ‚­μ œ, κ²€μƒ‰μ„ μ²˜λ¦¬ν•˜λ©°, λ°μ΄ν„°λ² μ΄μŠ€μ˜ λ¬΄κ²°μ„±κ³Ό λ³΄μ•ˆμ„ μœ μ§€ν•˜λŠ” μ—­ν• μ„ ν•©λ‹ˆλ‹€. μ—¬λŸ¬ μ‚¬μš©μžκ°€ λ™μ‹œμ— λ°μ΄ν„°λ² μ΄μŠ€μ— μ ‘κ·Όν•˜κ³  μ‘°μž‘ν•  μˆ˜ μžˆλ„둝 μ§€μ›ν•˜λ©°, λ°μ΄ν„°μ˜ μΌκ΄€μ„±μ„ λ³΄μž₯ν•©λ‹ˆλ‹€.

DBMS의 핡심은 CRUD (Create, Read, Update, Delete)


일반적으둜 μ‚¬μš©λ˜λŠ” λͺ‡ 가지 λŒ€ν‘œμ μΈ DBMSλŠ” λ‹€μŒκ³Ό κ°™μŠ΅λ‹ˆλ‹€: MySQL, PostgreSQL, Oracle Database, Microsoft SQL Server, MongoDB

 


 

 

P.s) 메타데이터?

메타데이터(Metadata)λŠ” λ‹€λ₯Έ λ°μ΄ν„°λ₯Ό μ„€λͺ…ν•˜λŠ” λ°μ΄ν„°λ‘œ, μ •λ³΄μ˜ νŠΉμ„±, κ΅¬μ‘°, κ΄€κ³„, μΆœμ²˜ λ“±μ„ λ‚˜νƒ€λ‚΄λŠ” μ •λ³΄λ₯Ό λ§ν•©λ‹ˆλ‹€. 

λ©”νƒ€λ°μ΄ν„°λŠ” λ°μ΄ν„°λ₯Ό μ΄ν•΄ν•˜κ³  ν™œμš©ν•˜κΈ° μœ„ν•΄ ν•„μš”ν•œ μ»¨ν…μŠ€νŠΈλ₯Ό μ œκ³΅ν•˜λ©°, λ°μ΄ν„°μ˜ νš¨μœ¨μ μΈ κ΄€λ¦¬μ™€ κ²€μƒ‰μ„ λ„μ™€μ€λ‹ˆλ‹€. κ°„λ‹¨νžˆ λ§ν•˜λ©΄, "데이터에 λŒ€ν•œ λ°μ΄ν„°"둜 μƒκ°ν•  μˆ˜ μžˆμŠ΅λ‹ˆλ‹€.

 

 


Data: Raw and unprocessed facts, figures, symbols, or objects.

Information: Data that has been processed, organized, and given context to make it meaningful.

Database: A structured collection of data organized for efficient storage, retrieval, and manipulation.

DBMS (Database Management System): Software that manages databases by providing an interface for users and applications to interact with the database.

Metadata: Data that describes other data, providing information about its characteristics, structure, and context.

'Computer Science > Database' μΉ΄ν…Œκ³ λ¦¬μ˜ λ‹€λ₯Έ κΈ€

6 Create(Insert), Update, Delete  (1) 2024.01.11
5 CRUD (Create, Read, Update and Delete) + Practice tables  (0) 2024.01.08
4 Database Languages - DDL, DML, SQL  (0) 2024.01.08
3 Relational Database (feat. key, constraints)  (1) 2023.12.23
2 Data Model  (0) 2023.12.22

λŒ“κΈ€