Over a million developers have joined DZone.

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

· Big Data Zone

Read this eGuide to discover the fundamental differences between iPaaS and dPaaS and how the innovative approach of dPaaS gets to the heart of today’s most pressing integration problems, brought to you in partnership with Liaison.

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.

Discover the unprecedented possibilities and challenges, created by today’s fast paced data climate and why your current integration solution is not enough, brought to you in partnership with Liaison


The best of DZone straight to your inbox.

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.

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

{{ parent.tldr }}

{{ parent.urlSource.name }}