Transitive closure clustering with CLR and JSON

added by DotNetKicks
12/20/2017 10:49:24 AM

2 Kicks, 295 Views

Transitive closure is a graph algorithm that tries to follow paths in graph edges and tries to find all elements that can be reached from some element, or groups of elements that are mutually reachable. Although SQL Server still don't provides native function for transitive closure, this algorithm can be implemented using CLR aggregates that can be placed in SQL database.