DataStax Blog

The Five Minute Interview – Workware Systems

By Robin Schumacher -  April 16, 2012 | 0 Comments

This article is one in a series of quick-hit interviews with companies using Apache Cassandra for key parts of their business.  For this interview, we talked to Don Ledford (Co-Founder & CTO) of Workware Systems Inc. in Seattle, WA.

DataStax: So Don, what’s Workware Systems all about?

Don: We produce intelligence collection and management systems, which sounds a little broad, but essentially we center on investigative case management and serve markets like government intelligence and law enforcement agencies, and other public organizations, as well as private enterprises.

DataStax: What kind of infrastructure and development environment do you have?

Don: Our applications are all web-based. We use Linux for our servers, and Java as the primary development language. We use Hector to connect to Cassandra.

DataStax: What caused you to go with Cassandra for your data store?

Don: We started working with relational databases, and began building things primarily with PostgreSQL at first.  But dealing with the kind of data that we do, the data model just wasn’t appropriate. We started with Cassandra in the beginning to solve one problem: we needed to persist large vector data that was updated frequently from many different sources. RDBMS’s just don’t do that very well, and the performance is really terrible for fast read operations. By contrast, Cassandra stores that type of data exceptionally well and the performance is fantastic. We went on from there and just decided to store everything in Cassandra.

DataStax: Why did you choose Cassandra over some of the other NoSQL options?

Don: There were two primary reasons. First, the data model allowed us to have very effective large vector handling. And second, the Cassandra community is vast, vibrant and extremely helpful; everyone is very responsive whereas other communities weren’t even close in that regard.

DataStax: What’s the typical configuration and data volume that you guys deal with?

Don: A normal setup for our customers is a couple of web servers, a 3-node Cassandra cluster, with a replication factor of 3, and a total data volume of around 12 terabytes.  That usually serves an organization like a police department with several thousand concurrent users very well. There are some larger law enforcement agencies that we’re beginning to work with that will necessitate a multi-data center setup for disaster recovery purposes.

DataStax: What kind of performance are you seeing with Cassandra?

Don: For a general million-plus set of objects and unstructured documents we see near instantaneous response time for reads and searches, which is great.

DataStax: Don – thanks for the time!

Don: You bet.

For more information on Workware Systems Inc., visit: http://workwaresystems.com

 



Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>