Skip to main content
Top

2016 | OriginalPaper | Chapter

Improving Query Processing Performance Using Optimization Techniques for Object-Oriented DBMS

Authors : Sheetal Dhande, G. R. Bamnote

Published in: Proceedings of the Second International Conference on Computer and Communication Technologies

Publisher: Springer India

Activate our intelligent search to find suitable subject content or patents.

search-config
loading …

Abstract

This work is based on strategies of query optimization of object-oriented database and subsequent techniques for implementing those strategies. First, an extension of direct navigation method optimization, this proposed methodology can handle multiple attributes of objects through direct navigation method and second is an extension of cache-based optimization for complex queries. Proposed algorithms work on complex queries which involved number of objects and attributes. The experimental result shows that proposed algorithms are capable of handling multiple attributes and gives more optimized result.

Dont have a licence yet? Then find out more about our products and how to get one now:

Springer Professional "Wirtschaft+Technik"

Online-Abonnement

Mit Springer Professional "Wirtschaft+Technik" erhalten Sie Zugriff auf:

  • über 102.000 Bücher
  • über 537 Zeitschriften

aus folgenden Fachgebieten:

  • Automobil + Motoren
  • Bauwesen + Immobilien
  • Business IT + Informatik
  • Elektrotechnik + Elektronik
  • Energie + Nachhaltigkeit
  • Finance + Banking
  • Management + Führung
  • Marketing + Vertrieb
  • Maschinenbau + Werkstoffe
  • Versicherung + Risiko

Jetzt Wissensvorsprung sichern!

Springer Professional "Technik"

Online-Abonnement

Mit Springer Professional "Technik" erhalten Sie Zugriff auf:

  • über 67.000 Bücher
  • über 390 Zeitschriften

aus folgenden Fachgebieten:

  • Automobil + Motoren
  • Bauwesen + Immobilien
  • Business IT + Informatik
  • Elektrotechnik + Elektronik
  • Energie + Nachhaltigkeit
  • Maschinenbau + Werkstoffe




 

Jetzt Wissensvorsprung sichern!

Springer Professional "Wirtschaft"

Online-Abonnement

Mit Springer Professional "Wirtschaft" erhalten Sie Zugriff auf:

  • über 67.000 Bücher
  • über 340 Zeitschriften

aus folgenden Fachgebieten:

  • Bauwesen + Immobilien
  • Business IT + Informatik
  • Finance + Banking
  • Management + Führung
  • Marketing + Vertrieb
  • Versicherung + Risiko




Jetzt Wissensvorsprung sichern!

Literature
1.
go back to reference Jarke, M., Koch, J.: Query optimization in database systems. ACM Comput. Surveys 16(2), 111–152 (1984) Jarke, M., Koch, J.: Query optimization in database systems. ACM Comput. Surveys 16(2), 111–152 (1984)
3.
go back to reference Pieciukiewicz, T., Stencel, K., Subieta, K.: Recursive query processing in SBQL. J. Comput. Sci. Polish Ac Sci. Ed. Elsevier Sci. Publishers, North-Holland, pp. 391–407. ISSN:0138-0648 Pieciukiewicz, T., Stencel, K., Subieta, K.: Recursive query processing in SBQL. J. Comput. Sci. Polish Ac Sci. Ed. Elsevier Sci. Publishers, North-Holland, pp. 391–407. ISSN:0138-0648
4.
go back to reference Stencel, B.M.: Optimization of object-oriented queries addressing large and small collections. IMCSIT 09 ISBN:978-1-4244-5314-6 (2009) Stencel, B.M.: Optimization of object-oriented queries addressing large and small collections. IMCSIT 09 ISBN:978-1-4244-5314-6 (2009)
5.
go back to reference Kozankiewicz, H., Stencel, K., Subieta, K.: Distributed query optimization in the stack-based approach. In: Springer Journal LNCS, 3726, 904–909. Springer, Berlin (2005) Kozankiewicz, H., Stencel, K., Subieta, K.: Distributed query optimization in the stack-based approach. In: Springer Journal LNCS, 3726, 904–909. Springer, Berlin (2005)
6.
go back to reference Cybula, P., Subieta, K.: Query optimization through cached queries for object-oriented query language SBQL. Springer J. Lecture Notes Comput. Sci. 5901, 308–320. ISBN:978-3-642-11265-2 Cybula, P., Subieta, K.: Query optimization through cached queries for object-oriented query language SBQL. Springer J. Lecture Notes Comput. Sci. 5901, 308–320. ISBN:978-3-642-11265-2
7.
go back to reference Cybula, P., Subieta, K.: Decomposition of SBQL queries for optimal result caching, pp. 841–848. FCCSIS (2011). ISBN:978-83-60810-22-4 Cybula, P., Subieta, K.: Decomposition of SBQL queries for optimal result caching, pp. 841–848. FCCSIS (2011). ISBN:978-83-60810-22-4
8.
go back to reference Plodezien, J., Subieta, K.: Optimization methods in object query languages Plodezien, J., Subieta, K.: Optimization methods in object query languages
9.
go back to reference Dhande, S.S., Bamnote, G.R.: Query optimization of OODBMS: semantic matching of cached queries using normalization. ERCICA-2013, Elsevier Publication DBLP, ISBN:978-93-5107-102-0, Aug 2013 Dhande, S.S., Bamnote, G.R.: Query optimization of OODBMS: semantic matching of cached queries using normalization. ERCICA-2013, Elsevier Publication DBLP, ISBN:978-93-5107-102-0, Aug 2013
10.
go back to reference Dhande, S.S., Bamnote, G.R.: Query optimization in OODBMS: identifying subquery for complex query management. In: Second International Conference of Database and Data Mining (DBDM 2014) organised by Academy & Industry Research Collaboration Center (AIRCC), Dubai Dhande, S.S., Bamnote, G.R.: Query optimization in OODBMS: identifying subquery for complex query management. In: Second International Conference of Database and Data Mining (DBDM 2014) organised by Academy & Industry Research Collaboration Center (AIRCC), Dubai
11.
go back to reference Dhande, S.S., Bamnote, G.R.: Query optimization in object oriented DBMS: direct navigation. In: ICCUBEA 2015: First IEEE International Conference on Computing, Communication, Control and Automation, IEEE Pune section, 26 Feb 2015 Dhande, S.S., Bamnote, G.R.: Query optimization in object oriented DBMS: direct navigation. In: ICCUBEA 2015: First IEEE International Conference on Computing, Communication, Control and Automation, IEEE Pune section, 26 Feb 2015
12.
go back to reference Dhande, S.S., Bamnote, G.R.: Query-optimization-in-oodbms-identifying-subquery-for-complex-query-management. Int. J. Database Manage. Syst. (IJDMS) 6(2) (2014) Dhande, S.S., Bamnote, G.R.: Query-optimization-in-oodbms-identifying-subquery-for-complex-query-management. Int. J. Database Manage. Syst. (IJDMS) 6(2) (2014)
13.
go back to reference Satish1, L., Halawani, S.: A fusion algorithm for joins based on collections in odra-object database for rapid application development. IJCSI Int. J. Comput. Sci. 8(4), 2 (2011). ISSN (Online):1694–0814 Satish1, L., Halawani, S.: A fusion algorithm for joins based on collections in odra-object database for rapid application development. IJCSI Int. J. Comput. Sci. 8(4), 2 (2011). ISSN (Online):1694–0814
14.
go back to reference Dhande, S.S., Bamnote, G.R.: Query optimization in object oriented database management system. IRISS 2015: 9th Inter-Research-Institute Seminar in Computer Science, ACM India Feb 5, 2015, Goa, Annual event 2015 Dhande, S.S., Bamnote, G.R.: Query optimization in object oriented database management system. IRISS 2015: 9th Inter-Research-Institute Seminar in Computer Science, ACM India Feb 5, 2015, Goa, Annual event 2015
Metadata
Title
Improving Query Processing Performance Using Optimization Techniques for Object-Oriented DBMS
Authors
Sheetal Dhande
G. R. Bamnote
Copyright Year
2016
Publisher
Springer India
DOI
https://doi.org/10.1007/978-81-322-2523-2_11