Over a million developers have joined DZone.
{{announcement.body}}
{{announcement.title}}

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

Need to build an application around your data? Learn more about dataflow programming for rapid development and greater creativity. 

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.


Check out the Exaptive data application Studio. Technology agnostic. No glue code. Use what you know and rely on the community for what you don't. Try the community version.

Topics:

Opinions expressed by DZone contributors are their own.

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

{{ parent.tldr }}

{{ parent.urlSource.name }}