{"id":"https://openalex.org/W2890445839","doi":"https://doi.org/10.5897/jiis2018.0106","title":"Performance comparison of in-memory and disk-based databases using transaction processing performance council (TPC) benchmarking","display_name":"Performance comparison of in-memory and disk-based databases using transaction processing performance council (TPC) benchmarking","alternate_titles":[],"publication_year":2018,"publication_date":"2018-08-31","ids":{"openalex":"https://openalex.org/W2890445839","doi":"https://doi.org/10.5897/jiis2018.0106","mag":"2890445839"},"language":"en","primary_location":{"id":"doi:10.5897/jiis2018.0106","doi":"https://doi.org/10.5897/jiis2018.0106","is_oa":true,"landing_page_url":"https://doi.org/10.5897/jiis2018.0106","pdf_url":"https://academicjournals.org/journal/JIIS/article-full-text-pdf/D74EDF358447.pdf","source":{"id":"https://openalex.org/S4210208801","display_name":"Journal of Internet and Information Systems","issn_l":"2141-6478","issn":["2141-6478"],"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":["norway-1"],"host_organization":"https://openalex.org/P4310321074","host_organization_name":"Academic Journals","host_organization_lineage":["https://openalex.org/P4310321074"],"host_organization_lineage_names":["Academic Journals"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Journal of Internet and Information Systems","raw_type":"journal-article"},"parent_works":[],"lineage":["https://openalex.org/W2890445839"],"child_works_count":0,"type":"article","is_traditional":true,"indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"diamond","oa_url":"https://academicjournals.org/journal/JIIS/article-full-text-pdf/D74EDF358447.pdf","any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5082447639","display_name":"M. B. Ayub","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"contributor_roles":[],"raw_author_name":"M. B. Ayub","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"last","author":{"id":null,"display_name":"N. Ali","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"contributor_roles":[],"raw_author_name":"N. Ali","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":0,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.7161,"has_fulltext":true,"cited_by_count":10,"citation_normalized_percentile":{"value":0.76870639,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":87,"max":97},"biblio":{"volume":"8","issue":"1","first_page":"1","last_page":"8"},"is_retracted":false,"is_pulled":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","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"}},"topics":[{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","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"}},{"id":"https://openalex.org/T10054","display_name":"Parallel Computing and Optimization Techniques","score":0.0003000000142492354,"subfield":{"id":"https://openalex.org/subfields/1708","display_name":"Hardware and Architecture"},"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/T12127","display_name":"Software System Performance and Reliability","score":0.00019999999494757503,"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/in-memory-databases","display_name":"in-memory databases","score":0.9779999852180481},{"id":"https://openalex.org/keywords/disk-based-databases","display_name":"disk-based databases","score":0.9990000128746033},{"id":"https://openalex.org/keywords/database-performance-comparison","display_name":"database performance comparison","score":0.8330000042915344},{"id":"https://openalex.org/keywords/transaction-throughput","display_name":"transaction throughput","score":0.5770000219345093},{"id":"https://openalex.org/keywords/response-time","display_name":"response time","score":0.9610000252723694},{"id":"https://openalex.org/keywords/lock-contention","display_name":"lock contention","score":0.9490000009536743},{"id":"https://openalex.org/keywords/index-design","display_name":"index design","score":0.6600000262260437},{"id":"https://openalex.org/keywords/concurrent-users","display_name":"concurrent users","score":0.6710000038146973},{"id":"https://openalex.org/keywords/parallelism","display_name":"parallelism","score":0.9409999847412109},{"id":"https://openalex.org/keywords/sql-server","display_name":"SQL Server","score":0.6919999718666077},{"id":"https://openalex.org/keywords/database-migration","display_name":"database migration","score":0.7070000171661377}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8232258558273315},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.7921576499938965},{"id":"https://openalex.org/C86251818","wikidata":"https://www.wikidata.org/wiki/Q816754","display_name":"Benchmarking","level":2,"score":0.6993438005447388},{"id":"https://openalex.org/C107535962","wikidata":"https://www.wikidata.org/wiki/Q2459880","display_name":"Database tuning","level":4,"score":0.595027506351471},{"id":"https://openalex.org/C75949130","wikidata":"https://www.wikidata.org/wiki/Q848010","display_name":"Database transaction","level":2,"score":0.4901209771633148},{"id":"https://openalex.org/C78161392","wikidata":"https://www.wikidata.org/wiki/Q5227414","display_name":"Database testing","level":4,"score":0.4424777030944824},{"id":"https://openalex.org/C30775581","wikidata":"https://www.wikidata.org/wiki/Q632285","display_name":"Database schema","level":3,"score":0.4359172582626343},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.42144298553466797},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.2938857674598694},{"id":"https://openalex.org/C162853370","wikidata":"https://www.wikidata.org/wiki/Q39809","display_name":"Marketing","level":1,"score":0.0},{"id":"https://openalex.org/C144133560","wikidata":"https://www.wikidata.org/wiki/Q4830453","display_name":"Business","level":0,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.5897/jiis2018.0106","doi":"https://doi.org/10.5897/jiis2018.0106","is_oa":true,"landing_page_url":"https://doi.org/10.5897/jiis2018.0106","pdf_url":"https://academicjournals.org/journal/JIIS/article-full-text-pdf/D74EDF358447.pdf","source":{"id":"https://openalex.org/S4210208801","display_name":"Journal of Internet and Information Systems","issn_l":"2141-6478","issn":["2141-6478"],"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":["norway-1"],"host_organization":"https://openalex.org/P4310321074","host_organization_name":"Academic Journals","host_organization_lineage":["https://openalex.org/P4310321074"],"host_organization_lineage_names":["Academic Journals"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Journal of Internet and Information Systems","raw_type":"journal-article"}],"best_oa_location":{"id":"doi:10.5897/jiis2018.0106","doi":"https://doi.org/10.5897/jiis2018.0106","is_oa":true,"landing_page_url":"https://doi.org/10.5897/jiis2018.0106","pdf_url":"https://academicjournals.org/journal/JIIS/article-full-text-pdf/D74EDF358447.pdf","source":{"id":"https://openalex.org/S4210208801","display_name":"Journal of Internet and Information Systems","issn_l":"2141-6478","issn":["2141-6478"],"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":["norway-1"],"host_organization":"https://openalex.org/P4310321074","host_organization_name":"Academic Journals","host_organization_lineage":["https://openalex.org/P4310321074"],"host_organization_lineage_names":["Academic Journals"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Journal of Internet and Information Systems","raw_type":"journal-article"},"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W2890445839.pdf","grobid_xml":"https://content.openalex.org/works/W2890445839.grobid-xml"},"referenced_works_count":12,"referenced_works":["https://openalex.org/W171388289","https://openalex.org/W1550275036","https://openalex.org/W1668303622","https://openalex.org/W2014977566","https://openalex.org/W2026024369","https://openalex.org/W2039154437","https://openalex.org/W2040974191","https://openalex.org/W2078392118","https://openalex.org/W2288426512","https://openalex.org/W2412047973","https://openalex.org/W2471928259","https://openalex.org/W7015459451"],"related_works":["https://openalex.org/W4412346474","https://openalex.org/W2475161192","https://openalex.org/W7135480968","https://openalex.org/W1817723063","https://openalex.org/W2086572791","https://openalex.org/W2346836035","https://openalex.org/W2398519237","https://openalex.org/W2605035899","https://openalex.org/W2187800196","https://openalex.org/W2911773845"],"abstract_inverted_index":{"Database":[0],"performance":[1,40,52,170,197,217,259,265],"throughput":[2,155],"is":[3,25,63,94,121],"one":[4,95],"of":[5,9,18,66,80,134,140,174],"the":[6,10,34,38,60,74,87,91,145,159,231,236],"main":[7,46],"measurements":[8],"application":[11,23,88],"effectiveness":[12],"or":[13,54],"a":[14,27,81],"system,":[15],"in":[16,64,118,130,142,193],"terms":[17,65],"speed":[19],"and":[20,71,84,115,138,153,168,177,234],"delivery.":[21],"Higher":[22],"efficiency":[24],"always":[26],"goal":[28],"for":[29,187,243],"any":[30],"organization;":[31],"therefore,":[32],"finding":[33],"way":[35],"to":[36,51,107,111,158,195,201,227],"improve":[37],"database":[39,61,92,112,126,147,189,226,229,263],"has":[41],"priority.":[42],"There":[43,100],"are":[44,101],"two":[45],"factors":[47],"that":[48,78,97,105,212,222],"can":[49,213],"contribute":[50],"gain":[53],"slowness.":[55],"Firstly,":[56],"how":[57],"well":[58],"designed":[59],"structure":[62],"data":[67,129,137,141],"types,":[68],"referential":[69],"integrity,":[70],"indexes.":[72],"Secondly,":[73],"underlying":[75,116],"hardware":[76],"infrastructure":[77],"consists":[79],"server,":[82],"storage,":[83],"network.":[85],"During":[86],"design":[89,114,245],"lifecycle,":[90],"schema":[93,113],"area":[96],"continuously":[98],"evolves.":[99],"numerous":[102],"configurational":[103],"parameters":[104],"need":[106],"be":[108,214],"adjusted":[109],"according":[110],"infrastructure,":[117],"which":[119],"in-memory":[120,146,167,202,228],"an":[122],"important":[123],"feature.":[124],"In-memory":[125],"stores":[127],"all":[128],"physical":[131,143],"memory,":[132,144],"because":[133],"keeping":[135],"entire":[136],"changes":[139,198],"provides":[148,164],"very":[149],"short":[150],"response":[151,232,267],"time":[152,233],"transactional":[154],"as":[156],"compared":[157],"disk-based":[160,169,204,225],"database.":[161,205],"This":[162,219],"study":[163,220],"comparison":[165],"between":[166],"with":[171],"impact":[172],"analysis":[173],"concurrent":[175,270],"users":[176],"parallelism":[178],"using":[179],"TPC-C":[180],"benchmarking.":[181],"A":[182],"comprehensive":[183],"benchmark":[184],"guideline":[185],"benefits":[186],"specific":[188],"environment":[190],"was":[191],"provided":[192,209],"order":[194],"track":[196],"while":[199],"migrating":[200],"from":[203,224],"These":[206],"benchmarking":[207],"statistics":[208],"comparative":[210],"standpoint":[211],"verified":[215],"during":[216],"bottleneck.":[218],"shows":[221],"transitioning":[223],"decreased":[230],"reduced":[235],"lock":[237],"contention,":[238],"however,":[239],"requires":[240],"detailed":[241],"review":[242],"index":[244],"changes.":[246],"Key":[247],"words:":[248],"Microsoft":[249],"Structured":[250],"Query":[251],"Language":[252],"(SQL)":[253],"Server,":[254],"in-memory,":[255],"disk-based,":[256],"transaction":[257],"processing":[258],"council":[260],"(TPC-C),":[261],"benchmarking,":[262],"performance,":[264],"comparison,":[266],"time,":[268],"parallelism,":[269],"users.":[271]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W2890445839","counts_by_year":[{"year":2026,"cited_by_count":1},{"year":2024,"cited_by_count":4},{"year":2023,"cited_by_count":2},{"year":2021,"cited_by_count":2},{"year":2019,"cited_by_count":1}],"updated_date":"2026-11-16T12:05:36.265796","created_date":"2018-09-27T00:00:00"}
