April 01, 2004
SQL, Data Mining, & Genetic Programming
Apr04: SQL, Data Mining, & Genetic Programming
(a)
create table t_profile_column_values
(id int not null,
test int NULL,
parent1 int NULL,
parent2 int NULL,
c_name varchar(30) not null,
operator char(2) not null, /* '==' or '!=' */
c_value varchar(255) not null
)
(b)
SELECT P.ProfileID, M.TargetValue, count(*)
FROM t_mine_relations M, profiles P
WHERE {profile P matches M}
GROUP BY P.ProfileID, M.TargetValue
Example 1: (a) SQL WHERE clause represented as a profile; (b) potential WHERE clauses within the current GP generation can be evaluated with a single SQL statement.
Previous Page |
1
|
2
|
3
|
4
|
5
|
6
|
7
|
8
Next Page
more
