Postgres as BI platform for largest Irish pharmacy supplier’s chain
Our experience and lessons learned
Database Architect in a wide variety of business applications.
Strongly interested in server and relational database design using Postgres and Rails.
Started to work with database since 2006, began with Oracle, but later on fallen in love with Postgres.
Speaker of pgconf.ru (2017, 2019), pgconf.asia (2017)
Now is engaged in development of BI platform based on Postgres for largest pharmaceutical selling group in Ireland.
No video of the event yet, sorry!
Today BI platforms are typical instrument to make proper decisions on data in almost every size business. Market is full of cloud based as well as on-premises solutions, but sometimes companies are making decisions to build in-house solutions.
I will talk about our BI application which we built on Postgres for largest Irish pharmacy supplier’s chain. We will review business requirements shortly. Later on I will describe specific of our architecture, why we chose snowflake scheme and how we are doing extract, transformation and load procedures.
It will be mentioned about special Postgres tuning for OLAP and massive data bulk load workloads. Also I will let you know about Postgres usage as a column database with cstore_fdw by Citus and results achieved. Cons and problems of our approach will be described in the end of the talk.
- 2019 June 21 - 09:00
- 50 min
- PostgreSQL Ibiza
- Track 2
- [x],[y],zheap - What is it good for?
- Start Time:
- 2019 June 21 09:00