O'Reilly logo

Joe Celko's Trees and Hierarchies in SQL for Smarties, 2nd Edition by Joe Celko

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 1. Graphs, Trees, and Hierarchies
Let's start with a little mathematical background. Graph theory is a branch of mathematics that deals with abstract structures known as graphs. These are not the presentation charts that you get out of a spreadsheet package.
Keywords: edges, nodes, subordination, inheritance, organizational charts, parts explosions, static nodes, static edges, dynamic edges, dynamic nodes, recursion
Let's start with a little mathematical background. Graph theory is a branch of mathematics that deals with abstract structures known as graphs. These are not the presentation charts that you get out of a spreadsheet package.
Very loosely speaking, a graph is a diagram of “dots” (called nodes or vertices) and “lines” (edges or ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required