Data Modeling

Naturally Increasing Data Value with Hierarchical Structures

  • Article

Hierarchical structures have an inherent ability for significant data value increases beyond the data collected. This will be shown to exist in hierarchical structures and even more powerfully in their natural hierarchical processing capabilities. These will demonstrate flexible and efficient ways to increase data value automatically and will be discussed in this article. SQL will be used to perform a wide range of hierarchical processing operations that easily demonstrate these increasing data value capabilities.

2011-03-23

3,291 reads

Extending Hierarchical Data Modeling Demonstrated in SQL

  • Article

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.

2010-07-16

3,196 reads

Blogs

Everyone Run a SQL Saturday in 2021

By

With SQL Saturdays being rebooted, and the SQLSaturday.com website live, it’s time for events....

Modern Data Warehouse & Reverse ETL

By

An extension to the Modern Data Warehouse (MDW) that I have heard a bit...

Daily Coping 12 Apr 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

performance tuning

By rohitkocharda

Hi everyone, Any good suggestion to tune below query:   --CREATE NONCLUSTERED INDEX nonclust_code...

Understanding the Internals of a Data Page

By Mohsin_A_Khan

Comments posted to this topic are about the item Understanding the Internals of a...

Preventing Trigger Execution

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Preventing Trigger Execution

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers