Tibero교육교재_데이터베이스관리시스템 교육_V1.0.pdf

Tibero교육교재_데이터베이스관리시스템 교육_V1.0.pdf

Info icon This preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 데이터베이스관리시스템 교육 Tibero RDBMS 목차 목차 1. TIBERO RDBMS 소개 및 설치 ................................................................................................... 6 1.1. 1.1.1. Tibero RDBMS란? .................................................................................................................................. 7 1.1.2. Tibero RDBMS 주요 기능 .................................................................................................................. 7 1.2. TIBERO RDBMS 구조 ........................................................................................................................................ 9 1.2.1. Tibero RDBMS 전체구조 .................................................................................................................... 9 1.2.2. Tibero RDBMS 프로세스 구조......................................................................................................... 9 1.2.3. Tibero RDBMS 프로세스 종류....................................................................................................... 10 1.3. TIBERO RDBMS 설치 및 제거 .................................................................................................................... 13 1.3.1. 시스템 요구 사항 ................................................................................................................................ 13 1.3.2. 설치 전 준비사항 ................................................................................................................................ 14 1.3.3. 설치 ............................................................................................................................................................ 18 1.3.4. 설치 확인................................................................................................................................................. 30 1.3.5. 기동 및 종료.......................................................................................................................................... 35 1.3.6. 사용자 계정 ............................................................................................................................................ 37 1.3.7. 제거 ............................................................................................................................................................ 37 1.4. TBADMIN.............................................................................................................................................................. 40 1.4.1. tbAdmin이란? ........................................................................................................................................ 40 1.4.2. tbAdmin 주요 기능 ............................................................................................................................ 40 1.4.3. 설치 ............................................................................................................................................................ 40 1.4.4. 기동 및 종료.......................................................................................................................................... 40 1.4.5. tbAdmin 화면 구성 ............................................................................................................................ 44 1.4.6. tbAdmin 기본 기능 ............................................................................................................................ 53 1.5. 2. TIBERO RDBMS 소개 ........................................................................................................................................ 7 TBSQL .................................................................................................................................................................. 68 1.5.1. tbSQL이란? ............................................................................................................................................. 68 1.5.2. tbSQL 주요 기능.................................................................................................................................. 68 1.5.3. tbSQL 실행과 종료 ............................................................................................................................. 68 1.5.4. 시스템 변수 ............................................................................................................................................ 72 1.5.5. 기본 기능................................................................................................................................................. 77 1.5.6. 고급 기능................................................................................................................................................. 82 1.5.7. 명령어 ....................................................................................................................................................... 87 SQL ............................................................................................................................................. 119 2 목차 2.1. SQL 개요 ........................................................................................................................................................ 120 2.1.1. SQL 정의 .............................................................................................................................................. 120 2.1.2. SQL 역할 .............................................................................................................................................. 120 2.1.3. SQL 종류 .............................................................................................................................................. 121 2.2. SQL 구성요소 ............................................................................................................................................... 123 2.2.1. 데이터 타입 ......................................................................................................................................... 123 2.2.2. 스키마 객체 ......................................................................................................................................... 125 2.3. SQL 연산 ........................................................................................................................................................ 128 2.3.1. 2.4. 연산자 .................................................................................................................................................... 128 내장함수 ......................................................................................................................................................... 131 2.4.1. 단일 행 함수....................................................................................................................................... 131 2.4.2. 그룹 함수.............................................................................................................................................. 132 2.5. 데이터 정의어(DDL) .................................................................................................................................. 133 2.5.1. 테이블 스페이스(Tablespace) ...................................................................................................... 133 2.5.2. 테이블 스페이스 생성 .................................................................................................................... 136 2.5.3. 테이블 스페이스 변경 .................................................................................................................... 136 2.5.4. 테이블 스페이스 삭제 .................................................................................................................... 136 2.5.5. 사용자 관리 ......................................................................................................................................... 137 2.5.6. 사용자 생성, 변경, 삭제 ................................................................................................................ 137 2.5.7. 테이블 생성 ......................................................................................................................................... 138 2.5.8. 테이블 변경 ......................................................................................................................................... 139 2.5.9. 테이블 삭제 ......................................................................................................................................... 139 2.5.10. DDL 공통 문법 요소 ....................................................................................................................... 140 2.6. 데이터 조작어(DML) ................................................................................................................................. 141 2.6.1. 데이터 검색 ......................................................................................................................................... 142 2.6.2. 데이터 삽입 ......................................................................................................................................... 143 2.6.3. 데이터 갱신 ......................................................................................................................................... 143 2.6.4. 데이터 삭제 ......................................................................................................................................... 144 2.7. 데이터 제어어(DCL) ................................................................................................................................... 145 2.7.1. GRANT ................................................................................................................................................... 145 2.7.2. REVOKE.................................................................................................................................................. 148 2.7.3. COMMIT ................................................................................................................................................ 151 2.7.4. ROLLBACK ............................................................................................................................................ 151 2.8. SQL 뷰(VIEW)................................................................................................................................................. 152 2.8.1. 뷰의 생성.............................................................................................................................................. 152 2.8.2. 뷰의 제거.............................................................................................................................................. 153 3 목차 2.8.3. 3. SQL 기본 실습 .......................................................................................................................... 155 3.1. 산술 및 문자열 연산자 .................................................................................................................. 156 3.1.2. 비교 연산자 ......................................................................................................................................... 157 3.1.3. WHERE 절에서의 연산자 .............................................................................................................. 158 3.1.4. 다중 행 SQL 연산자 ....................................................................................................................... 162 3.1.5. 논리 연산자 ......................................................................................................................................... 163 3.1.6. 집합 연산자 ......................................................................................................................................... 165 함수의 활용 실습........................................................................................................................................ 168 3.2.1. 단일행 함수(Single-Row Function) ........................................................................................... 168 3.2.2. 그룹 함수(Group Function) .......................................................................................................... 177 3.3. DDL 실습........................................................................................................................................................ 179 3.3.1. tbSQL을 이용한 실습 ..................................................................................................................... 179 3.3.2. tbAdmin을 이용한 실습 ................................................................................................................ 182 3.3.3. 케이스별 SELECT 문 실습 ............................................................................................................ 185 SQL 고급 ................................................................................................................................... 191 4.1. 5. SQL 연산자의 활용 실습 ......................................................................................................................... 156 3.1.1. 3.2. 4. 뷰에 대한 DML 연산 ...................................................................................................................... 153 조인(JOIN)...................................................................................................................................................... 192 4.1.1. 조인 조건.............................................................................................................................................. 192 4.1.2. 동등 조인(Equi Join) ........................................................................................................................ 192 4.1.3. 자체 조인(Self Join) ......................................................................................................................... 192 4.1.4. 카티션 프로덕트 ................................................................................................................................ 193 4.1.5. 내부 조인(Inner Join) ...................................................................................................................... 193 4.1.6. 외부 조인(Outer Join) ..................................................................................................................... 193 4.1.7. 안티 조인(Anti Join) ........................................................................................................................ 194 4.1.8. 세미 조인(Semi Join) ....................................................................................................................... 194 4.2. 서브쿼리(SUBQUERY) ................................................................................................................................... 195 4.3. SQL 튜닝 ........................................................................................................................................................ 196 4.3.1. SQL 튜닝 절차 ................................................................................................................................... 196 4.3.2. SQL 튜닝 포인트 .............................................................................................................................. 197 SQL 고급 실습 .......................................................................................................................... 199 5.1. 테이블 조인 실습........................................................................................................................................ 200 5.1.1. CROSS JOIN ........................................................................................................................................ 200 5.1.2. INNER JOIN ......................................................................................................................................... 201 4 목차 5.1.3. NATURAL JOIN ................................................................................................................................... 202 5.1.4. OUTER JOIN ........................................................................................................................................ 202 5.2. 5.2.1. 단일행 서브쿼리 ................................................................................................................................ 207 5.2.2. 다중행 서브쿼리 ................................................................................................................................ 208 5.2.3. INLINE VIEW ....................................................................................................................................... 208 5.3. 6. SQL 튜닝 실습 ............................................................................................................................................. 210 백업과 복구 ............................................................................................................................... 220 6.1. 백업(BACKUP) ................................................................................................................................................. 221 6.1.1. 백업 종류.............................................................................................................................................. 221 6.1.2. 백업 모드.............................................................................................................................................. 222 6.1.3. 백업 가이드 ......................................................................................................................................... 222 6.2. 7. 서브쿼리 실습 .............................................................................................................................................. 207 복구(RECOVERY) ............................................................................................................................................. 223 6.2.1. 부트 모드 별 복구 ........................................................................................................................... 223 6.2.2. 복구 종류.............................................................................................................................................. 224 백업/복구 실습 ......................................................................................................................... 226 7.1. OFFLINE BACKUP & RECOVERY .................................................................................................................... 227 7.1.1. Offline Backup .................................................................................................................................... 227 7.1.2. Offline Recovery ................................................................................................................................ 230 7.2. ONLINE BACKUP & RECOVERY ..................................................................................................................... 233 7.2.1. Online Backup .................................................................................................................................... 233 7.2.2. Online Recovery ................................................................................................................................ 239 5 1. Tibero RDBMS 소개 및 설치 1. Tibero RDBMS 소개 및 설 1.1. Tibero RDBMS 소개 1.1.1. Tibero RDBMS란? 기업의 비즈니스는 폭발적인 데이터의 증가와 다양한 환경 및 플랫폼의 등장으로 빠르게 확 장되고 있다. 즉, 새로운 비즈니스 환경이 도래함에 따라서, 보다 더 효율적이고 유연한 데이 터 서비스와 정보의 처리, 데이터 관리 기능이 필요하게 되었다. Tibero RDBMS는 이러한 변화에 맞춰 기업 비즈니스 구현의 기반이 되는 데이터베이스 인프 라 구성을 지원하며 고성능, 고가용성 및 확장성의 문제를 해결하는 엔터프라이즈 데이터베 이스 관리 시스템이다. 기존 RDBMS의 단점을 보완하기 위해 Tibero RDBMS는 독자적인 Tibero Thread Architecture 를 채택, 구현하였다. 한정된 서버 프로세스로 CPU 및 메모리 등의 시스템 리소스를 효율적 으로 사용하면서 뛰어난 성능과 안정성 및 확장성을 보장하고 편리한 개발과 관리 기능을 제 공한다. 1.1.2. Tibero RDBMS 주요 기능 대용량의 데이터를 관리하고 안정적인 비즈니스 연속성을 보장하는 데이터 관리 솔루션인 Tibero RDBMS는 RDBMS 환경에서 요구되는 주요 기능을 다음과 같이 갖추고 있다. 분산 데이터베이스 링크(Distributed Database Link) 데이터베이스 인스턴스별로 각각 서로 다른 데이터를 저장하는 기능이다. 이 기능을 통해 원격 데이터베이스에 저장된 데이터를 네트워크를 통해 읽기 및 쓰기를 수행할 수 있다. 데이터 이중화(Data Replication) 현재 운영중인 데이터베이스에서 변경된 모든 내용을 Standby DB로 복제하는 기능이다. 즉,...
View Full Document

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern