Skip to main content

2016 | OriginalPaper | Buchkapitel

PACOKS: Progressive Ant-Colony-Optimization-Based Keyword Search over Relational Databases

verfasst von : Ziyu Lin, Qian Xue, Yongxuan Lai

Erschienen in: Web-Age Information Management

Verlag: Springer International Publishing

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

search-config
loading …

Abstract

Keyword search over relational databases makes it easier to retrieve information from structural data. One solution is to first represent the relational data as a graph, and then find the minimum Steiner tree containing all the keywords by traversing the graph. However, the existing work involves substantial costs even for those based on heuristic algorithms, as the minimum Steiner tree problem is proved to be an NP-hard problem. In order to reduce the response time for a single search to a low level, a progressive ant-colony-optimization-based algorithm, called PACOKS, is proposed here, which achieves the best answer in a step-by-step manner, through the cooperation of large amounts of searches over time, instead of in an one-step manner by a single search. Through this way, the high costs for finding the best answer, are shared among large amounts of searches, so that low cost and fast response time for a single search is achieved. Extensive experimental results based on our prototype show that our method can achieve better performance than those state-of-the-art methods.

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!

Literatur
1.
Zurück zum Zitat Agrawal, S., Chaudhuri, S., Das, G.: DBXplorer: A system for keyword-based search over relational databases. In: Proceedings of ICDE, pp. 5–16 (2002) Agrawal, S., Chaudhuri, S., Das, G.: DBXplorer: A system for keyword-based search over relational databases. In: Proceedings of ICDE, pp. 5–16 (2002)
2.
Zurück zum Zitat Bhalotia, G., Hulgeri, A., Nakhe, C., Chakrabarti, S., Sudarshan, S.: Keyword searching and browsing in databases using banks. In: Proceedings of ICDE, pp. 431–440 (2002) Bhalotia, G., Hulgeri, A., Nakhe, C., Chakrabarti, S., Sudarshan, S.: Keyword searching and browsing in databases using banks. In: Proceedings of ICDE, pp. 431–440 (2002)
3.
Zurück zum Zitat Djebali, S., Raimbault, T.: SimplePARQL: a new approach using keywords over SPARQL to query the web of data. In: Proceedings of the 11th International Conference on Semantic Systems, SEMANTICS 2015, Vienna, Austria, 15–17 September 2015, pp. 188–191 (2015) Djebali, S., Raimbault, T.: SimplePARQL: a new approach using keywords over SPARQL to query the web of data. In: Proceedings of the 11th International Conference on Semantic Systems, SEMANTICS 2015, Vienna, Austria, 15–17 September 2015, pp. 188–191 (2015)
4.
Zurück zum Zitat Gutjahr, W.J.: A graph-based ant system and its convergence. Future Gener. Comput. Syst. 16(1), 873–888 (2000)CrossRef Gutjahr, W.J.: A graph-based ant system and its convergence. Future Gener. Comput. Syst. 16(1), 873–888 (2000)CrossRef
5.
Zurück zum Zitat He, H., Wang, H., Yang, J., Yu, P.S.: BLINKS: ranked keyword searches on graphs. In: Proceedings of SIGMOD, pp. 305–316 (2007) He, H., Wang, H., Yang, J., Yu, P.S.: BLINKS: ranked keyword searches on graphs. In: Proceedings of SIGMOD, pp. 305–316 (2007)
6.
Zurück zum Zitat Hristidis, V., Papakonstantinou, Y.: DISCOVER: Keyword search in relationaldatabases. In: Proceedings of VLDB, pp. 670–681 (2002) Hristidis, V., Papakonstantinou, Y.: DISCOVER: Keyword search in relationaldatabases. In: Proceedings of VLDB, pp. 670–681 (2002)
7.
Zurück zum Zitat Kacholia, V., Pandit, S., Chakrabarti, S., Sudarshan, S., Desai, R., Karambelkar, H.: Bidirectional expansion for keyword search on graph databases. In: Proceedings of VLDB, pp. 505–516 (2005) Kacholia, V., Pandit, S., Chakrabarti, S., Sudarshan, S., Desai, R., Karambelkar, H.: Bidirectional expansion for keyword search on graph databases. In: Proceedings of VLDB, pp. 505–516 (2005)
8.
Zurück zum Zitat Kim, I.-J., Whang, K.-Y., Kwon, H.-Y.: SRT-rank: Ranking keyword query results in relational databases using the strongly related tree. IEICE Trans. Inf. Syst. 97(D(9)), 2398–2414 (2014)CrossRef Kim, I.-J., Whang, K.-Y., Kwon, H.-Y.: SRT-rank: Ranking keyword query results in relational databases using the strongly related tree. IEICE Trans. Inf. Syst. 97(D(9)), 2398–2414 (2014)CrossRef
9.
Zurück zum Zitat Li, G., Ooi, B.C., Feng, J., Wang, J., Zhou, L.: EASE: an effective 3-in-1 keyword search method for unstructured, semi-structured and structured data. In: Proceedings of SIGMOD, pp. 903–914 (2008) Li, G., Ooi, B.C., Feng, J., Wang, J., Zhou, L.: EASE: an effective 3-in-1 keyword search method for unstructured, semi-structured and structured data. In: Proceedings of SIGMOD, pp. 903–914 (2008)
10.
Zurück zum Zitat Liu, F., Yu, C., Meng, W., Chowdhury, A.: Effective keyword search in relational databases. In: Proceedings of SIGMOD, pp. 563–574 (2006) Liu, F., Yu, C., Meng, W., Chowdhury, A.: Effective keyword search in relational databases. In: Proceedings of SIGMOD, pp. 563–574 (2006)
11.
Zurück zum Zitat Luo, Y., Wang, W., Lin, X., Zhou, X., Wang, J., Li, K.: Spark2: Top-k keyword query in relational databases. TKDE 23(12), 1763–1780 (2011) Luo, Y., Wang, W., Lin, X., Zhou, X., Wang, J., Li, K.: Spark2: Top-k keyword query in relational databases. TKDE 23(12), 1763–1780 (2011)
12.
Zurück zum Zitat Markowetz, A., Yang, Y., Papadias, D.: Keyword search on relational data streams. In: Proceedings of SIGMOD, pp. 605–616 (2007) Markowetz, A., Yang, Y., Papadias, D.: Keyword search on relational data streams. In: Proceedings of SIGMOD, pp. 605–616 (2007)
13.
Zurück zum Zitat Park, C.-S., Lim, S.: Effective keyword query processing with an extended answer structure in large graph databases. IJWIS 10(1), 65–84 (2014) Park, C.-S., Lim, S.: Effective keyword query processing with an extended answer structure in large graph databases. IJWIS 10(1), 65–84 (2014)
14.
Zurück zum Zitat Tao, Y., Yu, J.X.: Finding frequent co-occurring terms in relational keyword search. In: Proceedings of EDBT, pp. 839–850 (2009) Tao, Y., Yu, J.X.: Finding frequent co-occurring terms in relational keyword search. In: Proceedings of EDBT, pp. 839–850 (2009)
15.
Zurück zum Zitat Yang, W., Guo, T.: An ant colony optimization algorithm for the minimum steiner tree problem and its convergence proof. Acta Math. Appl. Sinica 29(2), 352–361 (2006)MathSciNet Yang, W., Guo, T.: An ant colony optimization algorithm for the minimum steiner tree problem and its convergence proof. Acta Math. Appl. Sinica 29(2), 352–361 (2006)MathSciNet
16.
Zurück zum Zitat Zhou, J., Liu, Y., Yu, Z.: Improving the effectiveness of keyword search in databases using query logs. In: Li, J., Sun, Y., Yu, X., Sun, Y., Dong, X.L., Dong, X.L. (eds.) WAIM 2015. LNCS, vol. 9098, pp. 193–206. Springer, Heidelberg (2015). doi:10.1007/978-3-319-21042-1_16 CrossRef Zhou, J., Liu, Y., Yu, Z.: Improving the effectiveness of keyword search in databases using query logs. In: Li, J., Sun, Y., Yu, X., Sun, Y., Dong, X.L., Dong, X.L. (eds.) WAIM 2015. LNCS, vol. 9098, pp. 193–206. Springer, Heidelberg (2015). doi:10.​1007/​978-3-319-21042-1_​16 CrossRef
Metadaten
Titel
PACOKS: Progressive Ant-Colony-Optimization-Based Keyword Search over Relational Databases
verfasst von
Ziyu Lin
Qian Xue
Yongxuan Lai
Copyright-Jahr
2016
DOI
https://doi.org/10.1007/978-3-319-39958-4_9

Neuer Inhalt