Database Overview What is Database Database Database Intro

Database Overview What is Database? Database란 무엇인가

Database Intro: Why & How Data vs. Information Data is a collection of facts. Information is data processed for knowledge. Changing data into information Organize data so that it can be viewed in a useful form. What information are needed? 2. How will information be produced? 1. What data to collect? 3. Requirements Identify the Context of data → Metadata • Organize 정리, 체계화, 조직화 → Structured Data 구조적 데이터 • Summarize 요약 → Information • Database Design 2

Data → Information: 1. Identify Context Data Obama, Barack H. Bush, George H W. Bush, George W. Clinton, William J. Carter, James E. 19610804 19240612 19460706 19460819 19241001 Context Living presidents, United States, as of 2020/1/1 • Name (last name, first name middle initial), birthdate (YYYYMMDD) Class Roster, Database Design Course, LIS Department, KNU, Spring 2020 • Database Design Name (last name, first name middle initial), student ID 3

Data → Information: 2. Organize Data Identify metadata (metadata의 식별) Course Title Database Design Course ID DB-s 20 Credit Hours 3. 0 Class Time Monday 3 -4: 15 p. m. , Wednesday 4: 30 -5: 45 p. m. Semester Spring 2020 Instructor Yang, Kiduk Department Library & Information Science College School of Social Science University Kyungpook National University Identify additional data items ( data 식별을 위한 부가적 요소) Lname Fname Init Stud_ID Major Level GPA Obama Barack H 19610804 LIS YR 1 3. 8 Bush George HW 19240612 TCOM YR 4 2. 1 Bush George W 19460706 ACCT YR 1 3. 0 Clinton William J 19460819 CS YR 3 3. 9 Carter James E 19241001 LIS YR 2 3. 7 Database Design 4

Data → Information: 3. Summarize Patterns, Trends & Visualization Enrollment Pie Chart 10% DS 15% CS 30 20 45% LIS 15% TCOM ACCT = Accounting CS = Computer Science DS = Data Science LIS = Library & Information Science TCOM = Telecommunication Database Design Enrollment 15% ACCT Enrollment over Time 15 10 5 0 s 0 f 1 s 1 f 2 s 2 f 3 s 3 f 4 s 4 f 5 s 5 f 6 s Semester 5

Database Intro: Function u What Store 저장 / Retrieve 검색 / View 검토 data efficiently & effectively. Characteristics A collection of organized data related to a particular subject/purpose • Structured data 구조적 데이터, Security 보안, Control 통제 Data. Base Management System (DBMS) • (Data) Storage 저장, Processing 처리/가공, Retrieval 검색 User Interface • Database Design Data Entry 데이터 입력, Search 입력, View/Report 검토/보고 6

Database: Definitions Database Collection of related data 관련된 데이터 and its metadata organized in a structured format 구조적 형식 for optimized information management 정보 관리 Database Management System (DBMS) Software that enables easy creation 구축, modification 변경, & access 접속 of databases for efficient and effective database management 데이터베이스 관리 Database System Integrated system 통합 시스템 of hardware, software, data, procedures, & people that define 결정 and regulate 규제 the collection, storage, management, & use of data within a database environment 데이터베이스 환경 Database Design 7

Database Management System · Software that enables easy creation 구축, modification 변경, & access 접속 of databases for efficient and effective database management 데이터베이스 관리 → Manages interaction between end users and database 이용자와 DB사이의 상호 작용 관리 Database Systems: Design, Implementation, & Management: Rob & Coronel Database Design 8

Database System Environment § Hardware § Software - OS - DBMS - Applications § People § Procedures § Database Systems: Design, Implementation, & Management: Rob & Coronel Database System 9

Database Overview Evolution of Database System

Evolution of Database 발전 1960 s 1970 s 1980 s 1990 s 2000+ File-based Hierarchical Network Relational Entity-Relationship Object-oriented Web-based No. SQL New. SQL Database Design 11