Tools

LEADER 03543cam 2200553Ii 4500

001 on1037952168;

003 OCoLC;

005 20180917125803.0;

006 m o d ;

007 cr unu||||||||;

008 180529s2018 ncua obm 000 0 eng d;

035 a| (Sirsi) o1037952168;

035 a| (OCoLC)1037952168;

049 a| EREE;

090 a| QA76.7;

100 1 a| Anderson, Davide| author.=| ^A210390;

245 10 a| Modeling and analysis of SQL queries in PHP systems /c| by David Anderson.;

264 1 a| [Greenville, N.C.] :b| [East Carolina University],c| 2018.;

300 a| 67 pages :b| illustrations;

336 a| textb| txt2| rdacontent;

337 a| computerb| c2| rdamedia;

338 a| online resourceb| cr2| rdacarrier;

347 a| text fileb| PDFc| 1.21 MB2| rda;

538 a| System requirements: Adobe Reader.;

538 a| Mode of access: World Wide Web.;

502 b| M.S.c| East Carolina Universityd| 2018;

500 a| Presented to the faculty of the Department of Computer Science;

500 a| Advisor: Mark Hills;

500 a| Title from PDF t.p. (viewed September 6, 2018).;

520 3 a| PHP is a common language used for creating dynamic websites. These websites often include the use of databases to store data, with embedded SQL queries constructed within the PHP code and executed through the use of database access libraries. One of these libraries is the original MySQL library that, despite not being supported in current versions of PHP, is still widely used in existing PHP code. As a first step towards developing program comprehension and transformation tools for PHP systems that use this library, this research presents a query modeling tool that models embedded SQL queries in PHP systems and an empirical study conducted through analysis of these models. A main focus of this study was to establish common patterns developers use to construct SQL queries and to extract information about their occurrences in actual PHP systems. Using these patterns, the parts of queries that are generally static, and the parts that are often computed at runtime were extracted. For dynamically computed query parts, we also extracted data about which PHP language features are used to construct them. Finally, information about which clauses most often differ based on control flow was extracted as well as counts for how often each SQL query type and SQL clause is used in practice. We believe this information is useful for future work on building program understanding and transformation tools to renovate PHP code using database libraries.;

504 a| Includes bibliographical references.;

650 0 a| Query languages (Computer science)=| ^A850130;

650 0 a| PHP (Computer program language)=| ^A519284;

650 0 a| SQL (Computer program language)=| ^A270202;

653 a| MySQL;

653 a| Program Analysis;

653 a| Database;

653 a| Modeling;

653 a| Empirical Software Engineering;

700 1 a| Hills, Mark,e| degree supervisor.?| UNAUTHORIZED;

710 2 a| East Carolina University.b| Department of Computer Science.?| UNAUTHORIZED;

856 40 z| Access via ScholarShipu| http://hdl.handle.net/10342/6743;

949 o| wjh;

994 a| C0b| ERE;

596 a| 1 4;

998 a| 4867543;

999 a| CLICK ON WEB ADDRESSw| ASISc| 1i| 4867543-1001l| JNETm| JOYNERr| Ys| Yt| JNE3ETDu| 5/31/2018x| ETDz| JERESOURCE;

999 a| CLICK ON WEB ADDRESSw| ASISc| 1i| 4867543-2001l| HSLELECm| HSLr| Ys| Yt| HEETDu| 5/31/2018x| ETDz| HERESOURCE;

Modeling and analysis of SQL queries in PHP systems / by David Anderson.

Author/creator	Anderson, David author.
Other author	Hills, Mark, degree supervisor.
Other author	East Carolina University. Department of Computer Science.
Format	Theses and dissertations
Publication	[Greenville, N.C.] : [East Carolina University], 2018.
Description	67 pages : illustrations
Supplemental Content	Access via ScholarShip
Subjects	Query languages (Computer science) PHP (Computer program language) SQL (Computer program language)

Summary	PHP is a common language used for creating dynamic websites. These websites often include the use of databases to store data, with embedded SQL queries constructed within the PHP code and executed through the use of database access libraries. One of these libraries is the original MySQL library that, despite not being supported in current versions of PHP, is still widely used in existing PHP code. As a first step towards developing program comprehension and transformation tools for PHP systems that use this library, this research presents a query modeling tool that models embedded SQL queries in PHP systems and an empirical study conducted through analysis of these models. A main focus of this study was to establish common patterns developers use to construct SQL queries and to extract information about their occurrences in actual PHP systems. Using these patterns, the parts of queries that are generally static, and the parts that are often computed at runtime were extracted. For dynamically computed query parts, we also extracted data about which PHP language features are used to construct them. Finally, information about which clauses most often differ based on control flow was extracted as well as counts for how often each SQL query type and SQL clause is used in practice. We believe this information is useful for future work on building program understanding and transformation tools to renovate PHP code using database libraries.
General note	Presented to the faculty of the Department of Computer Science
General note	Advisor: Mark Hills
General note	Title from PDF t.p. (viewed September 6, 2018).
Dissertation note	M.S. East Carolina University 2018
Bibliography note	Includes bibliographical references.
Technical details	System requirements: Adobe Reader.
Technical details	Mode of access: World Wide Web.

Availability

Library	Location	Call Number	Status	Item Actions
	Electronic Resources	Access Content Online	✔ Available

Modeling and analysis of SQL queries in PHP systems / by David Anderson.

Click here for more information about this title

Availability