Software Open Access

bety: BETYdb 4.6

Scott Rohde; Carl Crott; mulroony; Jeremy Kemball; David LeBauer; Rob Kooper; 董伊琳; Jimmy Chen; andrewshirk; Zhengqi Yang; Max Burnette; MarvinJ; Uday Saraf; The Gitter Badger; Michael Dietze


DCAT Export

<?xml version='1.0' encoding='utf-8'?>
<rdf:RDF xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:adms="http://www.w3.org/ns/adms#" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:dct="http://purl.org/dc/terms/" xmlns:dctype="http://purl.org/dc/dcmitype/" xmlns:dcat="http://www.w3.org/ns/dcat#" xmlns:duv="http://www.w3.org/ns/duv#" xmlns:foaf="http://xmlns.com/foaf/0.1/" xmlns:frapo="http://purl.org/cerif/frapo/" xmlns:geo="http://www.w3.org/2003/01/geo/wgs84_pos#" xmlns:gsp="http://www.opengis.net/ont/geosparql#" xmlns:locn="http://www.w3.org/ns/locn#" xmlns:org="http://www.w3.org/ns/org#" xmlns:owl="http://www.w3.org/2002/07/owl#" xmlns:prov="http://www.w3.org/ns/prov#" xmlns:rdfs="http://www.w3.org/2000/01/rdf-schema#" xmlns:schema="http://schema.org/" xmlns:skos="http://www.w3.org/2004/02/skos/core#" xmlns:vcard="http://www.w3.org/2006/vcard/ns#" xmlns:wdrs="http://www.w3.org/2007/05/powder-s#">
  <rdf:Description rdf:about="https://doi.org/10.5281/zenodo.48661">
    <rdf:type rdf:resource="http://www.w3.org/ns/dcat#Dataset"/>
    <dct:type rdf:resource="http://purl.org/dc/dcmitype/Software"/>
    <dct:identifier rdf:datatype="http://www.w3.org/2001/XMLSchema#anyURI">https://doi.org/10.5281/zenodo.48661</dct:identifier>
    <foaf:page rdf:resource="https://doi.org/10.5281/zenodo.48661"/>
    <dct:creator>
      <rdf:Description>
        <rdf:type rdf:resource="http://xmlns.com/foaf/0.1/Agent"/>
        <foaf:name>Scott Rohde</foaf:name>
      </rdf:Description>
    </dct:creator>
    <dct:creator>
      <rdf:Description>
        <rdf:type rdf:resource="http://xmlns.com/foaf/0.1/Agent"/>
        <foaf:name>Carl Crott</foaf:name>
        <org:memberOf>
          <foaf:Organization>
            <foaf:name>&lt;( '.' &lt;) &lt;( '.' )&gt; (&gt; '.' )&gt;</foaf:name>
          </foaf:Organization>
        </org:memberOf>
      </rdf:Description>
    </dct:creator>
    <dct:creator>
      <rdf:Description>
        <rdf:type rdf:resource="http://xmlns.com/foaf/0.1/Agent"/>
        <foaf:name>mulroony</foaf:name>
      </rdf:Description>
    </dct:creator>
    <dct:creator>
      <rdf:Description>
        <rdf:type rdf:resource="http://xmlns.com/foaf/0.1/Agent"/>
        <foaf:name>Jeremy Kemball</foaf:name>
      </rdf:Description>
    </dct:creator>
    <dct:creator>
      <rdf:Description>
        <rdf:type rdf:resource="http://xmlns.com/foaf/0.1/Agent"/>
        <foaf:name>David LeBauer</foaf:name>
        <org:memberOf>
          <foaf:Organization>
            <foaf:name>University of Illinois</foaf:name>
          </foaf:Organization>
        </org:memberOf>
      </rdf:Description>
    </dct:creator>
    <dct:creator>
      <rdf:Description>
        <rdf:type rdf:resource="http://xmlns.com/foaf/0.1/Agent"/>
        <foaf:name>Rob Kooper</foaf:name>
        <org:memberOf>
          <foaf:Organization>
            <foaf:name>NCSA</foaf:name>
          </foaf:Organization>
        </org:memberOf>
      </rdf:Description>
    </dct:creator>
    <dct:creator>
      <rdf:Description>
        <rdf:type rdf:resource="http://xmlns.com/foaf/0.1/Agent"/>
        <foaf:name>董伊琳</foaf:name>
      </rdf:Description>
    </dct:creator>
    <dct:creator>
      <rdf:Description>
        <rdf:type rdf:resource="http://xmlns.com/foaf/0.1/Agent"/>
        <foaf:name>Jimmy Chen</foaf:name>
      </rdf:Description>
    </dct:creator>
    <dct:creator>
      <rdf:Description>
        <rdf:type rdf:resource="http://xmlns.com/foaf/0.1/Agent"/>
        <foaf:name>andrewshirk</foaf:name>
      </rdf:Description>
    </dct:creator>
    <dct:creator>
      <rdf:Description>
        <rdf:type rdf:resource="http://xmlns.com/foaf/0.1/Agent"/>
        <foaf:name>Zhengqi Yang</foaf:name>
      </rdf:Description>
    </dct:creator>
    <dct:creator>
      <rdf:Description>
        <rdf:type rdf:resource="http://xmlns.com/foaf/0.1/Agent"/>
        <foaf:name>Max Burnette</foaf:name>
        <org:memberOf>
          <foaf:Organization>
            <foaf:name>NCSA</foaf:name>
          </foaf:Organization>
        </org:memberOf>
      </rdf:Description>
    </dct:creator>
    <dct:creator>
      <rdf:Description>
        <rdf:type rdf:resource="http://xmlns.com/foaf/0.1/Agent"/>
        <foaf:name>MarvinJ</foaf:name>
      </rdf:Description>
    </dct:creator>
    <dct:creator>
      <rdf:Description>
        <rdf:type rdf:resource="http://xmlns.com/foaf/0.1/Agent"/>
        <foaf:name>Uday Saraf</foaf:name>
      </rdf:Description>
    </dct:creator>
    <dct:creator>
      <rdf:Description>
        <rdf:type rdf:resource="http://xmlns.com/foaf/0.1/Agent"/>
        <foaf:name>The Gitter Badger</foaf:name>
        <org:memberOf>
          <foaf:Organization>
            <foaf:name>Gitter</foaf:name>
          </foaf:Organization>
        </org:memberOf>
      </rdf:Description>
    </dct:creator>
    <dct:creator>
      <rdf:Description>
        <rdf:type rdf:resource="http://xmlns.com/foaf/0.1/Agent"/>
        <foaf:name>Michael Dietze</foaf:name>
        <org:memberOf>
          <foaf:Organization>
            <foaf:name>Boston University</foaf:name>
          </foaf:Organization>
        </org:memberOf>
      </rdf:Description>
    </dct:creator>
    <dct:title>bety: BETYdb 4.6</dct:title>
    <dct:publisher>
      <foaf:Agent>
        <foaf:name>Zenodo</foaf:name>
      </foaf:Agent>
    </dct:publisher>
    <dct:issued rdf:datatype="http://www.w3.org/2001/XMLSchema#gYear">2016</dct:issued>
    <dct:issued rdf:datatype="http://www.w3.org/2001/XMLSchema#date">2016-03-30</dct:issued>
    <owl:sameAs rdf:resource="https://zenodo.org/record/48661"/>
    <adms:identifier>
      <adms:Identifier>
        <skos:notation rdf:datatype="http://www.w3.org/2001/XMLSchema#anyURI">https://zenodo.org/record/48661</skos:notation>
        <adms:schemeAgency>url</adms:schemeAgency>
      </adms:Identifier>
    </adms:identifier>
    <dct:relation rdf:resource="https://github.com/PecanProject/bety/tree/betydb_4.6"/>
    <dct:description>&lt;a class="anchor" href="#summary-of-changes"&gt;&lt;span class="octicon octicon-link"&gt;&lt;/span&gt;&lt;/a&gt;Summary of Changes &lt;p&gt;New API and Use of Proper Datatypes&lt;/p&gt; &lt;p&gt;This release adds a new versioned API for adding new trait data and for querying most all data. It updates measurement and statistical data to use the proper datatypes and adds and modifies many features to make maintenance of BETYdb easier.&lt;/p&gt; &lt;p&gt;&lt;strong&gt;&lt;em&gt;Administrators need to do a database migration.&lt;/em&gt;&lt;/strong&gt;&lt;/p&gt; &lt;p&gt;See &amp;quot;Database Changes&amp;quot; below.&lt;/p&gt; &lt;a class="anchor" href="#new-api"&gt;&lt;span class="octicon octicon-link"&gt;&lt;/span&gt;&lt;/a&gt;New API &lt;p&gt;A new API (version v0) has been added for obtaining data in both JSON and XML formats. The new API also supports insertion of new trait data (provided in either JSON or XML format), something not provided by previous APIs. Documentation of this API is forthcoming. (A brief introduction is given in some of the comments to GitHub issues &lt;a href="https://github.com/PecanProject/bety/issues/381"&gt;https://github.com/PecanProject/bety/issues/381&lt;/a&gt; and &lt;a href="https://github.com/terraref/computing-pipeline/issues/52."&gt;https://github.com/terraref/computing-pipeline/issues/52.&lt;/a&gt;)&lt;/p&gt; &lt;a class="anchor" href="#new-features"&gt;&lt;span class="octicon octicon-link"&gt;&lt;/span&gt;&lt;/a&gt;New Features &lt;a class="anchor" href="#docker-files-for-application-packaging"&gt;&lt;span class="octicon octicon-link"&gt;&lt;/span&gt;&lt;/a&gt;Docker files for application packaging &lt;p&gt;Docker files have been added.&lt;/p&gt; &lt;a class="anchor" href="#travis"&gt;&lt;span class="octicon octicon-link"&gt;&lt;/span&gt;&lt;/a&gt;Travis &lt;p&gt;A Travis configuration file has been added in order to hook BETYdb into the Travis CI continuous integration service. This service will automatically run all of the non-Javascript based RSpec tests each time a new commit is pushed to GitHub.&lt;/p&gt; &lt;a class="anchor" href="#new-and-modified-rake-tasks"&gt;&lt;span class="octicon octicon-link"&gt;&lt;/span&gt;&lt;/a&gt;New and Modified Rake Tasks &lt;ul&gt; &lt;li&gt;&lt;p&gt;A new Rake task bety:db:populate has been added to make it easier for developers to get a new BETYdb instance up and running or to get a fresh copy of the BETYdb database. This is a wrapper for Pecan's load.bety.sh script and replaces the wrapper script update-betydb.sh for most use-cases relevant to the BETYdb developer.&lt;/p&gt;&lt;/li&gt; &lt;li&gt;&lt;p&gt;db:test:load_structure has been modified to behave correctly when using the postgis adapter. It will now drop the test database if it exists and then recreate it and load the database schema defined by the *_structure.sql file corresponding to the current environment. This makes it easier to set up the test database for testing, even if the other databases have not been set up.&lt;/p&gt;&lt;/li&gt; &lt;li&gt;&lt;p&gt;A description has been added for the Rake task db:test:clone_structure.&lt;/p&gt;&lt;/li&gt; &lt;li&gt;&lt;p&gt;The task db:fixtures:load has been disabled for all but the test environment. This will help prevent data loss caused by inadvertently running it in the wrong environment.&lt;/p&gt;&lt;/li&gt; &lt;li&gt;&lt;p&gt;The db:create task now only creates the database corresponding to the current environment. (When Rails.env was &amp;quot;development&amp;quot;, it used to also create the test database. Though perhaps useful, this seemed counterintuitive.)&lt;/p&gt;&lt;/li&gt; &lt;/ul&gt; &lt;a class="anchor" href="#bug-fixes"&gt;&lt;span class="octicon octicon-link"&gt;&lt;/span&gt;&lt;/a&gt;Bug Fixes &lt;ul&gt; &lt;li&gt;&lt;p&gt;Some missing model associations have been added. This should facilitate getting useful information from related tables via an API call.&lt;/p&gt;&lt;/li&gt; &lt;li&gt;&lt;p&gt;The script script/update-betydb.sh has been updated to make it consistend with the load.bety.sh script from the Pecan repository, for which it serves as a wrapper.&lt;/p&gt;&lt;/li&gt; &lt;li&gt;&lt;p&gt;Some fixes have been made to the Add-SQL-Geometry Python script (script/buildSQLGeom.py).&lt;/p&gt;&lt;/li&gt; &lt;li&gt;&lt;p&gt;A bug has been fixed in the header-normalization routine of the Bulk Upload wizard whereby any header (e.g. a trait name) containing the consecutive letters 'se' was getting capitalized. Now only the string 'se' itself is normalized (to 'SE'—Standard Error).&lt;/p&gt;&lt;/li&gt; &lt;/ul&gt; &lt;a class="anchor" href="#steps-needed-for-upgrade"&gt;&lt;span class="octicon octicon-link"&gt;&lt;/span&gt;&lt;/a&gt;Steps Needed for Upgrade &lt;a class="anchor" href="#database-changes"&gt;&lt;span class="octicon octicon-link"&gt;&lt;/span&gt;&lt;/a&gt;Database Changes &lt;p&gt;&lt;strong&gt;&lt;em&gt;Administrators need to do database migrations!&lt;/em&gt;&lt;/strong&gt;&lt;/p&gt; &lt;p&gt;The migration ChangeNumericsToFloats changes the datatype of all columns that were previously arbitrary precision numbers of type NUMERIC(16, 4) into double precision floating-point types. The columns in question are those used to represent values of trait, covariate, and yield measurements and the values of associated statistics (and also the parameter columns in the priors table). This helps to make the number of significant digits recordable for a particular measurement independent of the unit used for recording the measurement. Moreover, as the PostgreSQL documentation points out, &amp;quot;arithmetic on numeric values is very slow compared ... to the floating-point types&amp;quot;, so using floating-point types represents an improvement if computational features of SQL are to be used.&lt;/p&gt; &lt;p&gt;The database version for this release is 20160303221049.&lt;/p&gt; &lt;a class="anchor" href="#gem-installation"&gt;&lt;span class="octicon octicon-link"&gt;&lt;/span&gt;&lt;/a&gt;Gem Installation &lt;p&gt;&lt;strong&gt;&lt;em&gt;Administrators need to run the bundler to install new Ruby Gems related to the new API.&lt;/em&gt;&lt;/strong&gt;&lt;/p&gt; &lt;a class="anchor" href="#status-of-rspec-tests"&gt;&lt;span class="octicon octicon-link"&gt;&lt;/span&gt;&lt;/a&gt;Status of RSpec Tests &lt;ul&gt; &lt;li&gt; &lt;p&gt;All tests continue to pass when run in the default environment and can be run using the command&lt;/p&gt; bundle exec rspec &lt;/li&gt; &lt;li&gt; &lt;p&gt;Pass/failure status of the latest commits to GitHub are now shown at &lt;a href="https://travis-ci.org/PecanProject/bety"&gt;https://travis-ci.org/PecanProject/bety&lt;/a&gt;. Only the non-JavaScript based tests are run by Travis. To check the others, run&lt;/p&gt; bundle exec rspec -t js &lt;/li&gt; &lt;/ul&gt; &lt;p&gt;Complete details for running the rspec tests are on the updated Wiki page at &lt;a href="https://github.com/PecanProject/bety/wiki/Automated-Tests"&gt;https://github.com/PecanProject/bety/wiki/Automated-Tests&lt;/a&gt;&lt;/p&gt;</dct:description>
    <dct:accessRights rdf:resource="http://publications.europa.eu/resource/authority/access-right/PUBLIC"/>
    <dct:accessRights>
      <dct:RightsStatement rdf:about="info:eu-repo/semantics/openAccess">
        <rdfs:label>Open Access</rdfs:label>
      </dct:RightsStatement>
    </dct:accessRights>
    <dcat:distribution>
      <dcat:Distribution>
        <dcat:accessURL rdf:resource="https://doi.org/10.5281/zenodo.48661"/>
      </dcat:Distribution>
    </dcat:distribution>
    <dcat:distribution>
      <dcat:Distribution>
        <dcat:accessURL rdf:resource="https://doi.org/10.5281/zenodo.48661"/>
        <dcat:byteSize>13899845</dcat:byteSize>
        <dcat:downloadURL rdf:resource="https://zenodo.org/record/48661/files/bety-betydb_4.6.zip"/>
        <dcat:mediaType>application/zip</dcat:mediaType>
      </dcat:Distribution>
    </dcat:distribution>
  </rdf:Description>
</rdf:RDF>
29
7
views
downloads
All versions This version
Views 2928
Downloads 77
Data volume 97.3 MB97.3 MB
Unique views 2827
Unique downloads 77

Share

Cite as