How to clone a table structure in MySQL
I have often needed to clone a table without it’s data in MySQL. Oftentimes this has been because I have a continually growing temporary table… Read More »How to clone a table structure in MySQL
Databases
pt-online-schema-change Add Index
Percona has a great toolkit that allows you to perform schema changes on a MySQL or MariaDB database without any downtime, it works by creating… Read More »pt-online-schema-change Add Index
The Relational Database Model
Relational databases first made an appearance in the mid-1970s, between the years 1974 and 1977 with the creation of Ingres and System R which led… Read More »The Relational Database Model
Product Update: ADD becomes Serengeti
As a product update; The “Autonomous Distributed Database”, otherwise known as simply ADD has been renamed to Serengeti. The Serengeti is a vast ecosystem in east-central Africa.… Read More »Product Update: ADD becomes Serengeti
All About Distributed Databases
A database “is a structured collection of data. Card indices, printed catalogues of archaeological artefacts and telephone directories are all examples of databases”. We are… Read More »All About Distributed Databases
Distributed Database Systems Observations
Traditional database systems were a centralised powerful database server that housed all operations pertaining to the database. There are countless reasons that this is unsustainable… Read More »Distributed Database Systems Observations
Top-down vs Bottom-up Database Design
There are essentially two different approaches one can take when designing databases; these, from a high-level analytic point of view, narrow down to what is… Read More »Top-down vs Bottom-up Database Design
Relational Database Proprietary Extensions
Standard Query Language – or SQL for short – is a language designed for relational databases that allows end users such as developers and database… Read More »Relational Database Proprietary Extensions
Locks used in Database Management Systems
Database Management Systems (DBMS?) are designed to store any amount of data that can then be retrieved or manipulated at a later date. In order… Read More »Locks used in Database Management Systems
Resolving InsufficientPrivilege Errors in Redshift
If you are getting the mysterious error: [ERROR] InsufficientPrivilege: permission denied for schema errors Then you can easily resolve this by running the following SQL:… Read More »Resolving InsufficientPrivilege Errors in Redshift
How to increase column size in Redshift database tables
It is only possible to alter VARCHAR columns, and only under the following circumstances: You can not alter a column with compression encodings BYTEDICT, RUNLENGTH,… Read More »How to increase column size in Redshift database tables
Entity and Referential Integrity in Relational Databases
Data integrity is the overall completeness, accuracy and consistency of data (Techopedia, n.d.). In order to achieve data integrity, it is important to analyse Entity… Read More »Entity and Referential Integrity in Relational Databases
Data Warehouses vs Data Marts
Although the terms “data warehouse” and “data mart” sound similar, they are quite different. It is important to first understand how they differ in order… Read More »Data Warehouses vs Data Marts
Graph Databases and their Properties
The concept of a graph in mathematics is simply a collection of elements which are typically called Nodes and are joined together by Edges. Each… Read More »Graph Databases and their Properties
How to Install MongoDB on Mac
You can use Homebrew to install MongoDB on a Mac. For ages you were able to simply do: brew install mongodb, but more recently, that… Read More »How to Install MongoDB on Mac
Relational (SQL) vs NoSQL Database Models
The Relational (SQL) database has been a central piece to businesses since the 1970s when they first had their claim to fame. Experts say that… Read More »Relational (SQL) vs NoSQL Database Models
When to use FLUSH PRIVILEGES in MySQL
So if you’ve ever created users and given them specific permissions from with SQL or the commandline, you will be familiar with a statement called… Read More »When to use FLUSH PRIVILEGES in MySQL
MySQL Community Server MSI Installer Hangs on Windows 10
I was trying to install MySQL Community Server for Windows 10 using the standard .MSI installer provded from the MySQL website and the installer just… Read More »MySQL Community Server MSI Installer Hangs on Windows 10
A bit on SQL Standards
SQL (Structured Query Language) for relational databases was maintained and standardised by the American National Standards Institute (ANSI) and the International Organisation for Standardisation (ISO)… Read More »A bit on SQL Standards
A Brief Talk on Databases
Databases have been around since ancient times, when elaborate database systems were deployed by governments, hospitals and organisations to keep track of vast amounts of… Read More »A Brief Talk on Databases