Database Answers Header
Home First Timers Ask a Question Careers Clients Community Data Models Tutorials Site Map
BMEWS and BI in the Clouds for an Airport-in-a-Box 


BI on a Golf Course for an Airport-in-a-Box

An Alert is triggered ...
Phone Alarm

When a "spike" is detected ...
Cellphone ECG Monitor

As part of a Risk Dashboard ...
Risk Dashboard


For this demonstration, we have set up a KPI that triggers an Alert if the Landing Interval is 10 minutes or greater.

In this small set of Demonstration Data the last record would trigger an Alert to the designated mobile/cell phone.
This follows the design of our POC Cloud Reference Data Architecture.

Rcd ID Flight Number Arrival Date+Time Landing Interval KPI Colour
1 BA1234 Dec 01 09:00 2 minutes Green
2 BA1235 Dec 01 09:02 2 minutes Green
3 BA1236 Dec 01 09:04 2 minutes Green
4 BA1237 Dec 01 09:06 2 minutes Green
5 BA1238 Dec 01 09:08 2 minutes Green
6 BA1239 Dec 01 09:18 10 minutes Red

NOTE
The last record will trigger an Alert which is an email or message like this one to be sent to the CEO following the 'management by exception' principle.
Data Mart Design
The six data records shown above are stored
in a table that looks like this :-



© DatabaseAnswers.org 2016
About Us Contact Us