{"_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", "sets": ["user-ucsy"]}, "communities": ["ucsy"], "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_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": "", "file_order": 0, "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.0, "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_value_mlt": [{"interim": "Publication"}]}, "item_1583108428133": {"attribute_name": "Publication type", "attribute_value_mlt": [{"interim": "Article"}]}, "item_1583159729339": {"attribute_name": "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": ["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}