Posts Written By: srigalamilitan

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 a playlists table with a billion songs and […]

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 valid data type, including collections and other existing […]

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 “composed” types (collections and UDT), a tuple is […]

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 table_name SET columns WHERE conditional for updating data, […]

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 other column names that define the order of […]

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

map is a JSON value A map of properties and values defines the […]

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. Create user Syntax for create user

Before […]

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 commands on a database. Opening and maintaining a […]

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


  Implementation Using SimpleJdbcCall

  3.1 Calling the store procedure

3.2 Calling the Stored function

Implementation using CallableStatement


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  

  create SwaggerConfiguration class

    Add annotation swagger @ApiOperation on the Method endpoint. Example

@ApiModel and @ApiModelProperty this is used for tell consumer application about information about the property (response/ request) example […]