{"id":"https://openalex.org/W1501284171","doi":"https://doi.org/10.1007/s007780050043","title":"S eek ing the truth about ad hoc join costs","display_name":"S eek ing the truth about ad hoc join costs","publication_year":1997,"publication_date":"1997-08-01","ids":{"openalex":"https://openalex.org/W1501284171","doi":"https://doi.org/10.1007/s007780050043","mag":"1501284171"},"language":"en","primary_location":{"id":"doi:10.1007/s007780050043","is_oa":false,"landing_page_url":"https://doi.org/10.1007/s007780050043","pdf_url":null,"source":{"id":"https://openalex.org/S78926909","display_name":"The VLDB Journal","issn_l":"0949-877X","issn":["0949-877X","1066-8888"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319900","host_organization_name":"Springer Science+Business Media","host_organization_lineage":["https://openalex.org/P4310319900","https://openalex.org/P4310319965"],"host_organization_lineage_names":["Springer Science+Business Media","Springer Nature"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"The VLDB Journal The International Journal on Very Large Data Bases","raw_type":"journal-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://minds.wisconsin.edu/bitstream/1793/59726/1/TR1148.pdf","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5086612708","display_name":"Laura M. Haas","orcid":null},"institutions":[{"id":"https://openalex.org/I4210085935","display_name":"IBM Research - Almaden","ror":"https://ror.org/005w8dd04","country_code":"US","type":"facility","lineage":["https://openalex.org/I1341412227","https://openalex.org/I4210085935","https://openalex.org/I4210114115"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Laura M. Haas","raw_affiliation_strings":["IBM Almaden Research Center, K55/B1, 650 Harry Road, San Jose, CA 95120, USA\n, , , , , , US","IBM Almaden Research Center, K55/B1, 650 Harry Road, San Jose, CA 95120, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"IBM Almaden Research Center, K55/B1, 650 Harry Road, San Jose, CA 95120, USA\n, , , , , , US","institution_ids":["https://openalex.org/I4210085935"]},{"raw_affiliation_string":"IBM Almaden Research Center, K55/B1, 650 Harry Road, San Jose, CA 95120, USA","institution_ids":["https://openalex.org/I4210085935"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5011512061","display_name":"Michael J. Carey","orcid":"https://orcid.org/0000-0003-1561-4059"},"institutions":[{"id":"https://openalex.org/I4210085935","display_name":"IBM Research - Almaden","ror":"https://ror.org/005w8dd04","country_code":"US","type":"facility","lineage":["https://openalex.org/I1341412227","https://openalex.org/I4210085935","https://openalex.org/I4210114115"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Michael J. Carey","raw_affiliation_strings":["IBM Almaden Research Center, K55/B1, 650 Harry Road, San Jose, CA 95120, USA\n, , , , , , US","IBM Almaden Research Center, K55/B1, 650 Harry Road, San Jose, CA 95120, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"IBM Almaden Research Center, K55/B1, 650 Harry Road, San Jose, CA 95120, USA\n, , , , , , US","institution_ids":["https://openalex.org/I4210085935"]},{"raw_affiliation_string":"IBM Almaden Research Center, K55/B1, 650 Harry Road, San Jose, CA 95120, USA","institution_ids":["https://openalex.org/I4210085935"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5042010270","display_name":"Miron Livny","orcid":"https://orcid.org/0000-0001-5444-7439"},"institutions":[{"id":"https://openalex.org/I1304256225","display_name":"University of Wisconsin System","ror":"https://ror.org/03ydkyb10","country_code":"US","type":"education","lineage":["https://openalex.org/I1304256225"]},{"id":"https://openalex.org/I135310074","display_name":"University of Wisconsin\u2013Madison","ror":"https://ror.org/01y2jtd41","country_code":"US","type":"education","lineage":["https://openalex.org/I135310074"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Miron Livny","raw_affiliation_strings":["Computer Sciences Dept., University of Wisconsin-Madison, 1210 West Dayton Street, Madison, WI 53706, USA\n, , , , , , US","Computer Sciences Department, University of Wisconsin-Madison 1210 West Dayton Street, Madison WI 53706, USA#TAB#"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Computer Sciences Dept., University of Wisconsin-Madison, 1210 West Dayton Street, Madison, WI 53706, USA\n, , , , , , US","institution_ids":["https://openalex.org/I1304256225","https://openalex.org/I135310074"]},{"raw_affiliation_string":"Computer Sciences Department, University of Wisconsin-Madison 1210 West Dayton Street, Madison WI 53706, USA#TAB#","institution_ids":["https://openalex.org/I135310074"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5008777707","display_name":"Amit Shukla","orcid":"https://orcid.org/0000-0002-6378-0177"},"institutions":[{"id":"https://openalex.org/I1304256225","display_name":"University of Wisconsin System","ror":"https://ror.org/03ydkyb10","country_code":"US","type":"education","lineage":["https://openalex.org/I1304256225"]},{"id":"https://openalex.org/I135310074","display_name":"University of Wisconsin\u2013Madison","ror":"https://ror.org/01y2jtd41","country_code":"US","type":"education","lineage":["https://openalex.org/I135310074"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Amit Shukla","raw_affiliation_strings":["Computer Sciences Dept., University of Wisconsin-Madison, 1210 West Dayton Street, Madison, WI 53706, USA\n, , , , , , US","Computer Sciences Department, University of Wisconsin-Madison 1210 West Dayton Street, Madison WI 53706, USA#TAB#"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Computer Sciences Dept., University of Wisconsin-Madison, 1210 West Dayton Street, Madison, WI 53706, USA\n, , , , , , US","institution_ids":["https://openalex.org/I1304256225","https://openalex.org/I135310074"]},{"raw_affiliation_string":"Computer Sciences Department, University of Wisconsin-Madison 1210 West Dayton Street, Madison WI 53706, USA#TAB#","institution_ids":["https://openalex.org/I135310074"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":{"value":2890,"currency":"USD","value_usd":2890},"apc_paid":null,"fwci":6.7571,"has_fulltext":false,"cited_by_count":88,"citation_normalized_percentile":{"value":0.96574998,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":89,"max":98},"biblio":{"volume":"6","issue":"3","first_page":"241","last_page":"256"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9998999834060669,"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"}},"topics":[{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9998999834060669,"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"}},{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9998999834060669,"subfield":{"id":"https://openalex.org/subfields/1711","display_name":"Signal Processing"},"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/T10742","display_name":"Peer-to-Peer Network Technologies","score":0.9980999827384949,"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/join","display_name":"Join (topology)","score":0.9537272453308105},{"id":"https://openalex.org/keywords/joins","display_name":"Joins","score":0.9272952079772949},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8171044588088989},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.4759354591369629},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.3309903144836426},{"id":"https://openalex.org/keywords/distributed-computing","display_name":"Distributed computing","score":0.3298197388648987},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.10787129402160645},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.07692641019821167}],"concepts":[{"id":"https://openalex.org/C2776124973","wikidata":"https://www.wikidata.org/wiki/Q3183033","display_name":"Join (topology)","level":2,"score":0.9537272453308105},{"id":"https://openalex.org/C2778692605","wikidata":"https://www.wikidata.org/wiki/Q4041866","display_name":"Joins","level":2,"score":0.9272952079772949},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8171044588088989},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.4759354591369629},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.3309903144836426},{"id":"https://openalex.org/C120314980","wikidata":"https://www.wikidata.org/wiki/Q180634","display_name":"Distributed computing","level":1,"score":0.3298197388648987},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.10787129402160645},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.07692641019821167},{"id":"https://openalex.org/C114614502","wikidata":"https://www.wikidata.org/wiki/Q76592","display_name":"Combinatorics","level":1,"score":0.0}],"mesh":[],"locations_count":4,"locations":[{"id":"doi:10.1007/s007780050043","is_oa":false,"landing_page_url":"https://doi.org/10.1007/s007780050043","pdf_url":null,"source":{"id":"https://openalex.org/S78926909","display_name":"The VLDB Journal","issn_l":"0949-877X","issn":["0949-877X","1066-8888"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319900","host_organization_name":"Springer Science+Business Media","host_organization_lineage":["https://openalex.org/P4310319900","https://openalex.org/P4310319965"],"host_organization_lineage_names":["Springer Science+Business Media","Springer Nature"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"The VLDB Journal The International Journal on Very Large Data Bases","raw_type":"journal-article"},{"id":"pmh:oai:minds.wisconsin.edu:1793/59726","is_oa":true,"landing_page_url":"http://digital.library.wisc.edu/1793/59726","pdf_url":"https://minds.wisconsin.edu/bitstream/1793/59726/1/TR1148.pdf","source":{"id":"https://openalex.org/S4306401622","display_name":"Minds at UW (University of Wisconsin)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I135310074","host_organization_name":"University of Wisconsin\u2013Madison","host_organization_lineage":["https://openalex.org/I135310074"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"Technical Report"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.46.4516","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.46.4516","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www.almaden.ibm.com/cs/people/laura/joincosts.ps","raw_type":"text"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.56.5380","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.56.5380","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://medoc.springer.de:9999/Journals/vldb/tocs/../papers/7006003/70060241.ps.gz","raw_type":"text"}],"best_oa_location":{"id":"pmh:oai:minds.wisconsin.edu:1793/59726","is_oa":true,"landing_page_url":"http://digital.library.wisc.edu/1793/59726","pdf_url":"https://minds.wisconsin.edu/bitstream/1793/59726/1/TR1148.pdf","source":{"id":"https://openalex.org/S4306401622","display_name":"Minds at UW (University of Wisconsin)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I135310074","host_organization_name":"University of Wisconsin\u2013Madison","host_organization_lineage":["https://openalex.org/I135310074"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"Technical Report"},"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W1501284171.pdf"},"referenced_works_count":27,"referenced_works":["https://openalex.org/W1484813121","https://openalex.org/W1495330263","https://openalex.org/W1600795850","https://openalex.org/W1612551514","https://openalex.org/W1964297545","https://openalex.org/W2007069074","https://openalex.org/W2011351543","https://openalex.org/W2012802704","https://openalex.org/W2015372451","https://openalex.org/W2029849129","https://openalex.org/W2035095545","https://openalex.org/W2043934800","https://openalex.org/W2082004608","https://openalex.org/W2098372784","https://openalex.org/W2102116440","https://openalex.org/W2122949840","https://openalex.org/W2146884585","https://openalex.org/W2152362264","https://openalex.org/W2153329411","https://openalex.org/W2158237121","https://openalex.org/W2163192219","https://openalex.org/W2169486917","https://openalex.org/W2295596515","https://openalex.org/W2612504159","https://openalex.org/W2752853835","https://openalex.org/W2982723241","https://openalex.org/W3027900649"],"related_works":["https://openalex.org/W2393491644","https://openalex.org/W4206577045","https://openalex.org/W650102067","https://openalex.org/W3086237447","https://openalex.org/W2740404111","https://openalex.org/W1550806730","https://openalex.org/W1496672428","https://openalex.org/W2589740103","https://openalex.org/W1966967794","https://openalex.org/W2397450670"],"abstract_inverted_index":null,"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2024,"cited_by_count":3},{"year":2023,"cited_by_count":3},{"year":2022,"cited_by_count":1},{"year":2021,"cited_by_count":1},{"year":2020,"cited_by_count":3},{"year":2018,"cited_by_count":2},{"year":2017,"cited_by_count":2},{"year":2016,"cited_by_count":4},{"year":2015,"cited_by_count":4},{"year":2014,"cited_by_count":3},{"year":2013,"cited_by_count":3},{"year":2012,"cited_by_count":4}],"updated_date":"2026-07-23T08:03:31.855105","created_date":"2025-10-10T00:00:00"}