ORIGINAL PAPER
Methodology of comparing the performance of SQl insert operations in selected RDBMS
 
More details
Hide details
 
Journal of Research and Applications in Agricultural Engineering 2012;57(2):134-137
 
KEYWORDS
ABSTRACT
Currently, the majority of the existing IT systems and those that are under development are based on applications that work with database servers. The ever wider range of functionalities that such servers are able to provide results in an increase in the number of their users and in the amount of data processing. This leads to performance problems. Such problems are addressed through both programming and hardware solutions. In terms of programmatic solutions the authors' interest is focused on table structures in RDBMS's and their performance in terms of write operations on data. So far analyses have been conducted relating to the impact of the presence of a primary key and the way it is generated on data write operations in a sample of relational databases.
REFERENCES (8)
1.
Beynon-Davies P.: Systemy baz danych. Warszawa: WNT, 2003.
 
2.
Celko J.: SQL for Smarties, Advanced SQL Programming, 3 Edition, 2005.
 
3.
MySQL Reference Manual - http://dev.mysql.com/doc/refma... 2011.
 
4.
MySQL MyISAM Storage Engine Manual - http://dev.mysql.com/doc/refma....
 
7.
Ponniah P.: Data Warehousing Fundamentals for IT Professionals, 2010.
 
8.
SQL Server perfomance - http://www.sql-serverperforman.... com/articles/dev/sequence_sql_server_2011_p1.aspx 2011.
 
eISSN:2719-423X
ISSN:1642-686X
Journals System - logo
Scroll to top