Skip to main content

ADBS - top navigation

  • Learn
  • DRPS

Breadcrumb

  1. Home
  2. ADBS: Advanced Database Systems
  3. ADBS: Course Materials

ADBS: Week 8: Costing, Search & Transactions

Lecture 22: Query Optimisation - Costing

  • Reading: Chapter 15 of RG
  • Slides: 1 per page, 2 x 2

Lecture 23: Query Optimisation - Search

  • Reading: Chapter 15 of RG
  • Slides: 1 per page, 2 x 2 
Lecture08-4: Query Optimisation - Search (40:17)

Lecture08-4: Query Optimisation - Search (40:17)
Duration:40:17
Added:09 Mar 2021 08:55 PM
Added By:Milos Nikolic
Description:
Week 8: Lecture08-4: Query Optimisation - Search
Tags:query optimisation, databases, dynamic programming, relation, query, join, plan, plans, tuples, relations, cost, instance, plants, trees, implementations, access, table, result, output, operator, scan, evaluation, attribute

@X@EmbeddedFile.requestUrlStub@X@webapps/osv-kaltura-BB5d1b15b77a8ac /LtiMashupPlay?playUrl=/browseandembed/index/media/entryid/1_pg8u9gca/showDescription/false/showTitle/false/showTags/false/showDuration/false/showOwner/false/showUploadDate/false/playerSize/400x285/playerSkin/32599141/



 

Lecture 24: Transactions

  • Reading: Chapters 16 & 17 of RG
  • Slides: 1 per page, 2 x 2
License
All rights reserved The University of Edinburgh

Book traversal links for ADBS: Week 8: Costing, Search & Transactions

  • ADBS: Week 7: Processing Models & Plan Space
  • Up
  • ADBS: Week 9: Locking, Recovery, Distributed Transactions

Navigation links

  • ADBS: Course Materials
    • ADBS: Week 1: Intro, SQL, Relational Algebra
    • ADBS: Week 2: Conjunctive Queries
    • ADBS: Week 3: Conjunctive Queries (Part 2)
    • ADBS: Week 4: Database Storage
    • ADBS: Week 5: File Organisations & Indexing
    • ADBS: Week 6: Access Methods, Sorting & Aggregation, Joins
    • ADBS: Week 7: Processing Models & Plan Space
    • ADBS: Week 8: Costing, Search & Transactions
    • ADBS: Week 9: Locking, Recovery, Distributed Transactions
    • ADBS: Week 10: Parallel Query Processing
    • ADBS: Week 11: Guest Lecture & Revision
  • ADBS: Resource List
  • ADBS: Lecture Recordings
  • ADBS: Tutorials
  • ADBS: Assessment
RSS feed

Opencourse privacy & accessibility statements; contact Informatics, ILTS.