XAncestor: An efficient mapping approach for storing and querying XML documents in relational database using path-based technique

Qtaish, Amjad; Ahmad, Kamsuriah

doi:10.1016/j.knosys.2016.10.009

Cited by 14 publications

(15 citation statements)

References 17 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…The mapping scheme of XML to RDB are categorized into four main groups, namely, edge-based, node-based, path-based and hybrid-based scheme [8]. Among these, the edge-based scheme is the easiest, whereby all the edges are stored in a table.…”

Section: Issn: 2302-9285 mentioning

confidence: 99%

Transforming data-centric eXtensible markup language into relational databases using hybrid approach

Haw

Song

2021

Bulletin EEI

View full text Add to dashboard Cite

eXtensible markup language (XML) appeared internationally as the format for data representation over the web. Yet, most organizations are still utilising relational databases as their database solutions. As such, it is crucial to provide seamless integration via effective transformation between these database infrastructures. In this paper, we propose XML-REG to bridge these two technologies based on node-based and path-based approaches. The node-based approach is good to annotate each positional node uniquely, while the path-based approach provides summarised path information to join the nodes. On top of that, a new range labelling is also proposed to annotate nodes uniquely by ensuring the structural relationships are maintained between nodes. If a new node is to be added to the document, re-labelling is not required as the new label will be assigned to the node via the new proposed labelling scheme. Experimental evaluations indicated that the performance of XML-REG exceeded XMap, XRecursive, XAncestor and Mini-XML concerning storing time, query retrieval time and scalability. This research produces a core framework for XML to relational databases (RDB) mapping, which could be adopted in various industries.

show abstract

Section: Issn: 2302-9285 mentioning

confidence: 99%

Transforming data-centric eXtensible markup language into relational databases using hybrid approach

Haw

Song

2021

Bulletin EEI

View full text Add to dashboard Cite

show abstract

“…The authors compared the performance of Mini-XML against s-XML (citation), which indicated that Mini-XML has better performance and better storage space as well as more scalable to support huge XML data. In another approach, Qtaish and Ahmad [24] proposed XAncestor, which is also a path-based mapping technique. XAncestor contains of XtoDB, which is a mapping algorithm, and XtoSQL, which is a query retrieval algorithm and Fixed RDB, which is an integrated solution.…”

Section: Review On Existing Mapping Schemesmentioning

confidence: 99%

ORD-GAP: a hybrid-based labeling schemes to support XML dynamic updates

Amin

Haw

Subramaniam

2020

IJEECS

View full text Add to dashboard Cite

<span>eXtensible Markup Language (XML) has been widely used as the standard for data exchange standard over the Internet. With the fast growing rate of data, especially with high updates, it is crucial to ensure that the XML is able to cope with frequent changes with very least effect on the existing structure. Therefore, in this paper, we investigate on the existing labeling schemes and mapping approaches to gauge a better understanding in terms of the robustness of the labeling schemes and the importance of the mapping schemes. Next, we propose ORD-GAP labeling schemes to identify the structural relationship among XML nodes and yet, it is persistent to re-labeling when new nodes are inserted. Subsequently, a mapping scheme is proposed to transform XML into Relational Database (RDB). Preliminary experimental evaluation demonstrated that the proposed approach achieve 66% better as compared to ORDPATH, and 56% better as compared to ME labeling in terms of data loading time. </span>

show abstract

“…The XML Table database extension technique is constructed by extensible markup language (XML) [18,19]. This is accomplished by providing an XML data type or by adding the XML document into the database as a Large Object.…”

Section: Related Workmentioning

confidence: 99%

A native enhanced elastic extension tables multi-tenant database

Banhawy

Saber

Amer

2020

IJECE

View full text Add to dashboard Cite

A fundamental factor of digital image compression is the conversion processes. The intention of this process is to understand the shape of an image and to modify the digital image to a grayscale configuration where the encoding of the compression technique is operational. This article focuses on an investigation of compression algorithms for images with artistic effects. A key component in image compression is how to effectively preserve the original quality of images. Image compression is to condense by lessening the redundant data of images in order that they are transformed cost-effectively. The common techniques include discrete cosine transform (DCT), fast Fourier transform (FFT), and shifted FFT (SFFT). Experimental results point out compression ratio between original RGB images and grayscale images, as well as comparison. The superior algorithm improving a shape comprehension for images with grahic effect is SFFT technique.

show abstract

XAncestor: An efficient mapping approach for storing and querying XML documents in relational database using path-based technique

Cited by 14 publications

References 17 publications

Transforming data-centric eXtensible markup language into relational databases using hybrid approach

Transforming data-centric eXtensible markup language into relational databases using hybrid approach

ORD-GAP: a hybrid-based labeling schemes to support XML dynamic updates

A native enhanced elastic extension tables multi-tenant database

Contact Info

Product

Resources

About