Matches in SemOpenAlex for { <https://semopenalex.org/work/W2890445839> ?p ?o ?g. }
Showing items 1 to 70 of
70
with 100 items per page.
- W2890445839 endingPage "8" @default.
- W2890445839 startingPage "1" @default.
- W2890445839 abstract "Database performance throughput is one of the main measurements of the application effectiveness or a system, in terms of speed and delivery. Higher application efficiency is always a goal for any organization; therefore, finding the way to improve the database performance has priority. There are two main factors that can contribute to performance gain or slowness. Firstly, how well designed the database structure is in terms of data types, referential integrity, and indexes. Secondly, the underlying hardware infrastructure that consists of a server, storage, and network. During the application design lifecycle, the database schema is one area that continuously evolves. There are numerous configurational parameters that need to be adjusted according to database schema design and underlying infrastructure, in which in-memory is an important feature. In-memory database stores all data in physical memory, because of keeping entire data and changes of data in physical memory, the in-memory database provides very short response time and transactional throughput as compared to the disk-based database. This study provides comparison between in-memory and disk-based performance with impact analysis of concurrent users and parallelism using TPC-C benchmarking. A comprehensive benchmark guideline benefits for specific database environment was provided in order to track performance changes while migrating to in-memory from disk-based database. These benchmarking statistics provided comparative standpoint that can be verified during performance bottleneck. This study shows that transitioning from disk-based database to in-memory database decreased the response time and reduced the lock contention, however, requires detailed review for index design changes. Key words: Microsoft Structured Query Language (SQL) Server, in-memory, disk-based, transaction processing performance council (TPC-C), benchmarking, database performance, performance comparison, response time, parallelism, concurrent users.  " @default.
- W2890445839 created "2018-09-27" @default.
- W2890445839 creator A5078455801 @default.
- W2890445839 creator A5082447639 @default.
- W2890445839 date "2018-08-31" @default.
- W2890445839 modified "2023-10-02" @default.
- W2890445839 title "Performance comparison of in-memory and disk-based databases using transaction processing performance council (TPC) benchmarking" @default.
- W2890445839 cites W1550275036 @default.
- W2890445839 cites W171388289 @default.
- W2890445839 cites W2014977566 @default.
- W2890445839 cites W2026024369 @default.
- W2890445839 cites W2078392118 @default.
- W2890445839 cites W2288426512 @default.
- W2890445839 cites W2039154437 @default.
- W2890445839 doi "https://doi.org/10.5897/jiis2018.0106" @default.
- W2890445839 hasPublicationYear "2018" @default.
- W2890445839 type Work @default.
- W2890445839 sameAs 2890445839 @default.
- W2890445839 citedByCount "3" @default.
- W2890445839 countsByYear W28904458392021 @default.
- W2890445839 countsByYear W28904458392023 @default.
- W2890445839 crossrefType "journal-article" @default.
- W2890445839 hasAuthorship W2890445839A5078455801 @default.
- W2890445839 hasAuthorship W2890445839A5082447639 @default.
- W2890445839 hasBestOaLocation W28904458391 @default.
- W2890445839 hasConcept C107535962 @default.
- W2890445839 hasConcept C144133560 @default.
- W2890445839 hasConcept C148840519 @default.
- W2890445839 hasConcept C162853370 @default.
- W2890445839 hasConcept C30775581 @default.
- W2890445839 hasConcept C41008148 @default.
- W2890445839 hasConcept C54239708 @default.
- W2890445839 hasConcept C72108876 @default.
- W2890445839 hasConcept C75949130 @default.
- W2890445839 hasConcept C77088390 @default.
- W2890445839 hasConcept C78161392 @default.
- W2890445839 hasConcept C86251818 @default.
- W2890445839 hasConceptScore W2890445839C107535962 @default.
- W2890445839 hasConceptScore W2890445839C144133560 @default.
- W2890445839 hasConceptScore W2890445839C148840519 @default.
- W2890445839 hasConceptScore W2890445839C162853370 @default.
- W2890445839 hasConceptScore W2890445839C30775581 @default.
- W2890445839 hasConceptScore W2890445839C41008148 @default.
- W2890445839 hasConceptScore W2890445839C54239708 @default.
- W2890445839 hasConceptScore W2890445839C72108876 @default.
- W2890445839 hasConceptScore W2890445839C75949130 @default.
- W2890445839 hasConceptScore W2890445839C77088390 @default.
- W2890445839 hasConceptScore W2890445839C78161392 @default.
- W2890445839 hasConceptScore W2890445839C86251818 @default.
- W2890445839 hasIssue "1" @default.
- W2890445839 hasLocation W28904458391 @default.
- W2890445839 hasOpenAccess W2890445839 @default.
- W2890445839 hasPrimaryLocation W28904458391 @default.
- W2890445839 hasRelatedWork W1541209509 @default.
- W2890445839 hasRelatedWork W1554050497 @default.
- W2890445839 hasRelatedWork W1644729475 @default.
- W2890445839 hasRelatedWork W1981207589 @default.
- W2890445839 hasRelatedWork W2014399947 @default.
- W2890445839 hasRelatedWork W2246532623 @default.
- W2890445839 hasRelatedWork W2277570054 @default.
- W2890445839 hasRelatedWork W2937922288 @default.
- W2890445839 hasRelatedWork W3209405617 @default.
- W2890445839 hasRelatedWork W2558870711 @default.
- W2890445839 hasVolume "8" @default.
- W2890445839 isParatext "false" @default.
- W2890445839 isRetracted "false" @default.
- W2890445839 magId "2890445839" @default.
- W2890445839 workType "article" @default.