Approximate String Matching in RDBMS
From: PRAGMATECH <walid.saba_at_gmail.com>
Date: Wed, 19 Jan 2011 07:07:21 -0800 (PST)
Message-ID: <4888ed0c-23ea-412b-90d0-dc3cffc06be9_at_v12g2000vbx.googlegroups.com>
Dear All,
Date: Wed, 19 Jan 2011 07:07:21 -0800 (PST)
Message-ID: <4888ed0c-23ea-412b-90d0-dc3cffc06be9_at_v12g2000vbx.googlegroups.com>
Dear All,
Does someone know what is the best theoretical complexity in the
literature, as O(f(N)), where N is the number of rows in a table t
and
where approximate string matching on some field in t is to be done.
I am not asking about the complexity of a single approximate match
between 2 strings with lengths n and m, but on the cost of the lookup
over the entire table.
In other words, what is the cost of the following, in terms of N, the
number of rows in t:
SELECT * FROM t WHERE APPROXIMATELY_EQUAL(t.a, threshold)
I thank you in advance for any feedback.
Best Regards,
Walid Saba
Received on Wed Jan 19 2011 - 16:07:21 CET