Comparative analysis of database access technology

• Autorzy: Barczak A. , Zacharczuk D. , Jastrzębowski S.
• Języki publikacji: EN

Abstrakty

EN

The paper’s subject is comparative analysis of database access technologies. It presents the evolution of the discussed technologies, which are divided into the following categories: single-platform and multi-platform technologies. Sample programs showing the use of programming interfaces, used for initiating and establishing connections with databases and performing simple operations on them. A database diagram, which was used for measuring efficiency of selected technologies as well as testing plan and concept, system and hardware parameters, tested queries and the program skeleton that was used for measuring the efficiency of selected technologies, were presented. The results were grouped according to 4 query types and 3 operating systems. A description was attached to each graph. Conclusions were provided for query tests for each of the operating systems. Finally, the most efficient technologies were discussed, potential causes of increase or decrease in efficiency were presented, and the results were summarized.

Słowa kluczowe

EN

MySQL; Oracle; PostgreSQL

• Wydawca: Wydawnictwo Uniwersytetu Przyrodniczo-Humanistycznego w Siedlcach
• Czasopismo: Studia Informatica : systems and information technology
• Rocznik: 2009
• Tom: Vol. 1(12)
• Strony: 15--31
• Opis fizyczny: Bibliogr. 4 poz., rys., tab.

Twórcy

autor

Barczak A.

• Institute of Computer Science, Academy of Podlasie, ul. 3 Maja 54, 08-110 Siedlce, Poland

autor

Zacharczuk D.

• Institute of Computer Science, Academy of Podlasie, ul. 3 Maja 54, 08-110 Siedlce, Poland

autor

Jastrzębowski S.

• Institute of Computer Science, Academy of Podlasie, ul. 3 Maja 54, 08-110 Siedlce, Poland

Bibliografia

• 1 Wiesław Dudek, Bazy danych SQL. Teoria i praktyka, Helion, Gliwice 2006.
• 2 Paul Beynon-Davies, Systemy baz danych, Wydawnictwa Naukowo-Techniczne, Warszawa 2000.
• 3 William. J. Gilmore, PHP 4.0. Poradnik dla programistów, Mikom, Warszawa 2002.
• 4 Richard Stones, Neil Matthew, Bazy danych i MySQL. Od podstaw, Helion, Gliwice 2003.