1 / 15

Strategies & Technologies for Enterprise Data Management

Strategies & Technologies for Enterprise Data Management. Joe Pugh Enterprise Data Management January 24, 2014. Topics. Vision for Enterprise Data Management Basic Concepts of Linear Referencing Data Integration Data Analytics Next Steps. Vision Diagram.

bikita
Download Presentation

Strategies & Technologies for Enterprise Data Management

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Strategies & Technologies for Enterprise Data Management Joe PughEnterprise Data ManagementJanuary 24, 2014

  2. Topics Vision for Enterprise Data Management Basic Concepts of Linear Referencing Data Integration Data Analytics Next Steps

  3. Vision Diagram

  4. Linear Referencing System Basic Concepts • Linear referencing is defined as a method for storing geographic data by using a relative position along an already existing linear feature. • Linear Referencing Methods • Route Number and Mile Marker • Intersection and Offset • Street Name and Address Number • * Latitude and Longitude (X, Y)

  5. Previous Data Integration Pattern • More than 600 data exchanges in place • Worked well for expediency, but created long term problems

  6. Data Integration Concept Financial Data Data Exchange Broker HR Data Target System Data Exchange Broker

  7. Data Integration Objectives 1 2 3 4 5 Reduce point-to-point interfaces Minimize replication of data over and over Facilitate real-time data exchange Report success and failure of data transfers Internal / external system integration

  8. Current Data Integration DEB • Reducing hard dependencies between systems • Reusable ETL scripts = less custom code • Standard Data sets copied out of source only once • Errors are caught before the data goes to the target systems • All data exchanges are catalogued – and pre-approved by business owners

  9. Data Integration

  10. Temporal Data Analysis • Business Objectives… • The ability to answer temporal questions linking the road network as well as the transportation business events such as speed zones, crashes etc. • Ability to meet compliance and auditing requirements • Historical querying is complicated and unavailable to most • Ability to recover quickly during system crash or user errors • Ability to locate data as of a previous date. E.g. VDOT will use this for pavement data synchronization.

  11. Temporal Data Analysis Oracle Solution • Transparent to application • Updates applied from point in time • Ability to work with geospatial data

  12. Time Slider & Geo-database Archiving ESRI • Features • Visualizing, analyzing, and animating location and time-aware data provides opportunities for powerful storytelling…and a new dimension to managing data • Persists all edit history of a feature (i.e., roads) in the default version of the data. Allows for visualization of the data at a specific date/time. • Dynamic - safety service patrols, snowplows • Distinct - crashes, bridge inspections • Static - traffic volumes • Structural - routes, jurisdictions, census data

  13. ESRI Solution Time Slider Example – Mobile Phone Subscriptions Tools for desktop and web applications Source: ArcGIS.com

  14. Next Steps • Incorporating Smart Phones and Tablets for data collection and information dissemination • Dissemination of geospatial information from the cloud

More Related