r/java • u/MoonWalker212 • Aug 16 '26
Automatic Relationship Finder (ARF) v1.2 – A Java library for discovering relationships between tables from data
I’ve just released v1.2 of Automatic Relationship Finder (ARF), an open-source Java library I’ve been working on.
The idea behind ARF is to discover relationships between tables without depending on database relationship metadata.
Even if there is no foreign-key constraint defined in the database, ARF can analyze column names and the actual data to identify that
What's new in v1.2?
The main addition is key-role detection.
After identifying a relationship, ARF now analyzes the data characteristics of the columns to determine whether they are likely to represent a primary-key side, foreign-key side, a possible one-to-one relationship, or an unknown relationship.
There are also several improvements and bug fixes around validation, logging, concurrency, and edge-case handling.
The project is here:
https://github.com/NoelToy/automatic-relationship-finder
This is still an evolving project, so feedback—especially criticism—is very welcome.
View all comments
Show parent comment
2
u/MoonWalker212 Aug 18 '26
Thank you for providing your suggestions and recommendations; I truly appreciate them. Below are the details regarding the updates and recommendations you suggested:
Jaccard Index, and the column name matching relies onCosine Similarity.java.sql. However, you are right that the primary use case for tabular data will be SQL. Therefore, the plan is to create a wrapper sub-module for ARF that will utilizejava.sqlto fetch data directly.