Maps and Entities and JPA, OH MY!

Ryan McCullough Problem Solving, Programming, Technology Snapshot Leave a Comment

A client I’m working with has an email templating system that needs an upgrade! The current design utilizes a denormalized table that needed to grow a column every time a new unique token is needed. After a review of the offerings through JPA, I was happy to see that JPA had some support for java.util.Map through joins through a variety of the @MapKey annotation.

In this post, I’ll demonstrate the less frequently used methodology of applying and populating a Map of entities using a single table and a composite key.

Mapping Shortest Routes Using a Graph Database

Lou Mauget Databases, Java, Technology Snapshot 11 Comments

We often model interconnected data by cramming it in and out of table structures. Why don’t we simply model interconnected data as … interconnected data? I recently wrote that there are several kinds of NoSQL database stores: key-value, column family, document-oriented, and graph database.  This article targets Neo4j, a Java-based graph DBMS. The open-ended problem domain of graph databases includes …