>> Scanning • Scanning • Selection via Scanning • Iterators • Example Query • next_tuple() Function • Relation Copying • Scanning in PostgreSQL • Scanning…
Catalogs >> Catalogs Database Objects Catalogs Representing Databases Representing Tables COMP9315 21T1 ♢ Catalogs ♢ [0/11] ∧ >> ❖ Database Objects RDBMSs manage different kinds…
>> File Management • File Management • DBMS File Organisation • Single-file DBMS • Single-file Storage Manager • Example: Scanning a Relation • Single-File Storage…
PostgreSQL Buffer Manager >> PostgreSQL Buffer Manager PostgreSQL Buffer Manager Clock-sweep Replacement Strategy COMP9315 21T1 ♢ PG Buffers ♢ [0/8] ∧ >> ❖ PostgreSQL Buffer…
>> PostgreSQL Tuples • PostgreSQL Tuples • PostgreSQL Attribute Values COMP9315 21T1 ♢ PostgreSQL Tuples ♢ [0/12] ∧ >> ❖ PostgreSQL Tuples Definitions: include/postgres.h, include/access/*tup*.h…
>> Catalogs • Database Objects • Catalogs • Representing Databases • Representing Tables COMP9315 21T1 ♢ Catalogs ♢ [0/11] ∧ >> ❖ Database Objects RDBMSs…
>> DBMS Overview • DBMSs • Query Evaluation • Mapping SQL to RA • Mapping Example • Query Cost Estimation • Implementations of RA Ops…
Tuple Representation >> Tuple Representation Tuples Records vs Tuples Converting Records to Tuples Operations on Records Operations on Tuples Fixed-length Records Variable-length Records Data Types…
PostgreSQL Tuples >> PostgreSQL Tuples PostgreSQL Tuples PostgreSQL Attribute Values COMP9315 21T1 ♢ PostgreSQL Tuples ♢ [0/12] ∧ >> ❖ PostgreSQL Tuples Definitions: include/postgres.h, include/access/*tup*.h…
>> PostgreSQL Buffer Manager • PostgreSQL Buffer Manager • Clock-sweep Replacement Strategy COMP9315 21T1 ♢ PG Buffers ♢ [0/8] ∧ >> ❖ PostgreSQL Buffer Manager…