Over a million developers have joined DZone.

The Best of the Week (May 30): SQL Zone

DZone's Guide to

The Best of the Week (May 30): SQL Zone

· Java Zone ·
Free Resource

Verify, standardize, and correct the Big 4 + more– name, email, phone and global addresses – try our Data Quality APIs now at Melissa Developer Portal!

Make sure you didn't miss anything with this list of the Best of the Week in the SQL Zone (May 30 to June 5). Here they are, in order of popularity:

1. An Overwhelming Era of Databases

This era is significant in terms of the number of databases that have made their way into the enterprise data centers, such as column-based, graph or hierarchy, document, key/value store, and RDBMS++ & --.

2. How MySQL "Queries" and "Questions" are Measured

MySQL has status variables “questions” and “queries,” which are rather close, but also a bit different, making it confusing for many people. In this article, the author explores MySQL's "questions" and "queries."

3. MapDB: The Agile Java Data Engine

The fundamental concept for MapDB is very clever yet natural to use: provide a reliable, full-featured and “tune-able” database engine using the Java Collections API. MapDB is freely available for any use under the Apache 2.0 license.

4. MySQL Transaction Isolation Levels and Locks

Recently, an application that the author's team was working on encountered problems with a MySQL deadlock situation and it took them some time to figure out the reasons behind it. In this article, you'll find the author's solution to the problem and an exploration of transaction isolation.

5. NuoDB 2.0.4 Has Arrived!

Of course, every release has criteria that need to be met. In the case of NuoDB 2.0.4 the criteria were simple, and rooted firmly in product quality and stability. In this article, you'll find an overview of the new features in NuoDB 2.0.4 and the thinking behind them.

Developers! Quickly and easily gain access to the tools and information you need! Explore, test and combine our data quality APIs at Melissa Developer Portal – home to tools that save time and boost revenue. Our APIs verify, standardize, and correct the Big 4 + more – name, email, phone and global addresses – to ensure accurate delivery, prevent blacklisting and identify risks in real-time.


Opinions expressed by DZone contributors are their own.

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}