hierarchyid, graph, and Spatial Data types for the rescue!

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!

Ronen Ariely

Senior consultant and architect, data platform and application development.

Tel Aviv, Israel


Please note that Sessionize is not responsible for the accuracy or validity of the data provided by speakers. If you suspect this profile to be fake or spam, please let us know.

Jump to top