In-Database Analytics: A Passing Lane For Complex Analysis
A next-generation computational approach is earning front-line operational relevance for data warehouses, long a resource appropriate solely for back-office, strategic data analyses. Emerging in-database analytics exploits the programmability and parallel-processing capabilities of database engines from vendors Teradata, Netezza, Greenplum, and Aster Data Systems. The programmability lets application developers move calculations into the data warehouse, avoiding data movement that slows response time. Coupled with performance and scalability advances that stem from database platforms with parallelized, shared-nothing (MPP) architectures, database-embedded calculations respond to growing demand for high-throughput, operational analytics for needs such as fraud detection, credit scoring, and risk management.
Data-warehouse appliance vendor Netezza released its in-database analytics capabilities last May, and in September the company announced five partner-developed applications that rely on in-database computations to accelerate analytics.
"Netezza's [on-stream programmability] enabled us to create applications that were not possible before," says Netezza partner Arun Gollapudi, CEO of Systech Solutions. "Our engine for Profit Analytics generates and calls user-defined functions to compute complex functions based on a set of business rules. The resulting data mart build takes four to eight hours as compared to three to four weeks with traditional approaches." Gollapudi adds that even complex and multiple "what-if" scenarios can now be modeled and tested.
Table of Contents
In-Database Analytics: A Passing Lane For Complex Analysis
About the Author
InformationWeek is the business technology market's foremost multimedia brand. We recognize that business technology executives use various platforms for different reasons throughout the technology decision-making process, and we develop our content accordingly. The real-world IT experience and expertise of our editors, reporters, bloggers, and analysts have earned the trust of our business technology executive audience.
InformationWeek is the anchor brand for the InformationWeek Business Technology Network, a powerful portfolio of resources that span the technology market, including security with DarkReading.com, storage with ByteandSwitch.com, application architecture with IntelligentEnterprise.com, network architecture with NetworkComputing.com, communications with NoJitter.com and internet innovation with InternetEvolution.com.
Through its multi-media platform and unique content-in-context information distribution system, the InformationWeek Business Technology Network provides trusted information developed both by editors and real-world IT professionals delivered how and when business technology executives want it, 24/7.
Be the first one to comment.