[1] Liang Zuopeng, Wang Xiaoling, Xu Lizhen, Dong Yisheng, et al. A method for publishing relational schema into DTD [J]. Journal of Southeast University (English Edition), 2003, 19 (2): 117-120. [doi:10.3969/j.issn.1003-7985.2003.02.004]

Copy

A method for publishing relational schema into DTD()

Share：

Journal of Southeast University (English Edition)[ISSN:1003-7985/CN:32-1325/N]

Volumn:

19

Issue:

2003 2

Page:

117-120

Research Field:

Computer Science and Engineering

Publishing date:

2003-06-30

Info

Title:

A method for publishing relational schema into DTD

Author(s):

Liang Zuopeng;  Wang Xiaoling;  Xu Lizhen;  Dong Yisheng

Department of Computer Science and Engineering, Southeast University, Nanjing 210096, China

Keywords:

XML;  DTD;  relational database;  XML schema

PACS:

TP39

DOI:

10.3969/j.issn.1003-7985.2003.02.004

Abstract:

This paper focuses on exporting relational data into extensible markup language(XML). First, the characteristics of both relational schemas represented by E-R diagrams and XML document type definitions(DTDs)are analyzed. Secondly, the corresponding mapping rules are proposed. At last an algorithm based on edge tables is presented. There are two key points in the algorithm. One is that the edge table is used to store the information of the relational dictionary, and this brings about the efficiency of the algorithm. The other is that structural information can be obtained from the resulting DTDs and other applications can optimize their query processes using the structural information.

References:

[1] Bray T, Paoli J, Sperberg-McQueen C. Extensible markup language(XML)1.0 [EB/OL]. http://w3.org/XML, 2002-08-15.
[2] Bosak J. W3C XML specification DTD [EB/OL]. http://w3.org/xml, 2002-08-15.
[3] Deutsch A, Fernandez M, Suciu D. Storing semi-structured data with STORED [A]. In: SIGMOD Conference[C]. Dallas, Texus, 2000.
[4] Florescu D, Kossman D. Storing and querying XML data using and RDBMS [J]. IEEE Data Engineering Bulletin, 1999, 22(3):27-34.
[5] Jayavel Shanmugasundaram. Relational databases for storing XML documents: limitations and opportunities [A]. In: VLDB Conference[C]. Edinburgh, Scotland, 1999.
[6] Don Chamberlin, Daniela Florescu, Jonathan Robie, et al. XQuery: A query language for XML W3C working draft[R]. Technical Report WD-xquery-20010215, World Wide Web Consortium, 2001.

Memo

Memo:

Biographies: Liang Zuopeng(1973—), male, graduate; Dong Yisheng(corresponding author), male, professor, ysdong@seu.edu.cn.

Common functions