Title :
Presentation Mechanism about Temporal Attributes in BCDM Based on RDBMS
Author :
Lu-bang, Wang ; Jin, Wang
Author_Institution :
Bus. Sch., Zhejiang Wanli Univ., Ningbo, China
Abstract :
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.
Keywords :
relational databases; temporal databases; bitemporal conceptual data model; relational database management system snapshot model; temporal attributes; transaction time; virtual time; Aggregates; Data models; Electronic commerce; Information analysis; Information processing; Information technology; Relational databases; Standardization; Taxonomy; Transaction databases; Relational Normal Formula; Temporal Database; Temporal information;
Conference_Titel :
Electronic Commerce and Business Intelligence, 2009. ECBI 2009. International Conference on
Conference_Location :
Beijing
Print_ISBN :
978-0-7695-3661-3
DOI :
10.1109/ECBI.2009.62