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

The Best of the Week (Sep. 19): SQL Zone

DZone's Guide to

The Best of the Week (Sep. 19): 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 (September 19 to 26). Here they are, in order of popularity:
  1. Solving ORM: Keep the O, Drop the R, No Need for the M

    The ORM complexity problem has a simple, production-ready solution hiding in plain sight in the Java world.

  2. NoSQL and NewSQL: A Primer

    To fulfill the need for additional database processing speed and storage, the goal is to scale-out (add more commodity nodes to the system) rather than having to scale up (add more CPU or memory to each node). And to handle this need, two new kinds of scale-out databases have emerged: NoSQL and NewSQL. Let’s take a look at what sets them apart.

  3. JPA tutorial: Mapping Entities – Part 1

    In this article I will discuss about the entity mapping procedure in JPA. As for my examples I will use the same schemathat I used in one of my previous articles.

  4. SQL Injection & Optimizations Path

    It is silly, but I just had a conversation with one of our developers on SQL Injection. In RavenDB we support replicating to a relational database, which obviously require using SQL. We are doing things properly, with parameters and everything.

  5. How to Find Duplicate Indexes

    Josh Berkus at Database Soup wrote a post recently explaining how to find duplicate indexes in SQL. He has written a few queries to help those who need to filter through large amounts of indexes within a database. Berkus says his queries help to minimize the number of false positives that occur.


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 }}