Transforming XML DTD to SQL Schema based on JDBC

Transforming XML DTD to SQL Schema based on JDBC

, , Journal of Internet Computing and Services, Vol. 3, No. 1, pp. 29-40, Feb. 2002
Full Text:

Abstract

The information exchange on the using of XML such as B2B electronic is common. So the efficient method to store XML message in database is needed. Because the ORDBMS is extended to ORDBMS for supporting multimedia application such as Oracle8i, 9i, Informix and SQL2000 server, SQL2, the standard RDB is extended to SQL3 for ORDB, And the XML application based on java such as J2EE is extended. Therefor it is necessary for the efficient connection methods based on JDBC between XML application and database system. In this paper, the methodology a transformation XML DTD to SQL3 schema is proposed. For the transformation, first the methods of transformation XML DTD to object model in UML class diagram are proposed. And then the methods of mapping transferred object models to SQL3 schema are proposed. This approach for transform::1lion XML. DTD to SQL3 schema such as Oracle8i, 9i, Informix and SQL2000 server based on java is proposed in this paper, can be used in database design to build XML applications based on ORDB.

Statistics

Show / Hide Statistics

Statistics (Cumulative Counts from November 1st, 2017)
Multiple requests among the same browser session are counted as one view.
If you mouse over a chart, the values of data points will be shown.

Cite this article

[APA Style]

이상태 & 주경수 (2002). Transforming XML DTD to SQL Schema based on JDBC. Journal of Internet Computing and Services, 3(1), 29-40.

[IEEE Style]

이상태 and 주경수, "Transforming XML DTD to SQL Schema based on JDBC," Journal of Internet Computing and Services, vol. 3, no. 1, pp. 29-40, 2002.

[ACM Style]

이상태 and 주경수. 2002. Transforming XML DTD to SQL Schema based on JDBC. Journal of Internet Computing and Services, 3, 1, (2002), 29-40.