Steve Jones - SSC Editor (7/19/2016)
Markus (7/19/2016)
I keep hearing so many folks are putting stuff in the cloud. Here they have just approved moving our Oracle data warehouse to RedShift. Many other like apps will also be moving to Amazon and Azure. I still question how our DWH on Exadata is going to perform in Redshift but they did a POC and it is lightening fast. Time will tell.Be interested to know how things work. Especially in whether the POC was realistic in data size.
Also, I think it's performance + cost, not just performance. There are tradeoffs to be made, and depending on your workload and users, this may or may not make sense.
Steve, the benefit they see is easy to scale up when demand is required... like acquiring another brand... new large app comes online..etc... the 'cost savings' will be eliminating an older Oracle system and those licenses plus eliminating 8 SQL Servers. They say they did a realistic POC with a good chunk of data.... The other benefit is taking the data directly from our POS systems in the stores and directly putting them into Redshift. Today there is an about 2 hour delay in that process before it arrives in our DWH systems. That will be cut to 15 minutes or less by directly loading it in and eliminate a lot of hardware/licenses.