Skip to main content
SpringerLink
Log in

Analysis of the Effect of Chosen Initialization Parameters on Database Performance

  • Conference paper
Beyond Databases, Architectures and Structures (BDAS 2015)

Part of the book series: Communications in Computer and Information Science ((CCIS,volume 521))

Abstract

The paper presents an analysis of the influence of chosen initialization parameters on database efficiency and processing time. Experimental research is performed on a real banking system model which includes data structures characteristic to banking systems - structures supporting bank accounts, and reflecting a typical bank organization. Experimental results are compared with results of a real banking system.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Log in via an institution
Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 39.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 54.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. Belknap, P., Dageville, B., Dias, K., Yagoub, K.: Self-tuning for sql performance in oracle database 11g. In: IEEE 25th International Conference on Data Engineering, ICDE 2009, pp. 1694–1700 (March 2009)

    Google Scholar 

  2. Berkovic, I., Ivankovic, Z., Markoski, B., Radosav, D., Ivkovic, M.: Optimization of bulk operation performances within oracle database. In: 2010 8th International Symposium on Intelligent Systems and Informatics (SISY), pp. 163–167 (September 2010)

    Google Scholar 

  3. Boronski, R.: Wplyw ustawien parametru wieloblokowego sekwencyjnego czytania danych na czas wykonywania zapytania sql w bazie danych oracle 11g. In: Modele Inzynierii Teleinformatyki. Wyd. Politechniki Koszalinskiej, Koszalin (2012)

    Google Scholar 

  4. Li, Q., Honglin, X., Yan, G.: Research on performance optimization and implementation of oracle database. In: Third International Symposium on Intelligent Information Technology Application, IITA 2009, vol. 3, pp. 520–523 (November 2009)

    Google Scholar 

  5. Lightstone, S., Teorey, T., Nadeau, T.: Physical Database Design: The Database Professional’s Guide to Exploiting Indexes, Views, Storage, and More. Morgan Kaufmann Publishers Inc., San Francisco (2007)

    Google Scholar 

  6. Ling, Z., Qi, L., Qianyuan, Z., Wei, C.: The study of adjustment and optimization of oracle database in information system. In: 2013 Fifth International Conference on Computational and Information Sciences (ICCIS), pp. 442–445 (June 2013)

    Google Scholar 

  7. Oracle: Oracle database online documentation 12c, release 1 (12.1), http://docs.oracle.com/database/121/index.htm

  8. Oracle Tips by Burleson Consulting: Oracle instance tuning: Examining the internals, http://www.dba-oracle.com/art_tuning_instance.htm

  9. Qingfeng, D., Weishan, Z.: Performance optimization analysis based on oracle database application system. Computer Engineering 14, 91–93 (2005)

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Państwowa Wyższa Szkoła Zawodowa we Włocławku, 3 Maja 17, 87-800, Włocławek, Poland

    Wanda Gryglewicz-Kacerka

  2. Instytut Automatyki Politechniki Łódzkiej, Stefanowskiego 18/22, 90-924, Łódź, Poland

    Jarosław Kacerka

Authors
  1. Wanda Gryglewicz-Kacerka
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Jarosław Kacerka
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Wanda Gryglewicz-Kacerka .

Editor information

Editors and Affiliations

  1. Silesian University of Technology, Gliwice, Poland

    Stanisław Kozielski

  2. Silesian University of Technology, Gliwice, Poland

    Dariusz Mrozek

  3. Silesian University of Technology, Gliwice, Poland

    Paweł Kasprowski

  4. Silesian University of Technology, Gliwice, Poland

    Bożena Małysiak-Mrozek

  5. Silesian University of Technology, Gliwice,, Poland

    Daniel Kostrzewa

Rights and permissions

Reprints and permissions

Copyright information

© 2015 Springer International Publishing Switzerland

About this paper

Cite this paper

Gryglewicz-Kacerka, W., Kacerka, J. (2015). Analysis of the Effect of Chosen Initialization Parameters on Database Performance. In: Kozielski, S., Mrozek, D., Kasprowski, P., Małysiak-Mrozek, B., Kostrzewa, D. (eds) Beyond Databases, Architectures and Structures. BDAS 2015. Communications in Computer and Information Science, vol 521. Springer, Cham. https://doi.org/10.1007/978-3-319-18422-7_5

Download citation

  • DOI: https://doi.org/10.1007/978-3-319-18422-7_5

  • Publisher Name: Springer, Cham

  • Print ISBN: 978-3-319-18421-0

  • Online ISBN: 978-3-319-18422-7

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics

Search

Navigation