Database Sharding Concepts

Database sharding is a technique used to horizontally partition a database into smaller, more manageable pieces called shards. Each shard is essentially a separate database instance and contains a subset of the data. This approach allows for better scalability and Read More …

Design a database schema for an online merch store

Designing a database schema for an online merch store involves organizing data related to products, customers, orders, transactions, and other relevant information. Below is a simplified example of a database schema: This expanded schema includes additional details such as brand Read More …

How to handle data consistency in a Microservices architecture?

Data consistency in a microservices architecture can be a challenging aspect to handle due to the distributed nature of the system. Here are some strategies and patterns that can help you ensure data consistency: Remember that the choice of data Read More …

Relational Database Overview

Relational Database Architecture is a structured way of organizing data in a database management system (DBMS) that follows the principles of the relational model. The relational model was introduced by Edgar F. Codd in 1970 and has since become the Read More …

What is Database management System?

A Database Management System (DBMS) is software that allows users to create, manipulate, and manage databases. It serves as an intermediary between the users and the underlying database, providing an organized and efficient way to store, retrieve, update, and delete Read More …

How to select a right database?

Selecting the right database for your needs depends on various factors, including the nature of your data, the scale of your application, performance requirements, scalability, budget, and specific features you require. Here are some steps to help you in the Read More …

Best Relational Databases for Enterprise Application

Choosing the best relational database for an enterprise application depends on various factors such as the specific requirements of the application, scalability needs, performance expectations, data volume, budget, and existing infrastructure. Here are some popular and commonly used relational databases Read More …

Database Basic Concepts

Introduction The database is the backbone of any application. The success and failure of the application depend on various things and the database is also one of them. The performance of the application depends on the efficient and effective usages Read More …

SQL Query Performance Improvement Tips

Introduction The SQL query is a critical part of any software development and needs by many resources like – Developer – Tester – Lead – Manager – Management (Some Time) – Reporting Team All needs SQL query to get the Read More …

Oracle SQL Developer to generate an ER diagram

Introduction The Oracle SQL Developer is a pretty powerful and efficient tool to connect with the Oracle database and perform some useful utilities like Write PLSQL, SQL, Import, Export data, SQL performance and generate Entity Relationship Diagram. We will discuss Read More …

Oracle SQL Developer – Monitor Sessions

Introduction The database is a very important component of any software and needs to maintain and monitor properly. The main job of a database administrator is to monitor the database, he can monitor the activities of the database and its Read More …

DB – SQL Query to produce Result Randomly

Introduction Sometimes, The developer gets the requirement to produce a list of object or data in Random order. The Random order means that the developer should not control the order by using any other filtering criteria. The result should be Read More …

Read XML Data attribute Value From the Database through SQL Query

Introduction This is a very common situation where the user wants to read the contents of the XML file which store in the column with Data Type as a CLOB.This SQL is very specific to below-given XML and will vary Read More …

Pivoting rows into columns dynamically in Oracle Database SQL

Introduction The turning of rows to columns is a common requirement. The user can write a dynamic SQL query to turn rows to the column and vice-versa. Most of the database has some inbuilt function which helps to achieve this Read More …

Database SQL – Bulk Insert And Update

Introduction This tutorial helps to explain and write complex SQL Query which needs to create temporary tables and does bulk update or insertion. This is a common requirement for every project where data migration required to fetch the data from Read More …

Change Oracle password using SQL*Plus

Change or Reset Password using SQL Plus This tutorial helps to change the password using the command prompt, please follow below step by step instruction – Open the command prompts Type “sqlplus username@databasename“ Once hit enter button then it will Read More …

Set a custom date time format in Oracle SQL Develover

Introduction It is very important to set custom date time format for date column in Oracle as By default, Oracle SQL developer displays date values as 08-NOV-16. If a user wants to see the time part (hour/minute/second) by default then Read More …

Java DB Setup with Example

Introduction Sun Microsystems recently announced that it is distributing and supporting Java DB based on the 100 percent Java technology, open-source Apache Derby database. Derby was previously available under its earlier name, Cloudscape, from its former owners: Cloudscape, Informix, and IBM. IBM Read More …

Migrating Oracle SQL Developer Connections With Encrypted Password

Introduction This tutorial will help to migrate Database connection between SQL Developer(S). It is very helpful and quick when you export and import already existing database connection from one machine to other machine. it reduces a lot of effort and Read More …

IBM Curam KeyServer Generation

Introduction This tutorial aims to explain KeyServer generation technique for unique value for a specific column for one or more tables. Curam provides a technique to generate unique IDs across the application tables based on KeyServer name. The goal is to Read More …

H2 Database Configuration For IBM Curam

Introduction H2 is a Relational Database Management system(RDBMS) purely written in Java. It can be embedded in java application or run as a client server application mode. It is having very important and light weight feature like – Very fast, Read More …

Oracle Database Connection With Examples

To achieve this, JDBC specifications are agreed upon within the Java community–and each database vendor is then left to implement these specification to work with their product. Oracle Drivers Oracle provided two types of Drives. Thin OCI OCI   The OCI Read More …

DB2 Database Connection With Examples

An Example of connecting to DB2 Database using JDBC Driver. A typical example code of connect to database will look like this Class.forName(jdbcClassName); Connection connection = DriverManager.getConnection(url, user, password);   Listed below are connection examples for three common JDBC drivers Read More …

MySQL Database Connection With Examples

Introduction MySQL is a popular open source database which can be used free of charge. MySQL is a relational database. Web applications can use this database to store persistence data. This post explains how to set up Java applications to Read More …