This week’s review roundup includes reviews of Data Warehousing solutions. Choosing the right solution can be key for businesses as these solutions integrate data from disparate sources to create a central repository, or Warehouse. Here are some recent reviews from our community members of three Data Warehousing solutions:
Exadata – “We have a number of statistics collected before cutover on our legacy environment compared to Exadata. Without doing anything other than copying the data across, we saw significant performance gains for most key processes. We receive feedback from users stating how fast the performance is compared to other systems. Performance issues are few and far between. Our database environment is extremely stable compared to the legacy DB configuration. The patching process is a continually evolving. It’s changed drastically over the years and foresee some continued refinement on the horizon, especially when comparing the process to something like ODA. We have one one-off patch which requires a SR with Oracle Support every time the quarterly patch comes out. This is a bit of a pain but I do know sometimes these one-offs get rolled into the quarterly patch or in our case the next version (22.214.171.124). ” Read more here.
HP Vertica – “Not having to worry about speed or data volume changes you. Suddenly we began logging and reporting on everything. Where did users click? How long between clicks? How long does it take to type in a credit card number when you’re ready to pay? How much free memory does an iPad 1 have, and how does that change every second? Like all software engineers, we solve problems under constraints, and we had conditioned ourselves to think of logged data volume as a constraint. Suddenly that was no longer a constraint, but I would say it took us a full year to fully appreciate how powerful that was.” Read full review here.
SQL Server Data Warehouse – “Microsoft SQL Server Parallel Data Warehouse provides significant performance boost from 10-100 X times faster for data loading operation. It minimized the cost of design with lower infrastructure requirements. It is designed to provide optimized performance on latest industry hardware. It requires significant infrastructure expertise to implement. Possibility of over specified storage or under specified CPU (need proper planning before starting implementation) It requires significant SQL Server expertise. Microsoft SQL Server Parallel Data Warehouse is purposely built to provide high performance data warehousing. By adopting industry standard hardware it avoids vendor lock-in issue. It is best suited for mid-level to large scale organization.” Read full review here.