Skip to main content
SpringerLink
Log in

Storage Efficiency of LOB Structures for Free RDBMSs on Example of PostgreSQL and Oracle Platforms

  • Conference paper
  • First Online:
Beyond Databases, Architectures and Structures. Towards Efficient Solutions for Data Analysis and Knowledge Representation (BDAS 2017)

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

  • 1272 Accesses

Abstract

The article is a study upon storage efficiency of LOB structures for systems consisting of PostgreSQL or Oracle relational database management systems. Despite the fact that recently several NoSQL DBMS concepts were born (in particular document-oriented or key-value), relational databases still do not lose their popularity. The main content is focused on sparse data such as XML or base64 encoded data that stored in raw form consume significant volume of data storage. Studies cover both performance (data volume stored per unit of time) and savings (ability to save data storage) aspects.

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 EPUB and 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

References

  1. Virtualization and Containerization of Application Infrastructure: A Comparison, vol. 21, University of Twente (2014)

    Google Scholar 

  2. EnterpriseDB: Postgresql overview. http://www.enterprisedb.com/products-services-training/products/postgresql-overview

  3. Hovestadt, M., Kao, O., Kliem, A., Warneke, D.: Adaptive online compression in clouds—making informed decisions in virtual machine environments. J. Grid Comput. 11(2), 167–186 (2013). http://dx.doi.org/10.1007/s10723-013-9249-4

    Article  Google Scholar 

  4. Jägemar, M., Eldh, S., Ermedahl, A., Lisper, B.: Adaptive online feedback controlled message compression. In: 2014 IEEE 38th Annual Computer Software and Applications Conference (COMPSAC), pp. 558–567, July 2014

    Google Scholar 

  5. Kljajic, J., Bogdanovic, N., Nankovski, M., Toncev, M., Djordjevic, B.: Performance analysis of 64-bit EXT4, XFS and BTRFS filesystems on the solid-state disk technology. INFOTEH-JAHORINA 15, 563–566 (2013). http://infoteh.etf.unssa.rs.ba/zbornik/2016/radovi/RSS-2/RSS-2-8.pdf

    Google Scholar 

  6. Nicolae, B.: High throughput data-compression for cloud storage. In: Hameurlain, A., Morvan, F., Tjoa, A.M. (eds.) Globe 2010. LNCS, vol. 6265, pp. 1–12. Springer, Heidelberg (2010). doi:10.1007/978-3-642-15108-8_1

    Chapter  Google Scholar 

  7. Nicolae, B.: On the benefits of transparent compression for cost-effective cloud data storage. In: Hameurlain, A., Küng, J., Wagner, R. (eds.) TLDKS III. LNCS, vol. 6790, pp. 167–184. Springer, Heidelberg (2011). doi:10.1007/978-3-642-23074-5_7

    Chapter  Google Scholar 

  8. Oracle: Securefiles performance, November 2007. http://www.oracle.com/technetwork/database/database-technologies/performance/securefilesperformancepaper-130360.pdf

  9. Oracle: A technical overview of new features for automatic storage management in oracle database 12c, January 2013. http://www.oracle.com/technetwork/products/cloud-storage/oracle-12c-asm-overview-1965430.pdf

  10. Oracle: Oracle advanced compression with oracle database 12c release 2, November 2016. http://www.oracle.com/technetwork/database/options/compression/advanced-compression-wp-12c-1896128.pdf

  11. Oracle: Oracle asm considerations for exadata upgrades, April 2016. http://www.oracle.com/technetwork/database/availability/maa-exadata-upgrade-asm-2339100.pdf

  12. PostgreSQL: Binaryfilesindb https://wiki.postgresql.org/wiki/BinaryFilesInDB

  13. Rodeh, O., Bacik, J., Mason, C.: BTRFS: the linux B-tree filesystem. TOS 9(3), 9 (2013). http://doi.acm.org/10.1145/2501620.2501623

    Article  Google Scholar 

  14. Salomon, D.: Data Compression: The Complete Reference. Springer, New York Inc. (2006)

    MATH  Google Scholar 

  15. Salomon, D., Motta, G.: Handbook of Data Compression, 5th edn. Springer Publishing Company, Incorporated, London (2009)

    MATH  Google Scholar 

  16. Schönig, H.: PostgreSQL Administration Essentials. Community Experience Distilled. Packt Publishing, Birmingham (2014). https://books.google.pl/books?id=BMLUBAAAQBAJ

    Google Scholar 

  17. Vohra, D.: Hello Docker, pp. 1–18. Apress, Berkeley (2016). http://dx.doi.org/10.1007/978-1-4842-1830-3_1

  18. Wycislik, L.: Performance issues in data extraction methods of ETL process for XML. In: Kozielski, S., Mrozek, D., Kasprowski, P., Małysiak-Mrozek, B., Kostrzewa, D. (eds.) Beyond Databases, Architectures, and Structures. CCIS, vol. 424, pp. 581–589. Springer International Publishing, Switzerland (2014)

    Chapter  Google Scholar 

  19. Wycislik, L.: Features of SQL databases for multi-tenant applications based on Oracle DBMS. In: Kozielski, S., Mrozek, D., Kasprowski, P., Małysiak-Mrozek, B., Kostrzewa, D. (eds.) BDAS 2015-2016. CCIS, vol. 613, pp. 507–517. Springer, Cham (2016). doi:10.1007/978-3-319-34099-9_39

    Chapter  Google Scholar 

  20. Wycislik, L.: Independent data partitioning in oracle databases for LOB structures. In: Gruca, A., Brachman, A., Kozielski, S., Czachórski, T. (eds.) Man–Machine Interactions 4. AISC, vol. 391, pp. 687–696. Springer, Cham (2016). doi:10.1007/978-3-319-23437-3_59

    Google Scholar 

Download references

Author information

Authors and Affiliations

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

    Lukasz Wycislik

Authors
  1. Lukasz Wycislik
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Lukasz Wycislik .

Editor information

Editors and Affiliations

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

    Stanisław Kozielski

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

    Dariusz Mrozek

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

    Paweł Kasprowski

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

    Bożena Małysiak-Mrozek

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

    Daniel Kostrzewa

Rights and permissions

Reprints and permissions

Copyright information

© 2017 Springer International Publishing AG

About this paper

Cite this paper

Wycislik, L. (2017). Storage Efficiency of LOB Structures for Free RDBMSs on Example of PostgreSQL and Oracle Platforms. In: Kozielski, S., Mrozek, D., Kasprowski, P., Małysiak-Mrozek, B., Kostrzewa, D. (eds) Beyond Databases, Architectures and Structures. Towards Efficient Solutions for Data Analysis and Knowledge Representation. BDAS 2017. Communications in Computer and Information Science, vol 716. Springer, Cham. https://doi.org/10.1007/978-3-319-58274-0_18

Download citation

  • DOI: https://doi.org/10.1007/978-3-319-58274-0_18

  • Published:

  • Publisher Name: Springer, Cham

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

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

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics

Search

Navigation