You could buy a tool to help with that, but you said you want to build one. We created about 20 pertinent tables within a DB, normalized the data/column distribution amongst them, and started populating them with all the data values from across our many systems. Whenever a system, interface, or et...
[ more ]