Michigan DMR Data Exchange With EPA

Transcription

Michigan DMR DataExchange With EPAor “What I Node To Be True”Bill GeakeMichigan Department ofInformation Technology

Overview of DMR Data Flow ProcessPCSIDEF GenTranMI NodeClientRegulatedWastewaterFacilitiesLegacy CDXCDXNodeMichiganDEQDEQ DataCoding OperatorsUS EPA

Facility-to-State DMR Data FlowDBE-DMRDBRegulatedWastewaterFacilitiesNMSDBDEQ DMZDEQ IntranetMichigan DEQ

State-to-EPA DMR Data FlowPCSIDEF GenTranNMSDBMI NodeClientDEQ IntranetState of MichiganLegacy CDXCDX NodeEPA

Michigan Node Client ProcessingNMS DBDMRFlow.DLLE-DMRXML Michigan Node ClientIDEF MVXML File

EPA-to-State Feedback FlowIDEF PCS Report NotificationPCSIDEF GenTran ProcessorLegacy CDXReceipt AcknowledgementCDX NodeFrom StateEPA

EPA-to-State Feedback FlowPCS Update Audit ReportPCS RejectResolution UtilityCDX Web SiteNMS DBEPADEQ DataCoding OperatorState of Michigan

The BIG Picture80-Column text fileState NPDESPermit DatabasePCSEdit/Update Reports

The BIG PictureState NPDESPermit DatabasePCSIDEF GenTranIDEF XMLCDX Web SiteEdit/Update Reports(PDF Format)

The BIG PictureState NPDESPermit DatabasePCSIDEF GenTranCDX Web SiteEdit/Update Reports(PDF Format)IDEF XMLCDX Node

FLOWS are about PROCESSING! Two Aspects of Data Exchange:FormatData Container XML Schema ProcessRules surrounding the flow of data More complex than creating a format Can we have XML-based processinginstructions?

The “Ideal” Data Flow ScenarioOne Owner/Authority for a givendataset Each owner publishes to their node Nodes each provide a commoninterface for given data flow

The “Ideal” Data Flow Scenario Data Consumer should initiateRequests from the Data Provider“Come and get it” approachOnly the consumer knows what itneeds and when it needs itDataConsumerNodeWant MyData?No No No DataProviderNode

The “Ideal” Data Flow Scenario Data Provider should need NOknowledge of Data Requestor’sstate Complexity of storing data consumer’sstate on the provider sideNot as scalableDataConsumerNodeGimme the DataI Don’t HaveNope. Tell mewhat you want!!!DataProviderNode

The “Synchronization” Data Flow Scenario Push or Pull will workShould all happen in the backgroundOnly require user intervention when andexception occursDifficult to achieve when synchronizingheterogeneous systemsCrosswalking data what a mess!

Final Thoughts

The Ubiquitous “Questions” Slidewith Tacky WordArt

Michigan DMR Data Exchange With EPA or "What I Node To Be True" Bill Geake Michigan Department of Information Technology