乐胖代购免代理版

{"id":"https://openalex.org/W3092022493","doi":"https://doi.org/10.1145/3368308.3415367","title":"Understanding Students' Identification and Use of Patterns While Writing SQL Queries","display_name":"Understanding Students' Identification and Use of Patterns While Writing SQL Queries","publication_year":2020,"publication_date":"2020-10-07","ids":{"openalex":"https://openalex.org/W3092022493","doi":"https://doi.org/10.1145/3368308.3415367","mag":"3092022493"},"language":"en","primary_location":{"is_oa":false,"landing_page_url":"https://doi.org/10.1145/3368308.3415367","pdf_url":null,"source":null,"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false},"type":"article","type_crossref":"proceedings-article","indexed_in":["crossref"],"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/A5027544271","display_name":"Zahra Hatami","orcid":"https://orcid.org/0000-0002-6344-4421"},"institutions":[{"id":"https://openalex.org/I122266389","display_name":"University of Nebraska at Omaha","ror":"https://ror.org/04yrkc140","country_code":"US","type":"funder","lineage":["https://openalex.org/I122266389"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Zahra Hatami","raw_affiliation_strings":["University of Nebraska at Omaha, Omaha, NE, USA"],"affiliations":[{"raw_affiliation_string":"University of Nebraska at Omaha, Omaha, NE, USA","institution_ids":["https://openalex.org/I122266389"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5062531882","display_name":"Peter Wolcott","orcid":null},"institutions":[{"id":"https://openalex.org/I122266389","display_name":"University of Nebraska at Omaha","ror":"https://ror.org/04yrkc140","country_code":"US","type":"funder","lineage":["https://openalex.org/I122266389"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Peter Wolcott","raw_affiliation_strings":["University of Nebraska at Omaha, Omaha, NE, USA"],"affiliations":[{"raw_affiliation_string":"University of Nebraska at Omaha, Omaha, NE, USA","institution_ids":["https://openalex.org/I122266389"]}]}],"institution_assertions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":{"value":0.0,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":0,"max":60},"biblio":{"volume":null,"issue":null,"first_page":"20","last_page":"25"},"is_retracted":false,"is_paratext":false,"primary_topic":{"id":"https://openalex.org/T11902","display_name":"Intelligent Tutoring Systems and Adaptive Learning","score":0.9939,"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"}},"topics":[{"id":"https://openalex.org/T11902","display_name":"Intelligent Tutoring Systems and Adaptive Learning","score":0.9939,"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"}},{"id":"https://openalex.org/T11122","display_name":"Online Learning and Analytics","score":0.9871,"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/T10636","display_name":"Innovative Teaching and Learning Methods","score":0.9698,"subfield":{"id":"https://openalex.org/subfields/3204","display_name":"Developmental and Educational Psychology"},"field":{"id":"https://openalex.org/fields/32","display_name":"Psychology"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/data-definition-language","display_name":"Data definition language","score":0.8059936},{"id":"https://openalex.org/keywords/stored-procedure","display_name":"Stored procedure","score":0.562844},{"id":"https://openalex.org/keywords/data-transformation-services","display_name":"Data Transformation Services","score":0.5114245},{"id":"https://openalex.org/keywords/identification","display_name":"Identification","score":0.48749542},{"id":"https://openalex.org/keywords/sql/psm","display_name":"SQL/PSM","score":0.4566916}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8546338},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.8401338},{"id":"https://openalex.org/C55596503","wikidata":"https://www.wikidata.org/wiki/Q1431648","display_name":"Data definition language","level":3,"score":0.8059936},{"id":"https://openalex.org/C154420247","wikidata":"https://www.wikidata.org/wiki/Q846619","display_name":"Stored procedure","level":5,"score":0.562844},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.5376941},{"id":"https://openalex.org/C141589383","wikidata":"https://www.wikidata.org/wiki/Q644775","display_name":"Data Transformation Services","level":5,"score":0.5114245},{"id":"https://openalex.org/C9652623","wikidata":"https://www.wikidata.org/wiki/Q190109","display_name":"Field (mathematics)","level":2,"score":0.50979036},{"id":"https://openalex.org/C116834253","wikidata":"https://www.wikidata.org/wiki/Q2039217","display_name":"Identification (biology)","level":2,"score":0.48749542},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.4768418},{"id":"https://openalex.org/C167544706","wikidata":"https://www.wikidata.org/wiki/Q360842","display_name":"SQL/PSM","level":5,"score":0.4566916},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.44692394},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.3490247},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.32418066},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.245166},{"id":"https://openalex.org/C59822182","wikidata":"https://www.wikidata.org/wiki/Q441","display_name":"Botany","level":1,"score":0.0},{"id":"https://openalex.org/C86803240","wikidata":"https://www.wikidata.org/wiki/Q420","display_name":"Biology","level":0,"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},{"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/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.0},{"id":"https://openalex.org/C202444582","wikidata":"https://www.wikidata.org/wiki/Q837863","display_name":"Pure mathematics","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"is_oa":false,"landing_page_url":"https://doi.org/10.1145/3368308.3415367","pdf_url":null,"source":null,"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false}],"best_oa_location":null,"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/4","display_name":"Quality education","score":0.89}],"grants":[],"datasets":[],"versions":[],"referenced_works_count":11,"referenced_works":["https://openalex.org/W1858868033","https://openalex.org/W1987626674","https://openalex.org/W2029191123","https://openalex.org/W2045300586","https://openalex.org/W2091351040","https://openalex.org/W2104916970","https://openalex.org/W2106186687","https://openalex.org/W2762028850","https://openalex.org/W2894913924","https://openalex.org/W2938167505","https://openalex.org/W3018713462"],"related_works":["https://openalex.org/W638381921","https://openalex.org/W2912795851","https://openalex.org/W2738342198","https://openalex.org/W2512476881","https://openalex.org/W2282090486","https://openalex.org/W2240099544","https://openalex.org/W2228911486","https://openalex.org/W1890845846","https://openalex.org/W1725587203","https://openalex.org/W1520902996"],"abstract_inverted_index":{"SQL":[0,15,92,106,137],"(Structured":[1],"Query":[2],"Language)":[3],"is":[4,16,81],"a":[5,11,17,30],"standard":[6],"language":[7,138],"to":[8,34,82,114,122],"communicate":[9],"with":[10,48],"relational":[12],"database":[13,65],"system.":[14],"core":[18],"competency":[19],"for":[20,107],"people":[21],"in":[22,36,78],"the":[23,44,64,84,95,108,136],"data":[24,42,54,77],"management":[25,66],"field":[26],"and":[27,99,127,139],"is,":[28],"therefore,":[29],"foundational":[31],"skill":[32],"taught":[33,132],"users":[35],"information":[37],"systems.":[38],"This":[39,118],"research":[40,80,119],"analyzes":[41],"from":[43],"group":[45],"of":[46,57,75,87,110],"students":[47,69,90,97],"two":[49],"different":[50],"problem":[51],"sets.":[52],"The":[53,72],"set":[55],"consisted":[56],"student":[58],"activity,":[59],"log":[60],"data,":[61],"captured":[62],"by":[63],"system":[67],"as":[68],"executed":[70],"queries.":[71],"primary":[73],"goal":[74],"analyzing":[76],"this":[79],"observe":[83],"exact":[85],"sequence":[86],"attempts":[88],"while":[89],"formulate":[91],"queries,":[93],"understand":[94],"patterns":[96,102],"use":[98],"how":[100,128],"these":[101,116],"help":[103],"them":[104],"learn":[105],"purpose":[109],"finding":[111],"better":[112],"ways":[113],"teach":[115],"skills.":[117],"will":[120],"try":[121],"improve":[123],"students?":[124],"learning":[125],"processes":[126],"they":[129],"can":[130],"be":[131],"more":[133],"efficiently":[134],"about":[135],"its":[140],"usage.":[141]},"abstract_inverted_index_v3":null,"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W3092022493","counts_by_year":[],"updated_date":"2025-01-25T09:01:39.656289","created_date":"2020-10-15"}