{"id":"https://openalex.org/W6887936393","doi":"https://doi.org/10.18420/btw2023-02","title":"Workload-Driven Data Placement for Tierless In-Memory Database Systems","display_name":"Workload-Driven Data Placement for Tierless In-Memory Database Systems","publication_year":2023,"publication_date":"2023-01-01","ids":{"openalex":"https://openalex.org/W6887936393","doi":"https://doi.org/10.18420/btw2023-02"},"language":"en","primary_location":{"id":"doi:10.18420/btw2023-02","is_oa":true,"landing_page_url":"https://doi.org/10.18420/btw2023-02","pdf_url":null,"source":{"id":"https://openalex.org/S7407052918","display_name":"Gesellschaft f\u00fcr Informatik (GI)","issn_l":null,"issn":[],"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"article-journal"},"type":"article","indexed_in":["datacite"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://doi.org/10.18420/btw2023-02","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":null,"display_name":"Hurdelhey, Ben","orcid":null},"institutions":[],"countries":[],"is_corresponding":true,"raw_author_name":"Hurdelhey, Ben","raw_affiliation_strings":[],"affiliations":[]},{"author_position":"middle","author":{"id":null,"display_name":"Weisgut, Marcel","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Weisgut, Marcel","raw_affiliation_strings":[],"affiliations":[]},{"author_position":"last","author":{"id":null,"display_name":"Boissier, Martin","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Boissier, Martin","raw_affiliation_strings":[],"affiliations":[]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":3,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":{"value":0.30245227,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":null,"last_page":null},"is_retracted":false,"is_paratext":false,"is_xpac":true,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.6640999913215637,"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.6640999913215637,"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.10580000281333923,"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/T11181","display_name":"Advanced Data Storage Technologies","score":0.06849999725818634,"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-data-storage","display_name":"Computer data storage","score":0.38420000672340393},{"id":"https://openalex.org/keywords/benchmark","display_name":"Benchmark (surveying)","score":0.3644999861717224},{"id":"https://openalex.org/keywords/database-tuning","display_name":"Database tuning","score":0.3330000042915344},{"id":"https://openalex.org/keywords/data-set","display_name":"Data set","score":0.3224000036716461},{"id":"https://openalex.org/keywords/set","display_name":"Set (abstract data type)","score":0.32089999318122864},{"id":"https://openalex.org/keywords/latency","display_name":"Latency (audio)","score":0.31060001254081726},{"id":"https://openalex.org/keywords/memory-management","display_name":"Memory management","score":0.30570000410079956},{"id":"https://openalex.org/keywords/workload","display_name":"Workload","score":0.30550000071525574}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.847000002861023},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.47369998693466187},{"id":"https://openalex.org/C194739806","wikidata":"https://www.wikidata.org/wiki/Q66221","display_name":"Computer data storage","level":2,"score":0.38420000672340393},{"id":"https://openalex.org/C185798385","wikidata":"https://www.wikidata.org/wiki/Q1161707","display_name":"Benchmark (surveying)","level":2,"score":0.3644999861717224},{"id":"https://openalex.org/C107535962","wikidata":"https://www.wikidata.org/wiki/Q2459880","display_name":"Database tuning","level":4,"score":0.3330000042915344},{"id":"https://openalex.org/C58489278","wikidata":"https://www.wikidata.org/wiki/Q1172284","display_name":"Data set","level":2,"score":0.3224000036716461},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.32089999318122864},{"id":"https://openalex.org/C82876162","wikidata":"https://www.wikidata.org/wiki/Q17096504","display_name":"Latency (audio)","level":2,"score":0.31060001254081726},{"id":"https://openalex.org/C176649486","wikidata":"https://www.wikidata.org/wiki/Q2308807","display_name":"Memory management","level":3,"score":0.30570000410079956},{"id":"https://openalex.org/C2778476105","wikidata":"https://www.wikidata.org/wiki/Q628539","display_name":"Workload","level":2,"score":0.30550000071525574},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.29840001463890076},{"id":"https://openalex.org/C45235069","wikidata":"https://www.wikidata.org/wiki/Q278425","display_name":"Table (database)","level":2,"score":0.29030001163482666},{"id":"https://openalex.org/C98045186","wikidata":"https://www.wikidata.org/wiki/Q205663","display_name":"Process (computing)","level":2,"score":0.28040000796318054},{"id":"https://openalex.org/C79974875","wikidata":"https://www.wikidata.org/wiki/Q483639","display_name":"Cloud computing","level":2,"score":0.2784000039100647},{"id":"https://openalex.org/C75684735","wikidata":"https://www.wikidata.org/wiki/Q858810","display_name":"Big data","level":2,"score":0.2750000059604645},{"id":"https://openalex.org/C50954386","wikidata":"https://www.wikidata.org/wiki/Q656083","display_name":"Paging","level":2,"score":0.27090001106262207},{"id":"https://openalex.org/C19012869","wikidata":"https://www.wikidata.org/wiki/Q578372","display_name":"Response time","level":2,"score":0.26989999413490295},{"id":"https://openalex.org/C41045048","wikidata":"https://www.wikidata.org/wiki/Q202843","display_name":"Linear programming","level":2,"score":0.2687000036239624},{"id":"https://openalex.org/C2778434605","wikidata":"https://www.wikidata.org/wiki/Q2445479","display_name":"Total cost of ownership","level":2,"score":0.26409998536109924},{"id":"https://openalex.org/C79403827","wikidata":"https://www.wikidata.org/wiki/Q3988","display_name":"Real-time computing","level":1,"score":0.26159998774528503},{"id":"https://openalex.org/C56288433","wikidata":"https://www.wikidata.org/wiki/Q58673","display_name":"Data manipulation language","level":2,"score":0.2578999996185303},{"id":"https://openalex.org/C2777212361","wikidata":"https://www.wikidata.org/wiki/Q5127848","display_name":"Class (philosophy)","level":2,"score":0.257099986076355}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.18420/btw2023-02","is_oa":true,"landing_page_url":"https://doi.org/10.18420/btw2023-02","pdf_url":null,"source":{"id":"https://openalex.org/S7407052918","display_name":"Gesellschaft f\u00fcr Informatik (GI)","issn_l":null,"issn":[],"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":null,"raw_source_name":null,"raw_type":"article-journal"}],"best_oa_location":{"id":"doi:10.18420/btw2023-02","is_oa":true,"landing_page_url":"https://doi.org/10.18420/btw2023-02","pdf_url":null,"source":{"id":"https://openalex.org/S7407052918","display_name":"Gesellschaft f\u00fcr Informatik (GI)","issn_l":null,"issn":[],"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"article-journal"},"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":0,"referenced_works":[],"related_works":[],"abstract_inverted_index":{"High":[0],"main":[1,30,55,156,165],"memory":[2,21,31,79,157,166],"consumption":[3,167],"is":[4],"a":[5,84,140,153,181,189],"significant":[6],"cost":[7,128,196,217],"factor":[8],"for":[9,70,130,168],"in-memory":[10,72],"database":[11,73],"systems.":[12],"Tiering,":[13],"i.e.,":[14],"placing":[15],"parts":[16],"of":[17,155,172,185,191],"the":[18,29,71,78,164,173],"data":[19,35,41,48,66,99,136,171,192],"on":[20,50],"or":[22,93],"storage":[23,81,132],"devices":[24,44,82],"other":[25],"than":[26],"DRAM,":[27],"reduces":[28],"footprint.":[32],"A":[33],"controlled":[34],"placement":[36,67,100,193],"can":[37,162,206],"assign":[38],"rarely":[39],"accessed":[40],"to":[42,57,126,210],"slow":[43],"while":[45],"frequently":[46],"used":[47],"remains":[49],"fast":[51],"devices,":[52,160],"such":[53,103],"as":[54,104],"memory,":[56],"maintain":[58],"acceptable":[59],"query":[60,107],"latencies.":[61],"We":[62],"present":[63,207],"an":[64,122,149],"automatic":[65],"decision":[68],"system":[69,76,97],"Hyrise.":[74],"The":[75,96],"organizes":[77],"and":[80,109,148,158,195],"in":[83,114],"tierless":[85],"pool,":[86],"with":[87],"no":[88],"fixed":[89],"device":[90],"class":[91],"categorization":[92],"performance":[94],"order.":[95],"supports":[98],"use":[101],"cases,":[102],"minimizing":[105],"end-to-end":[106],"latencies":[108],"making":[110],"cost-optimal":[111],"purchase":[112],"recommendations":[113],"cloud":[115],"environments.":[116],"In":[117,188],"this":[118],"paper,":[119],"we":[120,138,161,198],"introduce":[121,139],"efficient":[123,150],"calibration":[124],"process":[125],"derive":[127],"models":[129],"various":[131],"devices.":[133],"To":[134],"determine":[135],"placements,":[137],"linear":[141,212],"programming-based":[142],"approach,":[143],"which":[144],"yields":[145],"optimal":[146,211],"configurations,":[147],"heuristic.":[151],"With":[152],"set":[154],"SSD":[159],"reduce":[163],"base":[169],"table":[170],"TPC-DS":[174],"benchmark":[175],"by":[176],"74":[177],"percent":[178],"when":[179],"accepting":[180],"workload":[182],"latency":[183],"increase":[184],"52":[186],"percent.":[187],"comparison":[190],"algorithms":[194,202],"models,":[197],"find":[199],"that":[200],"simplistic":[201],"(e.g.,":[203],"greedy":[204],"algorithms)":[205],"viable":[208],"alternatives":[209],"programming":[213],"algorithms,":[214],"especially":[215],"under":[216],"prediction":[218],"inaccuracies.":[219]},"counts_by_year":[],"updated_date":"2025-11-06T06:51:31.235846","created_date":"2025-10-10T00:00:00"}