大数据
-
How to Create a Table in MySQL
Introduction MySQL is a well-known, free and open-source database application. Its high performance, ease of use and data security makes it a popular database solution. One of the most crucial proces…
-
Data Warehouse Architecture Explained
Introduction Data processing frameworks, such as Apache Hadoop and Spark, have been powering the development of Big Data. Their ability to gather vast amounts of data from different data streams is i…
-
How to Create or Add an Index in MySQL With Examples
Introduction MySQL is a database application that organizes data in tables, which in turn have values organized in rows and columns. In MySQL, an index is a data structure that makes the information …
-
SQL vs NoSQL: What's the Difference?
Introduction When it comes to choosing a database, one of the biggest decisions is choosing between an SQL or NoSQL database solution. In this article, you will learn the key differences between SQL …
-
How to Install Redis on Ubuntu 20.04 / 18.04
Introduction Redis is an open-source in-memory data store. It’s used as a flexible, highly available key-value database that maintains a high level of performance. Apart from its performance and flex…
-
How to Install Cassandra on Windows 10
Introduction Apache Cassandra is a well-established wide-column NoSQL database. It uses a column-based storage model to capture large amounts of unstructured data. Cassandra focuses on operating in a…
-
How to Create Database & Collection in MongoDB
Introduction MongoDB is a NoSQL database solution that focuses on availability and scalability. The data is structured and stored in collections of JSON documents. By not using a fixed data structure…
-
How to Rename a Column in MySQL
Introduction MySQL provides a dynamic environment that enables you to alter database items with a few basic commands. By learning how to use various statements, you can manage your databases with eas…
-
How to Allow Remote Connections to MySQL
Introduction It is not uncommon to host databases and web servers on the same local machine. However, many organizations are now moving to a more distributed environment. A separate database server c…
-
How to Remove Duplicate Rows in MySQL
Introduction There are several instances in which you may encounter duplicate rows in your MySQL database. This guide will walk you through the process of how to remove duplicate row values in MySQL.…