Migrating to DSE Graph from Apache Cassandra
Factors to consider when migrating to DSE Graph from Apache Cassandra.
Migrating an Apache Cassandra™ database to DSE Graph requires analyzing how the data is stored
in the Cassandra tables. The following factors should be considered:
- A Cassandra table can represent a vertex and edges. Generally, the relationships will be duplicated amongst Cassandra tables due to denormalization. Identifying the entities and their relationships will require scrutinizing multiple tables.
- Cassandra table columns, especially clustering columns, are good candidates for property keys in DSE Graph.
A good starting point to build the graph data model is an entity-relationship (ER) diagram for the Apache Cassandra database. The ER diagram will show entities that will be vertex labels, entity attributes that represent property keys, and the relationships that will be edges in DSE Graph.