Research on mapping from XML-schema to relational data-schema

doi:10.3778/j.issn.1002-8331.2009.09.045

Computer Engineering and Applications ›› 2009, Vol. 45 ›› Issue (9): 157-160.DOI: 10.3778/j.issn.1002-8331.2009.09.045

• 数据库、信号与信息处理 • Previous Articles Next Articles

Research on mapping from XML-schema to relational data-schema

FANG Jie,LIU Guang-zhong

College of Information Engineering，Shanghai Maritime University，Shanghai 200135，China

Received:2008-02-04 Revised:2008-04-18 Online:2009-03-21 Published:2009-03-21
Contact: FANG Jie

XML模式到关系数据模式转换的研究

方洁,刘广钟

上海海事大学信息工程学院，上海 200135

通讯作者: 方洁

Abstract

Abstract: An inlining algorithm for mapping XML DTDs to relational schema is analyzed and studied.A mapping method with constraints and functional dependencies is proposed.According to given rules and discussion about some functional dependencies，it simplies XML DTD，builds a DTD graph with constraints，and obtains final relational sets.At last，mapping method is realized with an instance，and relational sets to meet the needs of completeness is obtained.

Key words: eXtensible Markup Language（XML） Document Type Definition（DTD）, relational-schema, constraint, functional dependency

摘要： 分析和研究了DTD模式到关系模式的内联映射算法，提出一种带约束条件和函数依赖的映射方法。该方法结合给定规则对XML DTD进行简化，构造带约束条件的DTD图，并依照图中的一些函数依赖关系以及函数依赖关系的讨论得到最终关系集合，在引入映射方法的同时给出实例进行介绍，从而得到更加完备的关系模式。

关键词: 可扩展标记语言文档类型定义, 关系模式, 约束, 函数依赖

FANG Jie,LIU Guang-zhong. Research on mapping from XML-schema to relational data-schema[J]. Computer Engineering and Applications, 2009, 45(9): 157-160.

方洁,刘广钟. XML模式到关系数据模式转换的研究[J]. 计算机工程与应用, 2009, 45(9): 157-160.

[1]	TAN Leping, SONG Ping, YANG Qifeng. Financing and Pricing Decisions of Risk-Averse Dual-Channel Supply Chain [J]. Computer Engineering and Applications, 2021, 57(7): 237-250.
[2]	TAN Leping, SONG Ping, YANG Qifeng. Equipment Decision of Investment and Loan Linkage Financing of Green Supply Chain [J]. Computer Engineering and Applications, 2021, 57(5): 229-238.
[3]	LI Yuqi, LIU Zhiqian, CHENG Ningyi, WANG Yingying, ZHU Chunli. Path Planning of UAV Under Multi-constraint Conditions [J]. Computer Engineering and Applications, 2021, 57(4): 225-230.
[4]	YANG Shanliang, CHANG Zheng. Chinese Implicit Sentiment Analysis Based on Graph Attention Neural Network [J]. Computer Engineering and Applications, 2021, 57(24): 161-167.
[5]	MA Yanfang, LI Baoyu, YANG Yifu, FENG Cuiying. Two-Echelon Capacitated Vehicle Routing Model and Algorithm for Fresh Products Distribution with Customer Classification [J]. Computer Engineering and Applications, 2021, 57(20): 287-298.
[6]	MENG Xiangfu, WANG Dandan, ZHANG Feng. Overview of Spatial Keyword Queries [J]. Computer Engineering and Applications, 2021, 57(20): 13-24.
[7]	JIA Wenyou, JIANG Lei, CAO Ziyang, LIANG Lidong. Optimization Trajectory Planning of Industrial Robot with Energy Consumption [J]. Computer Engineering and Applications, 2021, 57(15): 245-250.
[8]	WANG Qiaoyue, CHEN Shuyue. Defogging Algorithm Based on Color Transfer and Regularization Constraints of License Plate Images [J]. Computer Engineering and Applications, 2021, 57(14): 217-222.
[9]	WANG Sikui, LIU Yunpeng, QI Lin, ZHANG Zhongyu, LIN Zhiyuan. Object Tracking Method Based on Background Constraints and Convolutional Features [J]. Computer Engineering and Applications, 2020, 56(8): 205-214.
[10]	XIAO Chenglong, NIE Ziyang, WANG Shanshan. Correlation Heuristics Based on ParetoHeu and Instantiation Failure Statistics [J]. Computer Engineering and Applications, 2020, 56(5): 57-64.
[11]	ZHAI Zhinian, LU Yahui, ZHOU Wujie, PENG Yanbin, ZHENG Zhijun, YU Jian, FENG Mingkun. Acceleration of Boundary Shrinking in Incremental Pattern Backtracking for *WS-RI [J]. Computer Engineering and Applications, 2020, 56(24): 236-241.
[12]	CHEN Guangfeng, YU Lichao. Multi-frame Time Window Rotation Algorithm to Plan Storage Multiple AGV Car Path [J]. Computer Engineering and Applications, 2020, 56(23): 270-278.
[13]	XIE Zhangwei, CUI Zhanqi, ZHENG Liwei, ZHANG Zhihua. Dynamic Symbolic Execution Based on Assistance of Genetic Algorithm [J]. Computer Engineering and Applications, 2020, 56(21): 231-236.
[14]	YIN Hongji, CHEN Wei. Server Side Request Forgery Vulnerability Detection System with Graph Traversal Algorithm [J]. Computer Engineering and Applications, 2020, 56(19): 114-119.
[15]	LIANG Chengji, SHEN Zhe, ZHANG Yue. Quay Crane and AGV Joint Scheduling with Grouping Work Surface Under Interference Constraints [J]. Computer Engineering and Applications, 2020, 56(18): 254-261.

Research on mapping from XML-schema to relational data-schema

XML模式到关系数据模式转换的研究

PDF

Knowledge

Abstract

Cite this article

share this article

References

Related Articles 15

Recommended Articles

Metrics