[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()

一种关系模式的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

一种关系模式的DTD发布方法

Author(s):

Liang Zuopeng;  Wang Xiaoling;  Xu Lizhen;  Dong Yisheng

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

梁作鹏;  王晓玲;  徐立臻;  董逸生

东南大学计算机科学与工程系, 南京 210096

Keywords:

XML;  DTD;  relational database;  XML schema

XML;  DTD;  关系数据库;  XML模式

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.

提出了一种基于边表的关系模式的DTD发布方法. 在分析了关系模式和DTD的特征的基础上, 给出了它们之间的映射规则. 然后, 给出了基于边表的转换算法. 获取关系数据字典中的关系模式信息和基于边表的转换算法是该方法的2个关键点. 关系数据模式发布为DTD文档后, 其他应用就可以利用DTD所包含的结构信息对关系数据进行优化查询.

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