A novel keyword search paradigm in relational databases: Object summaries

Data and Knowledge Engineering

Volumn 70, Issue 2, 2011, Pages 208-229

  Fakas, Georgios John ^a,b  

^a MANCHESTER METROPOLITAN UNIVERSITY   (United Kingdom)

^b NONE   (United Kingdom)

Author keywords

Data extraction; Information retrieval; Keyword search; Relational databases

Indexed keywords

DATA EXTRACTION; DATA SUBJECTS; EXPERIMENTAL EVALUATION; F-SCORE; KEYWORD SEARCH; RELATIONAL DATABASE;

DATA MINING; INFORMATION RETRIEVAL; SEARCH ENGINES;

DATABASE SYSTEMS;

EID: 78650812599     PISSN: 0169023X     EISSN: None     Source Type: Journal    
DOI: 10.1016/j.datak.2010.11.003     Document Type: Article

References (46)

1. B. Aditya, G. Bhalotia, S. Chakrabarti, A. Hulgeri, C. Nakhe, Parag, and S. Sudarshan BANKS: browsing and keyword searching in relational databases Proc. Very Large Data Bases Conf. 2002
2. G. Bhalotia, A. Hulgeri, C. Nakhe, S. Chakrabarti, and S. Sudarshan Keyword searching and browsing in databases using BANKS Proc. Very Large Data Bases Conf. 2002
3. V. Hristidis, and Y. Papakonstantinou DISCOVER: keyword search in relational databases Proc. Very Large Data Bases Conf. 2002
4. Microsoft. Northwind Database, 2004. http://www.microsoft.com/downloads/ details.aspx?familyid=06616212-0356-46a0-8da2-eebc53a68034&displaylang=en.
5. G. Fakas Automated generation of object summaries from relational databases: a novel keyword searching paradigm Proc. ICDE Workshop on Ranking in Databases (DBRank'08) 2008
6. Oracle. http://technet.oracle.com/products/text/content.html. 2006.
7. IBM. http://www.ibm.com/software/data/db2/extenders/textinformation/ index.html. 2006.
8. Microsoft. Microsoft SQL Server 2000 Full-Text Search Deployment white paper (Q323739), 2004. http://support.microsoft.com/kb/323739.
9. MySQL. Full-Text Search Functions, 2010. http://dev.mysql.com/doc/refman/ 5.5/en/fulltext-search.html.
10. S. Agrawal, S. Chaudhuri, and G. Das DBXplorer: a system for keyword-based search over relational databases Proc. ICDE Conf. 2002
11. N. L. Sarda, and A. Jain, Mragyati, A system for keyword-based searching in databases, Technical report, computing research repository (CoRR) cs.DB/0110052, 2001.
12. A. Markowetz, Y. Yang, and D. Papadias Keyword search over relational tables and streams TODS 34 3 2009
13. A. Markowetz, Y. Yang, and D. Papadias Reachability indexes for relational keyword search Proc. ICDE 2009
14. V. Hristidis, L. Gravano, and Y. Papakonstantinou Efficient IR-style keyword search over relational databases Proc. Very Large Data Bases Conf. 2003
15. F. Liu, C. Yu, W. Meng, and A. Chowdhury Effective keyword search in relational databases Proc. ACM SIGMOD Conf. 2006
16. Y. Luo, X. Lin, W. Wang, and X. Zhou SPARK: top-k keyword query in relational databases Proc. ACM SIGMOD Conf. 2007
17. Q-H. Vu, B-C. Ooi, D. Papadias, A. Tung, A graph method for keyword-based selection of the top-K databases, Proc. ACM SIGMOD Conf., 2008.
18. B. Yu, G. Li, K. Sollins, and A.K.H. Tung Effective keyword-based selection of relational databases Proc. ACM SIGMOD 2007
19. A. Kashyap, V. Hristidis, M. Petropoulos, and S. Tavoulari Effective navigation of query results based on concept hierarchies IEEE TKDE 2010
20. G. Weikum, G. Kasneci, M. Ramanath, and F. Suchanek Database and information-retrieval methods for knowledge discovery Commun. ACM 52 4 2009
21. E. Chu, Baid A., X. Chai, A.H. Doan, and J.F. Naughton Combining keyword search and forms for ad hoc querying of databases Proc. ACM SIGMOD Conf. 2009
22. G. Li, J. Feng, J. Wang, L. Zhou, An effective and versatile keyword search engine on heterogenous data sources, PVLDB, 2008.
23. X. Yang, B. Wang, G. Wang, and G. Yu Enhancing Keyword Search in Relational Databases Using Nearly Duplicate Records IEEE Data Eng. Bull. 33 1 2010
24. L. Qin, J. Xu Yu, and L. Chang Keyword search in databases: the power of RDBMS Proc. ACM SIGMOD Conf. 2009
25. R. Goldman, N. Shivakumar, S. Venkatasubramanian, and H. Garcia-Molina Proximity search in databases Proc. Very Large Data Bases Conf. 1998
26. R. Guha, R. McCool, E. Miller, Semantic search, Proc. WWW Conf., 2003.
27. G. Koutrika, A. Simitsis, and Y. Ioannidis Précis: the essence of a query answer Proc. ICDE Conf. 2006
28. A. Simitsis, G. Koutrika, and Y. Ioannidis Generalized précis queries for logical database subset creation Proc. ICDE Conf. 2007
29. A. Simitsis, G. Koutrika, and Y. Ioannidis Précis: from unstructured keywords as queries to structured databases as answers VLDB J. 17 1 2008
30. S. Brin, and L. Page The anatomy of a large-scale hypertextual Web search engine WWW Conference 1998
31. A. Balmin, V. Hristidis, and Y. Papakonstantinou Objectrank: authority-based keyword search in databases Proc. Very Large Data Bases Conf. 2004
32. R. Varadarajan, V. Hristidis, and L. Raschid Explaining and reformulating authority flow queries Proc. ICDE Conf. 2008
33. G. Fakas, and Z. Cai Ranking of object summaries Proc. ICDE Workshop on Ranking in Databases (DBRank'09) 2009
34. S. Castano, V.D. Antonellis, M. Fugini, and B. Pernici Conceptual schema analysis: techniques and applications TODS 23 3 1998
35. D. Moody, A. Filtman, A methodology for clustering entity relationship models-a human information processing approach, In ER, 1999.
36. C. Yu, and H.V. Jagadish Schema summarization Proc. Very Large Data Bases Conf. 2006
37. X. Yang, C.M. Procopiuc, and D. Srivastava Summarizing relational databases PVLDB 2 1 2009 634 645
38. G. Das, V. Hristidis, N. Kapoor, and S. Sudarshan Ordering the attributes of query results Proc. ACM SIGMOD Conf. 2006
39. N. Choi, I.Y. Song, and H. Han A survey on ontology mapping SIGMOD Rec. 35 3 2006 34 41
40. J. Madhavan, P.A. Bernstein, and E. Rahm Generic schema matching with cupid Proc. Very Large Data Bases Conf. 2001
41. E. Rahm, and P.A. Bernstein A survey of approaches to automatic schema matching VLDB J. 10 4 2001 334 350
42. TPC, 2005. http://www.tpc.org/tpch/default.asp.
43. WordNet, A Lexical Database for the English Language, 2010. http://wordnet.princeton.edu/.
44. DBLP, 2010. http://www.informatik.uni-trier.de/ley/db/.
45. Internet Movie Database, 2010. www.imdb.com.
46. S. Polyviou, G. Samaras, and P. Evripidou A relationally complete visual query language for heterogeneous data sources and pervasive querying Proc. ICDE Conf. 2005