simpledboverview-mitdatabasegroup.pptVIP

What is SimpleDB? A basic database system SQL Front-end Provided for later labs Heap files Lab 1 Buffer Pool Labs 1-6 Basic Operators Labs 1 2 Scan, Filter, JOIN, Aggregate Transactions Lab 3 or 4 Query optimizer Lab 3 or 4 B-Tree Indexes Lab 5 Recovery Lab 6 Javadoc is your friend! Module Diagram Database Catalog List of DB tables Singleton Database: Database.getCatalog BufferPool Caches DB pages in memory Database.getBufferPool LogFile Ignore for Lab 1 Database.getLogFile Catalog Table: DbFile file String name String primary_key DbFile ID Table 001 Table1 002