Skip to main content
Top

2017 | OriginalPaper | Chapter

New Variants of Hash-Division Algorithm for Tolerant and Stratified Division

Authors : Noussaiba Benadjmi, Khaled Walid Hidouci

Published in: Flexible Query Answering Systems

Publisher: Springer International Publishing

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

search-config
loading …

Abstract

Works done in the context of the relational division for DBMS led to several approaches. Among which, the Hash-Division algorithm proved its superiority compared to the other approaches in the most of the cases. Nowadays, current trends of division are been oriented towards flexible queries and those involving preferences. However, the emphasis was always on proposing new operators which provide more flexibility and tolerance than the classical division operator. The performance aspect has not been adequately addressed. The proposed approaches in the literature suffer from a lack of performance, especially in a large volume of data. In this paper, we attempt to address this problem. Our idea consists in exploiting the advantages offered by the classical Hash-Division algorithm to propose new variants tailored for the flexible context. We paid a special attention to the improvement of some extended tolerant operators. Furthermore, we introduce a parallel implementation of our proposed techniques. Experimental results show the efficiency of our proposition. We obtained a very satisfactory improvement in processing time (the gain exceeds a ratio of 20 in the majority of cases) in both sequential and parallel implementation.

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!

Footnotes
1
In the literature, up to now, the largest dividend used never exceed 30000 tuples.
 
Literature
1.
go back to reference Habib, W.M., Mokhtar, H.M., El-Sharkawi, M.: Processing universal quantification queries using mapreduce. In: International Conference on Big Data and Smart Computing (BIGCOMP). IEEE (2014) Habib, W.M., Mokhtar, H.M., El-Sharkawi, M.: Processing universal quantification queries using mapreduce. In: International Conference on Big Data and Smart Computing (BIGCOMP). IEEE (2014)
2.
go back to reference Rantzau, R., Shapiro, L., Mitschang, B., Wang, Q.: Universal quantification in relational databases: a classification of data and algorithms. In: Jensen, C.S., Šaltenis, S., Jeffery, K.G., Pokorny, J., Bertino, E., Böhn, K., Jarke, M. (eds.) EDBT 2002. LNCS, vol. 2287, pp. 445–463. Springer, Heidelberg (2002). doi:10.1007/3-540-45876-X_29 CrossRef Rantzau, R., Shapiro, L., Mitschang, B., Wang, Q.: Universal quantification in relational databases: a classification of data and algorithms. In: Jensen, C.S., Šaltenis, S., Jeffery, K.G., Pokorny, J., Bertino, E., Böhn, K., Jarke, M. (eds.) EDBT 2002. LNCS, vol. 2287, pp. 445–463. Springer, Heidelberg (2002). doi:10.​1007/​3-540-45876-X_​29 CrossRef
3.
go back to reference Graefe, G.: Relational division: four algorithms and their performance. In: Fifth International Conference on Data Engineering, Proceedings. IEEE (1989) Graefe, G.: Relational division: four algorithms and their performance. In: Fifth International Conference on Data Engineering, Proceedings. IEEE (1989)
4.
go back to reference Bosc, P., Hadjali, A., Pivert, O.: Empty versus overabundant answers to flexible relational queries. Fuzzy Sets Syst. 159(12), 1450–1467 (2008)MathSciNetCrossRefMATH Bosc, P., Hadjali, A., Pivert, O.: Empty versus overabundant answers to flexible relational queries. Fuzzy Sets Syst. 159(12), 1450–1467 (2008)MathSciNetCrossRefMATH
5.
6.
go back to reference Galindo, J., et al.: Relaxing the universal quantifier of the division in fuzzy relational databases. Int. J. Intell. Syst. 16(6), 713–742 (2001)CrossRefMATH Galindo, J., et al.: Relaxing the universal quantifier of the division in fuzzy relational databases. Int. J. Intell. Syst. 16(6), 713–742 (2001)CrossRefMATH
7.
go back to reference Bosc, P., HadjAli, A., Pivert, O.: La notion de division tolèrante et son intèrêt pour remédier aux réponses vides. Ingénierie des systèmes d’information 13(5), 131–154 (2008)CrossRef Bosc, P., HadjAli, A., Pivert, O.: La notion de division tolèrante et son intèrêt pour remédier aux réponses vides. Ingénierie des systèmes d’information 13(5), 131–154 (2008)CrossRef
8.
go back to reference Kacprzyk, J., Zadrony, S., De Tre, G.: Fuzziness in database management systems: half a century of developments and future prospects. Fuzzy Sets Syst. 281, 300–307 (2015)MathSciNetCrossRef Kacprzyk, J., Zadrony, S., De Tre, G.: Fuzziness in database management systems: half a century of developments and future prospects. Fuzzy Sets Syst. 281, 300–307 (2015)MathSciNetCrossRef
9.
go back to reference Bosc, P., Pivert, O., Rocacher, D.: About quotient and division of crisp and fuzzy relations. J. Intell. Inform. Syst. 29(2), 185–210 (2007)CrossRefMATH Bosc, P., Pivert, O., Rocacher, D.: About quotient and division of crisp and fuzzy relations. J. Intell. Inform. Syst. 29(2), 185–210 (2007)CrossRefMATH
10.
go back to reference Bosc, P., Pivert, O., Rocacher, D.: A propos de la sémantique de divers opérateurs de division de relations. In: INFORSID (2006) Bosc, P., Pivert, O., Rocacher, D.: A propos de la sémantique de divers opérateurs de division de relations. In: INFORSID (2006)
11.
go back to reference Bosc, P., Pivert, O., Soufflet, O.: On three classes of division queries involving ordinal preferences. J. Intell. Inform. Syst. 37(3), 315–331 (2011)CrossRefMATH Bosc, P., Pivert, O., Soufflet, O.: On three classes of division queries involving ordinal preferences. J. Intell. Inform. Syst. 37(3), 315–331 (2011)CrossRefMATH
12.
go back to reference Bosc, P., Pivert, O.: On some uses of a stratified divisor in an ordinal framework. In: Kacprzyk, J., Petry, F.E., Yazici, A. (eds.) Uncertainty Approaches for Spatial Data Modeling and Processing. SCI, vol. 271, pp. 133–154. Springer, Heidelberg (2010)CrossRef Bosc, P., Pivert, O.: On some uses of a stratified divisor in an ordinal framework. In: Kacprzyk, J., Petry, F.E., Yazici, A. (eds.) Uncertainty Approaches for Spatial Data Modeling and Processing. SCI, vol. 271, pp. 133–154. Springer, Heidelberg (2010)CrossRef
13.
go back to reference Wu, Y., Liu, G., Liu, Y.: Multi-user preferences based top-k query processing algorithm. In: Tenth International Conference on Computational Intelligence and Security (CIS). IEEE (2014) Wu, Y., Liu, G., Liu, Y.: Multi-user preferences based top-k query processing algorithm. In: Tenth International Conference on Computational Intelligence and Security (CIS). IEEE (2014)
14.
go back to reference Habib, W.M., Mokhtar, H.M., El-Sharkawi, M.: A new approach for scholars matching using universal quantifier queries. In: IEEE World Congress on Services (SERVICES). IEEE (2015) Habib, W.M., Mokhtar, H.M., El-Sharkawi, M.: A new approach for scholars matching using universal quantifier queries. In: IEEE World Congress on Services (SERVICES). IEEE (2015)
Metadata
Title
New Variants of Hash-Division Algorithm for Tolerant and Stratified Division
Authors
Noussaiba Benadjmi
Khaled Walid Hidouci
Copyright Year
2017
DOI
https://doi.org/10.1007/978-3-319-59692-1_9

Premium Partner