great video! a question - wondering what are the pros/cons of a separate revenue_fact table. It basically just has three extra columns (payment method, currency and payment date) when compared to booking_fact. Maybe it makes more sense to combine both revenue and booking fact table? curious to hear any thoughts about this. Thanks!
Why put attributes in the fact table? For instance, shouldn't booking_status have a separate dim? It is not an additive measure. It is an attribute no?
What kind of dbms are you going to use rowstore or columnstore? If you plan to use rowstore are you sure your read queries will work in scale of airbnb? If you plan to use columnstore how are you going to update the status of the booking? Columnstore dbs are terrible for mutable data.
This is being done for the purpose of the analytical purposes, hence columnstore is what should be ideally followed, imo. The data updates here if done through ETL should be done in batches which will not matter, and if done in realtime, then ELT would need to be used.
Everyone's burning question: Tool is SmartDraw
great video! a question - wondering what are the pros/cons of a separate revenue_fact table. It basically just has three extra columns (payment method, currency and payment date) when compared to booking_fact. Maybe it makes more sense to combine both revenue and booking fact table? curious to hear any thoughts about this. Thanks!
Why put attributes in the fact table?
For instance, shouldn't booking_status have a separate dim?
It is not an additive measure. It is an attribute no?
What kind of dbms are you going to use rowstore or columnstore? If you plan to use rowstore are you sure your read queries will work in scale of airbnb? If you plan to use columnstore how are you going to update the status of the booking? Columnstore dbs are terrible for mutable data.
This is being done for the purpose of the analytical purposes, hence columnstore is what should be ideally followed, imo. The data updates here if done through ETL should be done in batches which will not matter, and if done in realtime, then ELT would need to be used.
linking the listing_dim to host_dim or location_dim to listing_dim , will it not violate star schema?
Excellent
Thanks
What is the toolname used for modelling?
Great question!
what is the tool used here to draw ER ?
It's called "SmartDraw"!
What is the name of the tool used here?
Hey nwangwuuchechi7867, the tool is called SmartDraw!