Databases

How to clone a table structure in MySQL

I have often needed to clone a table without it’s data in MySQL.

Read More

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 a new table with the same schema, making the changes to it and applying triggers for insertion, deletion and all updates, all while performing your valuable schema updates for you!

Read More

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 to the creation of MS SQL Server, Sybase, Wang?

Read More

Product Update: ADD becomes Serengeti

As a product update; The “Autonomous Distributed Database”, otherwise known as simply ADD has been renamed to Serengeti.

Read More

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”.

Read More

Distributed Database Systems Observations

Traditional database systems were a centralised powerful database server that housed all operations pertaining to the database.

Read More

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 typically called “Top-down” and “Bottom-up” philosophies or methods.

Read More

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 administrators (DBAs) to manipulate data.

Read More

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.

Read More

Resolving InsufficientPrivilege Errors in Redshift

If you are getting the mysterious error: [ERROR] InsufficientPrivilege: permission denied for schema errors

Read More

How to increase column size in Redshift database tables

It is only possible to alter VARCHAR columns, and only under the following circumstances:

Read More

Entity and Referential Integrity in Relational Databases

Data integrity is the overall completeness, accuracy and consistency of data (Techopedia, n.

Read More

Data Warehouses vs Data Marts

Although the terms “data warehouse” and “data mart” sound similar, they are quite different.

Read More

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.

Read More

How to Install MongoDB on Mac

You can use Homebrew to install MongoDB on a Mac.

Read More

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.

Read More

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 FLUSH PRIVILEGES.

Read More

MySQL Community Server MSI Installer Hangs on Windows 10

I was trying to install MySQL Community Server for Windows 10 using the standard .

Read More

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) which is affiliated with the International Electrotechnical Commission (IEC).

Read More

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 information; but only until around the 1960s did computerised databases start to take shape and become cost effective for private organisations to start using (Quickbase, n.

Read More