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

Hortonworks Sandbox for HDP and HDF is your chance to get started on learning, developing, testing and trying out new features. Each download comes preconfigured with interactive tutorials, sample data and developments from the Apache community.

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 Community Connection (HCC) is an online collaboration destination for developers, DevOps, customers and partners to get answers to questions, collaborate on technical articles and share code examples from GitHub.  Join the discussion.

Topics:

Opinions expressed by DZone contributors are their own.

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

{{ parent.tldr }}

{{ parent.urlSource.name }}