Difference between revisions of "Database"

From Berlin Harvesting and Indexing Toolkit
Jump to: navigation, search
(Created page with "The default database is MySQL. If you want to use another system, you will have to change the configuration (application.properties) and add the library.")
 
Line 1: Line 1:
 
The default database is MySQL. If you want to use another system, you will have to change the configuration (application.properties) and add the library.
 
The default database is MySQL. If you want to use another system, you will have to change the configuration (application.properties) and add the library.
 +
 +
 +
Data is saved two times:
 +
*first, the original data delivered by the provider is saved in the raw* tables (rawidentification, rawcoordinates, rawoccurrence, rawpreservationtype, rawhigher)
 +
*after running the quality tests, improved data is saved in tables without the raw prefix (identification, coordinates, occurrence, perservationtype, higher)

Revision as of 14:34, 16 November 2015

The default database is MySQL. If you want to use another system, you will have to change the configuration (application.properties) and add the library.


Data is saved two times:

  • first, the original data delivered by the provider is saved in the raw* tables (rawidentification, rawcoordinates, rawoccurrence, rawpreservationtype, rawhigher)
  • after running the quality tests, improved data is saved in tables without the raw prefix (identification, coordinates, occurrence, perservationtype, higher)