200 likes | 430 Views
STAGED ELECTRONIC DATA DELIVERABLE (SEDD) - AN OVERVIEW AND STATUS REPORT. Dr. Anand R. Mudambi Environmental Protection Agency (USEPA) National Environmental Monitoring Conference Washington DC July 26, 2005. Federal Agency Need for Data in Electronic Format.
E N D
STAGED ELECTRONIC DATA DELIVERABLE (SEDD) - AN OVERVIEW AND STATUS REPORT Dr. Anand R. Mudambi Environmental Protection Agency (USEPA) National Environmental Monitoring Conference Washington DC July 26, 2005 SEDD/Dr. Anand R. Mudambi
Federal Agency Need for Data in Electronic Format • Collection of Large Amounts of Data Required to Make Various Environmental Decisions, Including: • Cleanup Remedies • Site Remediation End Points • Ease of Transmission, Receipt, Evaluation, Storage, and Retrieval • Efficient and Cost-Effective SEDD/Dr. Anand R. Mudambi
Problems with Current Electronic Data • Most data is received in proprietary formats (e.g., documents in Word or WordPerfect, spreadsheets in Excel or Lotus). • The business model for proprietary formats is PLANNED OBSOLESCENCE with little or no backward compatibility. • Thus, most data generated in these formats today will not be accessible 5-10 years from now. SEDD/Dr. Anand R. Mudambi
The Need for Open Data Standards • Eases data exchange between parties. • Allows all vendors/parties to compete on a level playing field. • Prevents individual monopolies locking a large market share into their proprietary formats. • Evolves to meet future needs. • Provides incentives for market forces to ensure backward compatibility. SEDD/Dr. Anand R. Mudambi
Open Data Standard Examples • HTML - Hypertext Markup Language (Used for the Web Pages on the Internet) • XML - eXtensible Markup Language (Becoming the Standard for Data Exchange) • GAML - General Analytical Markup Language SEDD/Dr. Anand R. Mudambi
XML eXtensible Mark-up Language.Standard devised by the World Wide Web Consortium. XML – A Self Defining Data Format • XML - eXtensible Markup Language • Final Recommended Standard by the World Wide Web Consortium • Each Piece of Data in XML Has a Tag (or Is Tagged) so the Data Set Electronic Data Deliverable (EDD) Is Self-Defined • Under SEDD, the EDD From the Laboratory Is Transmitted as an XML Document Based on a Document Type Definition (DTD) SEDD/Dr. Anand R. Mudambi
The Problem – Too Many EDDs • Laboratories Produce More than 300 Different EDDs • Most EDDs to Date Are Customer-Specific • Most EDDs Are Proprietary • No Stand-Alone, Self-Defining EDD Present - a Must in Case of Another National Emergency • No EDD Present That Meets Diverse Customer Needs for Detailed Analytical Chemistry Reporting SEDD/Dr. Anand R. Mudambi
The Solution - SEDD • Staged Approach Allows for Meeting Diverse Reporting Requirements • Eases Data Exchange between Various Parties • Analytical Data Delivered in XML Format (Non-Proprietary) • XML is Designed for Input into Various Databases SEDD/Dr. Anand R. Mudambi
Common SEDD Misconceptions SEDD Is NOT: • A Database • A Flat File • A Parser SEDD/Dr. Anand R. Mudambi
So What is SEDD? • SEDD is a hierarchal file created by a Laboratory Information Management System (LIMS) or any other database. • A SEDD file contains information regarding the chemical analysis of sample(s). • Information (analytical results) from a SEDD file can be reviewed and then input into customer databases using parsing routines. • Parsing routines need to be written ONLY once for each database type. SEDD/Dr. Anand R. Mudambi
Advantages of Using SEDD • For Laboratories - Reduce the Number of EDDs That They Support • For Data Requesters - Develop Common Automated Data Review Tools to Check EDDs • For Data Storage - EDDs Stored in Non-Proprietary Format SEDD/Dr. Anand R. Mudambi
Cost Savings Using SEDD • Laboratories are already delivering SEDD files for input into electronic review software. • Preliminary results show a 30 to 50% cost savings when compared to the same level of manual review. SEDD/Dr. Anand R. Mudambi
SEDD Status • Working on Pilots with Laboratories since 2002 • Laboratories (Including At Least One Major Network) and Two LIMS Vendors Are Already Delivering Compliant SEDD Stage 2 Files • SEDD Files Being Input and Checked by Automated Data Review Software SEDD/Dr. Anand R. Mudambi
SEDD Implementation • US Army Corps of Engineers (USACE) Formerly Used Defense Sites (FUDS) Policy Requirement - June 2004 • US EPA Region 10 Emergency Response - November 2004 • All EPA Regions Emergency Response - 2005 • US EPA Contract Laboratory Program (CLP) – Summer 2005 • USACE District Contracts – Summer 2005 SEDD/Dr. Anand R. Mudambi
SEDD Outreach • Working with US Department of Energy (DOE) Sites • Working with US Navy • Working with States • Working with the Private Sector SEDD/Dr. Anand R. Mudambi
What’s New with SEDD! • SEDD is being considered as an American Society for Testing and Materials (ASTM) standard for LIMS-to-LIMS data transfer. • SEDD is being embraced by the industry as it becomes a contract requirement. • SEDD Stage 4 is being developed with input from instrument manufacturers. SEDD/Dr. Anand R. Mudambi
SEDD Implementation Support • For Laboratories, SEDD Tool Provided by US EPA to Create SEDD Files • SEDD Files Can Also Be Created Using Vendor Support or by In-House Systems • For Contractors Working on Federal Projects, SEDD Parser and Automated Data Review (ADR)Software Is Available SEDD/Dr. Anand R. Mudambi
SEDD Implementation Support (con’t.) • For Federal Agencies, contract language for implementing SEDD is available. • For all parties interested in implementing SEDD, two courses are being offered at NEMC on Thurs July 28 • Morning – Technical Implementation of SEDD • Afternoon – SEDD Files: Automating the Parsing and Review of Analytical Data SEDD/Dr. Anand R. Mudambi
SEDD Implementation Support on the Web • A Web Page for SEDD Implementers • A List of Laboratories and Vendors Who Support SEDD (YOUR NAME HERE?) • A SEDD Q & A Web Page • A 10 Step Process for SEDD/ADR Implementation SEDD/Dr. Anand R. Mudambi
Contact Information • For more information regarding SEDD Implementation, please contact: - Anand Mudambi, Phone: 703-603-8796, email: mudambi.anand@epa.gov - Joe Solsky, Phone: 402-697-2573, email: joseph.f.solsky@usace.army.mil - The SEDD Web Page, located at: www.epa.gov/superfund/programs/clp/sedd.htm SEDD/Dr. Anand R. Mudambi