Mapping of XML Document and Relational Database (Using Structural Queries)

Pallavi Chikhale, Sinhgad Institute of Technology,Lonavala; Shital Harihar ,Sinhgad Institute of Technology,Lonavala; Vandna Adhude ,Sinhgad Institute of Technology,Lonavala; Prof. Prashant Raut ,Sinhgad Institute of Technology,Lonavala

XML, Relational Database, Time and Space Complexity, Stemming stopping process, Tree data structure

Now a day's, XML files are most vital facet of code trade. As a core normal, XML provides a solid foundation around that different standards could grow. Making DTD’s is possibly what the creators of XML had in mind after they known as it ex-tensile terminology. XML may be a file extension for XML file format accustomed produce common info formats and share each the format and also the information on the globe Wide internet, intranets, et al. victimization normal code text. XML provides regular thanks to describe semi-structured information. We tend to propose the propose methodology uses stemming stopping process in conjunction with tree structure. Performing stemming, stopping and parsing on that file, as per the tag file makes columns in relational database and insert tag information in the respective columns, all files saves in one folder. These embody consistency problems for mappings and schema, additionally as imposing tighter restrictions on mappings and queries to attain tractable question responsive in information exchange. The propose method can achieve better performance in decreasing of time and space complexities.
    [1] Huchao Zhu,Huiqun Yu(Corresponding Author), “Mini XML: An efficient mapping approach, between XML and Relational Database”,2017. [2] M.A. Ibrahim Fakharaldien, Jasni Mohamed Zain, and Norrozila Sulaiman,” XRecursive: A Storage Method for XML Document Based on Relational Database”, 2011 [3] Bousalem, Zakaria, and Ilias Cherti. "XMap: A Novel Approach to Store and Retrieve XML Document in Relational Databases." JSW 10.12 (2015): 1389-1401. [4] Masatoshi Yoshikawa and Toshiyuki Amagasa, “XRel: A Path-Based Approach to Storage and Retrieval of XML Documents using Relational Databases”, 2009 [5] Samini Subramaniam, Su-Cheng Haw, Poo Kuan Hoong,”s-XML: An efficient mapping scheme to bridge XML and relational database” [6] Arenas M, Barcel P, Libkin L, et al. Foundations of Data Exchange[C]// Cambridge University Press, 2014. [7] Vaidya AV, Study of Optimal Indexing Schema for Xml Query Processing and Effective Storage Management 2009 to 2013, 2015 [8] Yoshikawa M, Amagasa T, Shimura T, et al. XRel: a path-based approach to storage and retrieval of XML documents using relational databases [J]. Acm Transactions on Internet Technology, 2001, 1(1):110- 141 [9] Jiang H, Lu H, Wang W, et al. Path materialization revisited: an efficient storage model for XML data[C]// Australasian Database Conference. Australian Computer Society, Inc. 2002:85-94. [10] Dweib I M. Automatic mapping of XML documents into relational database [J]. University of Hudders eld, 2010. [11] Arenas M, Barcel P, Libkin L, et al. Relational and XML Data Exchange [J]. 2010, 2(1):112. [12] Arenas M, Barcel P, Libkin L, et al. Foundations of Data Exchange[C]//Cambridge University Press, 2014.
Paper ID: GRDJEV02I120036
Published in: Volume : 2, Issue : 12
Publication Date: 2017-12-01
Page(s): 47 - 49