Ryan Chan wrote:
> According to this document:
> http://dev.mysql.com/doc/refman/5.0/en/charset-unicode.html
>
> It said MySQL support UTF-8 using one to three bytes per character.
>
> But I have created a test table:
>
> -- create table test ( c char(5) ) default charset =utf8;
>
> >From the table
Geert-Jan Brits wrote:
> Perhaps you could give us a (generalized) description of your use-case, so
> we can better grasp what you want to achieve, and how you want to use it.
> i.e: since I can't imagine/ envison a real 'eucledian distance' over 96
> dimensions I bet you're talking a generalized d
Hello Chris,
The use case I'
m talking about is actually a typical usecase for GIS applications: give
me the x closest points to this one. E.g: give me the 10 points closest
to (1,2,79) or in my case: give me the 100 points closest to
(x1,x96). A query like yours might be possible and might be
ing to define a
distance measure based on each individual point. I'm not sure this is
feasable.
In general: KD-trees are quite good tools to deal with such large
dimensional spaces, but I see no possibility to use them in mysql,
Wkr,
>
>
> On Tue, Mar 30, 2010 at 11:39 AM, Werner Van
Geert-Jan Brits wrote:
> You're most likely talking about something like consine-similarity on
> N-dimensional vectors.
> http://en.wikipedia.org/wiki/Cosine_similarity
> http://stackoverflow.com/search?q=cosine+similarity
>
Cool links ! Although it is not why I need it for. I'm really talking
abou
Hello,
I have been pondering this for a while, but never really looked deeply
into the problem.
I have 96 dimensional points and I would like to pose queries such as:
'give me all points that are within such a radius of this one'. The gis
extensions to mysql might support such type of query. The
Sebastian Mendel wrote:
Werner Van Belle schrieb:
Hello,
You might find the following challenging -or- you might now the
answer :-)
Table Q
Subtable, field, val, ID
A 1 a42
A 2 b42
B 1 a78
B 2 t78
B 3 o78
C
the return value
Subtable, field, val, ID
A 1 a42
A 2 b42
C 1 u23
Is there anybody that bumped into a similar query and was able to solve
it satisfactory ?
--
Dr. Werner Van Belle
http://werner.sigtrans.org/
--
MySQL General Mailing List
For
VARCHAR(128));
LOAD DATA LOCAL INFILE 'imports/ensgdescriptions.csv'
INTO TABLE EnsgDescriptions;
Wkr (don't write this in your script :-),
--
Dr. Werner Van Belle
http://werner.sigtrans.org/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsub
been nice if I could just use various databases through the same local
server.
Are there any solutions for this kind of problem ?
Werner,-
--
Dr. Werner Van Belle
http://werner.sigtrans.org/
signature.asc
Description: This is a digitally signed message part.
10 matches
Mail list logo