{"id":"https://openalex.org/W1531774622","doi":"https://doi.org/10.1109/mascot.2004.1348303","title":"Database server workload characterization in an e-commerce environment","display_name":"Database server workload characterization in an e-commerce environment","publication_year":2004,"publication_date":"2004-11-08","ids":{"openalex":"https://openalex.org/W1531774622","doi":"https://doi.org/10.1109/mascot.2004.1348303","mag":"1531774622"},"language":"en","primary_location":{"id":"doi:10.1109/mascot.2004.1348303","is_oa":false,"landing_page_url":"https://doi.org/10.1109/mascot.2004.1348303","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"The IEEE Computer Society's 12th Annual International Symposium on Modeling, Analysis, and Simulation of Computer and Telecommunications Systems, 2004. (MASCOTS 2004). Proceedings.","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/A5101017822","display_name":"Liu Fujian","orcid":null},"institutions":[{"id":"https://openalex.org/I32625721","display_name":"University of Saskatchewan","ror":"https://ror.org/010x8gc63","country_code":"CA","type":"education","lineage":["https://openalex.org/I32625721"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Fujian Liu","raw_affiliation_strings":["Department of Computer Science, University of Saskatchewan, Saskatoon, SAS, Canada","Dept. of Comput. Sci., Saskatchewan Univ., Saskatoon, Sask., Canada"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Department of Computer Science, University of Saskatchewan, Saskatoon, SAS, Canada","institution_ids":["https://openalex.org/I32625721"]},{"raw_affiliation_string":"Dept. of Comput. Sci., Saskatchewan Univ., Saskatoon, Sask., Canada","institution_ids":["https://openalex.org/I32625721"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100297970","display_name":"Zhao Yanping","orcid":null},"institutions":[{"id":"https://openalex.org/I32625721","display_name":"University of Saskatchewan","ror":"https://ror.org/010x8gc63","country_code":"CA","type":"education","lineage":["https://openalex.org/I32625721"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Yanping Zhao","raw_affiliation_strings":["Department of Computer Science, University of Saskatchewan, Saskatoon, SAS, Canada","Dept. of Comput. Sci., Saskatchewan Univ., Saskatoon, Sask., Canada"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Department of Computer Science, University of Saskatchewan, Saskatoon, SAS, Canada","institution_ids":["https://openalex.org/I32625721"]},{"raw_affiliation_string":"Dept. of Comput. Sci., Saskatchewan Univ., Saskatoon, Sask., Canada","institution_ids":["https://openalex.org/I32625721"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100634524","display_name":"Wenguang Wang","orcid":"https://orcid.org/0000-0002-6012-7084"},"institutions":[{"id":"https://openalex.org/I32625721","display_name":"University of Saskatchewan","ror":"https://ror.org/010x8gc63","country_code":"CA","type":"education","lineage":["https://openalex.org/I32625721"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Wenguang Wang","raw_affiliation_strings":["Department of Computer Science, University of Saskatchewan, Saskatoon, SAS, Canada","Dept. of Comput. Sci., Saskatchewan Univ., Saskatoon, Sask., Canada"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Department of Computer Science, University of Saskatchewan, Saskatoon, SAS, Canada","institution_ids":["https://openalex.org/I32625721"]},{"raw_affiliation_string":"Dept. of Comput. Sci., Saskatchewan Univ., Saskatoon, Sask., Canada","institution_ids":["https://openalex.org/I32625721"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5030136940","display_name":"Dwight Makaroff","orcid":"https://orcid.org/0000-0002-0049-4413"},"institutions":[{"id":"https://openalex.org/I32625721","display_name":"University of Saskatchewan","ror":"https://ror.org/010x8gc63","country_code":"CA","type":"education","lineage":["https://openalex.org/I32625721"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"D. Makaroff","raw_affiliation_strings":["Department of Computer Science, University of Saskatchewan, Saskatoon, SAS, Canada","Dept. of Comput. Sci., Saskatchewan Univ., Saskatoon, Sask., Canada"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Department of Computer Science, University of Saskatchewan, Saskatoon, SAS, Canada","institution_ids":["https://openalex.org/I32625721"]},{"raw_affiliation_string":"Dept. of Comput. Sci., Saskatchewan Univ., Saskatoon, Sask., Canada","institution_ids":["https://openalex.org/I32625721"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I32625721"],"apc_list":null,"apc_paid":null,"fwci":null,"has_fulltext":false,"cited_by_count":15,"citation_normalized_percentile":null,"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"475","last_page":"483"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11181","display_name":"Advanced Data Storage Technologies","score":0.9998999834060669,"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":0.9998999834060669,"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/T11478","display_name":"Caching and Content Delivery","score":0.9998000264167786,"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.9990000128746033,"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.8724615573883057},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.8079566955566406},{"id":"https://openalex.org/keywords/cache","display_name":"Cache","score":0.6683318614959717},{"id":"https://openalex.org/keywords/log-shipping","display_name":"Log shipping","score":0.6198201179504395},{"id":"https://openalex.org/keywords/database-server","display_name":"Database server","score":0.6138674020767212},{"id":"https://openalex.org/keywords/database-tuning","display_name":"Database tuning","score":0.5535774230957031},{"id":"https://openalex.org/keywords/server","display_name":"Server","score":0.5532122850418091},{"id":"https://openalex.org/keywords/server-farm","display_name":"Server farm","score":0.5300500392913818},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.5235733389854431},{"id":"https://openalex.org/keywords/scalability","display_name":"Scalability","score":0.4838096499443054},{"id":"https://openalex.org/keywords/page-cache","display_name":"Page cache","score":0.4432944357395172},{"id":"https://openalex.org/keywords/workload","display_name":"Workload","score":0.43827682733535767},{"id":"https://openalex.org/keywords/web-server","display_name":"Web server","score":0.4329102635383606},{"id":"https://openalex.org/keywords/cache-algorithms","display_name":"Cache algorithms","score":0.3458516597747803},{"id":"https://openalex.org/keywords/cpu-cache","display_name":"CPU cache","score":0.31834256649017334},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.27860361337661743},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.24054959416389465},{"id":"https://openalex.org/keywords/client\u2013server-model","display_name":"Client\u2013server model","score":0.21002501249313354},{"id":"https://openalex.org/keywords/the-internet","display_name":"The Internet","score":0.11601617932319641}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8724615573883057},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.8079566955566406},{"id":"https://openalex.org/C115537543","wikidata":"https://www.wikidata.org/wiki/Q165596","display_name":"Cache","level":2,"score":0.6683318614959717},{"id":"https://openalex.org/C94925161","wikidata":"https://www.wikidata.org/wiki/Q6666854","display_name":"Log shipping","level":4,"score":0.6198201179504395},{"id":"https://openalex.org/C205295232","wikidata":"https://www.wikidata.org/wiki/Q76320","display_name":"Database server","level":2,"score":0.6138674020767212},{"id":"https://openalex.org/C107535962","wikidata":"https://www.wikidata.org/wiki/Q2459880","display_name":"Database tuning","level":4,"score":0.5535774230957031},{"id":"https://openalex.org/C93996380","wikidata":"https://www.wikidata.org/wiki/Q44127","display_name":"Server","level":2,"score":0.5532122850418091},{"id":"https://openalex.org/C105908466","wikidata":"https://www.wikidata.org/wiki/Q261645","display_name":"Server farm","level":4,"score":0.5300500392913818},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.5235733389854431},{"id":"https://openalex.org/C48044578","wikidata":"https://www.wikidata.org/wiki/Q727490","display_name":"Scalability","level":2,"score":0.4838096499443054},{"id":"https://openalex.org/C36340418","wikidata":"https://www.wikidata.org/wiki/Q7124288","display_name":"Page cache","level":5,"score":0.4432944357395172},{"id":"https://openalex.org/C2778476105","wikidata":"https://www.wikidata.org/wiki/Q628539","display_name":"Workload","level":2,"score":0.43827682733535767},{"id":"https://openalex.org/C11392498","wikidata":"https://www.wikidata.org/wiki/Q11288","display_name":"Web server","level":3,"score":0.4329102635383606},{"id":"https://openalex.org/C38556500","wikidata":"https://www.wikidata.org/wiki/Q13404475","display_name":"Cache algorithms","level":4,"score":0.3458516597747803},{"id":"https://openalex.org/C189783530","wikidata":"https://www.wikidata.org/wiki/Q352090","display_name":"CPU cache","level":3,"score":0.31834256649017334},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.27860361337661743},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.24054959416389465},{"id":"https://openalex.org/C152880691","wikidata":"https://www.wikidata.org/wiki/Q146813","display_name":"Client\u2013server model","level":3,"score":0.21002501249313354},{"id":"https://openalex.org/C110875604","wikidata":"https://www.wikidata.org/wiki/Q75","display_name":"The Internet","level":2,"score":0.11601617932319641}],"mesh":[],"locations_count":3,"locations":[{"id":"doi:10.1109/mascot.2004.1348303","is_oa":false,"landing_page_url":"https://doi.org/10.1109/mascot.2004.1348303","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"The IEEE Computer Society's 12th Annual International Symposium on Modeling, Analysis, and Simulation of Computer and Telecommunications Systems, 2004. (MASCOTS 2004). Proceedings.","raw_type":"proceedings-article"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.67.6460","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.67.6460","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www.cs.usask.ca/ftp/pub/discus/recent_2002/liu-mascots.pdf","raw_type":"text"},{"id":"pmh:oai:ecommons.usask.ca:10388/etd-12152005-203308","is_oa":false,"landing_page_url":"http://hdl.handle.net/10388/etd-12152005-203308","pdf_url":null,"source":{"id":"https://openalex.org/S4377196608","display_name":"University Library - University of Saskatchewan (University of Saskatchewan)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I32625721","host_organization_name":"University of Saskatchewan","host_organization_lineage":["https://openalex.org/I32625721"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"thesis"}],"best_oa_location":null,"sustainable_development_goals":[{"score":0.5299999713897705,"display_name":"Industry, innovation and infrastructure","id":"https://metadata.un.org/sdg/9"}],"awards":[],"funders":[{"id":"https://openalex.org/F4320334593","display_name":"Natural Sciences and Engineering Research Council of Canada","ror":"https://ror.org/01h531d29"}],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":58,"referenced_works":["https://openalex.org/W67693709","https://openalex.org/W78537038","https://openalex.org/W159719520","https://openalex.org/W196218644","https://openalex.org/W596567059","https://openalex.org/W1485782945","https://openalex.org/W1497005429","https://openalex.org/W1507724384","https://openalex.org/W1512840853","https://openalex.org/W1518749691","https://openalex.org/W1536585203","https://openalex.org/W1537068154","https://openalex.org/W1543747337","https://openalex.org/W1543756834","https://openalex.org/W1546188394","https://openalex.org/W1558090658","https://openalex.org/W1567646530","https://openalex.org/W1573401580","https://openalex.org/W1602178389","https://openalex.org/W1758239890","https://openalex.org/W1860107648","https://openalex.org/W1965893058","https://openalex.org/W1968403101","https://openalex.org/W1972539129","https://openalex.org/W2001414591","https://openalex.org/W2008633193","https://openalex.org/W2013571142","https://openalex.org/W2030006804","https://openalex.org/W2041881718","https://openalex.org/W2043213682","https://openalex.org/W2050734252","https://openalex.org/W2054308357","https://openalex.org/W2058165990","https://openalex.org/W2065961934","https://openalex.org/W2072853307","https://openalex.org/W2089951481","https://openalex.org/W2099554082","https://openalex.org/W2107460938","https://openalex.org/W2108255083","https://openalex.org/W2110658741","https://openalex.org/W2111784404","https://openalex.org/W2115870684","https://openalex.org/W2118173195","https://openalex.org/W2119037696","https://openalex.org/W2125009248","https://openalex.org/W2135102985","https://openalex.org/W2144570882","https://openalex.org/W2147020715","https://openalex.org/W2155239436","https://openalex.org/W2158310845","https://openalex.org/W2158483238","https://openalex.org/W2163772659","https://openalex.org/W2168354847","https://openalex.org/W2966207845","https://openalex.org/W3019383914","https://openalex.org/W6603177645","https://openalex.org/W6639025630","https://openalex.org/W6681515304"],"related_works":["https://openalex.org/W3153041035","https://openalex.org/W2913707658","https://openalex.org/W30138601","https://openalex.org/W933925366","https://openalex.org/W2379939615","https://openalex.org/W1518158855","https://openalex.org/W2125341508","https://openalex.org/W2366769908","https://openalex.org/W2388973293","https://openalex.org/W1531774622"],"abstract_inverted_index":{"In":[0,114],"an":[1,42],"e-commerce":[2,43,67,146],"system,":[3],"the":[4,18,21,26,34,38,48,55,60,72,77,86,99,105,111,122],"database":[5,22,39,56,61,78,87,112,126],"server":[6,40,62],"performance":[7],"is":[8,13,45],"crucial.":[9],"A":[10,30],"dynamic":[11,94,119,150],"cache":[12,95,120,151],"often":[14],"used":[15],"to":[16,47,130],"reduce":[17,98],"load":[19],"on":[20,71],"server,":[23],"which":[24],"reduces":[25,121],"need":[27],"for":[28],"scalability.":[29],"good":[31],"understanding":[32],"of":[33,37,54,85,107,110],"workload":[35],"characteristics":[36],"in":[41,64,125,137,144,153],"environment":[44],"important":[46],"design,":[49],"tuning,":[50],"and":[51,82,140],"capacity":[52],"planning":[53],"server.":[57,88,113],"We":[58,69,89],"characterize":[59],"workloads":[63],"a":[65,93,118,131,149],"benchmark":[66],"system.":[68],"focus":[70],"response":[73],"time,":[74],"CPU":[75,100],"utilization,":[76],"page":[79,127],"reference":[80],"characteristics,":[81],"disk":[83,108],"I/Os":[84,109],"find":[90],"that":[91,135],"using":[92,117,148],"can":[96],"substantially":[97],"utilization":[101],"but":[102,129],"not":[103],"always":[104],"number":[106],"most":[115],"cases,":[116],"temporal":[123,155],"locality":[124],"references,":[128],"smaller":[132],"degree":[133],"than":[134],"reported":[136],"file":[138],"servers":[139],"Web":[141],"proxies.":[142],"Interestingly,":[143],"certain":[145],"workloads,":[147],"results":[152],"better":[154],"locality.":[156]},"counts_by_year":[{"year":2024,"cited_by_count":1},{"year":2014,"cited_by_count":3}],"updated_date":"2026-07-14T23:27:15.235271","created_date":"2025-10-10T00:00:00"}