바로가기

모두를 위한 열린 강좌 KOCW

주메뉴

강의사진
  • 주제분류
    공학 >컴퓨터ㆍ통신 >컴퓨터공학
  • 강의학기
    2011년 1학기
  • 조회수
    7,786
  •  
This course is designed to provide individuals with a complete introduction to database design concepts. The purpose of this course is to teach students how to build databases through at least one running case study and a research project.
Introduce
배속
  • 이전차시
  • 다음차시

차시별 강의

PDF VIDEO SWF AUDIO DOC AX
1. 비디오 Introduce 데이터의 논리적인 구조 설명
Premiere Products , Database Background
URL
2. 비디오 Introduction to the Alexamara Marina Group Database Case Objectives, Introduction, Functional Dependence, Keys URL
3. 비디오 Database Design 1: Normalization(1) First,Second,Third Normal Form URL
비디오 Database Design 1: Normalization(2) Incorrect Decompositions, Multivalued Dependencies and Fourth Normal Form, Avoiding the Problem with Multivalued Dependencies, Application to Database Design URL
비디오 Database Design 1: Normalization(3) Multivalued Dependencies and Fourth Normal Form, Normal Form, Summary URL
4. 비디오 Database Design 2: Design Method(1) Introduction, Information-Level Design Method, Represent the User View As a Collection of Tables, Normalize the Tables, Identify All Keys, Types of Primary Keys, Database Design Language (DBDL), Entity-Relationship (E-R) Diagrams URL
5. 비디오 Database Design 2: Design Method(2) Merge the Result into the Design, Database Design Examples, Represent the User View As a Collection of Tables,
Database Design Examples
URL
비디오 Database Design 2: Design Method(3) Physical-Level Design, Top-Down Versus Bottom-Up, Survey Form
,Obtaining Information from Existing Documents
URL
6. 비디오 Database Design 2: Design Method(4) One-to-One Relationship Considerations, Many-to-Many Relationship Considerations, Nulls and Entity Subtypes, Avoiding Problems with Third Normal Form When Merging Tables, The Entity-Relationship Model, Summary URL
7. 비디오 DBMS Functions(1) Introduction, and Retrieve Data, Provide Catalog Services URL
비디오 DBMS Functions(2) Support Concurrent Update,
The Concurrent Problem,
Avoiding the Lost Problem, Two-Phase Locking, Deadlock, Locking on PC-Based DBMSs, Timestamping, Recover Data, Journaling
URL
비디오 DBMS Functions(3) Deadlock,
Recover Data
Journaling
Forward Recovery
Forward Recovery(continued)
Backward Recovery
Backward Recovery(continued)
Recovery on PC-Based DBMSs
Provide Security Servic
Encryption
Authentication
Authorizations
Views
Privacy
URL
8. 비디오 DBMS Functions(4) Provide Data Integrity Features
Provide Data Integrity Features(continued)
Support Data Independence
Adding a Field
Changing the Length of a Field
Creating an Index
Adding or Changing a Relationship
Support Data Replication
Provide Utility Services
Summary
Summary (continued)
URL
9. 비디오 Database Administration(1) Introduction
Database Policy Formulation and Enforcement
Access Privileges
Access Privileges(continued)
Security
Security(continued)
Disaster Planning
Disaster Planning(continued)
URL
비디오 Database Administration(2) Archiving
Archiving(continued)
Other Database Administration Functions
DBMS Evaluation and Selection
DBMS Evaluation and Selection(continued)
Data Dictionary Management
Training
Technical Functions
Database design
Testing
Testing(continued)
Performance tuning
Performance tuning(continued)
Summary
Summary (continued)
URL
10. 비디오 Database Management Approaches(1) Distributed Databases
Distributed Databases(continued)
Replication Transparency
Fragmentation Transparency
Fragmentation Transparency (continued)
Advantages of Distributed Databases
URL
비디오 Database Management Approaches(2) Disadvantages of Distributed Databases
Disadvantages of Distributed Databases (continued)
Rules for Distributed Databases
Rules for Distributed Databases (continued)
Client/Server Systems
Client/Server Systems (continued)
Advantages of Client/Server Systems
Web Access to Databases
Web Access to Databases(continued)
URL
11. 비디오 Database Management Approaches(3) Web Access to Databases (continued)
XML
XML(continued)
Data Warehouses
Data Warehouses(continued)
URL
비디오 Database Management Approaches(4) Data Warehouse Structure and Access
Data Warehouses (continued)
Data Warehouse Structure and Access(continued)
Rules for OLAP Systems
Rules for OLAP Systems(continued)
Object-Oriented DBMSs
What Is an Object-Oriented DBMS?
Objects and Classes
Methods and Messages
Methods and Messages(continued)
Inheritance
Unified Modeling Language (UML)
Unified Modeling Language (UML)(continued)
URL

연관 자료

loading..

사용자 의견

강의 평가를 위해서는 로그인 해주세요.

이용방법

  • 강의 이용시 필요한 프로그램 [바로가기]



    ※ 강의별로 교수님의 사정에 따라 전체 차시 중 일부 차시만 공개되는 경우가 있으니 양해 부탁드립니다.

이용조건