View Issue Details

IDProjectCategoryView StatusLast Update
0001083CaseTalk ModelerGeneration (SQL, XML, etc)public2016-09-30 12:01
ReporterBCP Software 
Assigned ToBCP Software 
PrioritynormalSeverityfeatureReproducibilityN/A
Status assignedResolutionopen 
Product Version 
Target VersionFutureFixed in Version 
Summary0001083: Cassandra Database support
DescriptionCan a Cassandra CQL plugin be added? The script is rather similar to SQL, with some minor and major differences.

http://docs.datastax.com/en/cql/3.1/cql/ddl/ddl_intro_c.html
TagsNo tags attached.

Relationships

Activities

BCP Software

BCP Software

2016-09-28 14:33

administrator   ~0000648

Composite primary keys for clustering can easily be generated by CaseTalk: Using the full rolepath for columns, it can nest columns to their initial place in the conceptual model. This will provide for proper clustering in Cassandra.

http://docs.datastax.com/en/cql/3.1/cql/cql_reference/refCompositePk.html
BCP Software

BCP Software

2016-09-28 14:51

administrator   ~0000649

Last edited: 2016-09-28 14:59

View 2 revisions

Perhaps a grouped model should be used in CaseTalk?

http://www.ippon.tech/blog/modeling-data-with-cassandra-what-cql-hides-away-from-you/

And try to optimize for queries. Master/Detail prepared table definitions and lookup tables for the one-to-many relationships.

http://www.ebaytechblog.com/2012/07/16/cassandra-data-modeling-best-practices-part-1/

Issue History

Date Modified Username Field Change
2016-09-28 14:29 BCP Software New Issue
2016-09-28 14:29 BCP Software Status new => assigned
2016-09-28 14:29 BCP Software Assigned To => BCP Software
2016-09-28 14:33 BCP Software Note Added: 0000648
2016-09-28 14:51 BCP Software Note Added: 0000649
2016-09-28 14:59 BCP Software Note Edited: 0000649 View Revisions