Configure Agent (Linux-slave) machine with Jenkins Master using SSH key file connection – as Oracle OS user. ▪️ The Linux (slave) agent machine to be configured using SSH key file as Oracle OS user. ▪️ We have earlier successfully configured Agent using SSH key… 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
Jenkins pipeline job to trigger commands/scripts based on time in Oracle DB server. ▪️ This job triggers the commands/scripts based on time (as Oracle user) in Oracle DB server (Jenkins Slave server) ▪️ This job will trigger the job similar to CRONJOB in Unix machine. What… Read More
Jenkins job to run SQL code in remote DB server. SQL code is executed (as shell file) in Oracle DB server (Jenkins Slave server) What is Jenkins: ▪️ Jenkins is a powerful tool that allows continuous integration (CI) and continuous delivery (CD) of projects, regardless of… Read More
Python Installation To write and execute the programs in python you have to download the python software. Python is open source, and it can be downloaded freely. 👉 Follow this link “https://www.python.org/” to download the python software you will find the page which is shown… 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
PHYSICAL DATA MODELING IN CASSANDRA Creating the physical model is a reasonably simple task once the logical data model has been developed. You go through each of the logical model tables, giving each object a type. Any valid CQL data type, including the basic kinds,… Read More
PYTHON Introduction Program: A program is a set of instructions that can be executed by the computer to perform a specific task. Purpose of using programs: 👉 To get accurate results. 👉 To get output very fast. We can write the programs using both the… 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
