How To Create Index On Table in NoSQL Cassandra

Use index in Cassandra on a table having many row than contain te indexed value(low or normal cardinality). the more unique value that exist in a particular column, the more overhead you wil have, on average to query and maintenance the index. For example, suppose you hand

Read More

How to Create User Defined Type(UDT) in NoSql Cassandra

In this section we will learn how to create user defined Type for column of table. User-defined types (UDTs) can attach multiple data fields, each named and typed, to a single column.UDT can having Collection data type. The fields used to create a UDT may be any

Read More

How to using tuple Data Type Cassandra

Tuple data type is a fixed-length sets of typed positional fields. Use a tuple as an alternative to user-defined type(UDT). A Tuple can accommodate many fields(32768). When we create a table, for tuple datatype use angle brackets and a comma delimeter for the commponent types. Unlike other

Read More

Cassandra Data Manipulation (Insert, Update, Delete) using `cqlsh`

In previous section we learn creating user, keyspaces and managed table. Now we will learning how to insert, update, and deleting data in cassandra using cassandra.Operation DML ( Data Manipulation Language) similar to RDMS (Relational Database Management System). Using Keyword INSERT INTO for inserting data, keyword UPDATE

Read More

Create, Alter and Drop Table Cassandra

Create, Alter and Drop Table Cassandra Table in Cassandra is a collection of ordered (by name) columns fetched by row. A row consists of columns and have a primary key. The first part of the key is a column name. Subsequent parts of a compound key are

Read More

Keyspace Cassandra

A keyspace is a container that holds the column families, user defined types. In Cassandra, Keyspace is similar to schema RDBMS Database. Keyspace holds column families, indexes, user defined types, data center awareness, strategy used in keyspace, replication factor, etc. Syntax [crayon-5b00ddb391875091636280/] map is a JSON value

Read More

How To Manage Users NoSql Cassandra using `cqlsh`

In this tutorial we learn how to manage user in database cassandra. Setting the cassandra database using username and password authentication. Learn how to login using default username and password cassandra, create user with or without password, create user superuser and nosuperuser, modifying user and dropping user.

Read More

Spring Boot Using Hikari Connection Pool

# Spring Boot Using Hikari Connection Pool Connection Pool In software engineering, a connection pool is a cache of database connections maintained so that the connections can be reused when future requests to the database are required. Connection pools are used to enhance the performance of executing

Read More

Dynamic Call Store Procedure and Function Database

spring-boot-call-store-procedure Dynamic calling store procedure and store function in database Dynamic calling store procedure and function 1. Via Callable Statement 2. Via SimpleJdbcCall spring-boot-starter-jdbc See Code Snippets Store Procedure [crayon-5b00ddb392702067872429/]   Function [crayon-5b00ddb39270a313305179/]   Implementation Using SimpleJdbcCall [crayon-5b00ddb39270e418031959/]   3.1 Calling the store procedure [crayon-5b00ddb392712543881905/] 3.2 Calling

Read More

Rest Documentation with Swagger And Spring boot

Simple Spring-boot Swagger Documentation Learning Swagger documentation for rest. To Add Swagger to your application add the depedencies   [crayon-5b00ddb392c75012023614/]   create SwaggerConfiguration class [crayon-5b00ddb392c7d562082831/]     Add annotation swagger @ApiOperation on the Method endpoint. Example [crayon-5b00ddb392c81917462865/] @ApiModel and @ApiModelProperty this is used for tell consumer application

Read More