Tag: 6.5

N1QL query with Self Referencing Hierarchy

A data construct that often appears in business application is the hierarchical data structure. Hierarchy captures the parent-child relationship often between the same object. For instance a company structure captures the reporting line between employees. Business organization captures the relationship...

/ February 17, 2019

JSON to Insights: Analyzing US healthcare Data.

“Nothing is certain except for death and taxes.” This isn’t a dataset made with a bed of roses or manicured green grass. A bit more serious. Let’s see if we can quickly learn anything here. The dataset is the following. “name”...

/ December 7, 2018
Jespsen Code Image

On Par with Window Functions.

  Use golf analogy when explaining to executives. Use a car analogy for all others.  — Confucius. The purpose of window functions is to translate the business reporting requirements declaratively and effectively to SQL so query performance and developer/business-analyst efficiency...

/ November 22, 2018