System Architecture and Implementation

System Architecture and Implementation

Ibrahim Dweib (Sultan Qaboos University, Oman) and Joan Lu (University of Huddersfield, UK)
DOI: 10.4018/978-1-4666-1975-3.ch017
OnDemand PDF Download:
$30.00
List Price: $37.50

Abstract

This chapter presents the system architecture, and implementation tools used for evaluating the MAXDOR model. The chapter also presents the main classes created to demonstrate the methodology for mapping XML document into relational database, rebuilding XML document from relational database, updating the content of XML document stored in relational database, XPath-To-SQL query translation, and building the result in XML format. Application on a case study is also presented. XML data sets from selected XML bench marks and XML data repository will be identified to be used for testing and evaluating the model. Finally, the chapter concludes with a summary.
Chapter Preview
Top

System Architecture And The Used Tools

<b>System Architecture</b></div><p>System architecture consists of four main components each of which represents one of the project requirements. Those components are:</p><ul class="xmlReaderUl"><li><i>1. </i><p><b>Mapping XML document into relational database:</b> the system loads the XML document and parses it using XML SAX parser as a sequence of events, shreds the document content into tokens, and inserts these tokens into predefined relational database schema. Detail of the relational schema has been given in chapter 4.</p></li><li><i>2. </i><p><b>Reconstructing XML document from relational database:</b> this component goes through the relational tables and reconstructs the requested XML document to check the method for lossless of XML document information in Part one or to exchange or export the document to other location.</p></li><li><i>3. </i><p><b>Updating XML document stored in relational database:</b> by this component, the user is given the facility to update the XML document stored in relational database. Update includes: inserting new tokens as element or element attributes, delete tokens or tokens' re-allocation within the document, and modify tokens' name and values.</p></li><li><i>4. </i><p><b>Retrieving and querying XML document stored in relational database:</b> throughout this component, XPath queries are translated into SQL statements. The resultant SQL statements are fired against the database engine so as to retrieve XML data results. The retrieved results are reconstructed as XML hierarchical format and returned to the user. Figure 1 gives an overview of the system architecture.</p></li></ul><div class="xmlReaderFig"><i>Figure 1. </i><div class="xmlReaderFig"><p>MAXDOR architecture</p></div><div style="width: 100%;"><a href="/sourcecontent/9781466619753_64884/978-1-4666-1975-3.ch017.f01.png" target="_blank"><img src="/sourcecontent/9781466619753_64884/978-1-4666-1975-3.ch017.f01.png" style="max-width: 100%;" /></a></div></graphic></div><p>The above listed components will be tested and evaluated in Chapter 6 for the MAXDOR model described in chapter 4. The following points are taken into consideration during system design; i.e. components of the system should be:</p><ul class="xmlReaderUl"><li><i>• </i><p><b>Testable against requirements:</b> every requirement should be easy to test.</p></li><li><i>• </i><p><b>Structured:</b> the system structure should be clear, read and its code should be easy and understandable.</p></li><li><i>• </i><p><b>Reusable:</b> the system design should be reusable and repeatable.</p></li></ul></div><div><title style="title-2" titleHref="tools-used"><b>Tools Used</b></div><p>The tools used in the project can be classified into:</p><ul class="xmlReaderUl"><li><i>1. </i><p>XML interface: both input and output documents are XML format and relational database technology is a target tool for storing XML documents' contents and structure; so, the relational database capabilities are used for internal processing of data.</p></li><li><i>2. </i><p>XPath or XQuery as source languages provided for users to represent their requests. SQL query language is a target language used against relational database to answer users’ queries. XPath is used for the following two reasons:</p><ul class="xmlReaderUl"><li><i>a. </i><p>XPath is simpler than XQuery, and hence would be better to achieve the objective of testing our model in current situation.</p></li><li><i>b. </i><p>Its structure is included in XQuery, so it is easier to be upgraded into XQuery.</p></li></ul></li><li><i>3. </i><p>Visual Basic 6.0 programming language is used as a tool to create the GUI and to implement the system components. It is used for the following reasons:</p><ul class="xmlReaderUl"><li><i>a. </i><p>VB structure is simple, mainly as to the executable code.</p></li><li><i>b. </i><p>VB is easy for building graphical user interfaces.</p></li><li><i>c. </i><p>VB application is easily connected with Microsoft Access database.</p></li></ul></li><li><i>4. </i><p>Microsoft Office Access is used as a relational database management system (RDBMS). It is used for the following reasons:</p><ul class="xmlReaderUl"><li><i>a. </i><p>It can be easily used with visual basic programming language.</p></li><li><i>b. </i><p>Access database can be easily sited on a website for access by remote users. Simple screens can be built in Access, Data Access Pages. Or it can be employed using Active Server Page (ASP) scripting.</p></li></ul></li></ul></div><div class="preview-footer"><a href="javascript:__doPostBack('ctl00$cphFeatured$lnkAddToCart','')">Purchase this chapter to continue reading all 13 pages ></a></div></div><div id="table-of-contents"><h2>Complete Chapter List</h2><div class="search-contents"><span class="text"> Search this Book: </span><span class="text-box-container"><input id="txtKeywords" type="text" maxlength="50" onkeypress="return SearchBookFulltextHandleEnter(event, 64884);" placeholder="Full text search terms" title="Full text search terms" class="full-text-search-box" /></span><div class="inline-block search-contents-xs-full-width"><span class="search"><span class="search-button" onclick="RemoveSpecialCharacters();SearchBookFulltext(64884);"></span></span><span class="reset"><span onclick="RemoveSpecialCharacters();SearchBookFulltextReset();" class="link-gray-s">Reset</span></span></div></div><div id="searchResults"></div><div id="full-toc"></div><div id="loading-toc" class="text-align-center"><div class="loading-icon-lg"></div></div><script type="text/javascript"> $(document).ready(function () { if (31 !== 0) { GetBookToc(64884, 69140, 2, 'True', '', '$37.50'); } else { GetBookTocFromSubmissionSystem(64884, 69140, 2, 'True', '', '$37.50'); } } ); </script></div></div></div></div><div class="contentcnav" style="display:none;"><span id="ctl00_cphFeatured_pnlAbstract"><a href="#abstract" class="navlinklightc">Abstract</a> | </span><span id="ctl00_cphFeatured_pnlPreview"><a href="#chapter-preview" class="navlinklightc">Chapter Preview</a> | </span><a href="#table-of-contents" class="navlinklightc">Complete Chapter List</a><div class="rightouter"><div class="rightheader"> Complete Book </div><div class="rightinner"><strong>$195.00 - $295.00</strong><div style="margin-top: 2px; padding-left: 2px;"><a href="/book/design-performance-analysis-innovative-information/64884" id="ctl00_cphFeatured_lnkBookPricing" class="navlinkcsmall">View Book Pricing Options</a></div></div></div><div id="ctl00_cphFeatured_ucInfoSciOnDemandSidebar_pnlSearch"><div class="panel-heading box-corner" data-toggle="collapse" data-target="#on-demand-search-toggle"><img src="/Images/infosci-ondemand-small.png" alt="InfoSci-OnDemand Powered Search" width="155" height="32" /></div><ul id="on-demand-search-toggle" class="nav nav-stacked list-unstyled collapse navbar-collapse nav-stacked-custom"><li style="padding: 6px 10px;"><div style="margin-bottom: 7px; font-size: 11px; color: #666;"> Full-text search over 107,700 research articles and chapters. </div><div style="display:inline-block;"><a onclick="RemoveSpecialCharacters();" id="ctl00_cphFeatured_ucInfoSciOnDemandSidebar_lnkSearch" class="ButtonBlack FloatRight" href="javascript:__doPostBack('ctl00$cphFeatured$ucInfoSciOnDemandSidebar$lnkSearch','')" style="height:19px;background-color:#777;"><span class="jQueryIconBlitzer ui-icon-search"></span></a><input name="ctl00$cphFeatured$ucInfoSciOnDemandSidebar$txtSearchPhrase" type="text" id="ctl00_cphFeatured_ucInfoSciOnDemandSidebar_txtSearchPhrase" class="SearchTextBox TextBoxWatermark FloatLeft" title="Full text search term(s)" style="width: 117px;" /></div></li></ul></div><div id="ctl00_cphFeatured_pnlRelatedTitles" class="rightouter"><div class="rightheader"> Related Chapters </div><div class="rightinner"><div class="list-item-link" style="border-bottom: dotted 1px #dadada; padding: 4px 0px; font-size: 11px;"><div title='Top-k Relevant Term Suggestion Approach for Relational Keyword Search'><a id="Link" href="/chapter/top-k-relevant-term-suggestion-approach-for-relational-keyword-search/138691" title='Top-k Relevant Term Suggestion Approach for Relational Keyword Search'> Top-k Relevant Term Suggestion Approach for... </a><div style="color: #555;">© 2016, 24 pp.</div></div></div><div class="list-item-link" style="border-bottom: dotted 1px #dadada; padding: 4px 0px; font-size: 11px;"><div title='Set-Oriented Queries in SQL'><a id="Link" href="/chapter/set-oriented-queries-in-sql/138692" title='Set-Oriented Queries in SQL'> Set-Oriented Queries in SQL </a><div style="color: #555;">© 2016, 24 pp.</div></div></div><div class="list-item-link" style="border-bottom: dotted 1px #dadada; padding: 4px 0px; font-size: 11px;"><div title='Evaluating Top-k Skyline Queries on R-Trees'><a id="Link" href="/chapter/evaluating-top-k-skyline-queries-on-r-trees/138693" title='Evaluating Top-k Skyline Queries on R-Trees'> Evaluating Top-k Skyline Queries on R-Trees </a><div style="color: #555;">© 2016, 39 pp.</div></div></div><div class="list-item-link" style="border-bottom: dotted 1px #dadada; padding: 4px 0px; font-size: 11px;"><div title='Processing of Queries with Fuzzy Similarity Domains'><a id="Link" href="/chapter/processing-of-queries-with-fuzzy-similarity-domains/138694" title='Processing of Queries with Fuzzy Similarity Domains'> Processing of Queries with Fuzzy Similarity Domains </a><div style="color: #555;">© 2016, 41 pp.</div></div></div><div class="list-item-link" style="border-bottom: dotted 1px #dadada; padding: 4px 0px; font-size: 11px;"><div title='Modeling and Querying Fuzzy Data'><a id="Link" href="/chapter/modeling-and-querying-fuzzy-data/138695" title='Modeling and Querying Fuzzy Data'> Modeling and Querying Fuzzy Data </a><div style="color: #555;">© 2016, 29 pp.</div></div></div><div class="list-item-link" style="border-bottom: dotted 1px #dadada; padding: 4px 0px; font-size: 11px;"><div title='Fuzzy XQuery'><a id="Link" href="/chapter/fuzzy-xquery/138696" title='Fuzzy XQuery'> Fuzzy XQuery </a><div style="color: #555;">© 2016, 41 pp.</div></div></div><div class="list-item-link" style="border-bottom: dotted 1px #dadada; padding: 4px 0px; font-size: 11px;"><div title='Probabilistic Ranking Method of XML Fuzzy Query Results'><a id="Link" href="/chapter/probabilistic-ranking-method-of-xml-fuzzy-query-results/138697" title='Probabilistic Ranking Method of XML Fuzzy Query Results'> Probabilistic Ranking Method of XML Fuzzy Query Results </a><div style="color: #555;">© 2016, 24 pp.</div></div></div></div></div><a href="/search/?sid=2&stid=138"><div class="rightnavad featuredtitles"><span class="item" style="font-size:14px;">More Library &<br />Info. Science Titles</span><span class="details"><strong>Related Titles</strong>View all Library &<br />Info. Science search results</span></div></a></div><script type="text/javascript"> MenuAdjust(); $(window).on('resize orientationChange', function (event) { MenuAdjust(); }); </script><footer class="footer"><div class="container"><div class="row"><div class="top-margin"><div class="col-md-6"><div class="footer-header"> Learn More </div><div class="text"><a href="/about/" class="footer-link">About IGI Global</a> | <a href="/publish/partnerships/" class="footer-link">Partnerships</a> | <a href="/contact/" class="footer-link">Contact</a> | <a href="/careers/" class="footer-link">Careers</a> | <a href="/faq/" class="footer-link">FAQ</a> | <a href="/staff/" class="footer-link">Staff</a></div><div class="footer-header header-margin-top"> Resources For </div><div class="text"><a href="/librarians/" class="footerlink">Librarians</a> | <a href="/publish/" class="footerlink">Authors/Editors</a> | <a href="/distributors/" class="footerlink">Distributors</a> | <a href="/course-adoption/" class="footerlink">Instructors</a> | <a href="/translators/" class="footerlink">Translators</a> | <a href="https://www.econtentpro.com/partners/referrer/2eeff007-a17a-e611-80c4-0cc47a0d221d?url=/copyediting" class="footerlink" target="_blank">Copy Editing Services</a></div><div class="footer-header header-margin-top"> Media Center </div><div class="text"><a href="/symposium/" class="footer-link">Online Symposium</a> | <a href="/newsroom/" class="footer-link">Blogs</a> | <a href="/catalogs/" class="footer-link">Catalogs</a> | <a href="/newsletters/" class="footer-link">Newsletters</a></div><div class="footer-header header-margin-top"> Policies </div><div class="text"><a href="/policies/privacy/" class="footer-link">Privacy Policy</a> | <a href="/policies/content-reuse/" class="footer-link">Content Reuse Policy</a> | <a href="/policies/ethics-and-malpractice/" class="footer-link">Ethics and Malpractice</a></div></div><div class="col-md-6 td-r"><div class="td-r-t"><div class="td-r-t-r"><a id="ctl00_lnkConferenceBadge" href="https://2018.alamidwinter.org/" target="_blank"><img src="/Images/ala-2018.png" alt="" style="height:124px;width:250px;" /></a></div><div class="td-r-t-l"><div class="t-space" style="margin-top:31px;"><a href="http://www.facebook.com/pages/IGI-Global/138206739534176?ref=sgm" target="_blank"><span class="fb"></span></a>  <a href="http://twitter.com/igiglobal" target="_blank"><span class="tw"></span></a></div><div class="b-space"><a href="http://www.world-forgotten-children.org" target="_blank"><img src="/images/proud-supporter-of-wfcf-07282015.png" alt="World Forgotten Children's Foundation" title="Proud Supporter of the World Forgotten Children's Foundation" width="157" height="52" /></a></div></div></div><div class="text"> Copyright © 1988-2017, IGI Global - All Rights Reserved </div><div class="td-r-ip"></div></div></div></div></div></footer><div class="aspNetHidden"><input type="hidden" name="__VIEWSTATEGENERATOR" id="__VIEWSTATEGENERATOR" value="679D6B48" /><input type="hidden" name="__EVENTVALIDATION" id="__EVENTVALIDATION" value="rQUvpiaAcOOxs99PxHvT4kWjbFjBpyZOHtGfa4685WIhPEaB7auM75S6yjo2lLJKm995J7wyKT2cTLgzSmgCNg74J4DzSSlO4x9y9g/xWWewI0d2FUSSXl/V2PqD8UuyqxZsSh7/J+jWpHvVPq+4FFb17iiwqMy1YMGGrY327p4N11wT8XrPWHGVxm3+nu96Ly8EBw4wpL/Kx7bEUu83cnPDnk3FeMJokb5Ntoz7U2SY2vhPZ9wrAfWDIHK4QMMNWzhStEk0NiZAUnwE9GuQw+9DZsK3lbFPJMNu11ph+R7yHk28fiebDv560yLx4IkjJM/7SwCGI07AKdNMiV+rm+ISk3wkzGqm/Z+oGKbPl/ILLJsS0Yf9qLpxaXwl+ecFdZYzOwTtPwHQCZ7Uvu6Do7ZiN0QRbQHBTEXcHjTMTRhog5ySvDF58nlpqFZiJJ4EjI6h37pe1zIGHg8m86hsP+DscrA=" /></div></form></body></html>