Transcript The Datastore Presenters: Nicholas Couture – President / CTO Marc Tomkinson – Director of Product Innovation General Systems Evolution Theory Strategic planning Exception management and reporting Communication and Optimization Transaction.

The Datastore
Presenters:
Nicholas Couture – President / CTO
Marc Tomkinson – Director of Product Innovation
General Systems Evolution Theory
Strategic
planning
Exception management
and reporting
Communication and Optimization
Transaction Management
Yard Smart’s evolution
Datastore
Software agents & reports
Automatically assign tasks & resources
Replace Radio
History of Yard Smart analytical data
• Yard Smart started with one database containing everything
• It evolved to a different set of tables for deleted and live data
• The operational model became loaded with analytical data
elements
• The operational code has more and more functionality
dedicated to analytical data capture and computing
• Yard Smart’s growth is becoming unsustainable…
We need the datastore!
The datastore, how it works
User
Action
YS
OPS
Staging
SSIS
Datastore
The benefits
Performance improvement
• Leaner operational database
• Only one action to save the event
• All data transformations are performed in an asynchronous
process
• Sustainable operational performance
Empowered Customers
• Access to all the data available in Yard Smart
• Very limited impact on transaction processing
• Easier understanding of the database structure with de-
normalization and documentation
Enough data to get strategic
• Ability to add numerous elements to the data model in new
versions with no impact on transactional processing
• Ability to make relations between history to create new
perspectives and correlations
• New areas of analysis
– Shunter productivity
– Door productivity
– Zone utilization
• Enabler for new functionality
New features on datastore
YS 4.2 – See the Future
Background Information Collector (BIC)
•
Monitoring tool for:
•
Physical Infrastructure
•
USC Monitoring
•
YS Server Monitoring
•
Client Usage
•
Establish Performance Benchmarks
•
Forecast Hardware & Software impact of deploying new site
•
Proactively identify potential issues
YS 4.2 – See the Past
Interactive Dashboards
• KPI-specific dashboards
• Shunter Productivity
• Dock Utilization
• Etc…
• Easily and Efficiently…
• Manage your resources
• React to Yard Issues
• View & Quantify
Improvements
• Built-in to the system – no config
required
Reporting
Yard:
BR
Date From:
03/12/2009 12:00:00 AM
Date To:
03/12/2009 11:59:59 PM
• Compatible with any BI tool
View Report
Dock Door Usage
• Sample Reports Out of the
Yard: BR
Date From: 03/12/2009 12:00:00 AM
Date To: 03/12/2009 12:00:00 AM
Central
Region:
Building
NR
Door
Occupied
Door
Date From:
03/12/2009
12:00:00 AM
%
Turns
Title
Date To:
72%
03/18/2009
11:59:59 PM 7
Title
100%
4
Title
D400
D401
Title
32%
2
Title
D402
Title
10%
1
View Report
Title
D403
Title
0%
Shunt
DriverTitle
Hours
...
SR
Region: Central
78%
14
Title 03/12/2009 12:00:01
D200
Title
100%
Date: From
AM5to 03/18/2009 11:59:59 PM
D201
Title
D202
Title
Driver D203
Date
...
Title
32%
3
Title
10%
1
Title Availability
25%
5
Total hours
Driving
Pause
Waiting
for Work
Total
Shunts
35
Title
Driver: Harrison Ford
56
42
14
7
03/12/2009 8
6
2
1
5
03/13/2009 8
6
2
1
5
03/14/2009 8
6
2
1
5
03/15/2009 8
6
2
1
5
03/16/2009 8
6
2
1
5
03/17/2009 8
6
2
1
5
03/18/2009 8
6
2
1
5
42
14
7
35
03/12/2009 8
6
2
1
5
03/13/2009 8
6
2
1
5
03/14/2009 8
6
2
1
5
03/15/2009 8
6
2
1
5
03/16/2009 8
6
2
1
5
03/17/2009 8
6
2
1
5
03/18/2009 8
6
2
1
5
Driver: Luke Skywalker
56
box with Yard Smart with
MSRS
•
Dock Door Usage
•
Shunter Driver Hours
•
…
Technical Requirements
• New instance of SQL server
• SQL server 2008
• Reporting Services for C3 Sample reports
• Mandatory Data Store as of Yard Smart 4.1