SBT Japan is a car exporter that sells used cars all over the world with its main offices in Japan. They coordinate the sourcing from dealers (refurbishing companies) who are in various locations and countries and delivery to various SBT international braches from where the customers purchase directly. Customers can also opt to import directly from them and SBT treats this as another branch called ‘online service’. They deal with products which are grouped into categories that include Station_Wagons, SUVs, Pickups, and Buses. Each of these categories also has the specific models such as Probox, Wingroad, Fielder for Station Wagon. SUV has models such as Juke, Forester, XTrail, Prado while Pick_ups models include Datsun, Ranger and Hilux. Buses have the following makes: Journey, Civilian, Rosa, and Coaster. Each sale done at the various branches must be stored in the data warehouse at the end of a 24-hour cycle with the following associated information: The dealer who supplied, the model (make), the branch that made the sale, the date of purchase, number of units and the associated revenue due to that sale. SBT has hired you to develop a data warehouse. i) Explain the considerations you would make for and against each of the following topologies: ‘star’, ‘galaxy’, ‘snow-flake’ or a ‘star-flake’ topology.
SBT Japan is a car exporter that sells used cars all over the world with its main offices in Japan. They coordinate the sourcing from dealers (refurbishing companies) who are in various locations and countries and delivery to various SBT international braches from where the customers purchase directly. Customers can also opt to import directly from them and SBT treats this as another branch called ‘online service’.
They deal with products which are grouped into categories that include Station_Wagons, SUVs, Pickups, and Buses. Each of these categories also has the specific models such as Probox, Wingroad, Fielder for Station Wagon. SUV has models such as Juke, Forester, XTrail, Prado while Pick_ups models include Datsun, Ranger and Hilux. Buses have the following makes: Journey, Civilian, Rosa, and Coaster.
Each sale done at the various branches must be stored in the data warehouse at the end of a 24-hour cycle with the following associated information: The dealer who supplied, the model (make), the branch that made the sale, the date of purchase, number of units and the associated revenue due to that sale.
SBT has hired you to develop a data warehouse.
i) Explain the considerations you would make for and against each of the following topologies: ‘star’, ‘galaxy’, ‘snow-flake’ or a ‘star-flake’ topology.
Step by step
Solved in 2 steps
