Reading Time: 12 minutes
What is ClickHouse?
ClickHouse is an open-source column-oriented DBMS (or database management system) primarily used for OLAP (or the Online Analytical Processing of queries). It is capable of blazing fast generation of real-time analytical data and reporting utilizing SQL queries. It is fault tolerant, scalable, highly reliable and contains a feature rich tool set.
In a regular database, data is stored in tables, columns, and rows. In a table, the related values are physically stored side by side in one row, which is critical to how it operates. This is how most string type databases work.
Continue reading “How to Install and Configure ClickHouse on Ubuntu 20.04”
Reading Time: 8 minutes
In this tutorial, we will examine what Neo4j is, what it is used for, and how it is implemented. We will also install and configure the installation on an Ubuntu 20.04 server. Neo4j is a graphical database used to create data relationships. Other examples of graphical databases include:
Continue reading “How to Install Neo4j on Ubuntu 20.04”
- Grakn Core
- Microsoft SQL Server 2017
Reading Time: 4 minutes
Throughout this tutorial, we will cover some of the fundamentals of indexing. As part of the MySQL series, we will introduce capabilities of MySQL indexing and the role it plays in optimizing database performance. Liquid Web recommends consulting with a DBA before making any changes to your production level application.
Continue reading “MySQL Performance: How To Leverage MySQL Database Indexing”
Reading Time: < 1 minute
PostgreSQL (pronounced “post-gress-Q-L”) is a household name for open source relational database management systems. Its object-relational meaning that you’ll be able to use objects, classes in database schemas and the query language. As part of our PostgreSQL series, we’ll show you how to list and switch between databases quickly.
Continue reading “Listing and Switching Databases in PostgreSQL”