Static MySQL Error Checking

Simple item page
dc.contributor.advisorConnan, James
dc.contributor.authorZarinkhail, Mohammad Shuaib
dc.date.accessioned2021-09-30T12:47:41Z
dc.date.accessioned2024-10-30T14:01:00Z
dc.date.available2021-09-30T12:47:41Z
dc.date.available2024-10-30T14:01:00Z
dc.date.issued2010
dc.descriptionMasters of Scienceen_US
dc.description.abstractCoders of databases repeatedly face the problem of checking their Structured Query Language (SQL) code. Instructors face the difficulty of checking student projects and lab assignments in database courses. We collect and categorize common MySQL programming errors into three groups: data definition errors, data manipulation errors, and transaction control errors. We build these into a comprehensive list of MySQL errors, which novices are inclined make during database programming. We collected our list of common MySQL errors both from the technical literature and directly by noting errors made in assignments handed in by students. In the results section of this research, we check and summarize occurrences of these errors based on three characteristics as semantics, syntax, and logic. These data form the basis of a future static MySQL checker that will eventually assist database coders to correct their code automatically. These errors also form a useful checklist to guide students away from the mistakes that they are prone to make.en_US
dc.identifier.urihttps://hdl.handle.net/10566/16993
dc.language.isoenen_US
dc.publisherUniversity of the Western Capeen_US
dc.rights.holderUniversity of the Western Capeen_US
dc.subjectDatabaseen_US
dc.subjectStructured Query Language (SQL)en_US
dc.subjectMySQLen_US
dc.subjectStatic Checkingen_US
dc.subjectCoding Toolsen_US
dc.subjectSoftware Maintenanceen_US
dc.subjectProgram Conventionsen_US
dc.subjectError Checker Toolsen_US
dc.titleStatic MySQL Error Checkingen_US

Files

Original bundle
Now showing 1 - 1 of 1
Thumbnail Image
Name:
Zarinkhail_m_nsc_2010.pdf
Size:
86.35 MB
Format:
Adobe Portable Document Format
Download
License bundle
Now showing 1 - 1 of 1
No Thumbnail Available
Name:
license.txt
Size:
1.71 KB
Format:
Plain Text
Description:
Download

Collections

Magister Scientiae - MSc (Computer Science)