Loading...
An object and XML database schemas design tool
Author(s)
Chankuang, Narudol
Chittayasothorn, Suphamit
Date Issued
July 6, 2004
Type
Conference Paper
Abstract
Nowadays relational database schemas are designed by using well-known database design techniques such as the Entity Relationship Model and the normalization process. The result schemas can be guaranteed to have minimum redundancies if the fifth normal form (5NF) is achieved. However, in more recent database schema design such as the design of object database schema, the concern about minimum redundancies does not seem to be an important issue. Functional dependencies may still appear in an object class of the class diagram thus introduce update anomalies. This pape rfirst presents the use of NIAM, a well-established conceptual schema model, as a conceptual model for the design of object databases. A transformation from a NIAM to an OODB schema with minimum redundancy is presented. The conceptual schema can also be transformed into Extensible Markup Language (XML) which is originally a language for document management. However, it now gains popularity in database representation. It is particularly useful as a data format when an application must communicate with another application. This paper also presents the NIAM conceptual schema model as a conceptual design tool for XML schema. A software tool that allows users to create NIAM schemas and generate object and XML schemas is develpoed.
Citation
International Conference on Information Technology Coding Computing ITCC, 2, 421-427, 2004