Basics of Docker Containers: What are containers: ▪️ Containers are lightweight packages of your application code together with dependencies such as specific versions of programming language runtimes and libraries required to run your software services. ▪️ Containers make it easy to share CPU, memory, storage, and… Read More
DEFINING THE SCHEMA Dividing the large partitions: The objective is to create tables that, in the event that a single partition is touched by a query, can yield the necessary data. Nonetheless, it is feasible to create broad partition-style tables that go close to Cassandra’s inherent… Read More
EVALUATING AND REFINING DATA MODELS /*After you’ve produced a physical model, you’ll want to assess and tweak table designs to assist ensure optimal performance.*/ PARTITION SIZE CALCULATON: The first thing you should look for is if your tables will have too large partitions, or, to… Read More
LOGICAL DATA MODELING To start with Cassandra data modeling, we are ready to begin designing Cassandra tables. From the conceptual model we must create a logical model containing a table for each query, capturing entities and relationships. Then identify the primary entity type for which… Read More
RULES FOR DATA MODELLING IN CASSANDRA: Cassandra is a query language which is resembles with SQL, but the modulation of data is completely different when compared with other data types. In Cassandra, a worst model of data can lower the performance, especially when the data… Read More
WRITE PATHS IN CASSANDRA: TERMINOLOGY OF APACHE CASSANDRA: 👉 Gossips 👉 Partitioners 👉 Snitchers 👉 SSTables 👉 Tombstones 👉 Compactions Cassandra uses murmur3 partitioners and murmur3 algorithms to create Tokens. Cassandra Data Write Path: How Data Is Written: Data is processed by Cassandra at multiple points along… Read More
AZURE: Storage Account Creation Storage Account: 👉 An Azure Storage account is a fundamental resource that holds all your Azure storage data objects like blobs, queues, files and tables. 👉 It provides a unique namespace so that anyone can access through HTTP and HTTPS requests.… Read More
Different types of availability options Azure offers different types of availability options which includes. 1. No infrastructure redundancy required. 2. Availability zone 3. Virtual machine scale set 4. Availability set 1. No infrastructure redundancy required. • This does not provide any redundancy. • When you… Read More
Contrib Modules: In PostgreSQL, “contrib” stands for “contributed modules”. These are additional functionalities and features developed by the community that are not part of the core PostgreSQL distribution, but can be easily added to enhance the capabilities of the database. Contributed modules are distributed separately… Read More
JOIN OPERATION IN PostgreSQL: In PostgreSQL, the JOIN clause is used to combine rows from two or more tables based on a related column or condition. It specifies how the tables should be joined and on which columns the join should be performed. There are… Read More
