Systems and methods for an information storage and retrieval system for an electronic document interchange (EDI) environment

A method implemented in an information storage and retrieval system comprising a hardware processor for an Electronic Document Interchange (EDI) environment, the method comprising:

• receiving, via a data repository management system operatively coupled to a data repository including a master self-referential table defining a hierarchy for the data repository, the master self-referential table including plurality of rows, each row corresponding to at least one of a plurality of third party systems, a child table, the child table references the master-self relational table and is configured to store a plurality of EDI document types corresponding to each the plurality of third party systems, a first sub-child table, the first sub-child table references the child table and is configured to store a plurality of data requests corresponding to each of the plurality of EDI document types and each of the plurality of third party systems and a second sub-child table, the second sub-child table references the child table and is configured to store a plurality of data responses corresponding to each of the EDI document types and each of the plurality of third party systems, from at least one third party system, at least one EDI document type, information associated with the third party system, a first set of data requests and a first set of data responses;
• generating, via the data repository management system, a row in the master self-relational table to store the information associated with the third party system;
• correlating, via the data repository management system, the at least one EDI document type of the plurality of EDI document types stored in the child table, with the third party information;
• associating, via the data repository management system, the first set of data requests of the plurality of data requests stored in the first sub-child table with the at least one EDI document type and the at least one third party information to define columns in the first sub-child table;
• and
• associating, via the data repository management system, the first set of data responses of the plurality of data responses stored in the second sub-child table with the at least one EDI document type and the at least one third party information to define columns in the second sub-child table.