{"id":"https://openalex.org/W2051028427","doi":"https://doi.org/10.1145/2513591.2513649","title":"Self-managing online partitioner for databases (SMOPD)","display_name":"Self-managing online partitioner for databases (SMOPD)","publication_year":2013,"publication_date":"2013-01-01","ids":{"openalex":"https://openalex.org/W2051028427","doi":"https://doi.org/10.1145/2513591.2513649","mag":"2051028427"},"language":"en","primary_location":{"id":"doi:10.1145/2513591.2513649","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2513591.2513649","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 17th International Database Engineering & Applications Symposium on - IDEAS '13","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/A5048225132","display_name":"Liangzhe Li","orcid":null},"institutions":[{"id":"https://openalex.org/I8692664","display_name":"University of Oklahoma","ror":"https://ror.org/02aqsxs83","country_code":"US","type":"education","lineage":["https://openalex.org/I8692664"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Liangzhe Li","raw_affiliation_strings":["University of Oklahoma, Norman, OK"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Oklahoma, Norman, OK","institution_ids":["https://openalex.org/I8692664"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5071062190","display_name":"Le Gruenwald","orcid":"https://orcid.org/0000-0002-5245-4747"},"institutions":[{"id":"https://openalex.org/I8692664","display_name":"University of Oklahoma","ror":"https://ror.org/02aqsxs83","country_code":"US","type":"education","lineage":["https://openalex.org/I8692664"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Le Gruenwald","raw_affiliation_strings":["University of Oklahoma, Norman, OK"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Oklahoma, Norman, OK","institution_ids":["https://openalex.org/I8692664"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I8692664"],"apc_list":null,"apc_paid":null,"fwci":1.8868,"has_fulltext":false,"cited_by_count":13,"citation_normalized_percentile":{"value":0.87428323,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":97},"biblio":{"volume":null,"issue":null,"first_page":"168","last_page":"173"},"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.9990000128746033,"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.9990000128746033,"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.9988999962806702,"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/T12761","display_name":"Data Stream Mining Techniques","score":0.9973999857902527,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"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.8445466756820679},{"id":"https://openalex.org/keywords/partition","display_name":"Partition (number theory)","score":0.7532522082328796},{"id":"https://openalex.org/keywords/benchmark","display_name":"Benchmark (surveying)","score":0.7261901497840881},{"id":"https://openalex.org/keywords/statistic","display_name":"Statistic","score":0.713230550289154},{"id":"https://openalex.org/keywords/key","display_name":"Key (lock)","score":0.6572903394699097},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.6329854130744934},{"id":"https://openalex.org/keywords/set","display_name":"Set (abstract data type)","score":0.5572912693023682},{"id":"https://openalex.org/keywords/task","display_name":"Task (project management)","score":0.5509924292564392},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.48083218932151794},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.10593372583389282}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8445466756820679},{"id":"https://openalex.org/C42812","wikidata":"https://www.wikidata.org/wiki/Q1082910","display_name":"Partition (number theory)","level":2,"score":0.7532522082328796},{"id":"https://openalex.org/C185798385","wikidata":"https://www.wikidata.org/wiki/Q1161707","display_name":"Benchmark (surveying)","level":2,"score":0.7261901497840881},{"id":"https://openalex.org/C89128539","wikidata":"https://www.wikidata.org/wiki/Q1949963","display_name":"Statistic","level":2,"score":0.713230550289154},{"id":"https://openalex.org/C26517878","wikidata":"https://www.wikidata.org/wiki/Q228039","display_name":"Key (lock)","level":2,"score":0.6572903394699097},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.6329854130744934},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.5572912693023682},{"id":"https://openalex.org/C2780451532","wikidata":"https://www.wikidata.org/wiki/Q759676","display_name":"Task (project management)","level":2,"score":0.5509924292564392},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.48083218932151794},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.10593372583389282},{"id":"https://openalex.org/C162324750","wikidata":"https://www.wikidata.org/wiki/Q8134","display_name":"Economics","level":0,"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/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/C205649164","wikidata":"https://www.wikidata.org/wiki/Q1071","display_name":"Geography","level":0,"score":0.0},{"id":"https://openalex.org/C187736073","wikidata":"https://www.wikidata.org/wiki/Q2920921","display_name":"Management","level":1,"score":0.0},{"id":"https://openalex.org/C13280743","wikidata":"https://www.wikidata.org/wiki/Q131089","display_name":"Geodesy","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":1,"locations":[{"id":"doi:10.1145/2513591.2513649","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2513591.2513649","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 17th International Database Engineering & Applications Symposium on - IDEAS '13","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[{"id":"https://openalex.org/F4320306076","display_name":"National Science Foundation","ror":"https://ror.org/021nxhr62"}],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":23,"referenced_works":["https://openalex.org/W1444968430","https://openalex.org/W1554451661","https://openalex.org/W1907097404","https://openalex.org/W1961270850","https://openalex.org/W1965641473","https://openalex.org/W1978239142","https://openalex.org/W1997375126","https://openalex.org/W2039795745","https://openalex.org/W2066771339","https://openalex.org/W2099918651","https://openalex.org/W2105252819","https://openalex.org/W2112474496","https://openalex.org/W2114679600","https://openalex.org/W2119430004","https://openalex.org/W2127126492","https://openalex.org/W2133741724","https://openalex.org/W2141463661","https://openalex.org/W2147419309","https://openalex.org/W2158491997","https://openalex.org/W2161906280","https://openalex.org/W2163371797","https://openalex.org/W2168780254","https://openalex.org/W2170870260"],"related_works":["https://openalex.org/W2378211422","https://openalex.org/W2745001401","https://openalex.org/W4321353415","https://openalex.org/W2130974462","https://openalex.org/W2028665553","https://openalex.org/W2086519370","https://openalex.org/W972276598","https://openalex.org/W2087343574","https://openalex.org/W4246352526","https://openalex.org/W2121910908"],"abstract_inverted_index":{"A":[0],"key":[1],"factor":[2],"of":[3,135,157],"measuring":[4],"database":[5,39,100],"performance":[6,101,109,156],"is":[7,12,19,40],"query":[8,83],"response":[9],"time,":[10],"which":[11],"dominated":[13],"by":[14,56],"I/O":[15,28],"time.":[16],"Database":[17],"partitioning":[18,52,74],"among":[20],"techniques":[21],"that":[22,112],"can":[23,96,114,128],"help":[24],"users":[25],"reduce":[26],"the":[27,57,99,108,132,138,143,151,155,158,161],"time":[29],"significantly.":[30],"However,":[31],"how":[32],"to":[33,49,117],"efficiently":[34],"partition":[35],"tables":[36],"in":[37,72],"a":[38,82,119],"not":[41],"an":[42,63],"easy":[43],"problem,":[44],"especially":[45],"when":[46,116],"we":[47],"want":[48],"have":[50],"this":[51],"task":[53],"done":[54],"automatically":[55,106],"system":[58,86,91,139],"itself.":[59],"This":[60,94,126],"paper":[61,148],"introduces":[62],"algorithm":[64,95,127,159],"called":[65],"Self-Managing":[66],"Online":[67],"Partitioner":[68],"for":[69],"Databases":[70],"(SMOPD)":[71],"vertical":[73],"based":[75],"on":[76],"closed":[77],"item":[78],"sets":[79],"mining":[80],"from":[81,90,124,131],"set":[84],"and":[85,105,140],"statistic":[87,92,145],"information":[88],"mined":[89],"views.":[93],"dynamically":[97],"monitor":[98],"using":[102,160],"user-configured":[103],"parameters":[104],"detect":[107],"trend":[110],"so":[111],"it":[113],"decide":[115],"perform":[118],"re-partitioning":[120],"action":[121],"without":[122],"feedback":[123],"DBAs.":[125],"free":[129],"DBAs":[130],"heavy":[133],"tasks":[134],"keeping":[136],"monitoring":[137],"struggling":[141],"against":[142],"large":[144],"tables.":[146],"The":[147],"also":[149],"presents":[150],"experimental":[152],"results":[153],"evaluating":[154],"TPC-H":[162],"benchmark.":[163]},"counts_by_year":[{"year":2024,"cited_by_count":1},{"year":2021,"cited_by_count":1},{"year":2020,"cited_by_count":2},{"year":2019,"cited_by_count":1},{"year":2017,"cited_by_count":3},{"year":2016,"cited_by_count":3},{"year":2015,"cited_by_count":1},{"year":2014,"cited_by_count":1}],"updated_date":"2026-06-26T08:34:08.712188","created_date":"2025-10-10T00:00:00"}