What is a dictionary? What do we gain by using one? How does this relate to CREATE DOMAIN? How would dictionaries affect query processing? Is a dictionary something a user has to be aware of? How does dictionary compression relate to domain encoding? What are the pros and cons of dictionary compression?
Video for my inverted classroom "Database Systems". (V2: bugfix in first SQL statement}
The complete list of videos, slides, and additional material is (will be) available at http://datenbankenlernen.de
Computer Science, Saarland University:
Bachelor (in German): http://www.cs.uni-saarland.de/index.p...
Master (in English): http://www.cs.uni-saarland.de/index.p...
Ph.D./Grad School: http://gradschool.cs.uni-saarland.de/