Skip to main content
Springer Nature Link
Log in

Features of SQL Databases for Multi-tenant Applications Based on Oracle DBMS

  • Conference paper
  • First Online:
Beyond Databases, Architectures and Structures. Advanced Technologies for Data Mining and Knowledge Discovery (BDAS 2015, BDAS 2016)

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

Abstract

The paper presents several architectural aspects of data layer for developing of multi-tenant applications. Multi-tenancy is a term describing the application model of services delivering in which a single or many instances of a software run on a server and serves multiple tenants. This feature has an impact on several nonfunctional aspects of system such as security, availability, backup, recovery and more. This article clarifies the specificity of these aspects in approach to multi-tenant applications building and points how different data layer architecures address them. On an example of Oracle database serveral build-in features and concepts that could be helpful to increase the quality of mensioned non-functional aspects were discussed.

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

Access this chapter

Log in via an institution

Subscribe and save

Springer+ Basic
$34.99 /Month
  • Get 10 units per month
  • Download Article/Chapter or eBook
  • 1 Unit = 1 Article or 1 Chapter
  • Cancel anytime
Subscribe now

Buy Now

Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Similar content being viewed by others

References

  1. Al Sheshri, W.: Cloud database: database as a service. Int. J. Database Manage. Syst. 5(2), 1 (2013)

    Article  Google Scholar 

  2. Bernstein, P.A., Cseri, I., Dani, N., Ellis, N., Kallan, A., Kakivaya, G., Lomet, D.B., Manne, R., Novik, L., Talius, T.: Adapting microsoft SQL server for cloud computing. In: ICDE. IEEE Computer Society, April 2011. http://research.microsoft.com/apps/pubs/default.aspx?id=152656

  3. Durao, F., Carvalho, J., Fonseka, A., Garcia, V.: A systematic review on cloud computing. J. Supercomputing 68(3), 1321–1346 (2014). http://dx.doi.org/10.1007/s11227-014-1089-x

    Article  Google Scholar 

  4. Gartner: It glossary. (visited on November 2015). http://www.gartner.com/it-glossary/multitenancy

  5. Jain, H., Reddy, B.: Layered architecture for assembling business applications from distributed components. J. Syst. Sci. Syst. Eng. 13(1), 60–77 (2004). http://dx.doi.org/10.1007/s11518-006-0154-2

    Article  Google Scholar 

  6. Kabbedijk, J., Bezemer, C., Jansen, S., Zaidman, A.: Defining multi-tenancy: a systematic mapping study on the academic and the industrial perspective. J. Syst. Softw. 100, 139–148 (2015). http://dx.doi.org/10.1016/j.jss.2014.10.034

    Article  Google Scholar 

  7. Oracle: Oracle label security with oracle database 12c. (visited on November 2015), June 2013. http://www.oracle.com/technetwork/database/options/label-security/label-security-wp-12c-1896140.pdf

  8. Oracle: Oracle multitenant. (visited on November 2015), June 2013. http://www.oracle.com/technetwork/database/multitenant/overview/multitenant-wp-12c-2078248.pdf

  9. Oracle: Oracle database 12c: full transportable export/import. (visited on November 2015), January 2014. http://www.oracle.com/technetwork/database/enterprise-edition/full-transportable-wp-12c-1973971.pdf

  10. Oracle: oracle partitioning with oracle database 12c. (visited on November 2015), September 2014. http://www.oracle.com/technetwork/database/options/partitioning/partitioning-wp-12c-1896137.pdf

  11. Oracle: Plug into the cloud with oracle database 12c. (visited on November 2015), October 2015. http://www.oracle.com/technetwork/database/plug-into-cloud-wp-12c-1896100.pdf

  12. Oracle: Oracle technology global price list. (visited on January 2016), January 2016. http://www.oracle.com/us/corporate/pricing/technology-price-list-070617.pdf

  13. Pathirage, M., Perera, S., Kumara, I., Weerawarana, S.: A multi-tenant architecture for business process executions. In: Proceedings of the 2011 IEEE International Conference on Web Services. ICWS 2011, pp. 121–128. IEEE Computer Society, Washington (2011). http://dx.doi.org/10.1109/ICWS.2011.99

  14. Seltsikas, P., Currie, W.: Evaluating the application service provider (ASP) business model: the challenge of integration. In: Proceedings of the 35th Annual Hawaii International Conference on System Sciences. HICSS, pp. 2801–2809, January 2002

    Google Scholar 

  15. Tao, L.: Shifting paradigms with the application service provider model. Computer 34(10), 32–39 (2001). http://dx.doi.org/10.1109/2.955095

    Article  Google Scholar 

  16. Zarate, M.S., Mendoza, L.C.: Cloud computing: a review of PAAS, IAAS, SAAS services and providers. Lampsakos 7(1), 47–57 (2012)

    Google Scholar 

  17. Zhang, Q., Cheng, L., Boutaba, R.: Cloud computing: state-of-the-art and research challenges. J. Internet Serv. Appl. 1(1), 7–18 (2010). http://dblp.uni-trier.de/db/journals/jisa/jisa1.html#ZhangCB10

    Article  Google Scholar 

Download references

Acknowledgements

This work was supported by NCBiR of Poland (No INNOTECH-K3/IN3/46/ 229379/NCBR/14).

Author information

Authors and Affiliations

  1. Institute of Informatics, Silesian University of Technology, 16 Akademicka Street, 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

© 2016 Springer International Publishing Switzerland

About this paper

Cite this paper

Wycislik, L. (2016). 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) Beyond Databases, Architectures and Structures. Advanced Technologies for Data Mining and Knowledge Discovery. BDAS BDAS 2015 2016. Communications in Computer and Information Science, vol 613. Springer, Cham. https://doi.org/10.1007/978-3-319-34099-9_39

Download citation

  • DOI: https://doi.org/10.1007/978-3-319-34099-9_39

  • Published:

  • Publisher Name: Springer, Cham

  • Print ISBN: 978-3-319-34098-2

  • Online ISBN: 978-3-319-34099-9

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics