Tags » Primary Key

Cassandra node vs partition: A simple explanation

As explained in How does Cassandra store data? – A simple explanation Cassandra uses partitioning key (the first part of primary key) to store a record into a partition on a node. 141 more words


Migrating SQL applications to Cassandra – Pattern #4

Pattern #4: Get rid of all OR operators from sql where clauses. For example, consider an SQL requirement to authenticate user by comparing the string entered by the user with either username… 76 more words


Cassandra Primary Key = ((Partitioning Key), Clustering Key): A simple explanation

Cassandra primary key (a unique identifier for a row) is made up of two parts – 1) one or more partitioning columns and 2) zero or more clustering columns. 526 more words


How and when to index data in Cassandra for fast and efficient retrieval? - A simple explanation

Cassandra is a multi-node, peer-to-peer cluster/distributed system that distributes/stores data across all nodes in the cluster.

Every table in Cassandra is physically stored in multiple SSTable files spread across one or multiple nodes.  296 more words


About relational databases

Speaking of Relational Databases, for some programmers, the normalization process and its levels are the subject of discussion.

For me, its clear that a good database design must include foreign keys (of course, if the database engine allows it). 430 more words


From Primary to Foreign

Keys that is. Hopefully you have understood how the primary key is constructed. Now you will learn about the foreign key. In the parent – child table relationship… 223 more words


What is Relational?

Strictly speaking it refers to a connection between people or things. For our purposes let’s use a simple example that will undoubtedly exist in real life. 250 more words