Matches in SemOpenAlex for { <https://semopenalex.org/work/W4226413916> ?p ?o ?g. }
Showing items 1 to 57 of
57
with 100 items per page.
- W4226413916 abstract "Structured Query Language (SQL) remains the standard language used in Relational Database Management Systems (RDBMSs) and has found applications in healthcare (patient registries), businesses (inventories, trend analysis), military, education, etc. Although SQL statements are English-like, the process of writing SQL queries is often problematic for nontechnical end-users in the industry. Similarly, formulating and comprehending written queries can be confusing, especially for undergraduate students. One of the pivotal reasons given for these difficulties lies with the simple syntax of SQL, which is often misleading and hard to understand. An ideal solution is to present these two audiences: undergraduate students and nontechnical end-users with learning and practice tools. These tools are mostly electronic and can be used to aid their understanding, as well as enable them to write correct SQL queries. This work proposes a new approach aimed at understanding and writing correct SQL queries using principles from Formal Language and Automata Theory. We present algorithms based on: regular expressions for the recognition of simple query constructs, context-free grammars for the recognition of nested queries, and a jumping finite automaton for the synthesis of SQL queries from natural language descriptions. As proof of concept, these algorithms were further implemented into interactive software tools aimed at improving SQL comprehension. Evaluation of these tools showed that the majority of participants agreed that the tools were intuitive and aided their understanding of SQL queries. These tools should, therefore, find applications in aiding SQL comprehension at higher learning institutions and assist in the writing of correct queries in data-centered industries." @default.
- W4226413916 created "2022-05-05" @default.
- W4226413916 creator A5053034151 @default.
- W4226413916 date "2022-03-02" @default.
- W4226413916 modified "2023-09-27" @default.
- W4226413916 title "PhD thesis: SQL Comprehension and Synthesis" @default.
- W4226413916 doi "https://doi.org/10.48550/arxiv.2203.03469" @default.
- W4226413916 hasPublicationYear "2022" @default.
- W4226413916 type Work @default.
- W4226413916 citedByCount "0" @default.
- W4226413916 crossrefType "posted-content" @default.
- W4226413916 hasAuthorship W4226413916A5053034151 @default.
- W4226413916 hasBestOaLocation W42264139161 @default.
- W4226413916 hasConcept C141589383 @default.
- W4226413916 hasConcept C150451098 @default.
- W4226413916 hasConcept C154420247 @default.
- W4226413916 hasConcept C164120249 @default.
- W4226413916 hasConcept C167544706 @default.
- W4226413916 hasConcept C179531526 @default.
- W4226413916 hasConcept C194222762 @default.
- W4226413916 hasConcept C199360897 @default.
- W4226413916 hasConcept C206384180 @default.
- W4226413916 hasConcept C23123220 @default.
- W4226413916 hasConcept C41008148 @default.
- W4226413916 hasConcept C510870499 @default.
- W4226413916 hasConcept C55596503 @default.
- W4226413916 hasConcept C97854310 @default.
- W4226413916 hasConceptScore W4226413916C141589383 @default.
- W4226413916 hasConceptScore W4226413916C150451098 @default.
- W4226413916 hasConceptScore W4226413916C154420247 @default.
- W4226413916 hasConceptScore W4226413916C164120249 @default.
- W4226413916 hasConceptScore W4226413916C167544706 @default.
- W4226413916 hasConceptScore W4226413916C179531526 @default.
- W4226413916 hasConceptScore W4226413916C194222762 @default.
- W4226413916 hasConceptScore W4226413916C199360897 @default.
- W4226413916 hasConceptScore W4226413916C206384180 @default.
- W4226413916 hasConceptScore W4226413916C23123220 @default.
- W4226413916 hasConceptScore W4226413916C41008148 @default.
- W4226413916 hasConceptScore W4226413916C510870499 @default.
- W4226413916 hasConceptScore W4226413916C55596503 @default.
- W4226413916 hasConceptScore W4226413916C97854310 @default.
- W4226413916 hasLocation W42264139161 @default.
- W4226413916 hasOpenAccess W4226413916 @default.
- W4226413916 hasPrimaryLocation W42264139161 @default.
- W4226413916 hasRelatedWork W125463085 @default.
- W4226413916 hasRelatedWork W1432037690 @default.
- W4226413916 hasRelatedWork W1518435705 @default.
- W4226413916 hasRelatedWork W218121808 @default.
- W4226413916 hasRelatedWork W2240099544 @default.
- W4226413916 hasRelatedWork W2750425440 @default.
- W4226413916 hasRelatedWork W3022706651 @default.
- W4226413916 hasRelatedWork W619366292 @default.
- W4226413916 hasRelatedWork W638381921 @default.
- W4226413916 hasRelatedWork W243884246 @default.
- W4226413916 isParatext "false" @default.
- W4226413916 isRetracted "false" @default.
- W4226413916 workType "article" @default.