Skip to main content
SpringerLink
Log in

The Storage Organisation Influence on Database Operations Performance

  • Conference paper
Man-Machine Interactions 3

Part of the book series: Advances in Intelligent Systems and Computing ((AISC,volume 242))

  • 1764 Accesses

Abstract

Nowadays, many database administrators come across problems regarding storing big amount of data. On the one hand there are made demands of improving of data access efficiency but on the other hand, ways of a storage cost reduction are searched for. One of popular approaches to enhancing database systems is using virtualization technologies. They differ in types of storage level access used as well as in expenses necessary for developing an environment. The main purpose of the research presented in the paper was to analyse the influence of an environment used for configuring database system on efficiency of its performance. Four database were taken into consideration: Oracle, MS SQL Server, DB2 and PostgreSQL along with two kinds of storage infrastructures, based on block and file level protocols.

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 169.00
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 219.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.

Similar content being viewed by others

References

  1. Aiken, S., Grunwald, D., Pleszkun, A.R., Willeke, J.: A performance analysis of the iscsi protocol. In: Proceedings of the 20th IEEE/11th NASA Goddard Conference on Mass Storage Systems and Technologies, pp. 123–134 (2003)

    Google Scholar 

  2. Fomchenko, A.: FIBRE CHANNEL vs. iSCSI for SQL databases, http://sqlconsulting.wordpress.com/2011/04/10/fibre-channel-vs-iscsi-for-sql-databases/ (accessed October 10, 2012)

  3. FreeBSD: FreeBSD Handboo. Chapter 29 Network Servers, http://www.freebsd.org/doc/handbook/network-nfs.html (accessed March 12, 2013)

  4. Hertel, C.: Implementing CIFS: The Common Internet File System. Prentice Hall (2003)

    Google Scholar 

  5. Hirata, S.: A Comparative Analysis of Oracle Database Using NAS and SAN Storage Architecture, http://www.bestthinking.com/articles/computers_and_technology/communications_networks/network_software/a-comparative-analysis-of-oracle-database-using-nas-and-san-storage-architecture (accessed November 12, 2012)

  6. Jones, M.: Network file systems and Linux, http://www.ibm.com/developerworks/linux/library/l-network-filesystems/index.html#author1 (accessed January 10, 2013)

  7. Liu, S.-J., Yi, Z.-J.: Research of network mass storage mode based on san. In: Jin, D., Lin, S. (eds.) Advances in ECWAC. AISC, vol. 149, pp. 279–284. Springer, Heidelberg (2012)

    Google Scholar 

  8. Meggyesi, Z.: Fibre Channel Overview, http://hsi.web.cern.ch/HSI/fcs/spec/overview.htm (accessed December 15, 2012)

  9. Microsoft: Common Internet File System, http://technet.microsoft.com/en-us/library/cc939973.aspx (accessed December 18, 2012)

  10. Microsoft: Files and Filegroups Architecture, http://msdn.microsoft.com/pl-pl/library/ms179316%28v=sql.100%29.aspx (accessed September 12, 2013)

  11. Mistry, R., Seenarine, S.: Microsoft SQL Server 2012 Management and Administration, 2nd edn. Sams Publishing (2012)

    Google Scholar 

  12. Onisick, J.: Storage Protocols, http://www.definethecloud.net/storage-protocols (accessed September 15, 2012)

  13. Oracle: Oracle Database Concepts 11g Release 2 (11.2), http://docs.oracle.com/cd/E11882_01/server.112/e16508/physical.htm (accessed February 05, 2013)

  14. PostgreSQL: Simple Configuration Recommendation, http://wiki.postgresql.org/wiki/Simple_Configuration_Recommendation (accessed November 10, 2012)

  15. Schulz, G.: Discussion of Fibre Channel SAN and NAS. Version: 1.0, http://www.bytepile.com/includes/Dbase_Conf-SAN_or_NAS_MTI.pdf (accessed August 10, 2012)

  16. Stephan, D.: Running Database Applications On NAS: How and Why? http://www.snia.org/sites/default/education/tutorials/2008/fall/applications/StephenDaniel_Running_Database_Application_NAS.pdf (accessed March 12, 2013)

  17. Tworek, G.: Microsoft iSCSI Software Target. Microsoft TechNet, http://technet.microsoft.com/pl-pl/library/microsoft-iscsi-software-target.aspx (accessed December 12, 2009)

Download references

Author information

Authors and Affiliations

  1. Institute of Informatics, Silesian University of Technology, Akademicka 16, 44-100, Gliwice, Poland

    Katarzyna Harężlak, Aleksandra Werner, Małgorzata Bach & Adam Duszeńko

Authors
  1. Katarzyna Harężlak
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Aleksandra Werner
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. Małgorzata Bach
    View author publications

    You can also search for this author in PubMed Google Scholar

  4. Adam Duszeńko
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Katarzyna Harężlak .

Editor information

Editors and Affiliations

  1. Institute of Informatics, Silesian University of Technology, Gliwice, Poland

    Dr. Aleksandra Gruca

  2. Polish Academy of Sciences and Silesian University of Technology, Gliwice, Poland

    Tadeusz Czachórski

  3. Institute of Informatics, Silesian University of Technology, Gliwice, Poland

    Stanisław Kozielski

Rights and permissions

Reprints and permissions

Copyright information

© 2014 Springer International Publishing Switzerland

About this paper

Cite this paper

Harężlak, K., Werner, A., Bach, M., Duszeńko, A. (2014). The Storage Organisation Influence on Database Operations Performance. In: Gruca, D., Czachórski, T., Kozielski, S. (eds) Man-Machine Interactions 3. Advances in Intelligent Systems and Computing, vol 242. Springer, Cham. https://doi.org/10.1007/978-3-319-02309-0_66

Download citation

  • DOI: https://doi.org/10.1007/978-3-319-02309-0_66

  • Publisher Name: Springer, Cham

  • Print ISBN: 978-3-319-02308-3

  • Online ISBN: 978-3-319-02309-0

  • eBook Packages: EngineeringEngineering (R0)

Publish with us

Policies and ethics

Search

Navigation