3 ms·
I spent a few months at Kroger headquarters working on a requirements analysis for replacing their master item database. At that time ('07) the system was this
by keefe 16y ago
I spent a few months at Kroger headquarters working on a requirements analysis for replacing their master item database.
At that time ('07) the system was this hybrid of IMS, COBOL-APPS and some DB2, with all the item management coming in from these green screen old school apps.
The loyalty program was one of the most modern programs, with some java based system. As I recall, a bunch of scripts did a dump to a flattened DB2 database and that was sent to dunnhumby.
--edit I forgot to mention the amusing kroger database schema story. apparently, they did their first schema so long ago that PLUs were not invented yet, so when PLUs came along they shoved them into some unused label field... as we analyzed the data more, we found more and more of these things, sometimes fields were even split and shoved into two unrelated fields...