0001083: Cassandra Database support

ID	Project	Category	View Status	Date Submitted	Last Update

0001083	CaseTalk Modeler	Generation (SQL, XML, etc)	public	2016-09-28 14:29	2016-09-30 12:01

Reporter	BCP Software	Assigned To	BCP Software
Priority	normal	Severity	feature	Reproducibility	N/A
Status	assigned	Resolution	open
Target Version	Future

Summary	0001083: Cassandra Database support
Description	Can 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
Tags	No tags attached.

CaseTalk Edition

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 2016-09-28 14:51 administrator ~0000649 Last edited: 2016-09-28 14:59	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/

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