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

The Best of the Week (July 11): SQL Zone

DZone's Guide to

The Best of the Week (July 11): SQL Zone

· Java Zone
Free Resource

Build vs Buy a Data Quality Solution: Which is Best for You? Gain insights on a hybrid approach. Download white paper now!

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

1. Realm: A Memory-Efficient Mobile Database

If you're a mobile developer looking for a database that won't crush devices more thoroughly than Play Services 5.0, SQLite isn't the only option anymore. Now there's Realm, currently available for iOS (and Android, soon).

2. More Functional Relational Transformation

In the past, we’ve been providing you with a new article every Friday about what’s new in Java 8. It has been a very exciting blog series, but we would like to focus again more on our core content, which is Java and SQL.

3. PostgreSQL vs. NoSQL: Your Database is a Humvee

If you're wondering about the similarities between your database choices and your militarized suburban vehicle choices, Bruce Momjian and Marc Linster have the presentation for you!

4. Logon Triggers: The Oracle Database Magic Bullet

Imagine you want to collect detailed usage statistics to tune your Oracle database, e.g. if you want to have A-Rows and A-Time values in your execution plans. It's simple enough, but of course, you hardly ever have the required privileges. So how can we get those advanced statistics? Easy: by using a logon trigger.

5. From JPA to Hibernate's Legacy and Enhanced Identifier Generators

While there’s not much application-side IDENTITY generator optimization (other than configuring database identity preallocation), the sequence identifiers offer much more flexibility in this regard. One of the most common optimization strategy is based on the hi/lo allocation algorithm. This article will investigate various sequence-like generation strategies and all the available optimizations.


Build vs Buy a Data Quality Solution: Which is Best for You? Maintaining high quality data is essential for operational efficiency, meaningful analytics and good long-term customer relationships. But, when dealing with multiple sources of data, data quality becomes complex, so you need to know when you should build a custom data quality tools effort over canned solutions. Download our whitepaper for more insights into a hybrid approach.

Topics:

Opinions expressed by DZone contributors are their own.

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

{{ parent.tldr }}

{{ parent.urlSource.name }}