Matches in SemOpenAlex for { <https://semopenalex.org/work/W2996343> ?p ?o ?g. }
Showing items 1 to 98 of
98
with 100 items per page.
- W2996343 endingPage "32" @default.
- W2996343 startingPage "23" @default.
- W2996343 abstract "Once students have mastered basic database querying with SQL, the next step for the instructor is to present operators that can extract complex information from multiple tables. The relational database left-outer-join (LOJ) expression (T1rT2) is used to merge two tables, say T1 and T2, using any given condition. Unlike regular database joins, when records from the first table (T1) fail to match records in the second table (T2) the LOJ operator retains each of those T1 tuples and adds an appropriate number of null values to compensate for the missing contribution of T2 records. In spite of its relatively simple definition and frequency in everyday common problems, we have observed that novice database students oftentimes have difficulties in understanding and properly using this technique. In this paper, we discuss three functionally equivalent versions of the left-outer-join operator to allow multiple ways of presenting the material and to show students a single data extraction problem from three viewpoints. We have developed an empirical evaluation of perceived difficulty and manageability of those versions. A simple performance analysis is conducted to determine the relative merits of each alternative." @default.
- W2996343 created "2016-06-24" @default.
- W2996343 creator A5013590625 @default.
- W2996343 creator A5034808531 @default.
- W2996343 creator A5035329434 @default.
- W2996343 date "2006-10-01" @default.
- W2996343 modified "2023-09-23" @default.
- W2996343 title "The case of the missing tuple: teaching the SQL outer-join operator to undergraduate information systems students" @default.
- W2996343 cites W1532064934 @default.
- W2996343 cites W1543136716 @default.
- W2996343 cites W1964523235 @default.
- W2996343 cites W2044009024 @default.
- W2996343 cites W2050428880 @default.
- W2996343 cites W2071100465 @default.
- W2996343 cites W2103028615 @default.
- W2996343 hasPublicationYear "2006" @default.
- W2996343 type Work @default.
- W2996343 sameAs 2996343 @default.
- W2996343 citedByCount "2" @default.
- W2996343 countsByYear W29963432012 @default.
- W2996343 countsByYear W29963432015 @default.
- W2996343 crossrefType "journal-article" @default.
- W2996343 hasAuthorship W2996343A5013590625 @default.
- W2996343 hasAuthorship W2996343A5034808531 @default.
- W2996343 hasAuthorship W2996343A5035329434 @default.
- W2996343 hasConcept C104317684 @default.
- W2996343 hasConcept C118615104 @default.
- W2996343 hasConcept C118930307 @default.
- W2996343 hasConcept C124101348 @default.
- W2996343 hasConcept C158448853 @default.
- W2996343 hasConcept C17020691 @default.
- W2996343 hasConcept C185592680 @default.
- W2996343 hasConcept C197129107 @default.
- W2996343 hasConcept C199360897 @default.
- W2996343 hasConcept C203763787 @default.
- W2996343 hasConcept C23123220 @default.
- W2996343 hasConcept C2778692605 @default.
- W2996343 hasConcept C33923547 @default.
- W2996343 hasConcept C41008148 @default.
- W2996343 hasConcept C45235069 @default.
- W2996343 hasConcept C510870499 @default.
- W2996343 hasConcept C55493867 @default.
- W2996343 hasConcept C55596503 @default.
- W2996343 hasConcept C5655090 @default.
- W2996343 hasConcept C77088390 @default.
- W2996343 hasConcept C86339819 @default.
- W2996343 hasConceptScore W2996343C104317684 @default.
- W2996343 hasConceptScore W2996343C118615104 @default.
- W2996343 hasConceptScore W2996343C118930307 @default.
- W2996343 hasConceptScore W2996343C124101348 @default.
- W2996343 hasConceptScore W2996343C158448853 @default.
- W2996343 hasConceptScore W2996343C17020691 @default.
- W2996343 hasConceptScore W2996343C185592680 @default.
- W2996343 hasConceptScore W2996343C197129107 @default.
- W2996343 hasConceptScore W2996343C199360897 @default.
- W2996343 hasConceptScore W2996343C203763787 @default.
- W2996343 hasConceptScore W2996343C23123220 @default.
- W2996343 hasConceptScore W2996343C2778692605 @default.
- W2996343 hasConceptScore W2996343C33923547 @default.
- W2996343 hasConceptScore W2996343C41008148 @default.
- W2996343 hasConceptScore W2996343C45235069 @default.
- W2996343 hasConceptScore W2996343C510870499 @default.
- W2996343 hasConceptScore W2996343C55493867 @default.
- W2996343 hasConceptScore W2996343C55596503 @default.
- W2996343 hasConceptScore W2996343C5655090 @default.
- W2996343 hasConceptScore W2996343C77088390 @default.
- W2996343 hasConceptScore W2996343C86339819 @default.
- W2996343 hasIssue "1" @default.
- W2996343 hasLocation W29963431 @default.
- W2996343 hasOpenAccess W2996343 @default.
- W2996343 hasPrimaryLocation W29963431 @default.
- W2996343 hasRelatedWork W1455205691 @default.
- W2996343 hasRelatedWork W1512904411 @default.
- W2996343 hasRelatedWork W1742163221 @default.
- W2996343 hasRelatedWork W180943430 @default.
- W2996343 hasRelatedWork W2012767282 @default.
- W2996343 hasRelatedWork W2037207320 @default.
- W2996343 hasRelatedWork W2164525119 @default.
- W2996343 hasRelatedWork W2188663837 @default.
- W2996343 hasRelatedWork W22272143 @default.
- W2996343 hasRelatedWork W2477336253 @default.
- W2996343 hasRelatedWork W2478634256 @default.
- W2996343 hasRelatedWork W2491178988 @default.
- W2996343 hasRelatedWork W2504748761 @default.
- W2996343 hasRelatedWork W2735246240 @default.
- W2996343 hasRelatedWork W2889098695 @default.
- W2996343 hasRelatedWork W3021776019 @default.
- W2996343 hasRelatedWork W3082746515 @default.
- W2996343 hasRelatedWork W343123302 @default.
- W2996343 hasRelatedWork W632801070 @default.
- W2996343 hasRelatedWork W2626907176 @default.
- W2996343 hasVolume "22" @default.
- W2996343 isParatext "false" @default.
- W2996343 isRetracted "false" @default.
- W2996343 magId "2996343" @default.
- W2996343 workType "article" @default.