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

fYear

2009

fDate

6-7 June 2009

Firstpage

49

Lastpage

52

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;

fLanguage

English

Publisher

ieee

Conference_Titel

Electronic Commerce and Business Intelligence, 2009. ECBI 2009. International Conference on

Conference_Location

Beijing

Print_ISBN

978-0-7695-3661-3

Type

conf

DOI

10.1109/ECBI.2009.62

Filename

5189483