Log in
Language:

MERAL Myanmar Education Research and Learning Portal

  • MERAL
  • Universities
  • Ranking
AND
To


Index Link

Index Tree

WEKO

One fine body…

Item

{"_buckets": {"deposit": "02c69664-555e-4e9f-939f-d0703cbcf831"}, "_deposit": {"id": "5083", "owners": [], "pid": {"revision_id": 0, "type": "recid", "value": "5083"}, "status": "published"}, "_oai": {"id": "oai:meral.edu.mm:recid/5083"}, "item_1583103067471": {"attribute_name": "Title", "attribute_value_mlt": [{"subitem_1551255647225": "Analysis of Query System for SQL and XQuery", "subitem_1551255648112": "en"}]}, "item_1583103085720": {"attribute_name": "Description", "attribute_value_mlt": [{"interim": "SQL is a special-purpose programminglanguage designed for managing data held in arelational database management system. XQueryis a standardized language for combiningdocuments, databases and Web pages. Amongmany query languages for native XML databases,XQuery is the most versatile and widely used, thusto analyze and compare the use of SQL againstXQuery is considered. This paper presentsanalysis of query system for SQL and XQuery. Thequery clauses used in this proposed systemareSelect Clause, Where Clause, Join Clause andOrder By Clause. This system convert from SQLdatabase into XML documents using SQL to XMLconversion algorithm and generate queries forSQL and XQuery using proposed query generationalgorithm. The processing times for each querytype of SQL and XQuery are analyzed in thissystem. From the experimental results, XQuerygenerally has faster processing time than SQL.However, XQuery cannot process and execute allfeatures that are available in SQL. In the case ofjoin statements, SQL turned out to be faster thanXQuery, because of predefined indexing."}]}, "item_1583103108160": {"attribute_name": "Keywords", "attribute_name_i18n": "Keywords", "attribute_value": []}, "item_1583103120197": {"attribute_name": "Files", "attribute_type": "file", "attribute_value_mlt": [{"accessrole": "open_access", "date": [{"dateType": "Available", "dateValue": "2019-07-18"}], "displaytype": "preview", "download_preview_message": "", "filename": "78_PDFsam_PSC_final proof.pdf", "filesize": [{"value": "137 Kb"}], "format": "application/pdf", "future_date_message": "", "is_thumbnail": false, "licensetype": "license_free", "mimetype": "application/pdf", "size": 137000, "url": {"url": "https://meral.edu.mm/record/5083/files/78_PDFsam_PSC_final proof.pdf"}, "version_id": "4ba986b5-6a4f-4ba2-86ad-c01336d42737"}]}, "item_1583103131163": {"attribute_name": "Journal articles", "attribute_value_mlt": [{"subitem_issue": "", "subitem_journal_title": "Eighth Local Conference on Parallel and Soft Computing", "subitem_pages": "", "subitem_volume": ""}]}, "item_1583103147082": {"attribute_name": "Conference papers", "attribute_value_mlt": [{"subitem_acronym": "", "subitem_c_date": "", "subitem_conference_title": "", "subitem_part": "", "subitem_place": "", "subitem_session": "", "subitem_website": ""}]}, "item_1583103211336": {"attribute_name": "Books/reports/chapters", "attribute_value_mlt": [{"subitem_book_title": "", "subitem_isbn": "", "subitem_pages": "", "subitem_place": "", "subitem_publisher": ""}]}, "item_1583103233624": {"attribute_name": "Thesis/dissertations", "attribute_value_mlt": [{"subitem_awarding_university": "", "subitem_supervisor(s)": [{"subitem_supervisor": ""}]}]}, "item_1583105942107": {"attribute_name": "Authors", "attribute_value_mlt": [{"subitem_authors": [{"subitem_authors_fullname": "Aung, Lwin Moe"}, {"subitem_authors_fullname": "Nyunt, Thi Thi Soe"}]}]}, "item_1583108359239": {"attribute_name": "Upload type", "attribute_name_i18n": "Upload type", "attribute_value": "Publication"}, "item_1583108428133": {"attribute_name": "Publication type", "attribute_name_i18n": "Publication type", "attribute_value": "Article"}, "item_1583159729339": {"attribute_name": "Publication date", "attribute_name_i18n": "Publication date", "attribute_value": "2017-12-27"}, "item_1583159847033": {"attribute_name": "Identifier", "attribute_value": "http://onlineresource.ucsy.edu.mm/handle/123456789/973"}, "item_title": "Analysis of Query System for SQL and XQuery", "item_type_id": "21", "owner": "1", "path": ["1582963302567/1597824273898"], "permalink_uri": "http://hdl.handle.net/20.500.12678/0000005083", "pubdate": {"attribute_name": "Deposited date", "attribute_value": "2019-07-18"}, "publish_date": "2019-07-18", "publish_status": "0", "recid": "5083", "relation": {}, "relation_version_is_last": true, "title": ["Analysis of Query System for SQL and XQuery"], "weko_shared_id": -1}
  1. University of Computer Studies, Yangon
  2. Conferences

Analysis of Query System for SQL and XQuery

http://hdl.handle.net/20.500.12678/0000005083
e427c972-f0a9-439f-a274-00509e25de45
02c69664-555e-4e9f-939f-d0703cbcf831
Preview
Name / File License Actions
78_PDFsam_PSC_final 78_PDFsam_PSC_final proof.pdf (137 Kb)
Publication type Article
Upload type Publication
Title
Analysis of Query System for SQL and XQuery
en
Publication date 2017-12-27
Authors
Aung, Lwin Moe
Nyunt, Thi Thi Soe
Description
SQL is a special-purpose programminglanguage designed for managing data held in arelational database management system. XQueryis a standardized language for combiningdocuments, databases and Web pages. Amongmany query languages for native XML databases,XQuery is the most versatile and widely used, thusto analyze and compare the use of SQL againstXQuery is considered. This paper presentsanalysis of query system for SQL and XQuery. Thequery clauses used in this proposed systemareSelect Clause, Where Clause, Join Clause andOrder By Clause. This system convert from SQLdatabase into XML documents using SQL to XMLconversion algorithm and generate queries forSQL and XQuery using proposed query generationalgorithm. The processing times for each querytype of SQL and XQuery are analyzed in thissystem. From the experimental results, XQuerygenerally has faster processing time than SQL.However, XQuery cannot process and execute allfeatures that are available in SQL. In the case ofjoin statements, SQL turned out to be faster thanXQuery, because of predefined indexing.
Journal articles
Eighth Local Conference on Parallel and Soft Computing
Conference papers
Books/reports/chapters
Thesis/dissertations
Back
0
0
views
downloads
See details
Views Downloads

Versions

Ver.1 2020-09-01 15:43:48.743729
Show All versions

Share

Mendeley CiteULike Twitter Facebook Print Addthis

Export

OAI-PMH
  • OAI-PMH DublinCore
Other Formats
  • JSON

Confirm


Back to MERAL


Back to MERAL