External Article

Binary Trees in SQL

A number of hierarchies and networks are most conveniently modelled as binary trees. So what is the best way of representing them in SQL? Joe Celko discards the Nested Set solution in favour of surprisingly efficient solution based on the Binary Heap

External Article

Extending Hierarchical Data Modeling Demonstrated in SQL

The capability of extending the limits of combining multiple node hierarchical structures has not been fully explored. Michael M. David presents a solution to advanced structure combining that is simple to use, generic and freely extends the way hierarchical structures can be semantically combined to produce advanced new hierarchical data structure mashups that dynamically increase the value of the data.

Blogs

T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?

By

It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...

Understanding Fabric MCP

By

Model Context Protocol, or MCP, is one of those technical ideas that sounds more...

AWS RDS Aurora - our first approach

By

When starting with AWS RDS Aurora for managing relational databases in the cloud, many...

Read the latest Blogs

Forums

BCA KCP Kas Arifin Ahmad TLP/WA 08216977749

By Call Center Cs BRI QLola

Komp. Hatta Centre, Jl. Arifin Ahmad Perkantoran Soekarno No.9 Blok D, Sidomulyo Timur, Marpoyan...

BCA KCP Kramat Jaya Hub.0853•5504•2311

By greatdubai02

BCA KCP Kramat Jaya Hub.0853•5504•2311 Jl. Kramat Jaya Raya No.10 Blok F1, Semper Bar.,...

BCA KCP Panam TLP/WA 0821•697•7701

By Call Center Cs BRI QLola

Jl. H.R. Subrantas No.74 A & B, Sidomulyo Bar., Kec. Tampan, Kota Pekanbaru, Riau...

Visit the forum

Question of the Day

May the Fourth Be With You Fun

In honor of May the fourth and Star Wars (may the force be with you), finish this quote:

"Do, or do not.  ..."

See possible answers