I have a new project to do an IA project ( predictive maintenace). I'm looking for an architecture to store the data for the Data scientist. We hesitate between PostgreSQL or Elasticsearch.
My proposititon currently is to use Elastcisearch as a Database. As my information, elasticsearch store data in a documents using indexes.
My question, is a data scientist can use this data ? And how he can access on it ?
I asked this question because usually I use PostgreSQL as a database, so a data scientist can access on a data because are stored in a tables. I would like to use Elasticsearch because it have many services like logstash to filter data, kibana to do a dashboards.
So I'm looking for this subject, if I use elastcisearch as a database, how a data scientist can access on a data.
Thanks in advance.