{"id":"https://openalex.org/W2022049690","doi":"https://doi.org/10.1145/1067445.1067492","title":"Teaching transaction management with SQL examples","display_name":"Teaching transaction management with SQL examples","publication_year":2005,"publication_date":"2005-06-27","ids":{"openalex":"https://openalex.org/W2022049690","doi":"https://doi.org/10.1145/1067445.1067492","mag":"2022049690"},"language":"en","primary_location":{"id":"doi:10.1145/1067445.1067492","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1067445.1067492","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 10th annual SIGCSE conference on Innovation and technology in computer science education","raw_type":"proceedings-article"},"type":"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/A5025255598","display_name":"Alan Fekete","orcid":"https://orcid.org/0000-0003-3804-5450"},"institutions":[{"id":"https://openalex.org/I129604602","display_name":"University of Sydney","ror":"https://ror.org/0384j8v12","country_code":"AU","type":"education","lineage":["https://openalex.org/I129604602"]}],"countries":["AU"],"is_corresponding":true,"raw_author_name":"Alan Fekete","raw_affiliation_strings":["University of Sydney"],"affiliations":[{"raw_affiliation_string":"University of Sydney","institution_ids":["https://openalex.org/I129604602"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":["https://openalex.org/A5025255598"],"corresponding_institution_ids":["https://openalex.org/I129604602"],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":5,"citation_normalized_percentile":{"value":0.10509739,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":96},"biblio":{"volume":null,"issue":null,"first_page":"163","last_page":"167"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10126","display_name":"Logic, programming, and type systems","score":0.9573000073432922,"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/T10126","display_name":"Logic, programming, and type systems","score":0.9573000073432922,"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/T13523","display_name":"Mathematics, Computing, and Information Processing","score":0.9571999907493591,"subfield":{"id":"https://openalex.org/subfields/1703","display_name":"Computational Theory and Mathematics"},"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.9524000287055969,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"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/computer-science","display_name":"Computer science","score":0.845916211605072},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.7165228128433228},{"id":"https://openalex.org/keywords/database-transaction","display_name":"Database transaction","score":0.6811866760253906},{"id":"https://openalex.org/keywords/focus","display_name":"Focus (optics)","score":0.6561259031295776},{"id":"https://openalex.org/keywords/set","display_name":"Set (abstract data type)","score":0.537930428981781},{"id":"https://openalex.org/keywords/subject","display_name":"Subject (documents)","score":0.5145863890647888},{"id":"https://openalex.org/keywords/reading","display_name":"Reading (process)","score":0.4739891588687897},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.4387511610984802},{"id":"https://openalex.org/keywords/nested-transaction","display_name":"Nested transaction","score":0.4350985288619995},{"id":"https://openalex.org/keywords/autocommit","display_name":"Autocommit","score":0.41813692450523376},{"id":"https://openalex.org/keywords/simple","display_name":"Simple (philosophy)","score":0.4109455943107605},{"id":"https://openalex.org/keywords/transaction-processing","display_name":"Transaction processing","score":0.3871127665042877},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.3581187129020691},{"id":"https://openalex.org/keywords/software-engineering","display_name":"Software engineering","score":0.3540921211242676},{"id":"https://openalex.org/keywords/distributed-transaction","display_name":"Distributed transaction","score":0.33238911628723145},{"id":"https://openalex.org/keywords/world-wide-web","display_name":"World Wide Web","score":0.3132457733154297},{"id":"https://openalex.org/keywords/query-by-example","display_name":"Query by Example","score":0.22083482146263123},{"id":"https://openalex.org/keywords/linguistics","display_name":"Linguistics","score":0.09646180272102356}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.845916211605072},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.7165228128433228},{"id":"https://openalex.org/C75949130","wikidata":"https://www.wikidata.org/wiki/Q848010","display_name":"Database transaction","level":2,"score":0.6811866760253906},{"id":"https://openalex.org/C192209626","wikidata":"https://www.wikidata.org/wiki/Q190909","display_name":"Focus (optics)","level":2,"score":0.6561259031295776},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.537930428981781},{"id":"https://openalex.org/C2777855551","wikidata":"https://www.wikidata.org/wiki/Q12310021","display_name":"Subject (documents)","level":2,"score":0.5145863890647888},{"id":"https://openalex.org/C554936623","wikidata":"https://www.wikidata.org/wiki/Q199657","display_name":"Reading (process)","level":2,"score":0.4739891588687897},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4387511610984802},{"id":"https://openalex.org/C137180784","wikidata":"https://www.wikidata.org/wiki/Q6997825","display_name":"Nested transaction","level":5,"score":0.4350985288619995},{"id":"https://openalex.org/C33882796","wikidata":"https://www.wikidata.org/wiki/Q4826222","display_name":"Autocommit","level":5,"score":0.41813692450523376},{"id":"https://openalex.org/C2780586882","wikidata":"https://www.wikidata.org/wiki/Q7520643","display_name":"Simple (philosophy)","level":2,"score":0.4109455943107605},{"id":"https://openalex.org/C72108876","wikidata":"https://www.wikidata.org/wiki/Q844565","display_name":"Transaction processing","level":3,"score":0.3871127665042877},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.3581187129020691},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.3540921211242676},{"id":"https://openalex.org/C25185021","wikidata":"https://www.wikidata.org/wiki/Q4053284","display_name":"Distributed transaction","level":4,"score":0.33238911628723145},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.3132457733154297},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.22083482146263123},{"id":"https://openalex.org/C41895202","wikidata":"https://www.wikidata.org/wiki/Q8162","display_name":"Linguistics","level":1,"score":0.09646180272102356},{"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/C111472728","wikidata":"https://www.wikidata.org/wiki/Q9471","display_name":"Epistemology","level":1,"score":0.0},{"id":"https://openalex.org/C120665830","wikidata":"https://www.wikidata.org/wiki/Q14620","display_name":"Optics","level":1,"score":0.0},{"id":"https://openalex.org/C121332964","wikidata":"https://www.wikidata.org/wiki/Q413","display_name":"Physics","level":0,"score":0.0},{"id":"https://openalex.org/C138885662","wikidata":"https://www.wikidata.org/wiki/Q5891","display_name":"Philosophy","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}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/1067445.1067492","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1067445.1067492","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 10th annual SIGCSE conference on Innovation and technology in computer science education","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"score":0.8700000047683716,"id":"https://metadata.un.org/sdg/4","display_name":"Quality Education"}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":16,"referenced_works":["https://openalex.org/W1512840853","https://openalex.org/W1521479407","https://openalex.org/W1569403765","https://openalex.org/W2041155182","https://openalex.org/W2052213808","https://openalex.org/W2069745625","https://openalex.org/W2117917070","https://openalex.org/W2753710282","https://openalex.org/W3149201378","https://openalex.org/W4212986618","https://openalex.org/W4234825580","https://openalex.org/W4244123675","https://openalex.org/W4250744454","https://openalex.org/W4285719527","https://openalex.org/W6633961643","https://openalex.org/W6808979367"],"related_works":["https://openalex.org/W2588999713","https://openalex.org/W2123909466","https://openalex.org/W590454891","https://openalex.org/W170089733","https://openalex.org/W2185948393","https://openalex.org/W2371295991","https://openalex.org/W1855065956","https://openalex.org/W1528095145","https://openalex.org/W1568312998","https://openalex.org/W2364250032"],"abstract_inverted_index":{"Transaction":[0],"management":[1],"is":[2],"an":[3,17],"important":[4],"topic":[5],"in":[6,65,90],"the":[7,14,26,53,62,69,73,84],"database":[8],"course.":[9],"This":[10],"remains":[11],"true":[12],"whether":[13],"subject":[15],"has":[16],"application":[18],"focus":[19],"or":[20,43],"a":[21,97],"systems":[22],"internals":[23],"focus.":[24],"All":[25],"standard":[27],"textbooks":[28],"use":[29],"toy":[30],"examples":[31,57,100],"of":[32,37,68,99,108],"transactions,":[33],"expressed":[34],"as":[35,41],"sequences":[36],"simple":[38],"operations":[39],"such":[40],"reading":[42],"writing":[44],"data":[45],"items.":[46],"In":[47],"this":[48],"paper":[49],"we":[50,95,102],"argue":[51],"that":[52,71,86,101],"teacher":[54],"should":[55,75],"choose":[56],"which":[58],"are":[59],"closer":[60],"to":[61,105],"students'":[63],"experiences":[64],"other":[66],"topics":[67],"course,":[70],"is,":[72],"transactions":[74],"be":[76,88],"like":[77],"programs":[78],"with":[79],"SQL":[80],"statements.":[81],"We":[82],"discuss":[83],"requirements":[85],"must":[87],"considered":[89],"choosing":[91],"useful":[92],"examples,":[93],"and":[94],"give":[96],"set":[98],"have":[103],"constructed":[104],"meet":[106],"many":[107],"these":[109],"requirements.":[110]},"counts_by_year":[{"year":2022,"cited_by_count":1},{"year":2020,"cited_by_count":2},{"year":2012,"cited_by_count":2}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}