{"id":1463,"date":"2012-11-22T11:06:53","date_gmt":"2012-11-22T19:06:53","guid":{"rendered":"http:\/\/bien.nceas.ucsb.edu\/bien\/?page_id=1463"},"modified":"2016-04-04T07:55:14","modified_gmt":"2016-04-04T15:55:14","slug":"bien-3-schema","status":"publish","type":"page","link":"https:\/\/bien.nceas.ucsb.edu\/bien\/biendata\/previous-bien-versions\/bien-3\/bien-3-schema\/","title":{"rendered":"Schema"},"content":{"rendered":"<p>The BIEN 3 database consists of two sets of tables: (1) a core database, containing the raw, normalized data, and (2) an analytical database, consisting of alternative denormalized views of the data from the core database, optimized for use in specific analyses. Most users will interact with the analytical database.<\/p>\n<p><strong>Core database<\/strong><\/p>\n<p><a href=\"http:\/\/bien.nceas.ucsb.edu\/bien\/wp-content\/uploads\/2012\/11\/vegbien.ERD_.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignleft size-full wp-image-1462\" title=\"BIEN 3 ERD\" src=\"http:\/\/bien.nceas.ucsb.edu\/bien\/wp-content\/uploads\/2012\/11\/vegbien.ERD_.png\" alt=\"BIEN 3 ERD\" width=\"1300\" height=\"2047\" srcset=\"https:\/\/bien.nceas.ucsb.edu\/bien\/wp-content\/uploads\/2012\/11\/vegbien.ERD_.png 1300w, https:\/\/bien.nceas.ucsb.edu\/bien\/wp-content\/uploads\/2012\/11\/vegbien.ERD_-190x300.png 190w, https:\/\/bien.nceas.ucsb.edu\/bien\/wp-content\/uploads\/2012\/11\/vegbien.ERD_-650x1024.png 650w, https:\/\/bien.nceas.ucsb.edu\/bien\/wp-content\/uploads\/2012\/11\/vegbien.ERD_-95x150.png 95w, https:\/\/bien.nceas.ucsb.edu\/bien\/wp-content\/uploads\/2012\/11\/vegbien.ERD_-400x629.png 400w\" sizes=\"(max-width: 1300px) 100vw, 1300px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>_________________________________________________________________________________________________<\/p>\n<p><strong>Analytical database<\/strong><\/p>\n<p>The heart of the BIEN 3 analytical database is the table analytical_aggregate. This table aggregates species observations both plots and specimens\u00a0within localities, and\u00a0is\u00a0therefore equivalent to the BIEN 2 table `observation` (or\u00a0`viewFullOccurrence`), very similar in structure. You can access the original table in PostgreSQL on server vegbiendev, or a copy in MySQL on server nimoy.<\/p>\n<p><a href=\"http:\/\/bien.nceas.ucsb.edu\/bien\/wp-content\/uploads\/2012\/11\/bien3_analytical_aggregate.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignleft size-full wp-image-1751\" title=\"bien3_analytical_aggregate\" src=\"http:\/\/bien.nceas.ucsb.edu\/bien\/wp-content\/uploads\/2012\/11\/bien3_analytical_aggregate.png\" alt=\"bien3_analytical_aggregate\" width=\"225\" height=\"673\" srcset=\"https:\/\/bien.nceas.ucsb.edu\/bien\/wp-content\/uploads\/2012\/11\/bien3_analytical_aggregate.png 225w, https:\/\/bien.nceas.ucsb.edu\/bien\/wp-content\/uploads\/2012\/11\/bien3_analytical_aggregate-100x300.png 100w, https:\/\/bien.nceas.ucsb.edu\/bien\/wp-content\/uploads\/2012\/11\/bien3_analytical_aggregate-50x150.png 50w\" sizes=\"(max-width: 225px) 100vw, 225px\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>The BIEN 3 database consists of two sets of tables: (1) a core database, containing the raw, normalized data, and (2) an analytical database, consisting of alternative denormalized views of the data from the core database, optimized for use in specific analyses. Most users will interact with the analytical database. Core database &nbsp; _________________________________________________________________________________________________ Analytical [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"parent":1385,"menu_order":5,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":"","_links_to":"","_links_to_target":""},"class_list":["post-1463","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/bien.nceas.ucsb.edu\/bien\/wp-json\/wp\/v2\/pages\/1463"}],"collection":[{"href":"https:\/\/bien.nceas.ucsb.edu\/bien\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/bien.nceas.ucsb.edu\/bien\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/bien.nceas.ucsb.edu\/bien\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/bien.nceas.ucsb.edu\/bien\/wp-json\/wp\/v2\/comments?post=1463"}],"version-history":[{"count":15,"href":"https:\/\/bien.nceas.ucsb.edu\/bien\/wp-json\/wp\/v2\/pages\/1463\/revisions"}],"predecessor-version":[{"id":2566,"href":"https:\/\/bien.nceas.ucsb.edu\/bien\/wp-json\/wp\/v2\/pages\/1463\/revisions\/2566"}],"up":[{"embeddable":true,"href":"https:\/\/bien.nceas.ucsb.edu\/bien\/wp-json\/wp\/v2\/pages\/1385"}],"wp:attachment":[{"href":"https:\/\/bien.nceas.ucsb.edu\/bien\/wp-json\/wp\/v2\/media?parent=1463"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}