{"id":"https://openalex.org/W2888990236","doi":"https://doi.org/10.1145/3226116.3226117","title":"Two-phase ranking method in relational database","display_name":"Two-phase ranking method in relational database","publication_year":2018,"publication_date":"2018-01-01","ids":{"openalex":"https://openalex.org/W2888990236","doi":"https://doi.org/10.1145/3226116.3226117","mag":"2888990236"},"language":"en","primary_location":{"id":"doi:10.1145/3226116.3226117","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3226116.3226117","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of 2018 International Conference on Big Data Technologies - ICBDT '18","raw_type":"proceedings-article"},"type":"conference-paper","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/A5100751765","display_name":"Yingqi Wang","orcid":"https://orcid.org/0000-0002-4030-1903"},"institutions":[{"id":"https://openalex.org/I151727225","display_name":"Harbin Engineering University","ror":"https://ror.org/03x80pn82","country_code":"CN","type":"education","lineage":["https://openalex.org/I151727225"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Yingqi Wang","raw_affiliation_strings":["Harbin Engineering University, Harbin"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Harbin Engineering University, Harbin","institution_ids":["https://openalex.org/I151727225"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5021313030","display_name":"Lianke Zhou","orcid":"https://orcid.org/0000-0002-3601-9286"},"institutions":[{"id":"https://openalex.org/I151727225","display_name":"Harbin Engineering University","ror":"https://ror.org/03x80pn82","country_code":"CN","type":"education","lineage":["https://openalex.org/I151727225"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Lianke Zhou","raw_affiliation_strings":["Harbin Engineering University, Harbin"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Harbin Engineering University, Harbin","institution_ids":["https://openalex.org/I151727225"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5100332080","display_name":"Hongbin Wang","orcid":"https://orcid.org/0000-0002-0534-8749"},"institutions":[{"id":"https://openalex.org/I151727225","display_name":"Harbin Engineering University","ror":"https://ror.org/03x80pn82","country_code":"CN","type":"education","lineage":["https://openalex.org/I151727225"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Hongbin Wang","raw_affiliation_strings":["Harbin Engineering University, Harbin"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Harbin Engineering University, Harbin","institution_ids":["https://openalex.org/I151727225"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I151727225"],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":{"value":0.07849173,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"1","last_page":"6"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9987999796867371,"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.9987999796867371,"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/T12016","display_name":"Web Data Mining and Analysis","score":0.9961000084877014,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.9951000213623047,"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.7895931005477905},{"id":"https://openalex.org/keywords/ranking","display_name":"Ranking (information retrieval)","score":0.7329679131507874},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.6643327474594116},{"id":"https://openalex.org/keywords/redundancy","display_name":"Redundancy (engineering)","score":0.6588041186332703},{"id":"https://openalex.org/keywords/semantics","display_name":"Semantics (computer science)","score":0.5366242527961731},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.47741806507110596},{"id":"https://openalex.org/keywords/rank","display_name":"Rank (graph theory)","score":0.46951693296432495},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.37608975172042847},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.37002795934677124},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.09348425269126892}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7895931005477905},{"id":"https://openalex.org/C189430467","wikidata":"https://www.wikidata.org/wiki/Q7293293","display_name":"Ranking (information retrieval)","level":2,"score":0.7329679131507874},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.6643327474594116},{"id":"https://openalex.org/C152124472","wikidata":"https://www.wikidata.org/wiki/Q1204361","display_name":"Redundancy (engineering)","level":2,"score":0.6588041186332703},{"id":"https://openalex.org/C184337299","wikidata":"https://www.wikidata.org/wiki/Q1437428","display_name":"Semantics (computer science)","level":2,"score":0.5366242527961731},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.47741806507110596},{"id":"https://openalex.org/C164226766","wikidata":"https://www.wikidata.org/wiki/Q7293202","display_name":"Rank (graph theory)","level":2,"score":0.46951693296432495},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.37608975172042847},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.37002795934677124},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.09348425269126892},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","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/C114614502","wikidata":"https://www.wikidata.org/wiki/Q76592","display_name":"Combinatorics","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3226116.3226117","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3226116.3226117","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of 2018 International Conference on Big Data Technologies - ICBDT '18","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"score":0.6299999952316284,"id":"https://metadata.un.org/sdg/4","display_name":"Quality Education"}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":11,"referenced_works":["https://openalex.org/W1989944922","https://openalex.org/W2010729673","https://openalex.org/W2034989007","https://openalex.org/W2046576694","https://openalex.org/W2067221642","https://openalex.org/W2082873936","https://openalex.org/W2117461391","https://openalex.org/W2132701924","https://openalex.org/W2170889259","https://openalex.org/W2558295850","https://openalex.org/W2589809277"],"related_works":["https://openalex.org/W2188500270","https://openalex.org/W2303858293","https://openalex.org/W2152992791","https://openalex.org/W2798198862","https://openalex.org/W2915512527","https://openalex.org/W1495042958","https://openalex.org/W2494338568","https://openalex.org/W51364034","https://openalex.org/W2798997222","https://openalex.org/W3160516639"],"abstract_inverted_index":{"With":[0],"the":[1,10,30,38,51,61,74,80,86],"extensive":[2],"application":[3],"of":[4,32,53,63,82,104],"keyword":[5],"query":[6,91],"in":[7,102],"relational":[8],"database,":[9],"ranking":[11,21,26,39,48,75],"algorithm":[12],"has":[13,99],"become":[14],"an":[15],"important":[16],"research":[17],"topic.":[18],"Most":[19],"existing":[20],"methods":[22],"have":[23],"adopted":[24],"IR-style":[25],"models":[27],"without":[28],"considering":[29],"effects":[31],"semantic":[33,54],"relevancy":[34,55],"and":[35,56,66,69,106],"diversity":[36,87],"on":[37,50],"results.":[40,92],"In":[41],"this":[42],"paper,":[43],"we":[44,59,84],"propose":[45],"a":[46],"novel":[47],"method":[49,98],"basis":[52],"diversity.":[57],"First,":[58],"define":[60],"concepts":[62],"basic":[64],"semantics":[65,68],"complex":[67],"then":[70],"add":[71],"them":[72],"to":[73,89],"function.":[76],"Next,":[77],"aiming":[78],"at":[79],"generation":[81],"redundancy,":[83],"design":[85],"strategy":[88],"re-rank":[90],"Experimental":[93],"results":[94],"demonstrate":[95],"that":[96],"our":[97],"better":[100],"performance":[101],"terms":[103],"precision":[105],"recall.":[107]},"counts_by_year":[],"updated_date":"2026-07-29T14:22:42.915294","created_date":"2025-10-10T00:00:00"}