Matches in SemOpenAlex for { <https://semopenalex.org/work/W4366683866> ?p ?o ?g. }
- W4366683866 abstract "Abstract A key function of a software system is its ability to facilitate the manipulation of data, which is often implemented using a flavour of the Structured Query Language (SQL). To develop the data operations of software (i.e, creating, retrieving, updating, and deleting data), developers are required to excel in writing and combining both SQL and application code. The problem is that writing SQL code in itself is already challenging (e.g., SQL anti-patterns are commonplace) and combining SQL with application code (i.e., for SQL development tasks) is even more demanding. Meanwhile, we have little empirical understanding regarding the characteristics of SQL development tasks. Do SQL development tasks typically need more code changes? Do they typically have a longer time-to-completion? Answers to such questions would prepare the community for the potential challenges associated with such tasks. Our results obtained from 20 Apache projects reveal that SQL development tasks have a significantly longer time-to-completion than SQL-unrelated tasks and require significantly more code changes. Through our qualitative analyses, we observe that SQL development tasks require more spread out changes, effort in reviews and documentation. Our results also corroborate previous research highlighting the prevalence of SQL anti-patterns. The software engineering community should make provision for the peculiarities of SQL coding, in the delivery of safe and secure interactive software." @default.
- W4366683866 created "2023-04-24" @default.
- W4366683866 creator A5011391821 @default.
- W4366683866 creator A5029870224 @default.
- W4366683866 creator A5052196896 @default.
- W4366683866 creator A5075963364 @default.
- W4366683866 date "2023-04-21" @default.
- W4366683866 modified "2023-09-26" @default.
- W4366683866 title "Studying the characteristics of SQL-related development tasks: An empirical study" @default.
- W4366683866 cites W1520713572 @default.
- W4366683866 cites W1628063087 @default.
- W4366683866 cites W1972386298 @default.
- W4366683866 cites W1978813754 @default.
- W4366683866 cites W1983981789 @default.
- W4366683866 cites W1997519660 @default.
- W4366683866 cites W2000241667 @default.
- W4366683866 cites W2003751975 @default.
- W4366683866 cites W2018871545 @default.
- W4366683866 cites W2026815387 @default.
- W4366683866 cites W2037789405 @default.
- W4366683866 cites W2041282815 @default.
- W4366683866 cites W2043336433 @default.
- W4366683866 cites W2047278770 @default.
- W4366683866 cites W2051978688 @default.
- W4366683866 cites W2054848463 @default.
- W4366683866 cites W2062666593 @default.
- W4366683866 cites W2075762420 @default.
- W4366683866 cites W2096547436 @default.
- W4366683866 cites W2112146477 @default.
- W4366683866 cites W2119944098 @default.
- W4366683866 cites W2123218263 @default.
- W4366683866 cites W2131965410 @default.
- W4366683866 cites W2139410856 @default.
- W4366683866 cites W2140952846 @default.
- W4366683866 cites W2146503100 @default.
- W4366683866 cites W2149014999 @default.
- W4366683866 cites W2151570219 @default.
- W4366683866 cites W2203366176 @default.
- W4366683866 cites W2340417905 @default.
- W4366683866 cites W2530824252 @default.
- W4366683866 cites W2796283679 @default.
- W4366683866 cites W2807825607 @default.
- W4366683866 cites W2809221603 @default.
- W4366683866 cites W2866517308 @default.
- W4366683866 cites W2921110186 @default.
- W4366683866 cites W2950504429 @default.
- W4366683866 cites W2953617193 @default.
- W4366683866 cites W2954276596 @default.
- W4366683866 cites W2991727166 @default.
- W4366683866 cites W3003877692 @default.
- W4366683866 cites W3020616315 @default.
- W4366683866 cites W3048560297 @default.
- W4366683866 cites W3085921543 @default.
- W4366683866 cites W3090668201 @default.
- W4366683866 cites W3098845882 @default.
- W4366683866 cites W3103719551 @default.
- W4366683866 cites W3129254119 @default.
- W4366683866 cites W4229977739 @default.
- W4366683866 cites W4238769149 @default.
- W4366683866 cites W4254795600 @default.
- W4366683866 cites W4288080276 @default.
- W4366683866 cites W64046567 @default.
- W4366683866 cites W78698729 @default.
- W4366683866 doi "https://doi.org/10.1007/s10664-023-10295-x" @default.
- W4366683866 hasPublicationYear "2023" @default.
- W4366683866 type Work @default.
- W4366683866 citedByCount "0" @default.
- W4366683866 crossrefType "journal-article" @default.
- W4366683866 hasAuthorship W4366683866A5011391821 @default.
- W4366683866 hasAuthorship W4366683866A5029870224 @default.
- W4366683866 hasAuthorship W4366683866A5052196896 @default.
- W4366683866 hasAuthorship W4366683866A5075963364 @default.
- W4366683866 hasBestOaLocation W43666838661 @default.
- W4366683866 hasConcept C114724005 @default.
- W4366683866 hasConcept C115903868 @default.
- W4366683866 hasConcept C136764020 @default.
- W4366683866 hasConcept C141589383 @default.
- W4366683866 hasConcept C150451098 @default.
- W4366683866 hasConcept C154420247 @default.
- W4366683866 hasConcept C164120249 @default.
- W4366683866 hasConcept C167544706 @default.
- W4366683866 hasConcept C179531526 @default.
- W4366683866 hasConcept C194222762 @default.
- W4366683866 hasConcept C199360897 @default.
- W4366683866 hasConcept C32145003 @default.
- W4366683866 hasConcept C41008148 @default.
- W4366683866 hasConcept C510870499 @default.
- W4366683866 hasConcept C55596503 @default.
- W4366683866 hasConcept C77088390 @default.
- W4366683866 hasConcept C97854310 @default.
- W4366683866 hasConceptScore W4366683866C114724005 @default.
- W4366683866 hasConceptScore W4366683866C115903868 @default.
- W4366683866 hasConceptScore W4366683866C136764020 @default.
- W4366683866 hasConceptScore W4366683866C141589383 @default.
- W4366683866 hasConceptScore W4366683866C150451098 @default.
- W4366683866 hasConceptScore W4366683866C154420247 @default.
- W4366683866 hasConceptScore W4366683866C164120249 @default.
- W4366683866 hasConceptScore W4366683866C167544706 @default.
- W4366683866 hasConceptScore W4366683866C179531526 @default.
- W4366683866 hasConceptScore W4366683866C194222762 @default.