database system

Overview of Database Design Requirement Analysis Conceptual design : ER Diagramvs. UML Logical design : RDB Schema Physical designEntities and Relati

Disks and FilesDBMS 저장소는 하드 또는 플래시 SSDs를 사용함CPU -> CPU Cache -> DRAM -> Disk Capacity ($/GB) : Harddisk >> Flash SSD Bandwidth (MB/sec): Harddisk <

Basic ConceptsAn index file consists of records (called data entry or index entry)search-key | pointerIndex files are typically much smaller than the

External merge sortBasic algorithm: “Load-Sort-Store”Some optimizations: blocked & overlapped I/ODBMS Sorting 필요한 경우Data requested in sorted order: or

What you should know from this chapterAlternative (physical) algorithms for selection, projection, join, set, and aggregation & grouping (logical) ope