web analytics

Data, data everywhere 

Twitter LinkedIn RSS
magnify
Home Archive for category "Self-managing database systems"
formats

What exactly is thread deadlock?

Performance testing is a key component of system testing, since a non-performant application is often viewed as just as poor as an application that contains other varieties of defects. Care and attention are required to ensure that even simple processes will not cause contention in a production environment – and sometimes these issues are difficult

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
No Comments  comments 
formats

How to give a query optimizer fits

Recently I have been interacting with a number of people, including Lukas Eder of JOOQ and consultant/blogger Vlad Mihalcea, on SQL and its merit as a query language, particularly with respect to object-relational mapping frameworks such as Hibernate. With native HQL, or with JPA’s JPQL language, Hibernate is responsible for creating the SQL query passed

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
No Comments  comments 
formats

Why the SQL Standard does not need another way to do GROUP BY

In a recent article, Lukas Eder proposed enhancements to the SQL Standard’s GROUP BY syntax to include support for implicit grouping attributes, such as that provided by the Cypher query language. I applaud Lukas’ efforts to define useful changes to the SQL language, but I am going to try to show in this article that

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
3 Comments  comments 
formats

SQL Anywhere achieves world-best TPC-C benchmark

My former colleagues at Sybase/SAP have recently published a remarkable TPC-C benchmark result for a 750Gb SQL Anywhere 16 database on a Dell PowerEdge T620 server with 128GB of RAM using Microsoft Windows 2012, simulating 90,000 users. The benchmark is noteworthy because it sets an all-time record for price/performance with the TPC-C benchmark: 112,890 tpmC

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
2 Comments  comments 
formats

The peril of complexity

In June 2011 I gave the keynote talk at the 2011 DBTEST Workshop in Athens, Greece, which was co-located with the 2011 ACM SIGMOD conference. Here, I have re-posted the slides of my talk, entitled The Peril of Complexity. In the talk, I outline some of the software engineering issues faced by relational database vendors

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
No Comments  comments 
formats

Set-level operations do matter

A recent email exchange with software consultant Breck Carter regarding the performance of user-defined functions in SQL has prompted me to re-post this article that I originally wrote in 2008. User-defined functions in SQL have their uses; unfortunately their performance characteristics are highly variable because it is very difficult impossible for a query optimizer to

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
1 Comment  comments 
formats

How microprocessors are changing everyday things

It is remarkable how the availability of cheap, powerful and low-power consuming microprocessors are changing everyday things. Most of us are familiar with, for example, the computerization of the automobile: microprocessors control anti-lock brakes, fuel injectors, odometers and console displays, in-car networking and telephony, emissions control, and a variety of other electro-mechanical devices within a

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
No Comments  comments 
formats

Program for SMDB 2013 is set

I am pleased to report that the accepted papers for SMDB 2013 have been announced. The 8th International Workshop on Self-Managing Database Systems will be held in conjunction with the 2013 IEEE Data Engineering Conference in Brisbane, Australia, on 8 April 2013. The list of accepted papers includes: Realistic Tenant Traces for Enterprise DBaaS Tim

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
No Comments  comments 
formats

SMDB 2013 Program Committee is set

The 8th International Workshop on Self-managing Database Systems (SMDB) will be held in Brisbane, Australia in conjunction with the 29th IEEE International Conference on Data Engineering at the Sofitel Brisbane Central Hotel in Brisbane from April 8-12, 2013. The Workshop itself is tentatively scheduled for April 8, 2013. Workshop chairs Florian Waas of EMC/Greenplum and

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
No Comments  comments 
formats

The first deadly sin

In this semester I’m teaching two SQL fundamentals courses, one with MySQL and one with Microsoft SQL Server. We are quickly reaching the point where the notions of query equivalence and support for domains will be necessary – and that reminded me of this blog post that I wrote last spring while I was still

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
No Comments  comments