Welcome to the 32nd CoffeeCAST with Stephen Hayward of Project X. Well welcome back. Today I have captured Graham for another fun discussion on Data Warehousing and Integration. So I am just finishing a great Starbucks Grande Bold and hope you have found a good coffee yourself for this CoffeeCAST and sit back while Grham and I chat about:
- Discussion on Cars – Environmentally friendly started by MIP‘s Smartcar (see my pic/post)
- Datawarehouse
- New Trends – Out from build to Support and Enhance
- Marts vs Warehouses (logical/physical)
- Master Data Management
- Customer Master File (CMF)
- Customer Information File (CIF)
- Data Integration
- In the Warehouse vs ETL
- DataStage and Informatica
- Teradata
- ELT (Sunopsis)
- Moving Data
So as always it was great to grab a chance to talk with Graham.
Download cc_32_warehouses_and_integration.mp3
Listen in and we hope you enjoy and more importantly, hope you join in the conversation. So drop a comment in the blog or send me an email and share your thoughts on the topic.
The audiocast is available on iTunes (as a Podcast) or here for download. Have a great day and join the conversation.
Podcast: Play in new window | Download
Who would have thought that the little warm-up dialogue in the beginning would elicite some great conversation.
Further info, if you are interested.
Ciao,
mip
http://www.autoblog.com/2006/03/25/five-diesels-from-europe-that-will-out-eco-a-prius/
Thanks for the link and added info. Those numbers being used are not the actual mileage being achieve though. Reference this study, done by governments across Canada who have been using the Prius. The study is here http://www.hybridexperience.ca/Toyota_Prius_Fuel_Performance.htm and indicates early on, for example, that the Prius as used by the BC government (one of the largest fleets in Canada) were only realizing 5.83L / 100KM.
This was one of the reasons I didn’t go for a hybrid. People I know who own one told me that their day-to-day driving habits (i.e. being stuck in traffic rather than continuous driving) did not allow them to realize the published fuel consumption targets. The Smart, I can confirm, is meeting those expectations. The rankings need to take into consideration the various “realities” of driving, such as weather. The first study I linked to took the various states of weather into consideration. Perhaps if you were going to drive a Prius all year long in Florida you might realize those rates, but, as per the study I linked to above, in Canada, they are not realizing those rates of consumption.
I agree with MIP completely, you’d have to buy a lot of gas to make up for the $14,000 difference in price between the Prius and the ForTwo. Assuming the third and fourth passengers are okay hanging onto the roof racks.
The source I was quoting from was:
http://oee.nrcan.gc.ca/transportation/personal/buying/energuide-winners.cfm?attr=8
There’s also a search page
http://oee.nrcan.gc.ca/transportation/tools/fuelratings/ratings-results.cfm?attr=8
Sorry about the lack of formating…The top 7 were:
Make/Model Class Eng Size/
# Cyl Trans #gears Fuel Consumption Rank CO2 kg per year
Type $/yr L/yr L/100km Class All
City Hwy
HONDA INSIGHT (HYBRID) T 1.0 / 3 M5+ X $504 720 3.9 3.3 1 1 1728
TOYOTA PRIUS (HYBRID) M 1.5 / 4 V X $574 820 4.0 4.2 1 2 1968
MERCEDES-BENZ SMART FORTWO CDI T 0.8 / 3 M6+ D $563 840 4.6 3.8 2 3 2269
MERCEDES-BENZ SMART FORTWO CDI CABRIOLET T 0.8 / 3 M6+ D $563 840 4.6 3.8 2 3 2269
HONDA CIVIC HYBRID C 1.3 / 4 V X $630 900 4.7 4.3 1 5 2160
VOLKSWAGEN GOLF TDI DIESEL C 1.9 / 4 M5+ D $737 1100 6.2 4.6 2 6 2970
VOLKSWAGEN NEW BEETLE TDI DIESEL S 1.9 / 4 M5+ D $737 1100 6.2 4.6 1 6 2970
Good coffeeCast but your research on fuel efficiency is a bit off. The Smart consumes less fuel than the Prius in tests that involve city driving, highway driving and combined driving, across all four seasons. How comes there is no link in your show notes to the data that is referenced? Here is a report that I looked at from transport Canada that shows that the Smart consumes 3.1L of fuel to go 100KM while he Prius consumes 3.8L of fuel to go 100KM.
http://www.tc.gc.ca/programs/environment/atvpgm/reports/tests/fc_9903.pdf
As well, the Prius starts at $31,000 which is considerably more than where the Smart starts which is approximately $17,000. You’d have to save a lot of gas to make up the $14,000 difference.