Databases

Need to install the ELK stack on Ubuntu 18.04 or 20.04? Follow this guide and set up each layer of the stack - Elasticsearch, Logstash, and Kibana.

MongoDB allows storing different fields in different documents, without a permanently fixed data structure. To set up MongoDB on CentOS 8, follow this step-by-step guide and install and configure the popular NoSQL database.

Install Redis on Ubuntu 20.04 in a couple of simple steps by following this tutorial. This guide also shows you how to set up the basic configuration and password authentication by modifying the Redis configuration file.

The process for creating tables in Cassandra depends on what type of information you want to query. Follow the instructions in this guide to create a table in Cassandra using different types of keys, and to learn how to alter, drop, or truncate a table.

The DROP statement is a simple method to remove entire tables from your databases. It provides several versatile options that allow you to automate specific tasks. This tutorial also shows how to create a custom piece of code to remove tables based on character strings.

The article explains how to import a CSV file into a MySQL database using the command line or phpMyAdmin. Also, find out how to exclude the header row from the CSV and speed up the importation process.

This tutorial shows you how to install, configure, and perform basic commands in Apache Hive. Improve your Hadoop cluster by allowing it to communicate with relational databases conveniently.

The article provides a detailed explanation of what a NoSQL databases is and how it differs from relational databases. It focuses on the strengths and weaknesses of the non-relational database model using many practical examples.

Apache Cassandra, a NoSQL database, supports a variety of data types, including built-in, collection, and user-defined data types. This article explains how these differ from each other and help you decide when to use one over the other.

NoSQL databases are an alternative to the traditional SQL databases. They are more flexible, scalable and functional for working with big data. There are different types of NoSQL databases. The most widely used types include: key-value databases, document databases, wide-column databases, and graph databases.