Now that the big picture is clear. Let’s get down to the actual realisation of this stuff warehousing infrastructure. Some similarities with IT engineering:
Tools:
- you need sql, a file editor…
- you need a saw, screwdrivers…
Bricks:
- planks, screws, cleats
- an ETL, a DBMS, etc…
Process:
- have to create the tables before designing the loading jobs
- have to build the main structure before adding the shelves
Anyways, here is a result I am proud of:
You should know that this piece of work successfully passed the integration tests, user acceptance tests and it handles the load pretty well.
Well, I guess this is the end of this series of posts about my diy weekends and the desperate need for numeric activities they foster.
