Conference Schedule - PGConf.EU 2019
Exploratory analytics and Health Big Data on PostgreSQL
Time: 14:40 - 15:30
Goals of health analytics consist in using trends to highlight the (underestimated) rising issue of antibiotic resistance, one of the biggest threats for patients safety in Europe. To do that, we need a huge amount of data that will be needed storage, management and querying in a relational schema. Of course, PostgreSQL was our choice to do that.
We will explore the ER model and simple queries which optimisation problem we ran into, and how we solved them. Then we'll explore analytics in depth using conditional expressions, aggregated values and date parsing, collecting and visualising results.
This talk aims to offer a different perspective on Postgres use cases, offering an insight of its power while doing exploratory analytics: databases are in fact the first instrument to perform data cleansing, descriptive statistics and time series analysis.