{"id":"https://openalex.org/W2952416325","doi":"https://doi.org/10.1145/3299869.3300098","title":"Generating Selective Filters for Access Method and Physical Design Evaluation","display_name":"Generating Selective Filters for Access Method and Physical Design Evaluation","publication_year":2019,"publication_date":"2019-06-18","ids":{"openalex":"https://openalex.org/W2952416325","doi":"https://doi.org/10.1145/3299869.3300098","mag":"2952416325"},"language":"en","primary_location":{"id":"doi:10.1145/3299869.3300098","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3299869.3300098","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2019 International Conference on Management of Data","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/A5087558180","display_name":"Pranav Subramaniam","orcid":"https://orcid.org/0009-0005-4684-0501"},"institutions":[{"id":"https://openalex.org/I40347166","display_name":"University of Chicago","ror":"https://ror.org/024mw5h28","country_code":"US","type":"education","lineage":["https://openalex.org/I40347166"]},{"id":"https://openalex.org/I39422238","display_name":"University of Illinois Chicago","ror":"https://ror.org/02mpq6x41","country_code":"US","type":"education","lineage":["https://openalex.org/I39422238"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Pranav Subramaniam","raw_affiliation_strings":["University of Chicago, Chicago, IL, USA"],"affiliations":[{"raw_affiliation_string":"University of Chicago, Chicago, IL, USA","institution_ids":["https://openalex.org/I40347166","https://openalex.org/I39422238"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":["https://openalex.org/A5087558180"],"corresponding_institution_ids":["https://openalex.org/I39422238","https://openalex.org/I40347166"],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":{"value":0.07562842,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"1853","last_page":"1855"},"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/T11181","display_name":"Advanced Data Storage 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/computer-science","display_name":"Computer science","score":0.8545839786529541},{"id":"https://openalex.org/keywords/leverage","display_name":"Leverage (statistics)","score":0.6068249940872192},{"id":"https://openalex.org/keywords/heuristic","display_name":"Heuristic","score":0.5669202208518982},{"id":"https://openalex.org/keywords/table","display_name":"Table (database)","score":0.5523180365562439},{"id":"https://openalex.org/keywords/set","display_name":"Set (abstract data type)","score":0.5148729085922241},{"id":"https://openalex.org/keywords/filter","display_name":"Filter (signal processing)","score":0.5098923444747925},{"id":"https://openalex.org/keywords/workload","display_name":"Workload","score":0.5023584365844727},{"id":"https://openalex.org/keywords/constraint","display_name":"Constraint (computer-aided design)","score":0.4827684462070465},{"id":"https://openalex.org/keywords/lookup-table","display_name":"Lookup table","score":0.4657367765903473},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.433185875415802},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.3367149829864502},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.1813550889492035},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.11812463402748108}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8545839786529541},{"id":"https://openalex.org/C153083717","wikidata":"https://www.wikidata.org/wiki/Q6535263","display_name":"Leverage (statistics)","level":2,"score":0.6068249940872192},{"id":"https://openalex.org/C173801870","wikidata":"https://www.wikidata.org/wiki/Q201413","display_name":"Heuristic","level":2,"score":0.5669202208518982},{"id":"https://openalex.org/C45235069","wikidata":"https://www.wikidata.org/wiki/Q278425","display_name":"Table (database)","level":2,"score":0.5523180365562439},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.5148729085922241},{"id":"https://openalex.org/C106131492","wikidata":"https://www.wikidata.org/wiki/Q3072260","display_name":"Filter (signal processing)","level":2,"score":0.5098923444747925},{"id":"https://openalex.org/C2778476105","wikidata":"https://www.wikidata.org/wiki/Q628539","display_name":"Workload","level":2,"score":0.5023584365844727},{"id":"https://openalex.org/C2776036281","wikidata":"https://www.wikidata.org/wiki/Q48769818","display_name":"Constraint (computer-aided design)","level":2,"score":0.4827684462070465},{"id":"https://openalex.org/C134835016","wikidata":"https://www.wikidata.org/wiki/Q690265","display_name":"Lookup table","level":2,"score":0.4657367765903473},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.433185875415802},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.3367149829864502},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.1813550889492035},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.11812463402748108},{"id":"https://openalex.org/C31972630","wikidata":"https://www.wikidata.org/wiki/Q844240","display_name":"Computer vision","level":1,"score":0.0},{"id":"https://openalex.org/C78519656","wikidata":"https://www.wikidata.org/wiki/Q101333","display_name":"Mechanical engineering","level":1,"score":0.0},{"id":"https://openalex.org/C127413603","wikidata":"https://www.wikidata.org/wiki/Q11023","display_name":"Engineering","level":0,"score":0.0},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3299869.3300098","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3299869.3300098","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2019 International Conference on Management of Data","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":6,"referenced_works":["https://openalex.org/W2016432059","https://openalex.org/W2057513751","https://openalex.org/W2112100340","https://openalex.org/W2141933093","https://openalex.org/W2605843372","https://openalex.org/W2798866333"],"related_works":["https://openalex.org/W2000785801","https://openalex.org/W986318368","https://openalex.org/W2384410913","https://openalex.org/W2352878646","https://openalex.org/W2004734601","https://openalex.org/W2130149817","https://openalex.org/W2990194547","https://openalex.org/W1480123525","https://openalex.org/W2620865396","https://openalex.org/W2414054180"],"abstract_inverted_index":{"It":[0],"is":[1,157],"a":[2,45,50,57,92,118,125,129,133,203,217],"challenge":[3],"for":[4,49,185,206],"researchers":[5,107],"and":[6,17,100,132,162,195,209],"system":[7],"developers":[8],"to":[9,63,108],"evaluate":[10,25,64],"the":[11,176,181,190,207,211,214],"impacts":[12],"of":[13,74,95,97,213],"new":[14,65,119],"access":[15],"methods":[16,103],"physical":[18],"designs":[19],"on":[20,60,216],"query":[21,53,101,120],"performance.":[22],"One":[23],"can":[24,78,90],"these":[26],"by":[27],"executing":[28],"selective":[29,52],"filters":[30],"over":[31,87],"differing":[32],"data":[33,98,219],"distributions.":[34],"For":[35],"example,":[36],"an":[37],"index":[38],"lookup":[39],"may":[40],"give":[41],"better":[42],"performance":[43,96,212],"than":[44],"full":[46],"table":[47,126],"scan":[48],"highly":[51],"[4].":[54],"However,":[55],"generating":[56,82,170],"filter":[58,146,171],"workload":[59],"nonsynthetic":[61],"datasets":[62],"techniques":[66],"currently":[67],"involves":[68],"manually":[69],"coming":[70],"up":[71],"with":[72,84,150,173],"workloads":[73,83],"varying":[75],"selectivities,":[76],"which":[77],"be":[79],"cumbersome.":[80],"Automatically":[81],"given":[85,124,177],"selectivities":[86,174],"any":[88],"dataset":[89],"facilitate":[91],"systematic":[93],"study":[94],"storage":[99],"optimization":[102],"that":[104,169],"also":[105],"allows":[106],"leverage":[109],"interesting":[110],"datasets.":[111],"Toward":[112],"this":[113,115],"goal,":[114],"paper":[116],"describes":[117],"generation":[121],"method":[122],"that,":[123],"T":[127,161,194,198],"in":[128,152,189],"database":[130],"D,":[131],"selectivity":[134],"constraint":[135,178],"(L,":[136],"R),":[137],"where":[138],"\u2264":[139,143],"L":[140,159,192],"<":[141],"R":[142,163,196],"1,":[144],"generates":[145],"queries":[147,149,172],"(i.e.,":[148],"predicates":[151],"WHERE-clauses)":[153],"whose":[154],"output":[155],"size":[156],"between":[158],"\u2022":[160,164,193,197],"T.":[165],"We":[166,200],"first":[167],"show":[168],"satisfying":[175],"requires":[179],"solving":[180],"subset":[182],"sum":[183],"problem":[184],"each":[186],"integral":[187],"value":[188],"range":[191],".":[199],"then":[201],"present":[202],"polynomial-time":[204],"heuristic":[205,215],"same":[208],"discuss":[210],"large":[218],"set.":[220]},"counts_by_year":[],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}