{"id":"https://openalex.org/W2062872677","doi":"https://doi.org/10.1145/1247480.1247551","title":"Addressing diverse user preferences in SQL-query-result navigation","display_name":"Addressing diverse user preferences in SQL-query-result navigation","publication_year":2007,"publication_date":"2007-06-11","ids":{"openalex":"https://openalex.org/W2062872677","doi":"https://doi.org/10.1145/1247480.1247551","mag":"2062872677"},"language":"en","primary_location":{"id":"doi:10.1145/1247480.1247551","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1247480.1247551","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2007 ACM SIGMOD 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/A5100438515","display_name":"Zhiyuan Chen","orcid":"https://orcid.org/0000-0002-6984-7248"},"institutions":[{"id":"https://openalex.org/I79272384","display_name":"University of Maryland, Baltimore County","ror":"https://ror.org/02qskvh78","country_code":"US","type":"education","lineage":["https://openalex.org/I79272384"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Zhiyuan Chen","raw_affiliation_strings":["University of Maryland, Baltimore County, Baltimore, MD"],"affiliations":[{"raw_affiliation_string":"University of Maryland, Baltimore County, Baltimore, MD","institution_ids":["https://openalex.org/I79272384"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5100455259","display_name":"Tao Li","orcid":"https://orcid.org/0000-0001-9277-1539"},"institutions":[{"id":"https://openalex.org/I19700959","display_name":"Florida International University","ror":"https://ror.org/02gz6gg07","country_code":"US","type":"education","lineage":["https://openalex.org/I19700959"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Tao Li","raw_affiliation_strings":["Florida International University, Miami, FL"],"affiliations":[{"raw_affiliation_string":"Florida International University, Miami, FL","institution_ids":["https://openalex.org/I19700959"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":["https://openalex.org/A5100438515"],"corresponding_institution_ids":["https://openalex.org/I79272384"],"apc_list":null,"apc_paid":null,"fwci":5.5054,"has_fulltext":false,"cited_by_count":84,"citation_normalized_percentile":{"value":0.96451494,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":89,"max":100},"biblio":{"volume":null,"issue":null,"first_page":"641","last_page":"652"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"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"}},"topics":[{"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.9998000264167786,"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/T10538","display_name":"Data Mining Algorithms and Applications","score":0.9980000257492065,"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/computer-science","display_name":"Computer science","score":0.8565199375152588},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.6043362021446228},{"id":"https://openalex.org/keywords/categorization","display_name":"Categorization","score":0.5848121643066406},{"id":"https://openalex.org/keywords/set","display_name":"Set (abstract data type)","score":0.5741574168205261},{"id":"https://openalex.org/keywords/tree","display_name":"Tree (set theory)","score":0.5121066570281982},{"id":"https://openalex.org/keywords/result-set","display_name":"Result set","score":0.5066471695899963},{"id":"https://openalex.org/keywords/rank","display_name":"Rank (graph theory)","score":0.498734712600708},{"id":"https://openalex.org/keywords/matching","display_name":"Matching (statistics)","score":0.4819321632385254},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.4349963366985321},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.37529027462005615},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.26296675205230713},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.13874563574790955}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8565199375152588},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.6043362021446228},{"id":"https://openalex.org/C94124525","wikidata":"https://www.wikidata.org/wiki/Q912550","display_name":"Categorization","level":2,"score":0.5848121643066406},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.5741574168205261},{"id":"https://openalex.org/C113174947","wikidata":"https://www.wikidata.org/wiki/Q2859736","display_name":"Tree (set theory)","level":2,"score":0.5121066570281982},{"id":"https://openalex.org/C4969071","wikidata":"https://www.wikidata.org/wiki/Q7316353","display_name":"Result set","level":3,"score":0.5066471695899963},{"id":"https://openalex.org/C164226766","wikidata":"https://www.wikidata.org/wiki/Q7293202","display_name":"Rank (graph theory)","level":2,"score":0.498734712600708},{"id":"https://openalex.org/C165064840","wikidata":"https://www.wikidata.org/wiki/Q1321061","display_name":"Matching (statistics)","level":2,"score":0.4819321632385254},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.4349963366985321},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.37529027462005615},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.26296675205230713},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.13874563574790955},{"id":"https://openalex.org/C105795698","wikidata":"https://www.wikidata.org/wiki/Q12483","display_name":"Statistics","level":1,"score":0.0},{"id":"https://openalex.org/C114614502","wikidata":"https://www.wikidata.org/wiki/Q76592","display_name":"Combinatorics","level":1,"score":0.0},{"id":"https://openalex.org/C134306372","wikidata":"https://www.wikidata.org/wiki/Q7754","display_name":"Mathematical analysis","level":1,"score":0.0},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.0},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.0}],"mesh":[],"locations_count":3,"locations":[{"id":"doi:10.1145/1247480.1247551","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1247480.1247551","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2007 ACM SIGMOD international conference on Management of data","raw_type":"proceedings-article"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.164.4329","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.164.4329","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://userpages.umbc.edu/~zhchen/papers/sigmod07-chen-navigation.pdf","raw_type":"text"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.90.9357","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.90.9357","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www.cs.fiu.edu/~taoli/pub/p641-chen-li-sigmod.pdf","raw_type":"text"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":32,"referenced_works":["https://openalex.org/W1504694836","https://openalex.org/W1516293359","https://openalex.org/W1594031697","https://openalex.org/W1620204465","https://openalex.org/W1984712439","https://openalex.org/W2033139852","https://openalex.org/W2047221353","https://openalex.org/W2064784316","https://openalex.org/W2067438047","https://openalex.org/W2081193615","https://openalex.org/W2095976990","https://openalex.org/W2096898303","https://openalex.org/W2102337314","https://openalex.org/W2103201239","https://openalex.org/W2105981469","https://openalex.org/W2110441437","https://openalex.org/W2119745643","https://openalex.org/W2125055259","https://openalex.org/W2130476464","https://openalex.org/W2133576408","https://openalex.org/W2148792468","https://openalex.org/W2149684865","https://openalex.org/W2149706766","https://openalex.org/W2151406030","https://openalex.org/W2152136853","https://openalex.org/W2154237551","https://openalex.org/W2155942458","https://openalex.org/W3085162807","https://openalex.org/W3143471909","https://openalex.org/W6682452324","https://openalex.org/W6738852829","https://openalex.org/W6843735874"],"related_works":["https://openalex.org/W2165912799","https://openalex.org/W2735662278","https://openalex.org/W2382615723","https://openalex.org/W4311804456","https://openalex.org/W1987484445","https://openalex.org/W2623658258","https://openalex.org/W2143413548","https://openalex.org/W1969219540","https://openalex.org/W1528066211","https://openalex.org/W2279212732"],"abstract_inverted_index":{"Database":[0],"queries":[1,10],"are":[2],"often":[3,7,64],"exploratory":[4],"and":[5,108,193,209],"users":[6,29,52,63,103],"find":[8],"their":[9],"return":[11],"too":[12],"many":[13,15],"answers,":[14],"of":[16,35,42,79,101,112,122,156,188,205],"them":[17],"irrelevant.":[18],"Existing":[19],"work":[20,48],"either":[21],"categorizes":[22],"or":[23,167],"ranks":[24],"the":[25,40,54,76,83,105,115,130,135,144,149,154,169,186,197,203],"results":[26,170],"to":[27,74,119,134],"help":[28],"locate":[30],"interesting":[31],"results.":[32],"The":[33,86,95,161,174],"success":[34],"both":[36,190],"approaches":[37],"depends":[38],"on":[39],"utilization":[41],"user":[43,56,80,93,123,126,136,150,162],"preferences.":[44,67,124],"However,":[45],"most":[46],"existing":[47],"assumes":[49],"that":[50,148],"all":[51,102],"have":[53,65],"same":[55],"preferences,":[57],"but":[58],"in":[59,104,143,171,196],"real":[60],"life":[61],"different":[62,66],"This":[68],"paper":[69],"proposes":[70],"a":[71,110,128,137,181],"two-step":[72],"solution":[73,88],"address":[75],"diversity":[77],"issue":[78],"preferences":[81],"for":[82],"categorization":[84],"approach.":[85,207],"proposed":[87],"does":[89],"not":[90],"require":[91],"explicit":[92],"involvement.":[94],"first":[96,145],"step":[97,132,146],"analyzes":[98],"query":[99],"history":[100],"system":[106],"offline":[107],"generates":[109],"set":[111],"clusters":[113,141,157],"over":[114,140],"data,":[116],"each":[117],"corresponding":[118],"one":[120],"type":[121],"When":[125],"asks":[127],"query,":[129],"second":[131],"presents":[133],"navigational":[138,175],"tree":[139,176],"generated":[142],"such":[147],"can":[151,164],"easily":[152],"select":[153],"subset":[155],"matching":[158],"his":[159],"needs.":[160],"then":[163],"browse,":[165],"rank,":[166],"categorize":[168],"selected":[172],"clusters.":[173],"is":[177],"automatically":[178],"constructed":[179],"using":[180],"cost-based":[182],"algorithm":[183],"which":[184],"considers":[185],"cost":[187],"visiting":[189],"intermediate":[191],"nodes":[192,195],"leaf":[194],"tree.":[198],"An":[199],"empirical":[200],"study":[201],"demonstrates":[202],"benefits":[204],"our":[206],"Categories":[208],"Subject":[210],"Descriptors":[211]},"counts_by_year":[{"year":2025,"cited_by_count":2},{"year":2023,"cited_by_count":1},{"year":2022,"cited_by_count":1},{"year":2021,"cited_by_count":4},{"year":2020,"cited_by_count":1},{"year":2019,"cited_by_count":2},{"year":2018,"cited_by_count":4},{"year":2017,"cited_by_count":3},{"year":2016,"cited_by_count":4},{"year":2015,"cited_by_count":4},{"year":2014,"cited_by_count":12},{"year":2013,"cited_by_count":8},{"year":2012,"cited_by_count":13}],"updated_date":"2026-04-04T16:13:02.066488","created_date":"2025-10-10T00:00:00"}