{"id":"https://openalex.org/W2910166962","doi":"https://doi.org/10.1109/access.2019.2893333","title":"Performance of OnPrem Versus Azure SQL Server: A Case Study","display_name":"Performance of OnPrem Versus Azure SQL Server: A Case Study","publication_year":2019,"publication_date":"2019-01-01","ids":{"openalex":"https://openalex.org/W2910166962","doi":"https://doi.org/10.1109/access.2019.2893333","mag":"2910166962"},"language":"en","primary_location":{"id":"doi:10.1109/access.2019.2893333","is_oa":true,"landing_page_url":"https://doi.org/10.1109/access.2019.2893333","pdf_url":"https://ieeexplore.ieee.org/ielx7/6287639/8600701/08618405.pdf","source":{"id":"https://openalex.org/S2485537415","display_name":"IEEE Access","issn_l":"2169-3536","issn":["2169-3536"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310319808","host_organization_name":"Institute of Electrical and Electronics Engineers","host_organization_lineage":["https://openalex.org/P4310319808"],"host_organization_lineage_names":["Institute of Electrical and Electronics Engineers"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"IEEE Access","raw_type":"journal-article"},"type":"article","indexed_in":["crossref","doaj"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"https://ieeexplore.ieee.org/ielx7/6287639/8600701/08618405.pdf","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5064026642","display_name":"Robert Gy\u0151r\u00f6di","orcid":"https://orcid.org/0000-0002-7027-5750"},"institutions":[{"id":"https://openalex.org/I162871001","display_name":"University of Oradea","ror":"https://ror.org/00wzhv093","country_code":"RO","type":"education","lineage":["https://openalex.org/I162871001"]}],"countries":["RO"],"is_corresponding":true,"raw_author_name":"Robert Gyorodi","raw_affiliation_strings":["Department of Computer Science and Information Technology, University of Oradea, Oradea, Romania"],"affiliations":[{"raw_affiliation_string":"Department of Computer Science and Information Technology, University of Oradea, Oradea, Romania","institution_ids":["https://openalex.org/I162871001"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5080512085","display_name":"Marius Iulian Pavel","orcid":null},"institutions":[{"id":"https://openalex.org/I162871001","display_name":"University of Oradea","ror":"https://ror.org/00wzhv093","country_code":"RO","type":"education","lineage":["https://openalex.org/I162871001"]}],"countries":["RO"],"is_corresponding":false,"raw_author_name":"Marius Iulian Pavel","raw_affiliation_strings":["Department of Computer Science and Information Technology, University of Oradea, Oradea, Romania"],"affiliations":[{"raw_affiliation_string":"Department of Computer Science and Information Technology, University of Oradea, Oradea, Romania","institution_ids":["https://openalex.org/I162871001"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5054934597","display_name":"Cornelia Gy\u0151r\u00f6di","orcid":"https://orcid.org/0000-0002-7815-4355"},"institutions":[{"id":"https://openalex.org/I162871001","display_name":"University of Oradea","ror":"https://ror.org/00wzhv093","country_code":"RO","type":"education","lineage":["https://openalex.org/I162871001"]}],"countries":["RO"],"is_corresponding":false,"raw_author_name":"Cornelia Gyorodi","raw_affiliation_strings":["Department of Computer Science and Information Technology, University of Oradea, Oradea, Romania"],"affiliations":[{"raw_affiliation_string":"Department of Computer Science and Information Technology, University of Oradea, Oradea, Romania","institution_ids":["https://openalex.org/I162871001"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5051026460","display_name":"Doina Zmaranda","orcid":"https://orcid.org/0000-0002-3344-5714"},"institutions":[{"id":"https://openalex.org/I162871001","display_name":"University of Oradea","ror":"https://ror.org/00wzhv093","country_code":"RO","type":"education","lineage":["https://openalex.org/I162871001"]}],"countries":["RO"],"is_corresponding":false,"raw_author_name":"Doina Zmaranda","raw_affiliation_strings":["Department of Computer Science and Information Technology, University of Oradea, Oradea, Romania"],"affiliations":[{"raw_affiliation_string":"Department of Computer Science and Information Technology, University of Oradea, Oradea, Romania","institution_ids":["https://openalex.org/I162871001"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":4,"corresponding_author_ids":["https://openalex.org/A5064026642"],"corresponding_institution_ids":["https://openalex.org/I162871001"],"apc_list":{"value":1850,"currency":"USD","value_usd":1850},"apc_paid":{"value":1850,"currency":"USD","value_usd":1850},"fwci":3.0523,"has_fulltext":true,"cited_by_count":18,"citation_normalized_percentile":{"value":0.92526188,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":91,"max":98},"biblio":{"volume":"7","issue":null,"first_page":"15894","last_page":"15902"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10101","display_name":"Cloud Computing and Resource Management","score":0.9997000098228455,"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/T10101","display_name":"Cloud Computing and Resource Management","score":0.9997000098228455,"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.9907000064849854,"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/T11614","display_name":"Cloud Data Security Solutions","score":0.9904999732971191,"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.8474681377410889},{"id":"https://openalex.org/keywords/cloud-computing","display_name":"Cloud computing","score":0.7378442287445068},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.7267115116119385},{"id":"https://openalex.org/keywords/cloud-database","display_name":"Cloud database","score":0.6994978189468384},{"id":"https://openalex.org/keywords/upload","display_name":"Upload","score":0.6241514682769775},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.46370750665664673},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.3537048101425171}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8474681377410889},{"id":"https://openalex.org/C79974875","wikidata":"https://www.wikidata.org/wiki/Q483639","display_name":"Cloud computing","level":2,"score":0.7378442287445068},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.7267115116119385},{"id":"https://openalex.org/C2778974508","wikidata":"https://www.wikidata.org/wiki/Q2499178","display_name":"Cloud database","level":3,"score":0.6994978189468384},{"id":"https://openalex.org/C71901391","wikidata":"https://www.wikidata.org/wiki/Q7126699","display_name":"Upload","level":2,"score":0.6241514682769775},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.46370750665664673},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.3537048101425171}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1109/access.2019.2893333","is_oa":true,"landing_page_url":"https://doi.org/10.1109/access.2019.2893333","pdf_url":"https://ieeexplore.ieee.org/ielx7/6287639/8600701/08618405.pdf","source":{"id":"https://openalex.org/S2485537415","display_name":"IEEE Access","issn_l":"2169-3536","issn":["2169-3536"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310319808","host_organization_name":"Institute of Electrical and Electronics Engineers","host_organization_lineage":["https://openalex.org/P4310319808"],"host_organization_lineage_names":["Institute of Electrical and Electronics Engineers"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"IEEE Access","raw_type":"journal-article"},{"id":"pmh:oai:doaj.org/article:0470770555644d68aab94df56508a7bd","is_oa":true,"landing_page_url":"https://doaj.org/article/0470770555644d68aab94df56508a7bd","pdf_url":null,"source":{"id":"https://openalex.org/S112646816","display_name":"SHILAP Revista de lepidopterolog\u00eda","issn_l":"0300-5267","issn":["0300-5267","2340-4078"],"is_oa":true,"is_in_doaj":true,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"journal"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"IEEE Access, Vol 7, Pp 15894-15902 (2019)","raw_type":"article"}],"best_oa_location":{"id":"doi:10.1109/access.2019.2893333","is_oa":true,"landing_page_url":"https://doi.org/10.1109/access.2019.2893333","pdf_url":"https://ieeexplore.ieee.org/ielx7/6287639/8600701/08618405.pdf","source":{"id":"https://openalex.org/S2485537415","display_name":"IEEE Access","issn_l":"2169-3536","issn":["2169-3536"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310319808","host_organization_name":"Institute of Electrical and Electronics Engineers","host_organization_lineage":["https://openalex.org/P4310319808"],"host_organization_lineage_names":["Institute of Electrical and Electronics Engineers"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"IEEE Access","raw_type":"journal-article"},"sustainable_development_goals":[{"display_name":"Climate action","id":"https://metadata.un.org/sdg/13","score":0.7400000095367432}],"awards":[],"funders":[],"has_content":{"pdf":true,"grobid_xml":true},"content_urls":{"pdf":"https://content.openalex.org/works/W2910166962.pdf","grobid_xml":"https://content.openalex.org/works/W2910166962.grobid-xml"},"referenced_works_count":15,"referenced_works":["https://openalex.org/W1966522639","https://openalex.org/W2010644199","https://openalex.org/W2029683657","https://openalex.org/W2041127627","https://openalex.org/W2046722858","https://openalex.org/W2113134378","https://openalex.org/W2204295848","https://openalex.org/W2270992672","https://openalex.org/W2280934013","https://openalex.org/W2323240969","https://openalex.org/W2590331281","https://openalex.org/W3112477952","https://openalex.org/W4235448192","https://openalex.org/W6774848261","https://openalex.org/W6787820130"],"related_works":["https://openalex.org/W2944823289","https://openalex.org/W3037018281","https://openalex.org/W4285687366","https://openalex.org/W2525741943","https://openalex.org/W2783067697","https://openalex.org/W183136791","https://openalex.org/W2338115216","https://openalex.org/W4387982383","https://openalex.org/W4389286057","https://openalex.org/W4379177077"],"abstract_inverted_index":{"This":[0,140],"paper":[1,141],"presents":[2],"a":[3,75,81,121,135,143,161,168],"comparative":[4,73],"study":[5],"between":[6],"on-premises":[7],"databases":[8,11],"and":[9,28,46,88,99,108,124,127,191,194,207],"cloud":[10,32,129,181],"regarding":[12],"the":[13,17,23,31,43,63,69,115,152,177,204],"response":[14],"time":[15],"of":[16,25,34,154,164,170,180],"database.":[18],"It":[19],"focuses":[20],"on":[21,36,49,95,120],"presenting":[22],"advantages":[24,179],"storing":[26],"data":[27,45,182,186],"applications":[29,47],"in":[30,39,68,137],"and,":[33],"course,":[35],"managing":[37,42],"it":[38,131],"comparison":[40],"with":[41,101,123,160],"same":[44],"locally":[48,94,119],"one":[50],"or":[51],"more":[52],"physical":[53,97],"machines.":[54],"A":[55],"Microsoft":[56],"Azure":[57],"account":[58],"was":[59,86,117,132],"created":[60,87],"to":[61,104,199,203],"manage":[62],"database":[64,103,116,156],"that":[65,79,102,146],"is":[66,92],"stored":[67,118,133],"cloud.":[70],"To":[71],"achieve":[72],"results,":[74],"specific":[76],"testing":[77],"architecture":[78],"uses":[80],"Universal":[82],"Windows":[83],"Platform":[84],"app":[85],"used.":[89],"The":[90],"application":[91],"running":[93],"multiple":[96],"machines":[98],"works":[100],"extract":[105],"data,":[106],"operate,":[107],"upload":[109],"new":[110],"data.":[111],"For":[112],"local":[113],"tests,":[114,130],"server,":[122],"without":[125],"replication,":[126],"for":[128,150],"into":[134],"server":[136],"Central":[138],"US.":[139],"provides":[142],"practical":[144],"approach":[145],"could":[147],"be":[148],"used":[149],"examining":[151],"performance":[153],"basic":[155],"operations":[157],"when":[158],"dealing":[159],"different":[162],"number":[163],"user":[165],"situations.":[166],"As":[167],"result":[169],"tests":[171],"carried":[172],"out,":[173],"we":[174,195],"will":[175,196],"highlight":[176],"many":[178],"storage,":[183],"such":[184],"as":[185],"accessibility,":[187],"speed,":[188],"security,":[189],"automation,":[190],"disaster":[192],"recovery,":[193],"also":[197],"try":[198],"offer":[200],"an":[201],"answer":[202],"most":[205],"common":[206],"important":[208],"question:":[209],"\u201cWhy":[210],"cloud?\u201d.":[211]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2024,"cited_by_count":3},{"year":2023,"cited_by_count":5},{"year":2022,"cited_by_count":3},{"year":2021,"cited_by_count":2},{"year":2020,"cited_by_count":2},{"year":2019,"cited_by_count":2}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}