Courts

Dept of Corrections

State
Police

Health Services

Future
Data Sources

Courts DW

Search Applications

Application

Server

DW Query Users

Third Party Providers

State
Police

Health Services

Typical results from a data warehouse query

BI Tools Prefer

are transformed...

BI Tools Prefer

Possibly
millions
of rows

Summary Measures

...baked down into

Dimensions

Measures / Facts

Dates

Locations

Statuses

Teams

Hierarchies

Count

Sum

Average

Min - Max

others...

STDEV

others...

SCAO DW

BI-Designer

Static
Dashboards

Business Intelligence Users

Measure
Summaries

Process

Measure
Summaries

Existing

Server

Static
Dashboards

Update

Process

Static
Dashboards

Daily

SCAO DW

BI

Designer

Semantic

Database

Business Intelligence

Users

Rules

Detail
Data

Daily

New BI
Servers

BI Vendor Server(s)

Vendors  Secure

Cloud

SOM

Firewall

SOM

Firewall

SCAO DW

Existing

Server

Business Intelligence Users

Measure

Summeries

Measure
Summaries

Process

Existing NSA

Detail

Data

The web
is built on
JavaScript

Bootstrap is the most popular HTML, CSS, and JS framework for developing responsive, mobile first projects on the web.

Node is open-source, cross-platform runtime environment for developing server-side Web applications, based on powerful Chrome V8 engine

REST (REpresentational State Transfer) is an approach to communications that is often used in the development of Web services.  REST is often preferred  because it does not leverage as much bandwidth, which makes it a better fit for use over the Internet

JSON (JavaScript Object Notation) is a lightweight data-interchange format. It is easy for humans to read and write. It is easy for machines to parse and generate. It is based on a subset of the JavaScript Programming Language

D3.js is a JavaScript library for manipulating documents based on data. D3 helps you to visualize data. D3’s emphasis on web standards gives you the full capabilities of modern browsers.  

C3.JS makes it easy to generate D3-based charts by wrapping the code required to construct the entire chart. Hundreds of reusable chart templates are available.

Teradata SQL provides both detail and measure-summary access via the REST interface and JSON data exchange to JavaScript.  It's the SQL you know and love.

More

Courts DW

Business Intelligence Users

Measure
Summaries

Measure
Summaries

Process

Detail

Data

The web
is built on
JavaScript

Electron

React

Node