Using Genetic Algorithm as Test Data Generator for Stored PL/SQL Program Units
PL/SQL is the most common language for ORACLE database application. It allows the developer to create stored pro- gram units (Procedures, Functions, and Packages) to improve software reusability and hide the complexity of the execution of a specific operation behind a name. Also, it acts as an inter...
Gespeichert in:
| Veröffentlicht in: | Journal of software engineering and applications 2013-02, Vol.6 (2), p.65-73 |
|---|---|
| Hauptverfasser: | , , , |
| Format: | Artikel |
| Sprache: | eng |
| Schlagworte: | |
| Online-Zugang: | Volltext |
| Tags: |
Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
|
| container_end_page | 73 |
|---|---|
| container_issue | 2 |
| container_start_page | 65 |
| container_title | Journal of software engineering and applications |
| container_volume | 6 |
| creator | Alshraideh, Mohammad A. Mahafzah, Basel A. Salman, Hamzeh S. Eyal Salah, Imad |
| description | PL/SQL is the most common language for ORACLE database application. It allows the developer to create stored pro- gram units (Procedures, Functions, and Packages) to improve software reusability and hide the complexity of the execution of a specific operation behind a name. Also, it acts as an interface between SQL database and DEVELOPER. Therefore, it is important to test these modules that consist of procedures and functions. In this paper, a new genetic algorithm (GA), as search technique, is used in order to find the required test data according to branch criteria to test stored PL/SQL program units. The experimental results show that this was not fully achieved, such that the test target in some branches is not reached and the coverage percentage is 98%. A problem rises when target branch is depending on data retrieved from tables; in this case, GA is not able to generate test cases for this branch. [PUBLICAITONABSTRACT] |
| doi_str_mv | 10.4236/jsea.2013.62011 |
| format | Article |
| fullrecord | <record><control><sourceid>proquest_cross</sourceid><recordid>TN_cdi_proquest_miscellaneous_1365144852</recordid><sourceformat>XML</sourceformat><sourcesystem>PC</sourcesystem><sourcerecordid>1365144852</sourcerecordid><originalsourceid>FETCH-LOGICAL-c1601-586180a74b29745025a5c37790fea2e622a408bf4a5c1058824ec2dfeec765e73</originalsourceid><addsrcrecordid>eNo9kM1PAjEQxRujiYievfboZaHfLUeCiiYbxQDnZiizuGQ_sF0O_vcuYjzMzMvMy8vkR8g9ZyMlpBnvE8JIMC5Hpu_8ggz4ROlMcqEu_zU31-QmpT1jxmllB-RtncpmR-fYYFcGOq12bSy7z5pCoitMHX2EDn7PEbo20qKvZS9wSxf5ePmR00VsdxFqum7KLt2SqwKqhHd_c0jWz0-r2UuWv89fZ9M8C9wwnmlnuGNg1UZMrNJMaNBBWjthBYJAIwQo5jaF6tecaeeEwiC2BWKwRqOVQ_Jwzj3E9uvY_-nrMgWsKmiwPSbPpdFcKadFbx2frSG2KUUs_CGWNcRvz5k_kfMncv5Ezv-Skz_qaF_I</addsrcrecordid><sourcetype>Aggregation Database</sourcetype><iscdi>true</iscdi><recordtype>article</recordtype><pqid>1365144852</pqid></control><display><type>article</type><title>Using Genetic Algorithm as Test Data Generator for Stored PL/SQL Program Units</title><source>Elektronische Zeitschriftenbibliothek - Frei zugängliche E-Journals</source><creator>Alshraideh, Mohammad A. ; Mahafzah, Basel A. ; Salman, Hamzeh S. Eyal ; Salah, Imad</creator><creatorcontrib>Alshraideh, Mohammad A. ; Mahafzah, Basel A. ; Salman, Hamzeh S. Eyal ; Salah, Imad</creatorcontrib><description>PL/SQL is the most common language for ORACLE database application. It allows the developer to create stored pro- gram units (Procedures, Functions, and Packages) to improve software reusability and hide the complexity of the execution of a specific operation behind a name. Also, it acts as an interface between SQL database and DEVELOPER. Therefore, it is important to test these modules that consist of procedures and functions. In this paper, a new genetic algorithm (GA), as search technique, is used in order to find the required test data according to branch criteria to test stored PL/SQL program units. The experimental results show that this was not fully achieved, such that the test target in some branches is not reached and the coverage percentage is 98%. A problem rises when target branch is depending on data retrieved from tables; in this case, GA is not able to generate test cases for this branch. [PUBLICAITONABSTRACT]</description><identifier>ISSN: 1945-3116</identifier><identifier>EISSN: 1945-3124</identifier><identifier>DOI: 10.4236/jsea.2013.62011</identifier><language>eng</language><subject>Computer programs ; Developers ; Gallium ; Genetic algorithms ; Packages ; Query languages ; Tables</subject><ispartof>Journal of software engineering and applications, 2013-02, Vol.6 (2), p.65-73</ispartof><oa>free_for_read</oa><woscitedreferencessubscribed>false</woscitedreferencessubscribed><citedby>FETCH-LOGICAL-c1601-586180a74b29745025a5c37790fea2e622a408bf4a5c1058824ec2dfeec765e73</citedby><cites>FETCH-LOGICAL-c1601-586180a74b29745025a5c37790fea2e622a408bf4a5c1058824ec2dfeec765e73</cites></display><links><openurl>$$Topenurl_article</openurl><openurlfulltext>$$Topenurlfull_article</openurlfulltext><thumbnail>$$Tsyndetics_thumb_exl</thumbnail><link.rule.ids>315,781,785,27929,27930</link.rule.ids></links><search><creatorcontrib>Alshraideh, Mohammad A.</creatorcontrib><creatorcontrib>Mahafzah, Basel A.</creatorcontrib><creatorcontrib>Salman, Hamzeh S. Eyal</creatorcontrib><creatorcontrib>Salah, Imad</creatorcontrib><title>Using Genetic Algorithm as Test Data Generator for Stored PL/SQL Program Units</title><title>Journal of software engineering and applications</title><description>PL/SQL is the most common language for ORACLE database application. It allows the developer to create stored pro- gram units (Procedures, Functions, and Packages) to improve software reusability and hide the complexity of the execution of a specific operation behind a name. Also, it acts as an interface between SQL database and DEVELOPER. Therefore, it is important to test these modules that consist of procedures and functions. In this paper, a new genetic algorithm (GA), as search technique, is used in order to find the required test data according to branch criteria to test stored PL/SQL program units. The experimental results show that this was not fully achieved, such that the test target in some branches is not reached and the coverage percentage is 98%. A problem rises when target branch is depending on data retrieved from tables; in this case, GA is not able to generate test cases for this branch. [PUBLICAITONABSTRACT]</description><subject>Computer programs</subject><subject>Developers</subject><subject>Gallium</subject><subject>Genetic algorithms</subject><subject>Packages</subject><subject>Query languages</subject><subject>Tables</subject><issn>1945-3116</issn><issn>1945-3124</issn><fulltext>true</fulltext><rsrctype>article</rsrctype><creationdate>2013</creationdate><recordtype>article</recordtype><recordid>eNo9kM1PAjEQxRujiYievfboZaHfLUeCiiYbxQDnZiizuGQ_sF0O_vcuYjzMzMvMy8vkR8g9ZyMlpBnvE8JIMC5Hpu_8ggz4ROlMcqEu_zU31-QmpT1jxmllB-RtncpmR-fYYFcGOq12bSy7z5pCoitMHX2EDn7PEbo20qKvZS9wSxf5ePmR00VsdxFqum7KLt2SqwKqhHd_c0jWz0-r2UuWv89fZ9M8C9wwnmlnuGNg1UZMrNJMaNBBWjthBYJAIwQo5jaF6tecaeeEwiC2BWKwRqOVQ_Jwzj3E9uvY_-nrMgWsKmiwPSbPpdFcKadFbx2frSG2KUUs_CGWNcRvz5k_kfMncv5Ezv-Skz_qaF_I</recordid><startdate>20130201</startdate><enddate>20130201</enddate><creator>Alshraideh, Mohammad A.</creator><creator>Mahafzah, Basel A.</creator><creator>Salman, Hamzeh S. Eyal</creator><creator>Salah, Imad</creator><scope>AAYXX</scope><scope>CITATION</scope><scope>7SC</scope><scope>8FD</scope><scope>JQ2</scope><scope>L7M</scope><scope>L~C</scope><scope>L~D</scope></search><sort><creationdate>20130201</creationdate><title>Using Genetic Algorithm as Test Data Generator for Stored PL/SQL Program Units</title><author>Alshraideh, Mohammad A. ; Mahafzah, Basel A. ; Salman, Hamzeh S. Eyal ; Salah, Imad</author></sort><facets><frbrtype>5</frbrtype><frbrgroupid>cdi_FETCH-LOGICAL-c1601-586180a74b29745025a5c37790fea2e622a408bf4a5c1058824ec2dfeec765e73</frbrgroupid><rsrctype>articles</rsrctype><prefilter>articles</prefilter><language>eng</language><creationdate>2013</creationdate><topic>Computer programs</topic><topic>Developers</topic><topic>Gallium</topic><topic>Genetic algorithms</topic><topic>Packages</topic><topic>Query languages</topic><topic>Tables</topic><toplevel>online_resources</toplevel><creatorcontrib>Alshraideh, Mohammad A.</creatorcontrib><creatorcontrib>Mahafzah, Basel A.</creatorcontrib><creatorcontrib>Salman, Hamzeh S. Eyal</creatorcontrib><creatorcontrib>Salah, Imad</creatorcontrib><collection>CrossRef</collection><collection>Computer and Information Systems Abstracts</collection><collection>Technology Research Database</collection><collection>ProQuest Computer Science Collection</collection><collection>Advanced Technologies Database with Aerospace</collection><collection>Computer and Information Systems Abstracts Academic</collection><collection>Computer and Information Systems Abstracts Professional</collection><jtitle>Journal of software engineering and applications</jtitle></facets><delivery><delcategory>Remote Search Resource</delcategory><fulltext>fulltext</fulltext></delivery><addata><au>Alshraideh, Mohammad A.</au><au>Mahafzah, Basel A.</au><au>Salman, Hamzeh S. Eyal</au><au>Salah, Imad</au><format>journal</format><genre>article</genre><ristype>JOUR</ristype><atitle>Using Genetic Algorithm as Test Data Generator for Stored PL/SQL Program Units</atitle><jtitle>Journal of software engineering and applications</jtitle><date>2013-02-01</date><risdate>2013</risdate><volume>6</volume><issue>2</issue><spage>65</spage><epage>73</epage><pages>65-73</pages><issn>1945-3116</issn><eissn>1945-3124</eissn><abstract>PL/SQL is the most common language for ORACLE database application. It allows the developer to create stored pro- gram units (Procedures, Functions, and Packages) to improve software reusability and hide the complexity of the execution of a specific operation behind a name. Also, it acts as an interface between SQL database and DEVELOPER. Therefore, it is important to test these modules that consist of procedures and functions. In this paper, a new genetic algorithm (GA), as search technique, is used in order to find the required test data according to branch criteria to test stored PL/SQL program units. The experimental results show that this was not fully achieved, such that the test target in some branches is not reached and the coverage percentage is 98%. A problem rises when target branch is depending on data retrieved from tables; in this case, GA is not able to generate test cases for this branch. [PUBLICAITONABSTRACT]</abstract><doi>10.4236/jsea.2013.62011</doi><tpages>9</tpages><oa>free_for_read</oa></addata></record> |
| fulltext | fulltext |
| identifier | ISSN: 1945-3116 |
| ispartof | Journal of software engineering and applications, 2013-02, Vol.6 (2), p.65-73 |
| issn | 1945-3116 1945-3124 |
| language | eng |
| recordid | cdi_proquest_miscellaneous_1365144852 |
| source | Elektronische Zeitschriftenbibliothek - Frei zugängliche E-Journals |
| subjects | Computer programs Developers Gallium Genetic algorithms Packages Query languages Tables |
| title | Using Genetic Algorithm as Test Data Generator for Stored PL/SQL Program Units |
| url | https://sfx.bib-bvb.de/sfx_tum?ctx_ver=Z39.88-2004&ctx_enc=info:ofi/enc:UTF-8&ctx_tim=2024-12-14T13%3A37%3A45IST&url_ver=Z39.88-2004&url_ctx_fmt=infofi/fmt:kev:mtx:ctx&rfr_id=info:sid/primo.exlibrisgroup.com:primo3-Article-proquest_cross&rft_val_fmt=info:ofi/fmt:kev:mtx:journal&rft.genre=article&rft.atitle=Using%20Genetic%20Algorithm%20as%20Test%20Data%20Generator%20for%20Stored%20PL/SQL%20Program%20Units&rft.jtitle=Journal%20of%20software%20engineering%20and%20applications&rft.au=Alshraideh,%20Mohammad%20A.&rft.date=2013-02-01&rft.volume=6&rft.issue=2&rft.spage=65&rft.epage=73&rft.pages=65-73&rft.issn=1945-3116&rft.eissn=1945-3124&rft_id=info:doi/10.4236/jsea.2013.62011&rft_dat=%3Cproquest_cross%3E1365144852%3C/proquest_cross%3E%3Curl%3E%3C/url%3E&disable_directlink=true&sfx.directlink=off&sfx.report_link=0&rft_id=info:oai/&rft_pqid=1365144852&rft_id=info:pmid/&rfr_iscdi=true |