ÇѱÛÁ¦¸ñ(Korean Title) |
°øÅë ¹®¼ ±¸Á¶ ÃßÃâÀ» ÅëÇÑ XML DTDÀÇ °ü°èÇü µ¥ÀÌÅÍ º£À̽º ½ºÅ°¸¶ º¯È¯ ±â¹ý |
¿µ¹®Á¦¸ñ(English Title) |
A Transformation Technique of XML DTD to Relational Database Schema Based On Extracting Common Structure in XML Documents |
ÀúÀÚ(Author) |
¾È¼ºÀº
ÃÖȲ±Ô
|
¿ø¹®¼ö·Ïó(Citation) |
VOL 9-D NO. 06 PP. 0999 ~ 1008 (2002. 12) |
Çѱ۳»¿ë (Korean Abstract) |
XMLÀº W3C¿¡ Á¦¾ÈµÈ ¸¶Å©¾÷ ¾ð¾î·Î HTMLÀÇ ´Ü¼øÇÔ°ú SGMLÀÇ º¹ÀâÇÔÀ» ±Øº¹ÇÏ¿©, À¥ »ó¿¡¼ µ¥ÀÌÅ͸¦ Ç¥ÇöÇÏ°í ±³È¯Çϱâ À§ÇÑ Ç¥ÁØÀ¸·Î µîÀåÇÏ°í ÀÖ´Ù. XML ¹®¼¸¦ ÁúÀÇ Ã³¸®Çϱâ À§ÇÑ ¹æ¹ýÀ¸·Î XML ¹®¼ Àü¿ë ÁúÀÇ ¾ð¾î°¡ °³¹ßµÇ°í ÀÖÁö¸¸, µ¥ÀÌÅÍÀÇ ¾çÀÌ Áõ°¡ÇÑ´Ù¸é °á±¹ ¸·´ëÇÑ ¾çÀÇ µ¥ÀÌÅ͸¦ ó¸® ÇÒ µ¥ÀÌÅͺ£À̽º ½Ã½ºÅÛÀ» ÇÊ¿äÇÏ°Ô µÈ´Ù. º» ³í¹®¿¡¼´Â XML DTD¸¦ °ü°èÇü µ¥ÀÌÅͺ£À̽º ½Ã½ºÅÛ ½ºÅ°¸¶·Î º¯È¯ÇÏ´Â ±â¹ýÀ» Á¦¾ÈÇÑ´Ù. Á¦¾ÈµÈ ±â¹ýÀº XML µ¥ÀÌÅÍÀÇ ½ºÅ°¸¶ ¿ªÇÒÀ» ÇÏ´Â DTDÀÇ Æ®¸® ±¸Á¶¸¦ »ý¼ºÇÏ¿©, XML µ¥ÀÌÅ͵éÀÇ °øÅ뱸Á¶¿Í ºñ °øÅ뱸Á¶¸¦ ÃßÃâÇÑ ÈÄ °ü°èÇü µ¥ÀÌÅͺ£À̽º ½ºÅ°¸¶¸¦ ÃßÃâÇÏ´Â ±â¹ýÀÌ´Ù. ÃßÃâµÈ °ü°èÇü µ¥ÀÌÅͺ£À̽º ½ºÅ°¸¶´Â ±âÁ¸ÀÇ ¹æ¹ýµé¿¡ ºñÇØ »ý¼º Å×ÀÌºí ¼ö°¡ ÀûÀ¸¸ç, ³Î(NULL)°ªÀÇ ÃâÇöÀ» °¨¼Ò½ÃŲ´Ù. ¶ÇÇÑ, Á¦¾È±â¹ýÀº XML µ¥ÀÌÅ͸¦ º¸´Ù ÀûÀº Å×À̺í·Î ¸ÊÇÎ(mapping)½ÃÅ´À¸·Î½á µ¥ÀÌÅÍ °Ë»ö ½Ã ÂüÁ¶ Å×ÀÌºí ¼ö¸¦ °¨¼Ò½Ãų ¼ö ÀÖÀ¸¸ç ÁúÀÇ Ã³¸® ½Ã¿¡µµ ¼º´É ¸é¿¡¼ ¿ì¼öÇÔÀ» º¸ÀδÙ.
|
¿µ¹®³»¿ë (English Abstract) |
XML is emerging as a standard data format to exchange and to present data on the Web. There are increasing needs to efficiently store and to query XML data. In this paper, we propose a new schema transformation algorithm based on a common structure extracting technique from XML documents. The common structure is shared by all XML documents referenced by DTD and the uncommon structure is ununiformly appeared on all XML documents referenced by DTD. Based on the extracted common and uncommon structures, we transform XML DTD into relational database schema. We conduct a performance evaluation based on the number of the generated tables, the size of the record, query processing time and the number of joins on the query. The performance of our algorithm is compared with the existing algorithms, then in most cases, our algorithm is better than the existing ones with respect to the number of the generated tables and appearance of NULL values in the tables. |
Å°¿öµå(Keyword) |
XML
Extensible Markup Language
DTD
Document Type Defnition
°ü°èÇü µ¥ÀÌÅͺ£À̽º
Relational Database
½ºÅ°¸¶
Schema
Ä«µð³Î¸®Æ¼ ¿¬»êÀÚ
Cardinality operator
|
ÆÄÀÏ÷ºÎ |
PDF ´Ù¿î·Îµå
|