Installing and Using PostgreSQL Modules
In this article, we will learn how to install and use the PostgreSQL modules chkpass, fuzzystrmatch, isn and hstore. Modules add different capabilities to a database, like admin and monitoring tools, new data…
Taming the Big Data Beast with Hadoop and Alternatives
Turn the clock back to 1970 — the year in which Edgar Codd published the paper “A Relational Model of Data for Large Shared Data Banks”. In it he described a language called…
NewSQL — The New Way to Handle Big Data
Big data, big data, big data! This term has been dominating information management for a while, leading to enhancements in systems, primarily databases, to handle this revolution. Though there are many alternative information…
FOSS is __FUN__: Get the Basics Right
A few thoughts about databases in general… and some rants about the good old ways. There are a plethora of free/open source databases around, from the good old Berkeley DB, SQLite, MySQL, PostgreSQL,…
The Importance of In-memory Databases
It has been predicted that in-memory computing will be one of the Top 10 technologies of 2012. In-memory databases (IMDBs) are a critical part of this paradigm. Through this introductory article, let’s get…
The Comprehensive LAMP Guide — Part 2 (MySQL)
MySQL is the most widely used Relational Database Management System (RDBMS), and is the “M” in the LAMP stack. One of the main uses for MySQL is with Web applications. To avoid the…
The Database Demands of Peta-scale Computing
Let’s take a brief look at the challenges for next-generation databases. In the previous article we discussed that as data volumes grow towards the peta-scale and beyond, most traditional databases find it difficult…
Testing Your Databases with DbUnit
DbUnit is ideal as an add-on testing framework when developing applications in Java-based languages, which rely heavily on databases. This article assumes that the reader is aware of basic testing concepts, and tries…
A Simple Guide to Database Design in MySQL
As the title says, this is an introduction to databases, their purpose and features. It deals with how to design and create a simple database in MySQL. Starting off with the concepts of…





