Over a million developers have joined DZone.

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

· Big Data Zone

Learn how you can maximize big data in the cloud with Apache Hadoop. Download this eBook now. Brought to you in partnership with Hortonworks.

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.


Hortonworks DataFlow is an integrated platform that makes data ingestion fast, easy, and secure. Download the white paper now.  Brought to you in partnership with Hortonworks

Topics:

Opinions expressed by DZone contributors are their own.

The best of DZone straight to your inbox.

SEE AN EXAMPLE
Please provide a valid email address.

Thanks for subscribing!

Awesome! Check your inbox to verify your email so you can start receiving the latest in tech news and resources.
Subscribe

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

{{ parent.tldr }}

{{ parent.urlSource.name }}