Linkifier

Fixed: The algorithm now checks whether estimated_min ≤ estimated_max holds - a necessity on MSSQL.

Linkifier

Add: Ability to complement the known foreign key constraints instead of ignoring all known foreign keys (controllable via a checkbox).
Add: Optionally validate the estimated foreign key constraints for foreign key violations. This can be slow. Hence there is a build in timeout on each check (20 seconds). To see whether the validation finished on the estimated foreign key constraint, inspect column "satisfiesFKC" in "Decision justification for FK". If the value is "timeout", it means Linkifier didn't find any foreign key violation in the time limit. When Linkifier finds a violation, it reruns the optimization and proposes a different set of foreign key constraints until no violation is found (or until it is the 10th re-optimization). As always, keep in mind that a technically valid foreign key constraint does not make a semantically valid foreign key constraint.

Linkifier

Fixed: The estimated ratios from MSSQL are now capped to interval 0..1.

Linkifier

Fixed: The multi-part identifier "stats.object_id" could not be bound.

Linkifier

Fixed: Cannot resolve the collation conflict between “...” and “...” in the equal to operation.

Linkifier

Bug fix for MSSQL (removed a forgotten comma in SQL).

Linkifier

Features based on database statistics are now all fuzzy. This improved accuracy of the predictions by ~5%.

Linkifier

Added support for connection to Microsoft SQL Server via Windows Authentication. To make it work, you have to manually copy a dll into Java path as described in README.

Linkifier

Linkifier now supports tables with more than 2 billion records.

Linkifier

Improved compatibility with Microsoft SQL Server.