{"id":"https://openalex.org/W2152563679","doi":"https://doi.org/10.14778/1687553.1687557","title":"An object placement advisor for DB2 using solid state storage","display_name":"An object placement advisor for DB2 using solid state storage","publication_year":2009,"publication_date":"2009-08-01","ids":{"openalex":"https://openalex.org/W2152563679","doi":"https://doi.org/10.14778/1687553.1687557","mag":"2152563679"},"language":"en","primary_location":{"id":"doi:10.14778/1687553.1687557","is_oa":false,"landing_page_url":"https://doi.org/10.14778/1687553.1687557","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the VLDB Endowment","raw_type":"journal-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/A5043925652","display_name":"Mustafa Canim","orcid":null},"institutions":[{"id":"https://openalex.org/I162577319","display_name":"The University of Texas at Dallas","ror":"https://ror.org/049emcs32","country_code":"US","type":"education","lineage":["https://openalex.org/I162577319"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Mustafa Canim","raw_affiliation_strings":["University of Texas at Dallas, Richardson, TX"],"affiliations":[{"raw_affiliation_string":"University of Texas at Dallas, Richardson, TX","institution_ids":["https://openalex.org/I162577319"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5003559911","display_name":"George A. Mihaila","orcid":"https://orcid.org/0000-0002-6185-9658"},"institutions":[{"id":"https://openalex.org/I1341412227","display_name":"IBM (United States)","ror":"https://ror.org/05hh8d621","country_code":"US","type":"company","lineage":["https://openalex.org/I1341412227"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"George A. Mihaila","raw_affiliation_strings":["IBM Watson Research Center, Hawthorne, NY"],"affiliations":[{"raw_affiliation_string":"IBM Watson Research Center, Hawthorne, NY","institution_ids":["https://openalex.org/I1341412227"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5069125151","display_name":"Bishwaranjan Bhattacharjee","orcid":"https://orcid.org/0009-0009-7097-4891"},"institutions":[{"id":"https://openalex.org/I1341412227","display_name":"IBM (United States)","ror":"https://ror.org/05hh8d621","country_code":"US","type":"company","lineage":["https://openalex.org/I1341412227"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Bishwaranjan Bhattacharjee","raw_affiliation_strings":["IBM Watson Research Center, Hawthorne, NY"],"affiliations":[{"raw_affiliation_string":"IBM Watson Research Center, Hawthorne, NY","institution_ids":["https://openalex.org/I1341412227"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5021663937","display_name":"Kenneth A. Ross","orcid":"https://orcid.org/0000-0001-9397-6990"},"institutions":[{"id":"https://openalex.org/I78577930","display_name":"Columbia University","ror":"https://ror.org/00hj8s172","country_code":"US","type":"education","lineage":["https://openalex.org/I78577930"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Kenneth A. Ross","raw_affiliation_strings":["Columbia University, New York, NY"],"affiliations":[{"raw_affiliation_string":"Columbia University, New York, NY","institution_ids":["https://openalex.org/I78577930"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5110235377","display_name":"Christian A. Lang","orcid":null},"institutions":[{"id":"https://openalex.org/I1341412227","display_name":"IBM (United States)","ror":"https://ror.org/05hh8d621","country_code":"US","type":"company","lineage":["https://openalex.org/I1341412227"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Christian A. Lang","raw_affiliation_strings":["IBM Watson Research Center, Hawthorne, NY"],"affiliations":[{"raw_affiliation_string":"IBM Watson Research Center, Hawthorne, NY","institution_ids":["https://openalex.org/I1341412227"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":5,"corresponding_author_ids":["https://openalex.org/A5043925652"],"corresponding_institution_ids":["https://openalex.org/I162577319"],"apc_list":null,"apc_paid":null,"fwci":5.4382,"has_fulltext":false,"cited_by_count":57,"citation_normalized_percentile":{"value":0.96069262,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":89,"max":99},"biblio":{"volume":"2","issue":"2","first_page":"1318","last_page":"1329"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11181","display_name":"Advanced Data Storage Technologies","score":1.0,"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/T11181","display_name":"Advanced Data Storage Technologies","score":1.0,"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/T10101","display_name":"Cloud Computing and Resource Management","score":0.9980999827384949,"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/T10715","display_name":"Distributed and Parallel Computing Systems","score":0.9972000122070312,"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.7869199514389038},{"id":"https://openalex.org/keywords/heuristics","display_name":"Heuristics","score":0.7818781137466431},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.6534230709075928},{"id":"https://openalex.org/keywords/random-access","display_name":"Random access","score":0.6002956628799438},{"id":"https://openalex.org/keywords/object","display_name":"Object (grammar)","score":0.5746005773544312},{"id":"https://openalex.org/keywords/database-administrator","display_name":"Database administrator","score":0.5447155237197876},{"id":"https://openalex.org/keywords/workload","display_name":"Workload","score":0.5427027940750122},{"id":"https://openalex.org/keywords/state","display_name":"State (computer science)","score":0.5280773639678955},{"id":"https://openalex.org/keywords/ibm","display_name":"IBM","score":0.5223953723907471},{"id":"https://openalex.org/keywords/knapsack-problem","display_name":"Knapsack problem","score":0.4565827250480652},{"id":"https://openalex.org/keywords/dynamic-programming","display_name":"Dynamic programming","score":0.43909475207328796},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.3106582760810852},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.13133284449577332},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.08819761872291565}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7869199514389038},{"id":"https://openalex.org/C127705205","wikidata":"https://www.wikidata.org/wiki/Q5748245","display_name":"Heuristics","level":2,"score":0.7818781137466431},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.6534230709075928},{"id":"https://openalex.org/C101722063","wikidata":"https://www.wikidata.org/wiki/Q218825","display_name":"Random access","level":2,"score":0.6002956628799438},{"id":"https://openalex.org/C2781238097","wikidata":"https://www.wikidata.org/wiki/Q175026","display_name":"Object (grammar)","level":2,"score":0.5746005773544312},{"id":"https://openalex.org/C70236469","wikidata":"https://www.wikidata.org/wiki/Q1078262","display_name":"Database administrator","level":2,"score":0.5447155237197876},{"id":"https://openalex.org/C2778476105","wikidata":"https://www.wikidata.org/wiki/Q628539","display_name":"Workload","level":2,"score":0.5427027940750122},{"id":"https://openalex.org/C48103436","wikidata":"https://www.wikidata.org/wiki/Q599031","display_name":"State (computer science)","level":2,"score":0.5280773639678955},{"id":"https://openalex.org/C70388272","wikidata":"https://www.wikidata.org/wiki/Q5968558","display_name":"IBM","level":2,"score":0.5223953723907471},{"id":"https://openalex.org/C113138325","wikidata":"https://www.wikidata.org/wiki/Q864457","display_name":"Knapsack problem","level":2,"score":0.4565827250480652},{"id":"https://openalex.org/C37404715","wikidata":"https://www.wikidata.org/wiki/Q380679","display_name":"Dynamic programming","level":2,"score":0.43909475207328796},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.3106582760810852},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.13133284449577332},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.08819761872291565},{"id":"https://openalex.org/C192562407","wikidata":"https://www.wikidata.org/wiki/Q228736","display_name":"Materials science","level":0,"score":0.0},{"id":"https://openalex.org/C171250308","wikidata":"https://www.wikidata.org/wiki/Q11468","display_name":"Nanotechnology","level":1,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.14778/1687553.1687557","is_oa":false,"landing_page_url":"https://doi.org/10.14778/1687553.1687557","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the VLDB Endowment","raw_type":"journal-article"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.151.8573","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.151.8573","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www.vldb.org/pvldb/2/vldb09-853.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":31,"referenced_works":["https://openalex.org/W320896","https://openalex.org/W135339695","https://openalex.org/W1539619594","https://openalex.org/W1550303690","https://openalex.org/W1841617228","https://openalex.org/W1890845846","https://openalex.org/W1974897895","https://openalex.org/W1981029608","https://openalex.org/W1990946453","https://openalex.org/W1996468759","https://openalex.org/W1997643953","https://openalex.org/W1999119023","https://openalex.org/W2004806949","https://openalex.org/W2006972799","https://openalex.org/W2014796038","https://openalex.org/W2020930775","https://openalex.org/W2079690139","https://openalex.org/W2096674153","https://openalex.org/W2099918651","https://openalex.org/W2108094106","https://openalex.org/W2112479717","https://openalex.org/W2129657903","https://openalex.org/W2130642985","https://openalex.org/W2141048674","https://openalex.org/W2171148344","https://openalex.org/W3145128584","https://openalex.org/W4246219036","https://openalex.org/W4285719527","https://openalex.org/W6600011973","https://openalex.org/W6632326794","https://openalex.org/W7029321148"],"related_works":["https://openalex.org/W241127407","https://openalex.org/W2381035939","https://openalex.org/W2468477307","https://openalex.org/W2910645127","https://openalex.org/W162895179","https://openalex.org/W1966986652","https://openalex.org/W2142105839","https://openalex.org/W1563501581","https://openalex.org/W4389887952","https://openalex.org/W2367132302"],"abstract_inverted_index":{"Solid":[0],"state":[1,52],"disks":[2],"(SSDs)":[3],"provide":[4],"much":[5],"faster":[6],"random":[7,38],"access":[8],"to":[9,12,40,58,116],"data":[10],"compared":[11],"conventional":[13,142],"hard":[14],"disk":[15],"drives.":[16],"Therefore,":[17],"the":[18,30,41,44,54,70,75,78,97,108,120,126,136,159,176,180,188,191],"response":[19,177],"time":[20,178],"of":[21,50,77,114,173,179,190],"a":[22,37,85,93,112,169],"database":[23,55,143],"engine":[24],"could":[25],"be":[26,117,183],"improved":[27],"by":[28,122,186],"moving":[29],"objects":[31,61,115],"that":[32,135,167],"are":[33],"frequently":[34],"accessed":[35],"in":[36,141],"fashion":[39],"SSD.":[42],"Considering":[43],"price":[45],"and":[46,155,161],"limited":[47],"storage":[48],"capacity":[49],"solid":[51],"disks,":[53],"administrator":[56],"needs":[57],"determine":[59],"which":[60],"(tables,":[62],"indexes,":[63],"materialized":[64],"views,":[65],"etc.),":[66],"if":[67],"placed":[68,118],"on":[69,119,150,158],"SSD,":[71],"would":[72],"most":[73],"improve":[74],"performance":[76],"system.":[79],"In":[80],"this":[81],"paper":[82],"we":[83,146],"propose":[84],"tool":[86],"called":[87],"\"Object":[88],"Placement":[89],"Advisor\"":[90],"for":[91,96],"making":[92],"wise":[94],"decision":[95],"object":[98],"placement":[99],"problem.":[100],"By":[101],"collecting":[102],"profile":[103],"inputs":[104],"from":[105],"workload":[106],"runs,":[107],"advisor":[109],"utility":[110],"provides":[111],"list":[113],"SSD":[121,174],"applying":[123],"heuristics":[124],"like":[125],"greedy":[127],"knapsack":[128],"technique":[129],"or":[130],"dynamic":[131],"programming.":[132],"To":[133],"show":[134],"proposed":[137],"approach":[138],"is":[139],"effective":[140],"management":[144],"systems,":[145],"have":[147],"conducted":[148],"experiments":[149],"IBM":[151],"DB2":[152],"with":[153],"queries":[154],"schemas":[156],"based":[157],"TPC-H":[160],"TPC-C":[162],"benchmarks.":[163],"The":[164],"results":[165],"indicate":[166],"using":[168],"relatively":[170],"small":[171],"amount":[172],"storage,":[175],"system":[181],"can":[182],"reduced":[184],"significantly":[185],"considering":[187],"recommendation":[189],"advisor.":[192]},"counts_by_year":[{"year":2024,"cited_by_count":1},{"year":2022,"cited_by_count":1},{"year":2021,"cited_by_count":2},{"year":2020,"cited_by_count":1},{"year":2019,"cited_by_count":3},{"year":2018,"cited_by_count":3},{"year":2017,"cited_by_count":2},{"year":2016,"cited_by_count":2},{"year":2015,"cited_by_count":7},{"year":2014,"cited_by_count":10},{"year":2013,"cited_by_count":10},{"year":2012,"cited_by_count":5}],"updated_date":"2026-04-05T17:49:38.594831","created_date":"2025-10-10T00:00:00"}