{"id":"https://openalex.org/W4284970220","doi":"https://doi.org/10.1145/3491418.3530290","title":"Performance Optimization of the Open XDMoD Datawarehouse","display_name":"Performance Optimization of the Open XDMoD Datawarehouse","publication_year":2022,"publication_date":"2022-07-08","ids":{"openalex":"https://openalex.org/W4284970220","doi":"https://doi.org/10.1145/3491418.3530290"},"language":"en","primary_location":{"id":"doi:10.1145/3491418.3530290","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3491418.3530290","pdf_url":null,"source":{"id":"https://openalex.org/S4306523034","display_name":"Practice and Experience in Advanced Research Computing","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Practice and Experience in Advanced Research Computing","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/A5089883238","display_name":"Gregary Dean","orcid":null},"institutions":[],"countries":[],"is_corresponding":true,"raw_author_name":"Gregary Dean","raw_affiliation_strings":["Center for Computational Research - University at Buffalo, USA"],"affiliations":[{"raw_affiliation_string":"Center for Computational Research - University at Buffalo, USA","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5030150080","display_name":"Joshua Moraes","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Joshua Moraes","raw_affiliation_strings":["Center for Computational Research - University at Buffalo, USA"],"affiliations":[{"raw_affiliation_string":"Center for Computational Research - University at Buffalo, USA","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5087331881","display_name":"Joseph P. White","orcid":"https://orcid.org/0000-0003-0078-5330"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Joseph White","raw_affiliation_strings":["Center for Computational Research - University at Buffalo, USA"],"affiliations":[{"raw_affiliation_string":"Center for Computational Research - University at Buffalo, USA","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5010580969","display_name":"Robert L. DeLeon","orcid":"https://orcid.org/0000-0003-1417-8363"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Robert Deleon","raw_affiliation_strings":["Center for Computational Research - University at Buffalo, USA"],"affiliations":[{"raw_affiliation_string":"Center for Computational Research - University at Buffalo, USA","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5014096956","display_name":"Matthew D. Jones","orcid":"https://orcid.org/0000-0001-7293-226X"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Matthew Jones","raw_affiliation_strings":["Center for Computational Research - University at Buffalo, USA"],"affiliations":[{"raw_affiliation_string":"Center for Computational Research - University at Buffalo, USA","institution_ids":[]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5086695342","display_name":"Thomas R. Furlani","orcid":"https://orcid.org/0000-0002-4683-0814"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Thomas Furlani","raw_affiliation_strings":["Center for Computational Research - University at Buffalo, USA"],"affiliations":[{"raw_affiliation_string":"Center for Computational Research - University at Buffalo, USA","institution_ids":[]}]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":6,"corresponding_author_ids":["https://openalex.org/A5089883238"],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":{"value":0.07252699,"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":"7"},"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.9930999875068665,"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.9930999875068665,"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.9869999885559082,"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/T10538","display_name":"Data Mining Algorithms and Applications","score":0.98580002784729,"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.8337409496307373},{"id":"https://openalex.org/keywords/cloud-computing","display_name":"Cloud computing","score":0.6278504729270935},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5697436928749084},{"id":"https://openalex.org/keywords/open-source","display_name":"Open source","score":0.4910619258880615},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.4394311308860779},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.3681201636791229},{"id":"https://openalex.org/keywords/world-wide-web","display_name":"World Wide Web","score":0.3260679244995117},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.24119412899017334},{"id":"https://openalex.org/keywords/software","display_name":"Software","score":0.10573461651802063}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8337409496307373},{"id":"https://openalex.org/C79974875","wikidata":"https://www.wikidata.org/wiki/Q483639","display_name":"Cloud computing","level":2,"score":0.6278504729270935},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5697436928749084},{"id":"https://openalex.org/C3018397939","wikidata":"https://www.wikidata.org/wiki/Q3644502","display_name":"Open source","level":3,"score":0.4910619258880615},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.4394311308860779},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.3681201636791229},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.3260679244995117},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.24119412899017334},{"id":"https://openalex.org/C2777904410","wikidata":"https://www.wikidata.org/wiki/Q7397","display_name":"Software","level":2,"score":0.10573461651802063}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3491418.3530290","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3491418.3530290","pdf_url":null,"source":{"id":"https://openalex.org/S4306523034","display_name":"Practice and Experience in Advanced Research Computing","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Practice and Experience in Advanced Research Computing","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/9","score":0.6299999952316284,"display_name":"Industry, innovation and infrastructure"}],"awards":[{"id":"https://openalex.org/G8550080351","display_name":null,"funder_award_id":"1445806","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"}],"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":2,"referenced_works":["https://openalex.org/W1495859460","https://openalex.org/W2151316504"],"related_works":["https://openalex.org/W2748952813","https://openalex.org/W2383532021","https://openalex.org/W2318636398","https://openalex.org/W2384888906","https://openalex.org/W2067134532","https://openalex.org/W2381966551","https://openalex.org/W2376314740","https://openalex.org/W2979321596","https://openalex.org/W2114208128","https://openalex.org/W394108043"],"abstract_inverted_index":{"Open":[0,42],"XDMoD":[1,43],"is":[2,17,28,44,51,130],"an":[3],"open":[4],"source":[5],"tool":[6],"to":[7,30,53,89,101,114,137,163],"facilitate":[8],"the":[9,55,72,81,87,90,102,121,126,153],"management":[10],"of":[11,41,57,62,64,155],"high":[12],"performance":[13,117],"computing":[14],"resources.":[15],"It":[16,129],"widely":[18],"deployed":[19],"at":[20],"academic,":[21],"industrial,":[22],"and":[23,27,33,36,108,124,141,157,167],"governmental":[24],"HPC":[25,35],"centers":[26],"used":[29],"monitor":[31],"large":[32],"small":[34],"cloud":[37],"systems.":[38],"The":[39],"core":[40],"a":[45,67,131,149],"MySQL":[46],"based":[47],"data":[48,127,165],"warehouse":[49],"that":[50,83,134,159],"designed":[52],"support":[54],"storage":[56,92],"historical":[58],"information":[59],"for":[60,71,152],"hundreds":[61],"millions":[63],"jobs":[65],"with":[66],"fast":[68],"query":[69,122],"time":[70],"interactive":[73],"web":[74],"portal.":[75],"In":[76,94],"this":[77,146],"paper,":[78],"we":[79,84],"describe":[80],"transition":[82],"made":[85,100],"from":[86],"MyISAM":[88],"InnoDB":[91],"engine.":[93],"addition,":[95],"other":[96],"improvements":[97,118],"were":[98,112],"also":[99],"database":[103],"queries":[104],"such":[105],"as":[106],"reordering":[107],"adding":[109],"indices.":[110],"We":[111],"able":[113],"attain":[115],"substantial":[116],"in":[119,125,139],"both":[120],"execution":[123],"ingestion/aggregation.":[128],"common":[132],"trend":[133],"databases":[135],"tend":[136],"grow":[138],"size":[140],"complexity":[142],"throughout":[143],"their":[144],"lifetime;":[145],"work":[147],"presents":[148],"practical":[150],"guide":[151],"types":[154],"practices":[156],"procedures":[158],"can":[160],"be":[161],"done":[162],"maintain":[164],"retrieval":[166],"ingestion":[168],"performance.":[169]},"counts_by_year":[],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}