1 / 15

SIS Database structure and architecture

SIS Database structure and architecture. NCEAS working group S.Barbara, 18 July 2001. Contents. The challenge The concept Status. The challenge. SIS must accommodate data on a huge variety of organisms Data requirements are not yet fully defined New data sets may need to be managed

Download Presentation

SIS Database structure and architecture

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. SIS Database structure and architecture NCEAS working group S.Barbara, 18 July 2001

  2. Contents • The challenge • The concept • Status

  3. The challenge • SIS must accommodate data on a huge variety of organisms • Data requirements are not yet fully defined • New data sets may need to be managed • New data sets may be needed for future products • Incomplete predefined output (e.g. products to be defined)

  4. The challenge • Define a minimum common denominator for all the information requirements of SSC • Create a modular data structure to accommodate future needs

  5. The concept • Species are central to all SSC information • Taxonomy is the main “authority list” of SIS • SIS is centred around a minimum set of “information objects” common to all taxa • More information can be added by adding new “information objects”

  6. The concept • Authority lists are: • Lists of keywords on a specific topic • A way to standardise information • A way to enable control of the information added to the database

  7. The concept • Information objects are: • Self-contained pieces of information, e.g.: • The species habitat description • The species geographic range • … • The way SIS implements modularity in the data structure

  8. The concept • SIS minimum set of information objects: • Red Listing Data • Population data • Geographic range • Habitat requirements • Conservation actions • References

  9. The concept Primary key to access information Objects containing different types of information Red Listing Data Population data Geographic range Habitat requirements Conservation actions References … SG modules Taxonomy Links

  10. Status • Data structure implemented in Access • All of the core information objects have their structure in SIS • Plans to migrate the structure under Oracle to enhance future compatibility

  11. Web enablingOverview • The Web Enabled SIS builds on the existing data structure of the stand alone SIS software package • It will enhance the existing functionalities of SIS to support concurrent access, data currency and broader accessibility

  12. Web enabling Overview

  13. Web enablingOverview • The Web Enabled SIS functionalities will be assembled to support to following main sets of applications • Specialist Tools • SG Administration • Biodiversity Analysis • Reader • CSU Administration

  14. Web enablingOverview • The Web Enabled SIS users will be grouped in the following categories • Specialist User • SG Data Authority • SG External Reviewer • Web User • SSC-CSU Internal User • SSC-CSU Administrator

  15. Specialist User (standalone application) LAN/WAN Internet (http) Specialist User (web application) SG Data Authority SG External Reviewer (web application) Biodiversity Analisys (JSP-Application) WESIS SSC-CSU (JSP-Application) WESIS SG Admin (JSP-Application) Published Internet Site WESIS SSC-CSU (JSP-Application) Admin Business Logic Specialist Tools Specialist Tools (JSP Application) WESIS Web User (web application) Web enablingSoftware architecture SSC-CSU Internal User WESIS Specialist Toolset Java Application (Swing U.I.) Java Client Communication Sync/Update Layer SSC-CSU Administrator http Local Sync/Update Business Logic Business Logic (Local A.S. OC4J) JDBC-NET8 Local RDBMS (Oracle 9i Lite) Oracle 9iAS Oracle 9i RDBMS

More Related