摘要 |
An ancestry of a database metadata residing in a computer database is tracked by determining a lineage of all modifications performed on the database metadata. In one aspect, this is achieved by determining one or more attributes associated with the database metadata residing in a system database. Based upon the attributes, a database system table including corresponding tuple of the attributes is generated. Upon detecting a modification in the database metadata, a previous condition and a current condition of the attributes is recorded in the generated database system table. Upon receiving a request to track the ancestry of the database metadata, the database system table is queried to retrieve a lineage of the database metadata by retrieving one or more previous conditions and the current conditions of the attributes associated with the modification. |