{"id":"https://openalex.org/W1629636929","doi":null,"title":"SQL pattern design, development & evaluation of its efficacy","display_name":"SQL pattern design, development & evaluation of its efficacy","publication_year":2013,"publication_date":"2013-01-01","ids":{"openalex":"https://openalex.org/W1629636929","mag":"1629636929"},"language":"en","primary_location":{"id":"pmh:oai:theses.gla.ac.uk:4632","doi":null,"is_oa":true,"landing_page_url":"https://theses.gla.ac.uk/4632/1/2013HudaPhD.pdf","pdf_url":"https://theses.gla.ac.uk/4632/1/2013HudaPhD.pdf","source":{"id":"https://openalex.org/S4306401724","display_name":"Enlighten: Theses (The University of Glasgow)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I7882870","host_organization_name":"University of Glasgow","host_organization_lineage":["https://openalex.org/I7882870"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"Thesis"},"volume":null,"type":"dissertation","is_traditional":true,"indexed_in":[],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://theses.gla.ac.uk/4632/1/2013HudaPhD.pdf","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5011662900","display_name":"Huda Salim Al Shuaily","orcid":"https://orcid.org/0000-0003-3935-5696","observed_orcids":["https://orcid.org/0000-0003-3935-5696"]},"institutions":[],"countries":[],"is_corresponding":true,"raw_author_name":"Huda Al-Shuaily","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":0,"corresponding_author_ids":["https://openalex.org/A5011662900"],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":null,"has_fulltext":true,"cited_by_count":4,"citation_normalized_percentile":null,"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":null,"last_page":null},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10533","display_name":"Teaching and Learning Programming","score":0.9937000274658203,"subfield":{"id":"https://openalex.org/subfields/1706","display_name":"Computer Science Applications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T10533","display_name":"Teaching and Learning Programming","score":0.9937000274658203,"subfield":{"id":"https://openalex.org/subfields/1706","display_name":"Computer Science Applications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T11299","display_name":"Problem and Project Based Learning","score":0.0006000000284984708,"subfield":{"id":"https://openalex.org/subfields/3304","display_name":"Education"},"field":{"id":"https://openalex.org/fields/33","display_name":"Social Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T10672","display_name":"Design Education and Practice","score":0.0006000000284984708,"subfield":{"id":"https://openalex.org/subfields/2210","display_name":"Mechanical Engineering"},"field":{"id":"https://openalex.org/fields/22","display_name":"Engineering"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.7110000252723694},{"id":"https://openalex.org/keywords/sql-learning","display_name":"SQL learning","score":0.5070000290870667},{"id":"https://openalex.org/keywords/novice-programmers","display_name":"novice programmers","score":0.6620000004768372},{"id":"https://openalex.org/keywords/problem-solving-strategies","display_name":"problem-solving strategies","score":0.6650000214576721},{"id":"https://openalex.org/keywords/student-errors","display_name":"student errors","score":0.5659999847412109},{"id":"https://openalex.org/keywords/instructional-design","display_name":"instructional design","score":0.8830000162124634},{"id":"https://openalex.org/keywords/learning-taxonomy","display_name":"taxonomy of learning","score":0.593999981880188},{"id":"https://openalex.org/keywords/knowledge-structuring","display_name":"knowledge structuring","score":0.46399998664855957},{"id":"https://openalex.org/keywords/programming-education","display_name":"programming education","score":0.46799999475479126}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8013383150100708},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.7505456209182739},{"id":"https://openalex.org/C167544706","wikidata":"https://www.wikidata.org/wiki/Q360842","display_name":"SQL/PSM","level":5,"score":0.7013909816741943},{"id":"https://openalex.org/C55596503","wikidata":"https://www.wikidata.org/wiki/Q1431648","display_name":"Data definition language","level":3,"score":0.6892330646514893},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.596015989780426},{"id":"https://openalex.org/C141589383","wikidata":"https://www.wikidata.org/wiki/Q644775","display_name":"Data Transformation Services","level":5,"score":0.5601429343223572},{"id":"https://openalex.org/C32145003","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"PL/SQL","level":5,"score":0.544418454170227},{"id":"https://openalex.org/C154420247","wikidata":"https://www.wikidata.org/wiki/Q846619","display_name":"Stored procedure","level":5,"score":0.4905640482902527},{"id":"https://openalex.org/C114724005","wikidata":"https://www.wikidata.org/wiki/Q5001740","display_name":"Business Intelligence Markup Language","level":5,"score":0.45837047696113586},{"id":"https://openalex.org/C206384180","wikidata":"https://www.wikidata.org/wiki/Q599380","display_name":"User-defined function","level":5,"score":0.4311322569847107},{"id":"https://openalex.org/C150451098","wikidata":"https://www.wikidata.org/wiki/Q506059","display_name":"SQL injection","level":5,"score":0.4161908030509949},{"id":"https://openalex.org/C203763787","wikidata":"https://www.wikidata.org/wiki/Q371029","display_name":"Null (SQL)","level":2,"score":0.41042810678482056},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.391021192073822},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.32784608006477356},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.32280486822128296},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.21041053533554077},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.0},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"pmh:oai:theses.gla.ac.uk:4632","doi":null,"is_oa":true,"landing_page_url":"https://theses.gla.ac.uk/4632/1/2013HudaPhD.pdf","pdf_url":"https://theses.gla.ac.uk/4632/1/2013HudaPhD.pdf","source":{"id":"https://openalex.org/S4306401724","display_name":"Enlighten: Theses (The University of Glasgow)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I7882870","host_organization_name":"University of Glasgow","host_organization_lineage":["https://openalex.org/I7882870"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"Thesis"},{"id":"mag:1629636929","doi":null,"is_oa":false,"landing_page_url":"https://ethos.bl.uk/OrderDetails.do?uin=uk.bl.ethos.586781","pdf_url":null,"source":null,"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":null}],"best_oa_location":{"id":"pmh:oai:theses.gla.ac.uk:4632","doi":null,"is_oa":true,"landing_page_url":"https://theses.gla.ac.uk/4632/1/2013HudaPhD.pdf","pdf_url":"https://theses.gla.ac.uk/4632/1/2013HudaPhD.pdf","source":{"id":"https://openalex.org/S4306401724","display_name":"Enlighten: Theses (The University of Glasgow)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I7882870","host_organization_name":"University of Glasgow","host_organization_lineage":["https://openalex.org/I7882870"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"Thesis"},"sustainable_development_goals":[{"display_name":"Quality education","id":"https://metadata.un.org/sdg/4","score":0.9235000014305115}],"study_designs":[],"awards":[],"funders":[],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W1629636929.pdf","grobid_xml":"https://content.openalex.org/works/W1629636929.grobid-xml"},"referenced_works_count":197,"referenced_works":["https://openalex.org/W48698079","https://openalex.org/W86773645","https://openalex.org/W107400008","https://openalex.org/W121527782","https://openalex.org/W125470328","https://openalex.org/W160923426","https://openalex.org/W173833665","https://openalex.org/W183937364","https://openalex.org/W197224857","https://openalex.org/W309732829","https://openalex.org/W1485165618","https://openalex.org/W1487083903","https://openalex.org/W1490481200","https://openalex.org/W1491094752","https://openalex.org/W1514297918","https://openalex.org/W1517090266","https://openalex.org/W1519179082","https://openalex.org/W1525276615","https://openalex.org/W1526142870","https://openalex.org/W1530579895","https://openalex.org/W1539137778","https://openalex.org/W1539190387","https://openalex.org/W1555629481","https://openalex.org/W1572700383","https://openalex.org/W1575391024","https://openalex.org/W1576563839","https://openalex.org/W1606424393","https://openalex.org/W1616782664","https://openalex.org/W1649645444","https://openalex.org/W1658908529","https://openalex.org/W1663587272","https://openalex.org/W1675691148","https://openalex.org/W1707104629","https://openalex.org/W1708874574","https://openalex.org/W1767209519","https://openalex.org/W1814452870","https://openalex.org/W1855222194","https://openalex.org/W1936022305","https://openalex.org/W1964523235","https://openalex.org/W1967806879","https://openalex.org/W1968344832","https://openalex.org/W1971492392","https://openalex.org/W1971946407","https://openalex.org/W1972065054","https://openalex.org/W1975534901","https://openalex.org/W1978346963","https://openalex.org/W1978966145","https://openalex.org/W1980169328","https://openalex.org/W1982812705","https://openalex.org/W1984143402","https://openalex.org/W1984462523","https://openalex.org/W1987975131","https://openalex.org/W1988384676","https://openalex.org/W1990566596","https://openalex.org/W1991379186","https://openalex.org/W1996650435","https://openalex.org/W1996850986","https://openalex.org/W1997427448","https://openalex.org/W2001911618","https://openalex.org/W2005945371","https://openalex.org/W2006216391","https://openalex.org/W2010110136","https://openalex.org/W2011126315","https://openalex.org/W2012014499","https://openalex.org/W2012546969","https://openalex.org/W2013094602","https://openalex.org/W2014243053","https://openalex.org/W2016009178","https://openalex.org/W2020126579","https://openalex.org/W2021759136","https://openalex.org/W2023195463","https://openalex.org/W2023725224","https://openalex.org/W2023745308","https://openalex.org/W2024931533","https://openalex.org/W2026190834","https://openalex.org/W2028985814","https://openalex.org/W2031681640","https://openalex.org/W2031992007","https://openalex.org/W2032492903","https://openalex.org/W2032664893","https://openalex.org/W2035704953","https://openalex.org/W2036389121","https://openalex.org/W2036586008","https://openalex.org/W2036832324","https://openalex.org/W2037085022","https://openalex.org/W2037901177","https://openalex.org/W2038828659","https://openalex.org/W2039458811","https://openalex.org/W2040888129","https://openalex.org/W2042160049","https://openalex.org/W2044009024","https://openalex.org/W2044142939","https://openalex.org/W2045224349","https://openalex.org/W2045362184","https://openalex.org/W2047323026","https://openalex.org/W2047926687","https://openalex.org/W2048297257","https://openalex.org/W2049400871","https://openalex.org/W2050299516","https://openalex.org/W2050428880","https://openalex.org/W2050525049","https://openalex.org/W2050781086","https://openalex.org/W2052213808","https://openalex.org/W2052838775","https://openalex.org/W2053125339","https://openalex.org/W2054003466","https://openalex.org/W2056642597","https://openalex.org/W2058580210","https://openalex.org/W2058655740","https://openalex.org/W2059217279","https://openalex.org/W2062384560","https://openalex.org/W2062573889","https://openalex.org/W2063984628","https://openalex.org/W2065994439","https://openalex.org/W2067860008","https://openalex.org/W2067978534","https://openalex.org/W2070187221","https://openalex.org/W2071100465","https://openalex.org/W2072031888","https://openalex.org/W2074731714","https://openalex.org/W2075504538","https://openalex.org/W2077539104","https://openalex.org/W2078221905","https://openalex.org/W2079905355","https://openalex.org/W2081354636","https://openalex.org/W2081768662","https://openalex.org/W2082897112","https://openalex.org/W2084637687","https://openalex.org/W2084946441","https://openalex.org/W2085832100","https://openalex.org/W2086946356","https://openalex.org/W2088007521","https://openalex.org/W2089371540","https://openalex.org/W2091785129","https://openalex.org/W2093215282","https://openalex.org/W2094622158","https://openalex.org/W2096036274","https://openalex.org/W2096431252","https://openalex.org/W2098307754","https://openalex.org/W2099859313","https://openalex.org/W2101568455","https://openalex.org/W2105206539","https://openalex.org/W2105455005","https://openalex.org/W2107626942","https://openalex.org/W2111054044","https://openalex.org/W2111163098","https://openalex.org/W2112020161","https://openalex.org/W2114700889","https://openalex.org/W2116343313","https://openalex.org/W2117976212","https://openalex.org/W2119877360","https://openalex.org/W2121523410","https://openalex.org/W2122801122","https://openalex.org/W2122838852","https://openalex.org/W2126385963","https://openalex.org/W2132516581","https://openalex.org/W2134260873","https://openalex.org/W2134606933","https://openalex.org/W2138432297","https://openalex.org/W2138709157","https://openalex.org/W2139408427","https://openalex.org/W2142368091","https://openalex.org/W2142597445","https://openalex.org/W2142635908","https://openalex.org/W2144546400","https://openalex.org/W2147026337","https://openalex.org/W2147070375","https://openalex.org/W2147285514","https://openalex.org/W2147903259","https://openalex.org/W2150147167","https://openalex.org/W2150629868","https://openalex.org/W2155651731","https://openalex.org/W2156210158","https://openalex.org/W2158033511","https://openalex.org/W2158081248","https://openalex.org/W2161967143","https://openalex.org/W2164097948","https://openalex.org/W2164599981","https://openalex.org/W2165343097","https://openalex.org/W2165805288","https://openalex.org/W2167146080","https://openalex.org/W2169484290","https://openalex.org/W2169973224","https://openalex.org/W2184504303","https://openalex.org/W2216374816","https://openalex.org/W2220588559","https://openalex.org/W2290839663","https://openalex.org/W2296348267","https://openalex.org/W2333196491","https://openalex.org/W2342091124","https://openalex.org/W2753710282","https://openalex.org/W2810929306","https://openalex.org/W2905452322","https://openalex.org/W2985538229","https://openalex.org/W3125763078","https://openalex.org/W3160329928","https://openalex.org/W3217611625"],"related_works":["https://openalex.org/W2289656759","https://openalex.org/W2514647172","https://openalex.org/W3092022493","https://openalex.org/W2149283267","https://openalex.org/W2902816530","https://openalex.org/W2972483799","https://openalex.org/W3093228195","https://openalex.org/W3172255581","https://openalex.org/W3009770877","https://openalex.org/W3003642164"],"abstract_inverted_index":{"Databases":[0],"provide":[1],"the":[2,35,63,67,77,129,142,185,198,250],"foundation":[3],"of":[4,76,99,114,131,184,200,217,239,252],"most":[5],"software":[6],"systems.":[7],"This":[8,104],"means":[9],"that":[10,47],"system":[11],"developers":[12],"will":[13],"inevitably":[14],"need":[15],"to":[16,19,52,128,145,174,206,248],"write":[17],"code":[18],"query":[20],"these":[21],"databases.":[22],"The":[23,71,84,122,136,182],"de":[24],"facto":[25],"language":[26,36],"for":[27],"querying":[28],"is":[29,34,44,124],"SQL":[30,82,100,109,115,147,150,158,179,186,208,210,229],"and":[31,57,65,69,89,118,141,163,177,197],"this,":[32],"consequently,":[33],"primarily":[37],"taught":[38],"by":[39,61,91],"higher":[40],"education":[41],"institutions.":[42],"There":[43],"some":[45],"evidence":[46,93],"learners":[48,240],"find":[49],"it":[50],"hard":[51],"master":[53],"SQL.":[54],"These":[55],"issues":[56,79,86],"concerns":[58],"were":[59,87],"confirmed":[60,88],"reviewing":[62],"literature":[64,72],"establishing":[66],"scope":[68],"context.":[70],"review":[73],"allowed":[74],"extraction":[75],"common":[78],"in":[80,204,224,227,241],"impacting":[81],"acquisition.":[83],"identified":[85],"justified":[90],"empirical":[92],"as":[94,126,149,192,212,214],"reported":[95],"here.":[96],"A":[97,165,231],"model":[98,107,113],"learning":[101,110],"was":[102,172],"derived.":[103],"framework":[105,123],"or":[106],"involves":[108],"taxonomy,":[111],"a":[112,132,215,236,242],"problem":[116,194],"solving":[117,195],"incorporates":[119],"cross-cutting":[120],"factors.":[121],"used":[125],"map":[127],"design":[130,137],"proposed":[133,213],"instructional":[134],"design.":[135],"employed":[138,173],"pattern":[139,180],"concepts":[140],"related":[143],"research":[144],"structure":[146],"knowledge":[148],"patterns.":[151],"Also":[152],"presented":[153],"are":[154],"details":[155],"on":[156],"how":[157],"patterns":[159,187],"could":[160],"be":[161,246],"organized":[162],"presented.":[164],"strong":[166],"theoretical":[167],"background":[168],"(checklist,":[169],"component-level":[170],"design)":[171],"organize,":[175],"present":[176],"facilitated":[178],"collection.":[181],"evaluation":[183],"yielded":[188,220],"new":[189],"insight":[190],"such":[191],"novice":[193,225],"strategies":[196],"types":[199],"errors":[201],"students":[202],"made":[203],"attempting":[205],"solve":[207],"problems.":[209],"patterns,":[211],"result":[216],"this":[218,253],"research,":[219],"statistically":[221],"significant":[222],"important":[223],"performance":[226],"writing":[228],"queries.":[230],"longitudinal":[232],"field":[233],"study":[234],"with":[235],"large":[237],"number":[238],"flexible":[243],"environment":[244],"should":[245],"conducted":[247],"confirm":[249],"findings":[251],"research.":[254]},"counts_by_year":[{"year":2021,"cited_by_count":1},{"year":2019,"cited_by_count":1},{"year":2015,"cited_by_count":1},{"year":2014,"cited_by_count":1}],"updated_date":"2026-11-04T10:54:05.112534","created_date":"2016-06-24T00:00:00"}