Cassandra

Data Model Map<RowKey, SortedMap<ColumnKey, ColumnValue>> CREATE KEYSPACE sports WITH REPLICATION = {'class' : 'NetworkTopologyStrategy', 'datacenter1' : 2}; # you can tune the r/w consistency level with keyspace Availability versus Consistency CREATE TABLE crossfit_gyms_by_city ( country_code text, state_province text, city text, gym_name text, opening_date timestamp, PRIMARY KEY ((country_code, state_province, city), opening_date, gym_name) ) WITH CLUSTERING ORDER BY ( opening_data ASC, gym_name ASC ); Cassandra RDBMS Keyspace Database Column Family Table Partition Key Primary Key Partitioner A partitioner determines how data is distributed across the nodes in the cluster (including replicas). ... Read more