{"id":"https://openalex.org/W2080484072","doi":"https://doi.org/10.1145/1594156.1594166","title":"Real application testing with database replay","display_name":"Real application testing with database replay","publication_year":2009,"publication_date":"2009-06-29","ids":{"openalex":"https://openalex.org/W2080484072","doi":"https://doi.org/10.1145/1594156.1594166","mag":"2080484072"},"language":"en","primary_location":{"id":"doi:10.1145/1594156.1594166","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1594156.1594166","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the Second International Workshop on Testing Database Systems","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/A5100362598","display_name":"Yujun Wang","orcid":"https://orcid.org/0000-0002-0921-0122"},"institutions":[{"id":"https://openalex.org/I1342911587","display_name":"Oracle (United States)","ror":"https://ror.org/006c77m33","country_code":"US","type":"company","lineage":["https://openalex.org/I1342911587"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Yujun Wang","raw_affiliation_strings":["Oracle USA, Redwood City, CA","Oracle USA, Redwood City, CA#TAB#"],"affiliations":[{"raw_affiliation_string":"Oracle USA, Redwood City, CA","institution_ids":[]},{"raw_affiliation_string":"Oracle USA, Redwood City, CA#TAB#","institution_ids":["https://openalex.org/I1342911587"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5037394423","display_name":"Supiti Buranawatanachoke","orcid":null},"institutions":[{"id":"https://openalex.org/I1342911587","display_name":"Oracle (United States)","ror":"https://ror.org/006c77m33","country_code":"US","type":"company","lineage":["https://openalex.org/I1342911587"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Supiti Buranawatanachoke","raw_affiliation_strings":["Oracle USA, Redwood City, CA","Oracle USA, Redwood City, CA#TAB#"],"affiliations":[{"raw_affiliation_string":"Oracle USA, Redwood City, CA","institution_ids":[]},{"raw_affiliation_string":"Oracle USA, Redwood City, CA#TAB#","institution_ids":["https://openalex.org/I1342911587"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5029827096","display_name":"Romain Colle","orcid":null},"institutions":[{"id":"https://openalex.org/I1342911587","display_name":"Oracle (United States)","ror":"https://ror.org/006c77m33","country_code":"US","type":"company","lineage":["https://openalex.org/I1342911587"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Romain Colle","raw_affiliation_strings":["Oracle USA, Redwood City, CA","Oracle USA, Redwood City, CA#TAB#"],"affiliations":[{"raw_affiliation_string":"Oracle USA, Redwood City, CA","institution_ids":[]},{"raw_affiliation_string":"Oracle USA, Redwood City, CA#TAB#","institution_ids":["https://openalex.org/I1342911587"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5086623481","display_name":"Karl Dias","orcid":null},"institutions":[{"id":"https://openalex.org/I1342911587","display_name":"Oracle (United States)","ror":"https://ror.org/006c77m33","country_code":"US","type":"company","lineage":["https://openalex.org/I1342911587"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Karl Dias","raw_affiliation_strings":["Oracle USA, Redwood City, CA","Oracle USA, Redwood City, CA#TAB#"],"affiliations":[{"raw_affiliation_string":"Oracle USA, Redwood City, CA","institution_ids":[]},{"raw_affiliation_string":"Oracle USA, Redwood City, CA#TAB#","institution_ids":["https://openalex.org/I1342911587"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5075918011","display_name":"Leonidas Galanis","orcid":null},"institutions":[{"id":"https://openalex.org/I1342911587","display_name":"Oracle (United States)","ror":"https://ror.org/006c77m33","country_code":"US","type":"company","lineage":["https://openalex.org/I1342911587"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Leonidas Galanis","raw_affiliation_strings":["Oracle USA, Redwood City, CA","Oracle USA, Redwood City, CA#TAB#"],"affiliations":[{"raw_affiliation_string":"Oracle USA, Redwood City, CA","institution_ids":[]},{"raw_affiliation_string":"Oracle USA, Redwood City, CA#TAB#","institution_ids":["https://openalex.org/I1342911587"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5057135534","display_name":"Stratos Papadomanolakis","orcid":null},"institutions":[{"id":"https://openalex.org/I1342911587","display_name":"Oracle (United States)","ror":"https://ror.org/006c77m33","country_code":"US","type":"company","lineage":["https://openalex.org/I1342911587"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Stratos Papadomanolakis","raw_affiliation_strings":["Oracle USA, Redwood City, CA","Oracle USA, Redwood City, CA#TAB#"],"affiliations":[{"raw_affiliation_string":"Oracle USA, Redwood City, CA","institution_ids":[]},{"raw_affiliation_string":"Oracle USA, Redwood City, CA#TAB#","institution_ids":["https://openalex.org/I1342911587"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5058457583","display_name":"Uri Shaft","orcid":null},"institutions":[{"id":"https://openalex.org/I1342911587","display_name":"Oracle (United States)","ror":"https://ror.org/006c77m33","country_code":"US","type":"company","lineage":["https://openalex.org/I1342911587"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Uri Shaft","raw_affiliation_strings":["Oracle USA, Redwood City, CA","Oracle USA, Redwood City, CA#TAB#"],"affiliations":[{"raw_affiliation_string":"Oracle USA, Redwood City, CA","institution_ids":[]},{"raw_affiliation_string":"Oracle USA, Redwood City, CA#TAB#","institution_ids":["https://openalex.org/I1342911587"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":7,"corresponding_author_ids":["https://openalex.org/A5100362598"],"corresponding_institution_ids":["https://openalex.org/I1342911587"],"apc_list":null,"apc_paid":null,"fwci":0.3427,"has_fulltext":false,"cited_by_count":6,"citation_normalized_percentile":{"value":0.62274238,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":96},"biblio":{"volume":null,"issue":null,"first_page":"1","last_page":"6"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T12127","display_name":"Software System Performance and Reliability","score":0.9995999932289124,"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/T12127","display_name":"Software System Performance and Reliability","score":0.9995999932289124,"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/T10743","display_name":"Software Testing and Debugging Techniques","score":0.9976999759674072,"subfield":{"id":"https://openalex.org/subfields/1712","display_name":"Software"},"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/T11719","display_name":"Data Quality and Management","score":0.9933000206947327,"subfield":{"id":"https://openalex.org/subfields/1803","display_name":"Management Science and Operations Research"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8631916046142578},{"id":"https://openalex.org/keywords/workload","display_name":"Workload","score":0.7998307347297668},{"id":"https://openalex.org/keywords/oracle","display_name":"Oracle","score":0.6177914142608643},{"id":"https://openalex.org/keywords/oracle-database","display_name":"Oracle database","score":0.5929283499717712},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5874837040901184},{"id":"https://openalex.org/keywords/upgrade","display_name":"Upgrade","score":0.5866780281066895},{"id":"https://openalex.org/keywords/troubleshooting","display_name":"Troubleshooting","score":0.505305826663971},{"id":"https://openalex.org/keywords/software","display_name":"Software","score":0.43728065490722656},{"id":"https://openalex.org/keywords/database-tuning","display_name":"Database tuning","score":0.43352776765823364},{"id":"https://openalex.org/keywords/database-administrator","display_name":"Database administrator","score":0.4146175980567932},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.3269079923629761},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.1989496648311615},{"id":"https://openalex.org/keywords/software-engineering","display_name":"Software engineering","score":0.1939719319343567},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.1440386176109314}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8631916046142578},{"id":"https://openalex.org/C2778476105","wikidata":"https://www.wikidata.org/wiki/Q628539","display_name":"Workload","level":2,"score":0.7998307347297668},{"id":"https://openalex.org/C55166926","wikidata":"https://www.wikidata.org/wiki/Q2892946","display_name":"Oracle","level":2,"score":0.6177914142608643},{"id":"https://openalex.org/C2987003710","wikidata":"https://www.wikidata.org/wiki/Q185524","display_name":"Oracle database","level":3,"score":0.5929283499717712},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5874837040901184},{"id":"https://openalex.org/C2780615140","wikidata":"https://www.wikidata.org/wiki/Q920419","display_name":"Upgrade","level":2,"score":0.5866780281066895},{"id":"https://openalex.org/C147494362","wikidata":"https://www.wikidata.org/wiki/Q2078905","display_name":"Troubleshooting","level":2,"score":0.505305826663971},{"id":"https://openalex.org/C2777904410","wikidata":"https://www.wikidata.org/wiki/Q7397","display_name":"Software","level":2,"score":0.43728065490722656},{"id":"https://openalex.org/C107535962","wikidata":"https://www.wikidata.org/wiki/Q2459880","display_name":"Database tuning","level":4,"score":0.43352776765823364},{"id":"https://openalex.org/C70236469","wikidata":"https://www.wikidata.org/wiki/Q1078262","display_name":"Database administrator","level":2,"score":0.4146175980567932},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.3269079923629761},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.1989496648311615},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.1939719319343567},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.1440386176109314}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/1594156.1594166","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1594156.1594166","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the Second International Workshop on Testing Database Systems","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/9","score":0.4300000071525574,"display_name":"Industry, innovation and infrastructure"}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":4,"referenced_works":["https://openalex.org/W1527501358","https://openalex.org/W2022431239","https://openalex.org/W2093826418","https://openalex.org/W2113531724"],"related_works":["https://openalex.org/W4301230095","https://openalex.org/W2907335577","https://openalex.org/W2292265674","https://openalex.org/W4256321408","https://openalex.org/W2265389754","https://openalex.org/W2276205351","https://openalex.org/W2350273309","https://openalex.org/W2224787469","https://openalex.org/W2505533899","https://openalex.org/W1553636018"],"abstract_inverted_index":{"Oracle":[0],"Database":[1,157],"Replay":[2,158],"provides":[3],"a":[4,11,21,49,67,119,126,145,152],"new":[5,120],"way":[6],"to":[7,10,26,38,65,101,138],"test":[8,22,68],"changes":[9,37],"database":[12,39,51],"system":[13,52,69],"by":[14],"reproducing":[15],"the":[16,72,78,92,98,112,131,163],"real":[17,79],"user":[18],"workload":[19,46,61,100],"in":[20,144],"environment.":[23],"It":[24,95],"helps":[25,166],"identify":[27],"potential":[28],"problems":[29,161],"after":[30,162],"software":[31,90],"or":[32,36,42],"hardware":[33],"upgrades,":[34],"patches,":[35],"parameters,":[40],"schema":[41],"data.":[43],"Any":[44],"interesting":[45],"period":[47],"of":[48,77,114,130],"production":[50,80],"can":[53,62],"be":[54,63],"captured":[55,60,99],"with":[56,125,136],"minimal":[57],"overhead.":[58],"The":[59,82],"used":[64],"drive":[66],"while":[70],"maintaining":[71],"concurrency":[73],"and":[74,105,117,133,165],"load":[75],"characteristics":[76],"workload.":[81],"replay":[83,115],"does":[84],"not":[85],"depend":[86],"on":[87],"any":[88],"other":[89],"including":[91],"application":[93],"itself.":[94],"reliably":[96],"reproduces":[97],"support":[102],"early":[103],"diagnosis":[104],"troubleshooting.":[106],"In":[107],"this":[108],"paper":[109],"we":[110],"discuss":[111],"analysis":[113],"results":[116],"introduce":[118],"compare-period":[121],"report,":[122],"which":[123],"assists":[124],"detailed":[127],"performance":[128,160],"comparison":[129],"capture":[132],"its":[134,142],"replays":[135],"respect":[137],"changes.":[139],"We":[140],"demonstrate":[141],"usefulness":[143],"case":[146],"study":[147],"involving":[148],"an":[149],"upgrade":[150,164],"for":[151],"Siebel":[153],"financial":[154],"application,":[155],"where":[156],"identifies":[159],"correcting":[167],"them.":[168]},"counts_by_year":[{"year":2022,"cited_by_count":2},{"year":2015,"cited_by_count":2},{"year":2013,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}