COMP418 - Computer Science 418 Study Guide (Print Version)...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Computer Science 418 Study Guide Distributed Database Systems and Database Tuning Credits and Copyright - Introduction - Unit 1 - Overview of Data Storage and Indexing Section 1 - Overview of Data Storage and Indexing Section 2 - Introduction to I/O Costs and Performance Tuning Section 3 - Overview of Memory Organization and File Structures Unit 2 - Tree Structured Indexing Section 1 - Introduction to the Structure of ISAM and B+ Tree Indexes. Section 2 - Implementation of the Search, Insert and Delete Operations Section 3 - Duplicates Handling and Other Practical Issues Unit 3 - Hash-Based Indexing Section 1 - The Static Hashing Scheme Section 2 - The Dynamic Hashing Schemes Unit 4 - Overview of Query Evaluation Section 1 - The System Catalog and Operator Evaluation Section 2 - Evaluation Algorithms for Relational Operations Section 3 - Overview of Query Optimization Unit 5 - External Sorting Section 1 - Introduction to External Sorting of Data Section 2 - The External Merge Sort Algorithm Section 3 - Using B+ Tree Index for Sorting Unit 6 - Evaluating Relational Operators Section 1 - Evaluation of the Selection Operation Section 2 - Evaluation of the Projection Operation Section 3 - Evaluation of the Joint Operation Section 4 - Evaluation of the Set Operation, Aggregate Operations and the Impact of Buffering Unit 7 - Query Optimizers Section 1 - SQL Queries Decomposition and Cost Estimation Section 2 - Relational Algebra Equivalences and Elaboration of Alternative Plans Section 3 - The System R and Other Approaches to Query Optimization Unit 8 - Overview of Transactions Management Section 1 - Introduction to the Concepts of Transaction and ACID Properties Section 2 - Introduction to Concurrent Execution of Transactions and Concurrency Control Section 3 - Transaction Support in SQL Section 4 - Introduction to Crash Recovery Unit 9 - Concurrency Control Section 1 - Overview of Concurrency Control Section 2 - Locks Management and Deadlocks Section 3 - Specialized Locking Techniques Section 4 - Concurrency Control Without Locking Unit 10 - Crash Recovery Section 1 - Introduction to Crash Recovery Computer Science 418 Study Guide (Print Version) Computer Science 418 Study Guide 1
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Section 2 - The Recovery Phases Section 3 - Media Recovery and Other Approaches Unit 11 - Physical Database Design and Tuning Section 1 - Introduction to Physical Database Design and Tuning Section 2 - Indexing and Clustering Section 3 - Database Tuning Section 4 - DBMS Benchmarking Unit 12 - Security and Authorization Section 1 - Introduction to Database Security Section 2 - Access Control Section 3 - Security for Internet Applications Section 4 - Other Issues Related to Security Unit 13 - Distributed Database Systems Section 1 - Introduction to Parallel Databases Section 2 - Introduction to Distributed Databases
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 102

COMP418 - Computer Science 418 Study Guide (Print Version)...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online