Enterprise Data Model for Transportation Planning Presentation to

Enterprise Data Model for Transportation Planning Presentation to 2009 TRB Planning Application Conference Minhua Wang, Ph. D. Citilabs, Inc. mwang@citilabs. com

Why Enterprise Data Model is Needed? Transportation modeling moving into enterprise environment • • Maintain a single repository for network data and modeling data • • Manage scenarios in an enterprise environment Allow multiple users to edit the same network data Allow multiple users to access the same modeling data Implement enterprise wide security policy on data maintenance, data access and data management Integrate with enterprise GIS system Transportation modeling data is available enterprise wide • • • Promote enterprise data sharing Eliminate data redundancy Reduce cost for data collection

What is Enterprise Data Model? • • • Master Network Model • Single network coverage • Support multi-modal network • Support multi-scenario network • Support multi-year network Public Transit Network Data Model Junction (Intersection) Data Model Scenario Management Data Model Transportation Metadata Model

How Enterprise Data Model is Implemented with Transportation Planning Software • • • Enterprise Data Management • Complete Enterprise Transportation Modeling Solution Enterprise Network Editing Enterprise System Integration (e. g. , Enterprise GIS integration)

Database Management Tools Server based database management • Data creation • Data Indexing • Data versioning • Data access control: user roles and user privileges • Concurrent transactional control • Data publishing: publish web services • Database replications • Data backup/restore and disaster recovery Geodatabase Manager Interface Tools • Metadata management • Input/output model data controls • Data Repository Management • Administrative tools for database management

Data Editing in Enterprise Environment Data Versioning • Support concurrent editing by multiple users - Versioning data for different users - Reconcile conflicts with base data Data Scenario Management • Control data editing on scenario based data - Creates child scenario data from parent scenario - Track Parent - Child scenario relationships within database Data Editing Tools • Network Editor - Edit highway network • PT Editor - Edit PT network and time tabling data • Junction Editor - Edit junction and movement data

Example Enterprise Database Solution Architecture Software Products Software Components Cube Base Data Manager Application Manager Scenario Manager Cube Data Connector Functional Libraries Arc. GIS Services Data Repositories Cube Arc. GIS Extensions Cube File Systems Cube Web Junction Analyzer Accessibility Analyzer Cube Voyager Data Web Services Cube Enterprise Database Remote Transportation Database

Thank You Contact Information: Minhua Wang, Ph. D. Citilabs, Inc. mwang@citilabs. com 703 -944 -4192