Harmonized Data Source - Use PostgreSQL for the HDS DBMS

status: {proposed | rejected | accepted | deprecated | … | superseded by ADR-0005}

date: {YYYY-MM-DD when the decision was last updated}

deciders: entire TSC and AWG.  Not controversial

Use PostgreSQL as the database management system for a relational Harmonized Data Store

Context and Problem Statement

The Harmonized Data Store should be implemented using well known technologies and utilize open source solutions if possible.

Decision Drivers

• open source for dbms

• experience and familiarity to the community of potential developers

Considered Options

• MongoDB

• PostgreSQL

• Oracle, SQL Server, MySQL

Decision Outcome

Chosen option: "PostgreSQL", because it is open source and relational technology is familiar to most development organizations.

Consequences

• Good, because learning curve is small

• Good, because no extra cost or setup complexity

Validation

??

Pros and Cons of the Options

MongoDB

• Good, because easy to add data and extract data

• Good, because schema on write

• Bad, because experience limited in potential maintainers

• Bad, because proprietary system