Big Data. Big Decisions
InformationWeek
Special Coverage Series


Apache's Cassandra Adds Column Data Analysis

Keynote at the Cassandra Summit outlined features in the 0.7 release of the NoSQL database system, notably support for secondary indexes.




Analytics Gallery: 2010 Data Center Operational Trends Report
(click for larger image and for full photo gallery)
NoSQL database system Cassandra recently launched the beta version its 0.7 feature improvement release with support for secondary indexes. The support makes it easier to analyze data found in a single column, such as finding a certain age grouping in a column of birth dates.

Cassandra is an open source project sponsored by the Apache Software Foundation to push forward the development of the key value store, NoSQL system. Jonathan Ellis, who founded the project while working for Rackspace, was the keynote speaker at the Cassandra Summit held at San Francisco's Mission Bay Conference Center Aug. 10. Current uses of Cassandra include Facebook, Digg, and Twitter, which stores 15 million tweets a day in Cassandra.

Ellis, in an interview, said the addition of secondary indexes to Cassandra makes it possible to index columns in the tables of the Cassandra database. Primary indexes, which are already supported, are based on rows in the database.

In addition, the 0.7 release includes support for rows that contain more than two GBs of data in Cassandra table; in the past two GBs was the limit for a row. The 0.7 release can also create families of columns while the database is running. Previously, a node needed to be shut down for a family to be generated from the data stored on it. A family can be queried and a response obtained more quickly than a query being required to review all the columns in the database, he said.

Ellis talked about the features of the 0.7 release in his address, The Present and Future of Cassandra. He was introduced by Bill Boebel, VP of strategy at Rackspace, who said Rackspace wished to contribute to open source projects that lead to more cloud computing software. As more users adopt the code, "we'll get a percentage of them" as cloud users in the company's cloud infrastructure offering. Rackspace is an investor in the company that Ellis co-founded, Riptano, to supply training and support. His partner was Matt Pfeil, also a former Rackspace employee.

Ellis said about 200 Cassandra users were at the summit. He asked attendees how many of them were using Cassandra in production systems and about a third indicated they were, he said. Boebel termed the Cassandra event "the biggest individual NoSQL event held thus far." MongoDB, a document-oriented, NoSQL system, held its own user conference in San Francisco May 3 with a similar number of attendees.

A non-scientific poll conducted by Hacker News among startup developers found the open source MySQL database system still the most popular choice for establishing a company database, followed by the PostgreSQL database project. On their heels came NoSQL systems, MongoDB, third, and CouchDB and Cassandra tied for sixth. Redis and Microsoft databases took the fourth and fifth place spots.

 1 | 2  | Next Page »


Related Reading


More Insights




Currently we allow the following HTML tags in comments:

Single tags

These tags can be used alone and don't need an ending tag.

<br> Defines a single line break

<hr> Defines a horizontal line

Matching tags

These require an ending tag - e.g. <i>italic text</i>

<a> Defines an anchor

<b> Defines bold text

<big> Defines big text

<blockquote> Defines a long quotation

<caption> Defines a table caption

<cite> Defines a citation

<code> Defines computer code text

<em> Defines emphasized text

<fieldset> Defines a border around elements in a form

<h1> This is heading 1

<h2> This is heading 2

<h3> This is heading 3

<h4> This is heading 4

<h5> This is heading 5

<h6> This is heading 6

<i> Defines italic text

<p> Defines a paragraph

<pre> Defines preformatted text

<q> Defines a short quotation

<samp> Defines sample computer code text

<small> Defines small text

<span> Defines a section in a document

<s> Defines strikethrough text

<strike> Defines strikethrough text

<strong> Defines strong text

<sub> Defines subscripted text

<sup> Defines superscripted text

<u> Defines underlined text

BYTE encourages readers to engage in spirited, healthy debate, including taking us to task. However, BYTE moderates all comments posted to our site, and reserves the right to modify or remove any content that it determines to be derogatory, offensive, inflammatory, vulgar, irrelevant/off-topic, racist or obvious marketing/SPAM. BYTE further reserves the right to disable the profile of any commenter participating in said activities.

Disqus Tips To upload an avatar photo, first complete your Disqus profile. | View the list of supported HTML tags you can use to style comments. | Please read our commenting policy.

Follow InformationWeek

By The Numbers

What Are Your Primary Concerns About Using Big Data Software?

Base: 417 respondents at organizations using or planning to deploy data analytics, BI or statistical analysis software
Data: InformationWeek 2013 Analytics, Business Intelligence and Information Management Survey of 541 business technology professionals, October 2012

What Do You Think?

What's your attitude about SQL analysis on top of Hadoop?
We want fast, standard SQL analysis capabilities on Hadoop ASAP
Hadoop is for unstructured data; SQL is for relational databases
We'll give SQL on Hadoop a try, but relational DBs will remain the mainstay
Given strong SQL support on Hadoop, we'd nix the data warehouse
We're not interested in Hadoop
No opinion



Related Content

From Our Sponsor

Five Big Data Challenges and How to Overcome Them with Visual Analytics

Five Big Data Challenges and How to Overcome Them with Visual Analytics

Business leaders often need a visual snapshot of data to quickly grasp and use it. This paper identifies five challenges in presenting data and how visual analytics can resolve them. Solutions are suggested to overcome the challenges of: speed, data clarity, data quality, displaying meaningful results, and dealing with outliers.

Game-Changing Analytics: How IT Executives Can Use Analytics to Create Innovation and Business Success

Game-Changing Analytics: How IT Executives Can Use Analytics to Create Innovation and Business Success

Today's competitive advantage requires a deeper understanding of your business, your market and your customers. As an IT executive, you can drive that knowledge transformation. In this white paper, learn how to make decisions as a strategic business leader and three steps to begin an analytics initiative within your enterprise.

Data Visualization Techniques: From Basics to Big Data with SAS Visual Analytics

Data Visualization Techniques: From Basics to Big Data with SAS Visual Analytics

High-performance data visualization turns sophisticated analyses into meaningful graphics, leading to faster and smarter decision making. In this white paper, learn how visual analytics can transform big data, with additional features such as real-time functionality, mobile compatibility, robust applications for technical groups and accessibility for nontechnical users.

Big Data: Lessons from the Leaders

Big Data: Lessons from the Leaders

Financial performance, competitive advantage, operational efficiency, strategic decision making - every business goal can extract value from big data, and the time for doubt or inaction has long passed. In this Economist Intelligence Unit report, in-depth interviews with data pioneers reveal the link between the effective use of big data and the bottom line among other results.

Decision-Driven Data Management: A Strategy for Better Decisions with Better Data

Decision-Driven Data Management: A Strategy for Better Decisions with Better Data

Which came first, the data or the decision? This white paper makes the case for having a decision in mind, then tailoring big data's volume, variety and velocity to achieve business results such as overcoming customer dissatisfaction or creating well-informed strategies in real time.

Informationweek Reports

Research: The Big Data Management Challenge

Research: The Big Data Management Challenge

The challenge of big data is real, but most organizations don't differentiate 'big data' from traditional data, and nearly 90% of respondents to our survey use conventional databases as the primary means of handling data. We'll help you understand what constitutes big data (it's not just size) and the numerous management challenges it poses.