A Game of Hierarchies: Mastering Recursive Queries

Speaker: Markus Ehrenmueller-Jensen

Duration: 60 minutes

Track: Application & Database Development

Hierarchies are the bread and butter of most business applications and you find them almost everywhere:
* Product Categories
* Sales Territories
* Calendar and Time
Even when there is a big need from a business perspective, the solutions in relational databases are still sort of awkward. The most flexible hierarchies are modeled as self-referenced tables. If you want to successfully query such self-referenced hierarchies, you will need either loops or recursive Common Table Expressions. You will learn how to master both and will learn how make them fast.
Join this session for a journey through best practices to transform your hierarchies into useful information. We will have fun playing around with a sample database based on G. R. R. Martin’s famous “Game of Thrones”.

Back to Top