Ordered access of interrelated data files

摘要

A computer implemented method and system for interrelating and providing ordered access to source data files (SDFs) is provided. Each SDF contains one or more records. A parsing component compiles a configuration language (CL) and generates file descriptors usable by an interlinear sort component (ISC) and an interrelated data access component (IDAC). The CL defines adopt and order key fields, a lineage relationship between the SDFs, and one or more predetermined subprograms. The subprograms process an instance of a record from a SDF and a start point and an end point of a sequence or a subsequence of related records from the SDF. The ISC sorts each SDF into the order defined in the CL and attaches a parent position number (PPN) to each child file record. The IDAC uses the PPN to access the sorted SDFs in the order defined by the CL and execute the defined subprograms.

主权项

1. A computer implemented method for interrelating a plurality of source data files and providing access to said interrelated source data files, said computer implemented method comprising:
providing an interrelated data integration application comprising an interlinear sort component and an interrelated data access component executable by at least one processor, wherein said interrelated data integration application is configured to sort and access a plurality of records in said source data files according to a graphical representation of a lineage relationship between said source data files defined in a configuration language; providing a parsing component executable by at least one processor, said parsing component configured to compile said configuration language and generate file descriptors usable by said interlinear sort component and said interrelated data access component of said interrelated data integration application, said configuration language configured to define:
said lineage relationship between said source data files, each of said source data files containing one or more of said records, wherein said source data files are graphically related to each other in a tree structure using an array of symbols;one or more adopt key fields, wherein a common one of said one or more adopt key fields is configured to relate each child file containing one or more child file records to a corresponding parent file containing one or more parent file records in said tree structure;one or more order key fields configured to define ordering criteria for said records of one or more of said source data files; andone or more predetermined subprograms configured to process instances of one or more of said records from said source data files, a start point of one of a sequence and a subsequence of said records of said source data files, and an end point of said one of said sequence and said subsequence of said records of said source data files; sorting said each of said source data files based on one or more of said lineage relationship, said one or more order key fields, and said one or more adopt key fields defined in said configuration language, and attaching a position number to each of said records of said each of said source data files, by said interlinear sort component of said interrelated data integration application; accessing said records in said source data files reordered by said interlinear sort component based on said lineage relationship between said source data files, and using said position number to determine access of a subsequent one of said records, by said interrelated data access component of said interrelated data integration application; and outputting on a user device responsive to a user request at runtime a set of records comprising a common lineage relationship.