Presentation Mechanism about Temporal Attributes in BCDM Based on RDBMS

Bi-temporal conceptual data model (BCDM) expresses bi-temporal mechanism effectively, which achieves the two-dimensional expression about virtual time and transaction time. Based on standardization of the temporal label in BCDM, the paper expresses temporal information based on RDBMS (relational database management system) snapshot model, then analyzes which normal formula can be expressed in BCDM, then decomposes the temporal model to 3NF based on RDBMS snapshot model. This can help to reduce redundancy, and prevent abnormal operation.