Performance analysis of relational databases Oracle and MS SQL based on desktop application
Article Sidebar
Open full text
Issue Vol. 8 (2018)
-
Object recognition on video from camera to computer
Oleksandr Cherednyk, Elżbieta Miłosz215-219
-
System and hardware security options available for users on devices running Android operating system
Tomasz Borysiewicz220-225
-
Efficiency of creating application’s presentation layer with frameworks AngularJS, Angular2, BackboneJS
Monika Tobiańska, Jakub Smołka226-229
-
User monitoring system using of social networks - structure and analysis of the opportunities
Sofiia Lahoda, Marek Miłosz230-234
-
Comparison of object-relational data mapping technology in Symfony 3 framework
Karol Sawłuk, Marek Miłosz235-240
-
Time analysis of the performance of Windows 10 and Windows 8.1 based on mobile application
Jacek Chmiel, Maria Skublewska-Paszkowska241-246
-
Comparison of selected network communication methods on the Android platform
Przemysław Żydek, Jakub Smołka247-251
-
Comparison of tools for automated tests of the graphical user interface using the the Sikuli and AutoIT example
Tomasz Paczuski, Beata Pańczyk252-257
-
Hosting models comparison of ASP.NET Core application
Kamil Zdanikowski, Beata Pańczyk258-262
-
Performance analysis of relational databases Oracle and MS SQL based on desktop application
Grzegorz Dziewit, Jakub Korczyński, Maria Skublewska-Paszkowska263-269
-
Verification methods of a programmer’s knowledge and skills
Paweł Hajduk, Norbert Wieruszewski, Maria Skublewska-Paszkowska270-276
-
Possibility analysis of environmental threat monitoring with the Arduino platform
Krzysztof Lenart, Małgorzata Plechawska-Wójcik277-281
-
Comparative analysis of mobile applications for IT project management
Ewelina Wlaszczyk, Elżbieta Miłosz282-285
-
Comparing the performance of integration platforms
Bartłomiej Karol Flis, Łukasz Kołyga, Maria Skublewska-Paszkowska286-291
-
Analysis of properties of reversible steganography methods
Piotr Zimnicki, Grzegorz Kozieł292-297
-
Performance comparison of automatic tests written in Selenium WebDriver and HP UFT
Krzysztof Drążek, Maria Skublewska-Paszkowska298-301
Main Article Content
DOI
Authors
grzegorz.dziewit@pollub.edu.pl
jakub.korczynski@pollub.edu.pl
Abstract
Comparison of efficiency is not a trivial phenomenon because of disparities between different database systems. This paper presents a methodology of comparing relational database systems in respect of mean time of execution individual DML queries containing subqueries and conjunction of tables. The presented methodology can be additionally accommodated to studies of efficiency in a range of database system itself (study of queries executed directly in database engine). The described methodology allows to receive statement telling which database system is better in comparison to another in dependency of functionalities fulfilled by external application. In the article the analysis of mean time of execution individual DML queries was performed.Two research hypotheses have been put forward: "Microsoft SQL Server database system needs less time to execute INSERT and UPDATE queries than Oracle database" and "Oracle database system needs less time to execute DML queries with binary data than SQL Server"
Keywords:
References
[2] Shapiro M., Miller E.: Managing databases with binary large objects. 16th IEEE Symposium on Mass Storage Systems in cooperation with the 7th NASA Goddard Conference on Mass Storage Systems and Technologies, San Diego 1999
[3] Khawar I., Kamran A., Syed B., Syed A.: Huge and Real-Time Database Systems: A Comparative Study and Review for SQL Server 2016, Oracle 12c & MySQL 5.7 for Personal Computer. Journal of Basic and Applied Sciences, 2017, 13.
[4] Mihailescu M., Sorensen E.: Model-View-ViewModel (MVVM) Design Pattern using Windows Presentation Foundation (WPF) Technology. Megabyte Journal, 2010
[5] Castel J.: Oracle 12c: SQL. Cengage Learning, 2015
[6] Sanka, D., Durkin, W., Radivojevic, M.: SQL Server 2016 Developer's Guide. Packt Publishing, 2017
[7] Specyfikacja diagramu ERD, https://msdn.microsoft.com/plpl/library/projektowanie-baz-danych--diagramy-erd-relacjemiedzy-tabelami-zwiazki-rekordy.aspx, [2018-06-20]
[8] Opis widoku V$SQL (Oracle), https://docs.oracle.com/cd/B19306_01/server.102/b14237/dynviews_2113.htm#REFRN 30246, [2018-05-15]
[9] Opis widoku sys.dm_exec_query_stats (Ms SQL Server), https://docs.microsoft.com/en-us/sql/relationaldatabases/system-dynamic-management-views/sys-dm-execquery-stats-transact-sql?view=sql-server-2017, [2018-05-15]
[10] Opis shared_pool dla bazy Oracle, http://www.dbaoracle.com/concepts/shared_pool_concepts.htm, [2018-06-20]
[11] Opis zapytania czyszczącego pamięć podręczną oraz plan zapytań dla bazy Oracle. http://www.dba-oracle.com/ tp_Oracle_shared_pool_routine_flush.htm, [2018-06-20]
[12] Opis zapytań czyszczących pamięć oraz plan zapytań dla bazy MS SQL, http://www.sqlpedia.pl/aspekty-wydajnosciowezapytan-sql/, [2018-06-20]
[13] Opis bazodanowego typu BLOB w systemie Oracle, https://docs.oracle.com/javadb/10.8.3.0/ref/rrefblob.html, [2018-05-15]
[14] Opis bazodanowego typu Image w systemie SQL Server, https://docs.microsoft.com/en-us/sql/t-sql/data-types/ntext-textand-image-transact-sql?view=sql-server-2017& viewFallback From=sql-server-2017, [2018-05-15]
Article Details
Abstract views: 811
License

This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
