Data Modeling as a Foundation for Asset Management

1
Data Modeling as a Foundation for Asset Management
INFORMATION SYSTEMS
2

• Blending asset management concepts with
  real-time supervisory and control systems

3
Successful companies select a few standards and
enforce them strictly. The elements of a
companies infrastructure that benefit most from
standardization are desktop systems, desktop
productivity applications, database systems, and
network services. From Bill Gates book Business
at the Speed of Thought  
4
(No Transcript)
5
Standards
A given IT product needs only to deal with the
immediately adjoining layers. Simplifies design
of IT components. Allow introduction of
commercial off-the-shelf products.
6
Data Management
Foundation supporting computer applications. Dat
a Centric approach focuses on data requirements
as an organizing concept for computer
applications.
7
Data Modeling

• Data objects are created when a system is built,
  insuring data-centric design.
• Design Data
• Build Functionality
• Build Data Model of Core Data Objects
• Construct Application

8
Data Models are used to

• Design and Build Databases
• Perform System Planning
• Carry-out Business Re-engineering
• Understand Key Business Functions
• Support Multiple Functions

9
Integration

• Adoption of Standards
• Structured Interfaces
• Data Modeling Across all Applications
• Uniformity Across Applications

10
Case Study Bus Stops/Shelters/Amenities Program

• Stops and Amenities
• Management Work Order Tracking
• Re-engineering of Business Function
• Development of the Stop/Amenities Data Model

11
Data Centric Approach

12

• Stops Amenities (Work Order Request)

Data Card
13
Asset ManagementSupervisory and Control

• Established in the mid-1980s, our data modeling
  technique presently supports over 100 tables that
  define schema for 15 mission critical business
  systems
• AVL Based Bus Dispatch, Instrumented Vehicles,
  Rail Control, Dial-a-Ride (ATP) Dispatch
  Integrated with business systems.
• Enterprise Environment Oracle database, Sun
  Processor Power Builder Front-end Applications,
  ESRI GIS

14
Success of Data Modeling

• Holistic Approach - Duplicates Real World
  Conditions
• Short-term Investment Leads to Long-Term Economy
• Updates are made once at the Source because the
  Information is located on a Single Platform

Model builds the data warehouse supporting Agency
functions via objects (people, location, route,
or bus shelter) Separates the Business
Expertise (Domain) Process from the DATA
Flexible structure allowing for Changing
Business Processes without changing the Data or
purchasing an entire new system. Accurate Data
Accessible at Desktop Reduce Redundancy Shared
Resources