Adoption of document databases is growing rapidly in response to the need for solutions that can handle large volumes of data. These solutions are adept at handling non-relational data models...
Smart organizations taking on a new project don’t try to go it alone – they recognize when outside help can provide the guidance needed to meet and exceed their objectives...
It's nice to see that PostgreSQL 9.5 is finally released! There are a number of blog posts out about that already, not to mention stories in InfoWorld, V3, and a...
The release of PostgreSQL 9.5 marks a turning point for enterprises using PostgreSQL for the development of high-speed mobile, web and digital economy applications, many for customer engagement.
Parallelism is now a reality in PostgreSQL. With 9.6, I hope we will see many different forms of queries that can use parallelism to execute. For now, I will limit...
As of December 1, 2015, Oracle® is no longer offering two of its most popular database license options, SE and SE1; replacing them instead with a new SE2 version which...
Open source software has been saving organizations money for years in operating systems with Linux, in the middleware layer with tools like JBoss, and virtualization with Xen and other options...
I previously suggested that we might be able to get parallel sequential scan committed to PostgreSQL 9.5. That did not happen. However, I'm pleased to report that I've just committed...
The only data structure recognized in traditional SQL databases was the row, and repeating groups were extracted into child rows linked through foreign keys. It worked well but could be...
Common practice in relational database design is to utilize a non-repeating, ordered series of integers for primary keys (PK) and by extension, foreign keys (FK). This practice has worked so...