Home > File Archive > Documents > Informatics > Database Schemas

Documents - Informatics - Database Schemas

Category Theme Document  (click on title to view file details) Download
Informatics Database Schemas Entity-relationship diagram for the GCE_Metabase2 Database
Abstract - This PDF file contains an annotated database schema image (entity-relationship diagram) for the refactored GCE Metadata Database (GCE_Metabase2) as implemented using SQL Server 2000. The diagram lists all tables and attributes as well as attribute data types and foreign key relationships between tables. This database is used to manage metadata for all GCE-LTER data sets as well as GCE personnel and tabular geographic information. This database can be queried on the WWW at http://gce-lter.marsci.uga.edu/public/app/data_catalog.asp.
(contributed by Wade Sheldon, 2011)
PDF file
    Entity-relationship diagram for the Research Projects tables in the GCE_Submissions database
Abstract - This PDF file contains an annotated database schema image (entity-relationship diagram) for the research project management tables in the GCE Submissions Database (GCE_Submissions), as implemented using SQL Server 2000. The diagram lists all tables and attributes as well as attribute data types and foreign key relationships between tables. This database is used to manage research project information linked to personnel, publications, study sites, data sets and other resources managed in GCE databases. Registered research projects can be viewed at http://gce-lter.marsci.uga.edu/public/research/projects.asp, and also from links on GCE research question pages and data set summary pages.

This database was designed to comply with the LTER Projects Database schema (http://intranet.lternet.edu/im/project/LTERProjectDatabase), and project-eml XML documents are dynamically generated using database views and a web application.

(contributed by Wade Sheldon, 2009)
PDF file
    Entity-relationship diagram for the File Archive Tables in the GCE Submissions Database
Abstract - This PDF file contains an annotated database schema image (entity-relationship diagram) for the file archive tables in the GCE Submissions Database (GCE_Submissions), as implemented using SQL Server 2000. The diagram lists all tables and attributes as well as attribute data types and foreign key relationships between tables. This database is used to manage the GCE document and imagery archive, which is cross-referenced to the GCE Bibliographic Database and GCE Taxonomic Database to provide integrated searching for public and private file resources. This database can be queried on the WWW at http://gce-lter.marsci.uga.edu/public/app/resource_search.asp.
(contributed by Wade Sheldon, 2008)
PDF file
    Entity-relationship diagram for the GCE Bibliographic Database
Abstract - This PDF file contains an annotated database schema image (entity-relationship diagram) for the GCE Bibliographic Database (GCE_Biblio) as implemented using SQL Server 2000. The diagram lists all tables and attributes as well as attribute data types and foreign key relationships between tables. This database is used to manage all bibliographic citations for the GCE-LTER project as well as the Georgia Rivers LMER project and University of Georgia Marine Institute (UGAMI). This database can be queried on the WWW at http://gce-lter.marsci.uga.edu/public/app/biblio_query.asp.
(contributed by Wade Sheldon, 2007)
PDF file
    Entity-relationship diagram for the GCE Metadata Database
Abstract - This PDF file contains an annotated database schema image (entity-relationship diagram) for the GCE Metadata Database (GCE_Metabase) as implemented using SQL Server 2000. The diagram lists all tables and attributes as well as attribute data types and foreign key relationships between tables. This database is used to manage metadata for all GCE-LTER data sets as well as GCE personnel and tabular geographic information. This database can be queried on the WWW at http://gce-lter.marsci.uga.edu/public/app/data_catalog.asp.
(contributed by Wade Sheldon, 2007)
PDF file
    Entity-relationship diagram for the GCE Research Cruise database
Abstract - This PDF file contains an annotated database schema image (entity-relationship diagram) for a prototype GCE Cruise Database as implemented using SQL Server 7. The diagram lists all tables and attributes as well as attribute data types and foreign key relationships between tables. This database is under development and is not fully populated.
(contributed by Wade Sheldon, 2007)
PDF file
    Entity-relationship diagram for the GCE Taxonomic Database
Abstract - This PDF file contains an annotated database schema image (entity-relationship diagram) for the GCE Taxonomic Database as implemented using SQL Server 2000. The diagram lists all tables and attributes as well as attribute data types and foreign key relationships between tables. This database is used to manage taxonomic information for all organisms listed in GCE-LTER species lists and data set metadata. This database can be queried on the WWW at http://gce-lter.marsci.uga.edu/public/app/all_species_lists.asp.
(contributed by Wade Sheldon, 2007)
PDF file
7 Records
LTER
NSF

This material is based upon work supported by the National Science Foundation under grants OCE-9982133, OCE-0620959 and OCE-1237140. Any opinions, findings, conclusions, or recommendations expressed in the material are those of the author(s) and do not necessarily reflect the views of the National Science Foundation.