So You Think You’re Ready for a Data Warehouse Appliance, Part 2
As I wrote in last weekâs blog post, a data warehouse appliance simplifies platform and system resource administration. It doesnât simplify the traditional time-intensive efforts of managing and integrating disparate data and addressing performance and tuning of various applications that contend for the same resources.
Many data warehouse appliance vendors offer sophisticated parallel processing environments, query optimization, and specialized storage structures to improve query processing (e.g., columnar-based engines). Itâs naïve to think that taking data from an SMP (Symmetric Multi-Processing) relational database and moving it into a parallel processing environment will effectively scale without any adjustments or changes. Moving onto an appliance can…
You must log in to post a comment.