web analytics

Data, data everywhere 

Twitter LinkedIn RSS
magnify
Home Self-managing database systems Archive for category "SQL Anywhere"
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

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 
formats

SQL Anywhere as a ubiquitous DBMS

Databases have become ubiquitous. In addition to mainframe and client-server systems, relational database systems are utilized by embedded applications, on smartphones, within web browsers – just about everywhere. The article below provides some background regarding the necessary properties of “ubiquitous” database management systems, and also provided the title of this blog. This blog entry is

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