Sybase iAnywhere SQL AAnywhere Mobile and Embedded Database

I'd rather play golf


Thoughts on data management, autonomic computing, and self-managing database systems.

header image

Entries Tagged as 'PostgreSQL'

The Orion Uncertain Data Management System

March 18th, 2010 · 1 Comment

Yesterday afternoon I listened to Sunil Prabhakar of Purdue University on the Orion Uncertain Data Management System [1-4]. Sunil’s talk is one of the Database Seminar Series at the University of Waterloo which is sponsored by Sybase iAnywhere. Here’s Sunil’s abstract: Many applications domains are faced with the need to store and manipulate uncertain or [...]

[Read more →]

Tags: Alternative query languages · Cost models · PostgreSQL · Query optimization

Virtualization Design Advisor for DBMS Workloads

May 24th, 2009 · Comments Off

This past Friday afternoon (22 May 2009) I listened to Ahmed A. Soror present work on a Virtualization Design Advisor for DBMS Workloads, follow-on work to a preliminary paper presented last summer at SIGMOD 2008 (Vancouver). Ahmed’s co-authors include a fellow graduate student, Umar Farooq Minhas, faculty members Ken Salem and Ashraf Aboulnaga, all from [...]

[Read more →]

Tags: DB2 · DBA Administration Tools · PostgreSQL · Virtualization

CPU performance and database architectures

December 22nd, 2008 · Comments Off

This month’s edition of Communications of the ACM (December 2008) contains a number of articles related to data management. One that I’ll point out is an interview with relational database pioneer and IBM Fellow Patricia Selinger (nee Griffiths) with James Hamilton (now a VP with Amazon Data Services, having recently left Microsoft). The second is [...]

[Read more →]

Tags: Database Management Systems · Enterprise DB and Postgres · Hardware · Hibernate · Ingres · Performance measurement · PostgreSQL

Hibernate: compatibility or performance?

June 2nd, 2008 · Comments Off

One of Hibernate’s strengths is its ability to work with a wide variety of database systems. One of the ways in which it is able to do so is including a Java layer that customizes the SQL statements being sent to the underlying DBMS to match the dialect and feature set of that particular system. [...]

[Read more →]

Tags: Database interfaces and persistent objects · Hibernate · Microsoft SQL Server · MySQL · Oracle · PostgreSQL · SQL Anywhere · SQL Standard · Sybase ASE

The trend towards virtualization

May 4th, 2008 · Comments Off

There is perhaps no other scientific field like Computer Science that can re-invent technology on such a regular basis and call it “new”. This is certainly true with the latest virtualization systems now available, such as VMware and Xen; twenty-five years ago I was a performance specialist with VM/CMS on IBM mainframes. The goals of [...]

[Read more →]

Tags: Database Administration · DB2 · DBA Administration Tools · PostgreSQL · Self-managing database systems · SQL Anywhere · Virtualization