By Dana Gardner | Article Rating: |
|
September 15, 2010 04:27 PM EDT | Reads: |
11,848 |

Aster Data has taken big data management and analytics to the next level with the announcement today of its Aster Data nCluster 4.6, which includes a column data store and provides a universal SQL-MapReduce analytic framework on a hybrid row and column massively parallel processing (MPP) database management system (DBMS).
The San Carlos, Calif. company's new offering will allow users to choose the data format best suited to their needs and benefit from the power of Aster Data’s SQL-MapReduce analytic capabilities, as well as Aster Data’s suite of 1000+ MapReduce-ready analytic functions. [Disclosure: Aster Data is a sponsor of BriefingsDirect podcasts.]
Row stores traditionally have been optimized for look-up style queries, while column stores are traditionally optimized for scan-style queries. Providing both a row store and a column store within nCluster and delivering a unified SQL-MapReduce framework across both stores enables both query types.
Universal query framework
For example, a retailer using historical customer purchases to derive customer behavior indicators may store each customer purchase in a row store to ease retrieval of any individual customer order. This is a look-up style query. This same retailer can see a 5-15x performance improvement by using a column store to provide access to the data for a scan-style query, such as the number of purchases completed per brand or category of product. The Aster Data platform now supports both query types with natively optimized stores and a universal query framework.
Other features include:
- Choice of storage, implemented per-table partition, which provides customers flexible performance optimization based on analytical workloads.
- Such services as dynamic workload management, fault tolerance, Online Precision Scaling on commodity hardware, compression, indexing, automatic partitioning, SQL-MapReduce, SQL constructs, and cross-storage queries, among others.
- New statistical functions popular in decision analysis, operations research, and quality management including decision trees and histograms.
You may also be interested in:
Published September 15, 2010 Reads 11,848
Copyright © 2010 SYS-CON Media, Inc. — All Rights Reserved.
Syndicated stories and blog feeds, all rights reserved by the author.
- Mindspeed(R) Debuts a Complete Suite of Low-Power 11.3G Chipsets for SONET/SDH, Ethernet, Fibre Channel and Fiber-to-the-Premise Applications
- QuickLogic's CSSP Platform Provides Flexible Upgrade Path for Smartphones
- BlueTree Wireless Data unleashes additional capacity with Firmware Release 2.0
- Big Data Consolidation Enters Home Stretch as Teradata Buys Aster Data
- Big Data Analytics Improve Application Support | @CloudExpo #BigData
More Stories By Dana Gardner
At Interarbor Solutions, we create the analysis and in-depth podcasts on enterprise software and cloud trends that help fuel the social media revolution. As a veteran IT analyst, Dana Gardner moderates discussions and interviews get to the meat of the hottest technology topics. We define and forecast the business productivity effects of enterprise infrastructure, SOA and cloud advances. Our social media vehicles become conversational platforms, powerfully distributed via the BriefingsDirect Network of online media partners like ZDNet and IT-Director.com. As founder and principal analyst at Interarbor Solutions, Dana Gardner created BriefingsDirect to give online readers and listeners in-depth and direct access to the brightest thought leaders on IT. Our twice-monthly BriefingsDirect Analyst Insights Edition podcasts examine the latest IT news with a panel of analysts and guests. Our sponsored discussions provide a unique, deep-dive focus on specific industry problems and the latest solutions. This podcast equivalent of an analyst briefing session -- made available as a podcast/transcript/blog to any interested viewer and search engine seeker -- breaks the mold on closed knowledge. These informational podcasts jump-start conversational evangelism, drive traffic to lead generation campaigns, and produce strong SEO returns. Interarbor Solutions provides fresh and creative thinking on IT, SOA, cloud and social media strategies based on the power of thoughtful content, made freely and easily available to proactive seekers of insights and information. As a result, marketers and branding professionals can communicate inexpensively with self-qualifiying readers/listeners in discreet market segments. BriefingsDirect podcasts hosted by Dana Gardner: Full turnkey planning, moderatiing, producing, hosting, and distribution via blogs and IT media partners of essential IT knowledge and understanding.
Apr. 25, 2018 10:00 AM EDT Reads: 2,357 |
By Liz McMillan ![]() Apr. 25, 2018 09:30 AM EDT Reads: 2,208 |
By Yeshim Deniz Apr. 25, 2018 09:30 AM EDT Reads: 1,709 |
By Yeshim Deniz Apr. 25, 2018 08:30 AM EDT Reads: 461 |
By Pat Romanski Apr. 25, 2018 06:15 AM EDT Reads: 1,849 |
By Yeshim Deniz ![]() Apr. 25, 2018 04:45 AM EDT Reads: 5,205 |
By Elizabeth White ![]() Apr. 25, 2018 04:00 AM EDT Reads: 4,980 |
By Elizabeth White Apr. 25, 2018 04:00 AM EDT Reads: 1,977 |
By Liz McMillan ![]() Apr. 25, 2018 03:00 AM EDT Reads: 4,000 |
By Liz McMillan Apr. 25, 2018 12:45 AM EDT Reads: 2,753 |
By Pat Romanski ![]() Apr. 25, 2018 12:00 AM EDT Reads: 3,923 |
By Elizabeth White ![]() Apr. 24, 2018 11:00 PM EDT Reads: 3,687 |
By Pat Romanski Apr. 24, 2018 11:00 PM EDT Reads: 2,893 |
By Liz McMillan ![]() Apr. 24, 2018 09:30 PM EDT Reads: 22,796 |
By Elizabeth White ![]() Apr. 24, 2018 09:15 PM EDT Reads: 1,313 |
By Pat Romanski ![]() Apr. 24, 2018 08:45 PM EDT Reads: 4,137 |
By Elizabeth White ![]() Apr. 24, 2018 08:30 PM EDT Reads: 5,024 |
By Liz McMillan ![]() Apr. 24, 2018 07:00 PM EDT Reads: 13,816 |
By Elizabeth White ![]() Apr. 24, 2018 06:45 PM EDT Reads: 6,057 |
By Elizabeth White Apr. 24, 2018 06:30 PM EDT Reads: 5,644 |