SYSTEM AND METHOD FOR GENERATING REPORTS FOR A VERSIONED DATABASE

摘要

A kind of system and method for the database of effectively multichannel storing data object version, and are generated and are provided at any given time reported to show the corresponding data object of single version. Data object is by versioned data structure, including one for storing the version objects of the corresponding data of faith conviction time field. It includes being retrieved for the specified required retrieval data object of field and the data object of a where clause indicated release that the data of single version objects retrieval, which are by generating SQL case statements code,. Single foreign key is used to access the version of multiple identical data objects.