Managing complex relationships in tabular database can be challenged. A relational database provides a basic solution by creating Single-to-Single or Single-to-Many relationships directly using primary key and foreign key.
This session is NOT about the theory but about practical solutions. In this session, I will demonstrate various methods and original tricks to improve working with complex data structures and complex queries.
We will discuss how we can use the built-in hierarchyid data type, Spatial Data types, and graph database capabilities to solve Many-to-Many relationship and other complex queries. We will show how we can use Spatial Data to solve “Hierarchical structure”, “gaps and islands”, and “ranges” problems.
This session is 100% practical solutions!