The solution to this dilemma was to add the database management system layer on top
of their established workflow. The researchers can acquire data, create models, perform
simulations and obtain results in their individual manner. They all agreed however to
structure the input data and the final results in a database management system so they can
profit from the advantages offered by a database regarding data structuring and retrieval.
The project partners also agreed to use the free and opensource database PostgreSQL
(PostgreSQL, 2010) due to its proven stability, its compatibility with opensource GIS
software and its (absence of) licence costs. The free and open source nature was one of the
major factors that influenced the decision, as commercial products usually have licence
and/or training costs that prove to be prohibitive for small research projects.
Moreover, as the researchers are physically distributed in various places in
Switzerland, the project decided for a common infrastructure distributed over the Internet.
The main idea of this concept is the distributed management of the data in different
databases. Each of these databases is located in the domain of a single data provider and is
maintained by this provider. This simplifies the workflow of the data provider since the
data is organized and stored according to the specific research needs of the individual
partner. As an additional benefit, if one of the databases fails, the data sources of the other
researchers are not affected.
The solution to this dilemma was to add the database management system layer on top
of their established workflow. The researchers can acquire data, create models, perform
simulations and obtain results in their individual manner. They all agreed however to
structure the input data and the final results in a database management system so they can
profit from the advantages offered by a database regarding data structuring and retrieval.
The project partners also agreed to use the free and opensource database PostgreSQL
(PostgreSQL, 2010) due to its proven stability, its compatibility with opensource GIS
software and its (absence of) licence costs. The free and open source nature was one of the
major factors that influenced the decision, as commercial products usually have licence
and/or training costs that prove to be prohibitive for small research projects.
Moreover, as the researchers are physically distributed in various places in
Switzerland, the project decided for a common infrastructure distributed over the Internet.
The main idea of this concept is the distributed management of the data in different
databases. Each of these databases is located in the domain of a single data provider and is
maintained by this provider. This simplifies the workflow of the data provider since the
data is organized and stored according to the specific research needs of the individual
partner. As an additional benefit, if one of the databases fails, the data sources of the other
researchers are not affected.
การแปล กรุณารอสักครู่..
![](//thimg.ilovetranslation.com/pic/loading_3.gif?v=b9814dd30c1d7c59_8619)