Over a million developers have joined DZone.

The Best of the Week (June 27): SQL Zone

DZone's Guide to

The Best of the Week (June 27): SQL Zone

· Big Data Zone ·
Free Resource

The open source HPCC Systems platform is a proven, easy to use solution for managing data at scale. Visit our Easy Guide to learn more about this completely free platform, test drive some code in the online Playground, and get started today.

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

1. Hibernate and UUID identifiers

In his previous post, the author talked about UUID surrogate keys and the use cases when there are more appropriate than the more common auto-incrementing identifiers. In this post, he explores UUID identifiers in Hibernate.

2. The Dangers of SQL JOINs & Aggregate Functions: How to Avoid Fanouts

Every SQL developer uses JOINs and aggregate functions, but some may not be aware that the two interacting can return incorrect results if not handled carefully. In this recent post, the author covers the issue, specifically when it comes to "fanouts."

3. Why %util Number from Iostat is Meaningless for MySQL Capacity Planning

Earlier this month I wrote about vmstat iowait cpu numbers, and some of the comments I got were advertising the use of util% as reported by the iostat tool instead. I find this number even more useless for MySQL performance tuning and capacity planning.

4. The Hi/Lo Algorithm

The hi/lo algorithms splits the sequences domain into “hi” groups. A “hi” value is assigned synchronously. Every “hi” group is given a maximum number of “lo” entries, that can by assigned off-line without worrying about concurrent duplicate entries.

5. SQL Pushes Back: New Projects to Handle Multi-Dimensional Arrays

Lately, it's looking more and more like the idea that SQL is fundamentally limited compared to NoSQL is waning, and that may be the case even when it comes to truly big data. According to Richard Chirgwin at The Register, the ISO SQL working group has announced a SQL/MDA spec project.

Managing data at scale doesn’t have to be hard. Find out how the completely free, open source HPCC Systems platform makes it easier to update, easier to program, easier to integrate data, and easier to manage clusters. Download and get started today.


Opinions expressed by DZone contributors are their own.

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

{{ parent.tldr }}

{{ parent.urlSource.name }}