Data Warehousing

[brancengregory]

I'm going to drop The Links™️

[brancengregory]

• https://www.nuwavesolutions.com/snapshot-fact-tables/
• https://dwbi1.wordpress.com/2019/02/20/transactional-fact-tables/
• https://www.ibm.com/docs/en/ida/9.1?topic=models-fact-tables-entities
• https://stackoverflow.com/questions/43827048/data-warehouse-how-to-create-a-fact-table-interecting-all-dimensions-with-r-an
• https://cran.r-project.org/web/packages/starschemar/vignettes/starschemar.html
• https://dzone.com/articles/olap-operation-r

[brancengregory]

'Databases use OnLine Transactional Processing (OLTP) to delete, insert, replace, and update large numbers of short online transactions quickly. This type of processing immediately responds to user requests, and so is used to process the day-to-day operations of a business in real-time. For example, if a user wants to reserve a hotel room using an online booking form, the process is executed with OLTP.

Data warehouses use OnLine Analytical Processing (OLAP) to analyze massive volumes of data rapidly. This process gives analysts the power to look at your data from different points of view. For example, even though your database records sales data for every minute of every day, you may just want to know the total amount sold each day. To do this, you need to collect and sum the sales data together for each day. OLAP is specifically designed to do this and using it for data warehousing 1000x faster than if you used OLTP to perform the same calculation."

[brancengregory]

• https://cdn.rawgit.com/jangorecki/jangorecki.github.io/master/_posts/Data-Warehousing-with-R.html#1
• https://community.rstudio.com/t/case-studies-of-using-r-as-etl-tool-for-data-warehousing/74610/3
• https://dsotm-rsa.space/post/2019/10/03/building-a-data-warehouse-r-postgresql-bash-and-task-scheduler/

[brancengregory]

• https://en.wikipedia.org/wiki/Dimensional_modeling