Mutation Analysis for SQL Database Applications
Testing database applications is crucial for ensuring good quality software as undetected faults can result in unrecoverable data corruption. SQL is the most widely used interface language for relational database systems. Our approach aims to achieve better testing by selecting fault revealing datab...
Gespeichert in:
| Hauptverfasser: | , , |
|---|---|
| Format: | Tagungsbericht |
| Sprache: | eng |
| Schlagworte: | |
| Online-Zugang: | Volltext bestellen |
| Tags: |
Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
|
| container_end_page | 151 |
|---|---|
| container_issue | |
| container_start_page | 146 |
| container_title | |
| container_volume | |
| creator | Cabeca, A.G. Jino, M. Leitao-Junior, P.S. |
| description | Testing database applications is crucial for ensuring good quality software as undetected faults can result in unrecoverable data corruption. SQL is the most widely used interface language for relational database systems. Our approach aims to achieve better testing by selecting fault revealing databases. We propose the use of mutation analysis on SQL statements and discuss two scenarios for applying strong and weak mutation techniques. Experiments using real applications, real faults and real data were performed to: (i) evaluate the applicability of the approach, and (ii) compare fault-revealing abilities of input databases. |
| doi_str_mv | 10.1109/ICSEA.2009.30 |
| format | Conference Proceeding |
| fullrecord | <record><control><sourceid>ieee_6IE</sourceid><recordid>TN_cdi_ieee_primary_5298467</recordid><sourceformat>XML</sourceformat><sourcesystem>PC</sourcesystem><ieee_id>5298467</ieee_id><sourcerecordid>5298467</sourcerecordid><originalsourceid>FETCH-LOGICAL-i175t-1555808f19aecab74a6f2701e0b8aff1198088d77c856abdaacd71a331af90ea3</originalsourceid><addsrcrecordid>eNotjE1Lw0AUAFdE0NYePXnJH0j6Xvbj7R5DrFqIlFI9l5dkFxZiG7Lx0H-vqKc5zDBCPCAUiODW2_qwqYoSwBUSrsQCyDgtiUhdiwWqUilF5OytWKUUWygNGasU3on129fMczyfsurEwyXFlIXzlB32TfbEM7ecfFaN4xC73yrdi5vAQ_Krfy7Fx_PmvX7Nm93Ltq6aPCLpOUettQUb0LHvuCXFJpQE6KG1HAKi-7G2J-qsNtz2zF1PyFIiBwee5VI8_n2j9_44TvGTp8tRl84qQ_IbwDNDCw</addsrcrecordid><sourcetype>Publisher</sourcetype><iscdi>true</iscdi><recordtype>conference_proceeding</recordtype></control><display><type>conference_proceeding</type><title>Mutation Analysis for SQL Database Applications</title><source>IEEE Electronic Library (IEL) Conference Proceedings</source><creator>Cabeca, A.G. ; Jino, M. ; Leitao-Junior, P.S.</creator><creatorcontrib>Cabeca, A.G. ; Jino, M. ; Leitao-Junior, P.S.</creatorcontrib><description>Testing database applications is crucial for ensuring good quality software as undetected faults can result in unrecoverable data corruption. SQL is the most widely used interface language for relational database systems. Our approach aims to achieve better testing by selecting fault revealing databases. We propose the use of mutation analysis on SQL statements and discuss two scenarios for applying strong and weak mutation techniques. Experiments using real applications, real faults and real data were performed to: (i) evaluate the applicability of the approach, and (ii) compare fault-revealing abilities of input databases.</description><identifier>ISBN: 1424447798</identifier><identifier>ISBN: 9781424447794</identifier><identifier>EISBN: 0769537774</identifier><identifier>EISBN: 9780769537771</identifier><identifier>DOI: 10.1109/ICSEA.2009.30</identifier><language>eng</language><publisher>IEEE</publisher><subject>Collaborative software ; Costs ; Data analysis ; database testing ; Genetic mutations ; mutation testing ; Programming ; quality assurance ; Scheduling ; software testing ; Sorting ; SQL ; Taxonomy ; Uncertainty</subject><ispartof>2009 Fourth International Conference on Software Engineering Advances, 2009, p.146-151</ispartof><woscitedreferencessubscribed>false</woscitedreferencessubscribed></display><links><openurl>$$Topenurl_article</openurl><openurlfulltext>$$Topenurlfull_article</openurlfulltext><thumbnail>$$Tsyndetics_thumb_exl</thumbnail><linktohtml>$$Uhttps://ieeexplore.ieee.org/document/5298467$$EHTML$$P50$$Gieee$$H</linktohtml><link.rule.ids>309,310,777,781,786,787,2052,27906,54901</link.rule.ids><linktorsrc>$$Uhttps://ieeexplore.ieee.org/document/5298467$$EView_record_in_IEEE$$FView_record_in_$$GIEEE</linktorsrc></links><search><creatorcontrib>Cabeca, A.G.</creatorcontrib><creatorcontrib>Jino, M.</creatorcontrib><creatorcontrib>Leitao-Junior, P.S.</creatorcontrib><title>Mutation Analysis for SQL Database Applications</title><title>2009 Fourth International Conference on Software Engineering Advances</title><addtitle>ICSEA</addtitle><description>Testing database applications is crucial for ensuring good quality software as undetected faults can result in unrecoverable data corruption. SQL is the most widely used interface language for relational database systems. Our approach aims to achieve better testing by selecting fault revealing databases. We propose the use of mutation analysis on SQL statements and discuss two scenarios for applying strong and weak mutation techniques. Experiments using real applications, real faults and real data were performed to: (i) evaluate the applicability of the approach, and (ii) compare fault-revealing abilities of input databases.</description><subject>Collaborative software</subject><subject>Costs</subject><subject>Data analysis</subject><subject>database testing</subject><subject>Genetic mutations</subject><subject>mutation testing</subject><subject>Programming</subject><subject>quality assurance</subject><subject>Scheduling</subject><subject>software testing</subject><subject>Sorting</subject><subject>SQL</subject><subject>Taxonomy</subject><subject>Uncertainty</subject><isbn>1424447798</isbn><isbn>9781424447794</isbn><isbn>0769537774</isbn><isbn>9780769537771</isbn><fulltext>true</fulltext><rsrctype>conference_proceeding</rsrctype><creationdate>2009</creationdate><recordtype>conference_proceeding</recordtype><sourceid>6IE</sourceid><sourceid>RIE</sourceid><recordid>eNotjE1Lw0AUAFdE0NYePXnJH0j6Xvbj7R5DrFqIlFI9l5dkFxZiG7Lx0H-vqKc5zDBCPCAUiODW2_qwqYoSwBUSrsQCyDgtiUhdiwWqUilF5OytWKUUWygNGasU3on129fMczyfsurEwyXFlIXzlB32TfbEM7ecfFaN4xC73yrdi5vAQ_Krfy7Fx_PmvX7Nm93Ltq6aPCLpOUettQUb0LHvuCXFJpQE6KG1HAKi-7G2J-qsNtz2zF1PyFIiBwee5VI8_n2j9_44TvGTp8tRl84qQ_IbwDNDCw</recordid><startdate>200909</startdate><enddate>200909</enddate><creator>Cabeca, A.G.</creator><creator>Jino, M.</creator><creator>Leitao-Junior, P.S.</creator><general>IEEE</general><scope>6IE</scope><scope>6IL</scope><scope>CBEJK</scope><scope>RIE</scope><scope>RIL</scope></search><sort><creationdate>200909</creationdate><title>Mutation Analysis for SQL Database Applications</title><author>Cabeca, A.G. ; Jino, M. ; Leitao-Junior, P.S.</author></sort><facets><frbrtype>5</frbrtype><frbrgroupid>cdi_FETCH-LOGICAL-i175t-1555808f19aecab74a6f2701e0b8aff1198088d77c856abdaacd71a331af90ea3</frbrgroupid><rsrctype>conference_proceedings</rsrctype><prefilter>conference_proceedings</prefilter><language>eng</language><creationdate>2009</creationdate><topic>Collaborative software</topic><topic>Costs</topic><topic>Data analysis</topic><topic>database testing</topic><topic>Genetic mutations</topic><topic>mutation testing</topic><topic>Programming</topic><topic>quality assurance</topic><topic>Scheduling</topic><topic>software testing</topic><topic>Sorting</topic><topic>SQL</topic><topic>Taxonomy</topic><topic>Uncertainty</topic><toplevel>online_resources</toplevel><creatorcontrib>Cabeca, A.G.</creatorcontrib><creatorcontrib>Jino, M.</creatorcontrib><creatorcontrib>Leitao-Junior, P.S.</creatorcontrib><collection>IEEE Electronic Library (IEL) Conference Proceedings</collection><collection>IEEE Proceedings Order Plan All Online (POP All Online) 1998-present by volume</collection><collection>IEEE Xplore All Conference Proceedings</collection><collection>IEEE Electronic Library (IEL)</collection><collection>IEEE Proceedings Order Plans (POP All) 1998-Present</collection></facets><delivery><delcategory>Remote Search Resource</delcategory><fulltext>fulltext_linktorsrc</fulltext></delivery><addata><au>Cabeca, A.G.</au><au>Jino, M.</au><au>Leitao-Junior, P.S.</au><format>book</format><genre>proceeding</genre><ristype>CONF</ristype><atitle>Mutation Analysis for SQL Database Applications</atitle><btitle>2009 Fourth International Conference on Software Engineering Advances</btitle><stitle>ICSEA</stitle><date>2009-09</date><risdate>2009</risdate><spage>146</spage><epage>151</epage><pages>146-151</pages><isbn>1424447798</isbn><isbn>9781424447794</isbn><eisbn>0769537774</eisbn><eisbn>9780769537771</eisbn><abstract>Testing database applications is crucial for ensuring good quality software as undetected faults can result in unrecoverable data corruption. SQL is the most widely used interface language for relational database systems. Our approach aims to achieve better testing by selecting fault revealing databases. We propose the use of mutation analysis on SQL statements and discuss two scenarios for applying strong and weak mutation techniques. Experiments using real applications, real faults and real data were performed to: (i) evaluate the applicability of the approach, and (ii) compare fault-revealing abilities of input databases.</abstract><pub>IEEE</pub><doi>10.1109/ICSEA.2009.30</doi><tpages>6</tpages></addata></record> |
| fulltext | fulltext_linktorsrc |
| identifier | ISBN: 1424447798 |
| ispartof | 2009 Fourth International Conference on Software Engineering Advances, 2009, p.146-151 |
| issn | |
| language | eng |
| recordid | cdi_ieee_primary_5298467 |
| source | IEEE Electronic Library (IEL) Conference Proceedings |
| subjects | Collaborative software Costs Data analysis database testing Genetic mutations mutation testing Programming quality assurance Scheduling software testing Sorting SQL Taxonomy Uncertainty |
| title | Mutation Analysis for SQL Database Applications |
| url | https://sfx.bib-bvb.de/sfx_tum?ctx_ver=Z39.88-2004&ctx_enc=info:ofi/enc:UTF-8&ctx_tim=2025-01-20T18%3A40%3A55IST&url_ver=Z39.88-2004&url_ctx_fmt=infofi/fmt:kev:mtx:ctx&rfr_id=info:sid/primo.exlibrisgroup.com:primo3-Article-ieee_6IE&rft_val_fmt=info:ofi/fmt:kev:mtx:book&rft.genre=proceeding&rft.atitle=Mutation%20Analysis%20for%20SQL%20Database%20Applications&rft.btitle=2009%20Fourth%20International%20Conference%20on%20Software%20Engineering%20Advances&rft.au=Cabeca,%20A.G.&rft.date=2009-09&rft.spage=146&rft.epage=151&rft.pages=146-151&rft.isbn=1424447798&rft.isbn_list=9781424447794&rft_id=info:doi/10.1109/ICSEA.2009.30&rft_dat=%3Cieee_6IE%3E5298467%3C/ieee_6IE%3E%3Curl%3E%3C/url%3E&rft.eisbn=0769537774&rft.eisbn_list=9780769537771&disable_directlink=true&sfx.directlink=off&sfx.report_link=0&rft_id=info:oai/&rft_id=info:pmid/&rft_ieee_id=5298467&rfr_iscdi=true |