Bridging XML and Relational Databases: An Effective Mapping Scheme based on Persistent Labeling

Subramaniam, Samini; Haw, Su-Cheng; Hoong, Poo Kuan

doi:10.11591/ijece.v2i2.215

Cited by 12 publications

(8 citation statements)

References 9 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…Good labeling is efficient to make sure the labels given to the XML nodes are uniquely identified. Hence, for the third approach of structural-based data mapping is s-XML [8], which is based on persistent labeling scheme [9]. Simple XML or better known as s-XML in short [8], utilised the persistent labeling to support the update labeling function without reconstructing the labels if any new nodes of insertion and deletion exist to the original XML document.…”

Section: Simple Xml (S-xml)mentioning

confidence: 99%

“…Table 1 and Table 2 depict the mapped result of ParentTable and ChildTable respectively. Subramaniam et al [8] found that s-XML has good performance because of the simple mapping approach usage and all data are distributed fairly among sufficient number of tables. In addition, the number of tables and format of the tables are fixed regardless of the XML document complexity.…”

Section: Simple Xml (S-xml)mentioning

confidence: 99%

See 1 more Smart Citation

Performance evaluation on structural mapping choices for data-centric XML documents

Haw

Soong

2020

IJEECS

Self Cite

View full text Add to dashboard Cite

<span>eXtensible Mark-up Language (XML) has been widely used as the de facto standard for data exchange over the Web. It is crucial to ensure that the data can be mapped correctly into the underlying data storage format, that is, without any lost of information. The two mapping strategies are structural-based and model-based. The structural-based mapping involves the presence of Data Type Definition (DTD) for schema mapping while the model-based mapping does not require the present of DTD or any schema for the mapping purpose. The structural-based mapping is good especially for data-centric type of data, i.e., data which is structured and can be binded into certain schema. As such, this paper evaluates and compares the performances of two selected existing structural-based mapping via simulation. Two main evaluations are: (i) storing the XML data into relational database (RDB), <br /> and (ii) querying the XML data from the RDB. The time taken for each respective process will be recorded and compared. From the experimental results, it is observed that the s-XML approach outperformed the SAX approach in terms of storing and query evaluations for most of the test cases conducted.</span>

show abstract

Section: Simple Xml (S-xml)mentioning

confidence: 99%

Section: Simple Xml (S-xml)mentioning

confidence: 99%

Performance evaluation on structural mapping choices for data-centric XML documents

Haw

Soong

2020

IJEECS

Self Cite

View full text Add to dashboard Cite

show abstract

“…Some of the information that can be explored from the information schema and useful in the process of matching schema, such as table, table_constraints, referential_constraints, and statistics. Thus, the proposed model does not use XML as an intermediary language ever developed by [43], [44].…”

Section: Information Schemamentioning

confidence: 99%

A Hybrid Model Schema Matching Using Constraint-Based and Instance-Based

Sutanta¹,

Wardoyo²,

Mustofa³

et al. 2016

IJECE

View full text Add to dashboard Cite

Schema matching is an important process in the Enterprise Information Integration (EII) which is at the level of the back end to solve the problems due to the schematic heterogeneity. This paper is a summary of preliminary result work of the model development stage as part of research on the development of models and prototype of hybrid schema matching that combines two methods, namely constraint-based and instance-based. The discussion includes a general description of the proposed models and the development of models, start from requirement analysis, data type conversion, matching mechanism, database support, constraints and instance extraction, matching and compute the similarity, preliminary result, user verification, verified result, dataset for testing, as well as the performance measurement. Based on result experiment on 36 datasets of heterogeneous RDBMS, it obtained the highest P value is 100.00% while the lowest is 71.43%; The highest R value is 100.00% while the lowest is 75.00%; and FMeasure highest value is 100.00% while the lowest is 81.48%. Unsuccessful matching on the model still happens, including use of an id attribute with data type as autoincrement; using codes that are defined in the same way but different meanings; and if encountered in common instance with the same definition but different meaning.

show abstract

“…It offers fast web application development and management, which makes it easy for web programmers to perform daily tasks, and supports multiple databases (MySQL, PostgreSQL, SQLite, etc.). Symfony is equipped with Doctrine, ORM, and the Symfony router has many options for configuring routes and annotations, YAML, XML and PHP [5].The authors [6] insist in their evaluation of performance of PHP frameworks, that Laravel is a framework that allows, on the one hand to work efficiently and is distinguished by the speed of its learning curve, it's very precise documentation and the support of the community as well.…”

Section: Introductionmentioning

confidence: 99%

A comparative study of laravel and symfony PHP frameworks

Laaziri

Benmoussa

Khoulji

et al. 2019

IJECE

View full text Add to dashboard Cite

With the current explosion of Information Systems, the market offers a wide range of interesting technological solutions. Yet, this does not mean adopting a technology without considering its impact on the existing information system and user expectations. It is recommended to identify and implement the technological solutions most suited to the Information Systems strategy. Therefore, new methods are emerging and design tools are still evolving; the PHP Frameworks are part of it, which open up new perspectives in terms of information system enrichment. In this context, this paper focuses on the elaboration of a comparative study between Laravel, symfony framworks, which are the most popular PHP frameworks. Thus, it provides an effective comparison model that merges seven dimensions: Features, Multilingual, System requirements, Technical architecture, Code Organization, Continuous Integration (CI) and finally Documentation and learning curve dimension. Results show that our model can be beneficial for IT project developers to select the suitable PHP Framework.

show abstract

Bridging XML and Relational Databases: An Effective Mapping Scheme based on Persistent Labeling

Cited by 12 publications

References 9 publications

Performance evaluation on structural mapping choices for data-centric XML documents

Performance evaluation on structural mapping choices for data-centric XML documents

A Hybrid Model Schema Matching Using Constraint-Based and Instance-Based

A comparative study of laravel and symfony PHP frameworks

Contact Info

Product

Resources

About