Turbo Charge Your Business Analytics with Solid State Drives
Solid state drives (SSDs) are a marvel, given that they offer the data persistence of storage, but with fast performance similar to memory. SSDs are very new, but they promise to clear many of the bottlenecks we suffer in business intelligence (BI), data warehousing (DW), and business analytics. For example, you can optimize a slow-running query many different ways, but you’re still held back by the fact that the query must fetch data from spinning disk. In other words, I/O simply takes time. The same fetch from a solid-state drive takes a fraction of the time.
As other example, in recent years BI/DW professionals in great numbers have turned to in-memory databases to speed up time-critical queries and table scans, whereas SSDs offer the speed of server memory, but with the added value of persistence. Likewise, any scenario that involves real-time or on demand information delivery and analytics would benefit from the speed of SSDs. Imagine speeding up the rescoring of analytic models or the complex queries of extreme SQL. Greater speed means a new level of effectiveness for time-sensitive business practices, like operational BI, performance management, and real-time analytics for risk, fraud, compliance, online customer interactions, and operational excellence.
Data profiling, data integration, and data quality go together like bread, peanut butter, and jam, because all three address related issues in data assessment, acquisition, and improvement. Because they overlap and complement each other, the three are progressively practiced in tandem, often by the same team within the same data-driven initiative. Hence, there are good reasons and ample precedence for bringing the three related practices together. The result is an integrated practice for data profiling, integration, and quality (dPIQ).
What you will learn:
- What SSDs are and why they’ll eventually be a common component in platforms for business intelligence (BI), data warehousing (DW), and business analytics
- Hardware and platform configurations in which server memory and SSDs handle hot data, while traditional drives handle data of cooler temperatures
- System performance data and configuration details
- Specific use cases in time-sensitive BI, DW, and analytics where SSDs can make a significant contribution
Philip Russom, Ph.D.