1 / 0

Is it time to reach for the cloud(s)? A service provider approach to collection databasing

Is it time to reach for the cloud(s)? A service provider approach to collection databasing. Norman Johnson Department of Evolution, Ecology & Organismal Biology C.A. Triplehorn Insect Collection The Ohio State University. Databasing at Triplehorn Collection. ASC Information Model

rafal
Download Presentation

Is it time to reach for the cloud(s)? A service provider approach to collection databasing

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. Is it time to reach for the cloud(s)? A service provider approach to collection databasing

    Norman Johnson Department of Evolution, Ecology & Organismal Biology C.A. Triplehorn Insect Collection The Ohio State University
  2. Databasing at Triplehorn Collection ASC Information Model extensions for data on literature, digital objects, web interfaces Implemented in RDBMS Running on Dell Power Edge 2900 dual core server Solaris operating system (version of UNIX) originally deployed in mid-1990’s
  3. Database Objectives management of primary occurrence data primarily specimen label data web accessibility available database engines at that time all stand-alone do something productive with the data therefore, not limited to collection management applications in taxonomic research
  4. Data Entry – batch mode
  5. Data Entry – individual record mode
  6. Data security Oracle functionality defined roles and select/insert/update privileges direct access to db objects highly limited Most data entry tasks go through web-based applications Daily backups
  7. Likes/Dislikes – Pros/Cons robust, scalable, stable platform standards compliant PL/SQL programming environment procedures, functions, packages Ohio State site license for Oracle normalized database schema web-based interface work anywhere need only a web browser, no special software ability to have specialized portals
  8. Application Service Providers E-Mail providers HotMail: 369 million users Yahoo Mail: 302 million users Gmail: 193 million users Used with web browsers access anywhere in the world Data stored centrally Data and system management issues are invisible to users Why is there no similar service for collection databasing?
  9. Cloud Computing Option for Collection Databasing Cons loss of complete local autonomy potential loss of privacy: others have access to data loss of immediate responsiveness to needs
  10. Cloud Computing Option for Collection Databasing Cons loss of complete local autonomy potential loss of privacy: others have access to data loss of immediate responsiveness to needs Pros implementation of data standards make use of existing functionality no hardware upgrades or replacements no software upgrades or replacements data backup GBIF data sharing new expectations from iDigBio/NSF ?
  11. Economics many collection databasing applications are free, but: costs for system administration managing operating system computer hardware Internet security costs of database administration software upgrades data migration data backup, off-site storage these costs are replicated in every institution
  12. Specimen Data Entry: $145/1K spms/year Data Maintenance: $9/1K spms/year
  13. Long Term Plan for Accessibility at Ohio State Operating costs supported by endowments from Josef N. Knull and Dorothy Johnson Knull Newly created Biodiversity Informatics staff position full-time position in Dept. of Evolution, Ecology & Organismal Biology cost recovery from users Joe Cora B.S. in Computer Science worked in insect collection since freshman year Ultimate insurance policy: DwC archives
  14. Acknowledgments Luciana Musetti, Joe Cora, Sara Hemly J.N. & D.J. Knull Funds; National Science Foundation grant DBI-0749705
More Related