IEEE Data(base) Engineering Bulletin · 2010 · 37 citations · 19 references
ComputingComputer ScienceData MiningDatabasesInformation RetrievalQuery ProcessingRelational AlgebraSemantic SearchString AlgorithmsStructured Query LanguageText Similarity AnalysisData FormattingExact Match RetrievalIndex StructuresInverted Index StructuresQuery AnsweringSimilarity ComputationSimilarity SearchSimilarity-based Querying
Consider a universe of tokens, each of which is associated with a weight, and a database consisting of strings that can be represented as subsets of these tokens. Given a query string, also represented as a set of tokens, a weighted string similarity query identifies all strings in the database whose similarity to the query is larger than a user specified threshold. Weighted string similarity queries are useful in applications like data cleaning and integration for finding approximate matches in the presence of typographical mistakes, multiple formatting conventions, data transformation errors, etc. We show that this problem has semantic properties that can be exploited to design index structures that support very efficient algorithms for query answering.
19
Optimal aggregation algorithms for middleware
Ronald Fagin, Amnon Lotem, Moni Naor · 2001 · 1.1K citations
Scaling up all pairs similarity search
Roberto J. Bayardo, Yiming Ma, Ramakrishnan Srikant · 2007 · 677 citations
Michael Cafarella, Alon Halevy, Daisy Zhe Wang et al. · Proceedings of the VLDB Endowment · 2008 · 634 citations
Approximate String Joins in a Database (Almost) for Free
Luis Gravano, Panagiotis G. Ipeirotis, H. V. Jagadish et al. · 2001 · 510 citations