{"id":"https://openalex.org/W2289656759","doi":null,"title":"SQL Pattern Design and Development","display_name":"SQL Pattern Design and Development","alternate_titles":[],"publication_year":2014,"publication_date":"2014-05-25","ids":{"openalex":"https://openalex.org/W2289656759","mag":"2289656759"},"language":"en","primary_location":{"id":"mag:2289656759","doi":null,"is_oa":false,"landing_page_url":"https://www.thinkmind.org/download.php?articleid=patterns_2014_1_10_70002","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},"parent_works":[],"lineage":["https://openalex.org/W2289656759"],"child_works_count":0,"type":"article","is_traditional":true,"indexed_in":[],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"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":[{"id":"https://openalex.org/I119744171","display_name":"Higher Colleges of Technology","ror":"https://ror.org/00qmy9z88","country_code":"AE","type":"education","lineage":["https://openalex.org/I119744171"]}],"countries":["AE"],"is_corresponding":false,"contributor_roles":[],"raw_author_name":"Huda Al-Shuaily","raw_affiliation_strings":["Higher College of Technology"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Higher College of Technology","institution_ids":["https://openalex.org/I119744171"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5035796880","display_name":"Karen Renaud","orcid":"https://orcid.org/0000-0002-7187-6531","observed_orcids":["https://orcid.org/0000-0002-7187-6531"]},"institutions":[{"id":"https://openalex.org/I7882870","display_name":"University of Glasgow","ror":"https://ror.org/00vtgdb53","country_code":"GB","type":"education","lineage":["https://openalex.org/I7882870"]}],"countries":["GB"],"is_corresponding":false,"contributor_roles":[],"raw_author_name":"Karen Renaud","raw_affiliation_strings":["*University of Glasgow"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"*University of Glasgow","institution_ids":["https://openalex.org/I7882870"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":1,"citation_normalized_percentile":{"value":0.0,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":87,"max":92},"biblio":{"volume":null,"issue":null,"first_page":"1","last_page":"7"},"is_retracted":false,"is_pulled":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10533","display_name":"Teaching and Learning Programming","score":0.9731000065803528,"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.9731000065803528,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.0038999998942017555,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"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/T10906","display_name":"AI-based Problem Solving and Planning","score":0.0015999999595806003,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/sql-learning","display_name":"SQL learning","score":0.5590000152587891},{"id":"https://openalex.org/keywords/novice-programmers","display_name":"novice programmers","score":0.8289999961853027},{"id":"https://openalex.org/keywords/instructional-material","display_name":"instructional material","score":0.5659999847412109},{"id":"https://openalex.org/keywords/knowledge-transfer","display_name":"knowledge transfer","score":0.746999979019165},{"id":"https://openalex.org/keywords/learning-models","display_name":"learning models","score":0.6890000104904175},{"id":"https://openalex.org/keywords/programming-education","display_name":"programming education","score":0.43799999356269836}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8301959037780762},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.6980482935905457},{"id":"https://openalex.org/C55596503","wikidata":"https://www.wikidata.org/wiki/Q1431648","display_name":"Data definition language","level":3,"score":0.6690667271614075},{"id":"https://openalex.org/C167544706","wikidata":"https://www.wikidata.org/wiki/Q360842","display_name":"SQL/PSM","level":5,"score":0.6266332864761353},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.6186729073524475},{"id":"https://openalex.org/C141589383","wikidata":"https://www.wikidata.org/wiki/Q644775","display_name":"Data Transformation Services","level":5,"score":0.5725194811820984},{"id":"https://openalex.org/C150451098","wikidata":"https://www.wikidata.org/wiki/Q506059","display_name":"SQL injection","level":5,"score":0.5270119905471802},{"id":"https://openalex.org/C154420247","wikidata":"https://www.wikidata.org/wiki/Q846619","display_name":"Stored procedure","level":5,"score":0.5252774953842163},{"id":"https://openalex.org/C98045186","wikidata":"https://www.wikidata.org/wiki/Q205663","display_name":"Process (computing)","level":2,"score":0.4933396875858307},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.4253028631210327},{"id":"https://openalex.org/C32145003","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"PL/SQL","level":5,"score":0.4213241934776306},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.3994078040122986},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.2447463870048523},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.23869436979293823},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.07987821102142334},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"mag:2289656759","doi":null,"is_oa":false,"landing_page_url":"https://www.thinkmind.org/download.php?articleid=patterns_2014_1_10_70002","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":null,"sustainable_development_goals":[{"display_name":"Quality education","id":"https://metadata.un.org/sdg/4","score":0.6164000034332275}],"study_designs":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":17,"referenced_works":["https://openalex.org/W181402224","https://openalex.org/W1557557006","https://openalex.org/W1580749063","https://openalex.org/W1629636929","https://openalex.org/W1982812705","https://openalex.org/W2036832324","https://openalex.org/W2047323026","https://openalex.org/W2057347716","https://openalex.org/W2074610374","https://openalex.org/W2090253867","https://openalex.org/W2111054044","https://openalex.org/W2116343313","https://openalex.org/W2122801122","https://openalex.org/W2155651731","https://openalex.org/W2158081248","https://openalex.org/W2573894086","https://openalex.org/W3086342064"],"related_works":["https://openalex.org/W1629636929","https://openalex.org/W2514647172","https://openalex.org/W3092022493","https://openalex.org/W2282583353","https://openalex.org/W3093740538","https://openalex.org/W2149283267","https://openalex.org/W1466460680","https://openalex.org/W2534674944","https://openalex.org/W2517400928","https://openalex.org/W2117817374"],"abstract_inverted_index":{"This":[0,29],"paper":[1],"presents":[2],"the":[3,7,34,51,57,63,66,74,107,113],"processes":[4],"involved":[5],"in":[6,33,83],"design":[8],"and":[9,43,130,144],"development":[10,58],"of":[11,14,50,59,65,116,127],"a":[12],"set":[13,91],"Structure":[15],"Query":[16],"Language":[17],"(SQL)":[18],"patterns.":[19,118],"The":[20],"intention":[21],"is":[22,31],"to":[23,70,72,86,93,97],"support":[24,73,87],"novices":[25,129],"during":[26,56],"SQL":[27,35,47,95,117,133,141],"acquisition.":[28,48],"process":[30,108],"grounded":[32],"learning":[36,40],"model":[37,61],"developed":[38],"from":[39],"theory":[41],"literature":[42],"empirical":[44],"investigations":[45],"into":[46],"One":[49],"crucial":[52],"crosscutting":[53],"factors":[54],"identified":[55,112],"this":[60,99],"was":[62],"quality":[64],"instructional":[67,103],"material":[68],"provided":[69],"learners":[71],"acquisition":[75],"process.":[76],"Since":[77],"patterns":[78,96,120],"have":[79],"been":[80],"successfully":[81],"deployed":[82],"other":[84],"areas":[85],"knowledge":[88],"transfer,":[89],"we":[90,111],"out":[92],"develop":[94],"meet":[98],"need":[100],"for":[101],"effective":[102],"material.":[104],"We":[105,135],"detail":[106],"by":[109,137],"which":[110],"required":[114],"components":[115],"Our":[119],"were":[121],"also":[122],"informed":[123],"based":[124],"on":[125],"observations":[126],"how":[128],"experts":[131],"solved":[132],"queries.":[134],"conclude":[136],"presenting":[138],"our":[139],"proposed":[140],"pattern":[142],"content":[143],"structure.":[145],"Keywords-Pattern;":[146],"SQL;":[147],"Expert":[148]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W2289656759","counts_by_year":[{"year":2013,"cited_by_count":1}],"updated_date":"2026-11-21T10:27:49.728292","created_date":"2016-06-24T00:00:00"}
