Use SPACEBAR to peruse the slides or click one to start...

Virtual Pivot Tables with SQLite

• Virtual Pivot Tables with SQLite
• Pivot tables
• Terminology
• Terminology
• Terminology
• Pivot tables arise in various situations:
• Pivot tables in earth science
• * Sample EAV data
• Foreign keys can reduce redundancy.
• Handling unpivoted data
• Self join
• Aggregate query
• SQLite::VirtualTable::Pivot
• Usage
• Implementation
• Implementation
• SQLite::VirtualTable::Pivot
• Performance of queries
• Performance
• Performance
• Performance
• Performance
• Overview of SQLite::VirtualTable::Pivot algorithm
• Conclusions
• Current status, future work
• The end

This presentation was generated by Vroom. Use <SPACE> key to go forward and <BACKSPACE> to go backwards.