Translating Data Between Xml Schema and 6Nf Conceptual Models

Sixth Normal Form (6NF) is a term used in relational database theory by Christopher Date to describe databases which decompose relational variables to irreducible elements. While this form may be unimportant for non-temporal data, it is certainly important for data containing temporal variables of a point-in-time or interval nature. With the advent of Data Warehousing 2.0 (DW 2.0), there is now an increased emphasis on using fully-temporalized databases in the context of data warehousing, in particular with approaches such as the Anchor Model and Data Vault. In this work, we will explore the concepts of temporal data, 6NF conceptual database models, and their relationship with DW 2.0. Further, we will evaluate the Anchor Model and Data Vault as design methods in which to capture temporal data. Using these methods, we will define a process for translating 6NF-compliant data into a standard eXtensible Markup Language (XML) Schema which can be used to describe and present such data to disparate systems in a structured format suitable for data exchange. Further, we will discuss benefits, advantages, and limitations to using XML representations of 6NF models for the transfer of data into a data warehouse.

Name thesis:degree_name

Master of Science in Computer Science (M.S.)

Level thesis:degree_level

Thesis (open access)

Discipline thesis:degree_discipline

Department of Computer Sciences

Year dc:date.available

2012

Author dc:creator

• Knowles, Curtis Maitland

Contributors dc:contributor

• Lixin Li
• Wen-Ran Zhang

• ETD
• Sixth normal form
• 6NF
• eXtensible Markup Language
• XML
• XSD
• Anchor Model
• Data Vault
• Temporal database
• Semantically temporal data
• Semantically stable data
• Semantic data change
• Valid time
• Transaction time
• Data Warehousing 20
• Dimension Fact Model
• DFM
• XSLT
• eXtensible Stylesheet Language Transformation
• XML (Document markup language)

Repository record dc:identifier

https://digitalcommons.georgiasouthern.edu/etd/688

OAI identifier oai:identifier

oai:digitalcommons.georgiasouthern.edu:etd-1688