When to use DSE Graph

A description of the environments when DSE Graph is the optimal choice for storing data.

DSE Graph inherits the benefits of Apache Cassandra as part of the DataStax Enterprise (DSE) database, while adding the ability to adapt to enterprise needs with other models such as graph or JSON data storage.

As an extension of the DSE database, DSE Graph reaps benefits if data is highly connected, revealing depth and breadth of the relationships between entities. DSE Graph uses query optimization that automatically processes as much of the query as possible in parallel, leading to increased performance.

Graph index structures create optimal entry points for queries, before starting a graph traversal. Graph partitioning handles vertices with extreme connectedness to prevent hotspots during the graph traversal.

Use DSE Graph to store data when the following characteristics are required:
  • Comprehensive data model
  • Data is database centric with single query
  • Entities and relationships are queried
  • Application is read heavy
Use the DSE database to store data when the following characteristics are required:
  • Heavy denormalization
  • Data is application centric with multiple queries
  • Individual entities are queried
  • Application is write heavy