Skip to main content

2017 | OriginalPaper | Buchkapitel

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

verfasst von : Noussaiba Benadjmi, Khaled Walid Hidouci

Erschienen in: Flexible Query Answering Systems

Verlag: Springer International Publishing

Aktivieren Sie unsere intelligente Suche, um passende Fachinhalte oder Patente zu finden.

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.

Sie haben noch keine Lizenz? Dann Informieren Sie sich jetzt über unsere Produkte:

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!

Fußnoten
1
In the literature, up to now, the largest dividend used never exceed 30000 tuples.
 
Literatur
1.
Zurück zum Zitat 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.
Zurück zum Zitat 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.
Zurück zum Zitat 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.
Zurück zum Zitat 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.
Zurück zum Zitat Pigozzi, G., Tsoukiàs, A., Viappiani, P.: Preferences in artificial intelligence. Ann. Math. Artif. Intell. 77(3–4), 361 (2016)MathSciNetCrossRefMATH Pigozzi, G., Tsoukiàs, A., Viappiani, P.: Preferences in artificial intelligence. Ann. Math. Artif. Intell. 77(3–4), 361 (2016)MathSciNetCrossRefMATH
6.
Zurück zum Zitat 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.
Zurück zum Zitat 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.
Zurück zum Zitat 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.
Zurück zum Zitat 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.
Zurück zum Zitat 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.
Zurück zum Zitat 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.
Zurück zum Zitat 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.
Zurück zum Zitat 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.
Zurück zum Zitat 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)
Metadaten
Titel
New Variants of Hash-Division Algorithm for Tolerant and Stratified Division
verfasst von
Noussaiba Benadjmi
Khaled Walid Hidouci
Copyright-Jahr
2017
DOI
https://doi.org/10.1007/978-3-319-59692-1_9

Premium Partner