{"id":"https://openalex.org/W1018083307","doi":null,"title":"Outer Joins by Example","display_name":"Outer Joins by Example","alternate_titles":[],"publication_year":2011,"publication_date":"2011-05-01","ids":{"openalex":"https://openalex.org/W1018083307","mag":"1018083307"},"language":"en","primary_location":{"id":"mag:1018083307","doi":null,"is_oa":false,"landing_page_url":"http://documents.el-una.org/670/","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/W1018083307"],"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/A5046402571","display_name":"Cathy Salika","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":true,"raw_author_name":"Cathy Salika","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":0,"corresponding_author_ids":["https://openalex.org/A5046402571"],"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":null,"biblio":{"volume":null,"issue":null,"first_page":null,"last_page":null},"is_retracted":false,"is_pulled":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.6000999808311462,"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"}},"topics":[{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.6000999808311462,"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/T13681","display_name":"Engineering and Information Technology","score":0.11389999836683273,"subfield":{"id":"https://openalex.org/subfields/1712","display_name":"Software"},"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/T11719","display_name":"Data Quality and Management","score":0.0421999990940094,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/outer-join","display_name":"outer join","score":0.9959999918937683},{"id":"https://openalex.org/keywords/sql-queries","display_name":"SQL queries","score":0.8190000057220459},{"id":"https://openalex.org/keywords/data-inconsistency","display_name":"data inconsistency","score":0.6330000162124634},{"id":"https://openalex.org/keywords/bibliographic-records","display_name":"bibliographic records","score":0.6240000128746033},{"id":"https://openalex.org/keywords/library-catalog-data","display_name":"library catalog data","score":0.5099999904632568},{"id":"https://openalex.org/keywords/query-statistics","display_name":"query statistics","score":0.621999979019165}],"concepts":[{"id":"https://openalex.org/C2778692605","wikidata":"https://www.wikidata.org/wiki/Q4041866","display_name":"Joins","level":2,"score":0.9847255945205688},{"id":"https://openalex.org/C2779182362","wikidata":"https://www.wikidata.org/wiki/Q17126187","display_name":"Session (web analytics)","level":2,"score":0.7221212983131409},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6241335868835449},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.36327534914016724},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.2770691514015198},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.12982907891273499}],"mesh":[],"locations_count":1,"locations":[{"id":"mag:1018083307","doi":null,"is_oa":false,"landing_page_url":"http://documents.el-una.org/670/","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":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":0,"referenced_works":[],"related_works":["https://openalex.org/W23033777","https://openalex.org/W1599687999","https://openalex.org/W4250764402","https://openalex.org/W4233418671","https://openalex.org/W1875283749","https://openalex.org/W1583189939","https://openalex.org/W1991604604","https://openalex.org/W7095724979","https://openalex.org/W1547939638","https://openalex.org/W2074877482"],"abstract_inverted_index":{"Outer":[0,38],"joins":[1,39,67],"are":[2,34],"a":[3],"technique":[4],"for":[5],"dealing":[6],"with":[7],"inconsistencies":[8],"in":[9,35],"your":[10,43],"data":[11],"when":[12],"you":[13],"write":[14],"queries.":[15],"What":[16,22,30],"if":[17,23,31],"some":[18,24,32],"items":[19,33],"aren\u2019t":[20,26,51],"barcoded?":[21],"bibs":[25],"indexed":[27],"by":[28,45],"title?":[29],"temporary":[36],"locations?":[37],"can":[40,73],"also":[41],"improve":[42],"statistics":[44],"making":[46],"sure":[47],"that":[48,62],"odd":[49],"cases":[50],"dropped.":[52],"In":[53],"this":[54],"session,":[55],"we\u2019ll":[56],"look":[57],"at":[58],"lots":[59],"of":[60,65],"queries":[61],"make":[63],"use":[64],"outer":[66],"and":[68],"see":[69],"how":[70],"helpful":[71],"they":[72],"be.":[74]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W1018083307","counts_by_year":[],"updated_date":"2025-11-06T04:12:42.849631","created_date":"2016-06-24T00:00:00"}
