About wrong winner predicted in the model

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I am using data mining of SQL server 2005 for one sport as basketball. I have thousands of match records of this sport. All the data points are in one table. In each record the most important columns are team1 and team2 for the two teams, and winner that tell us who win this match. There are several other columns that are about these two teams. I set up models using Neural Network and Decision Trees. After process the models, I use them to tell me who the winner will be. Though most results are one of team1 and team2, there do be a few results that are not team1 or team2. For example, for one match between England and India. The model will predict winner will be Japan. Is it an error of my work? Or this is normal for this kind of prediction?
Another problem is how I can tell the computer some columns are for team1, and some other columns are for team2, or just let the computer do the model process.
Thanks a lot for any advice.

Tong
.

Relevant Pages

  • Re: About wrong winner predicted in the model
    ... India played 20 games with Japan and 5 games with all other countries. ... notices that Team1 is India and predicts, most likely, Japan is the winner ... In each record the most important columns are team1 and team2 for ... and winner that tell us who win this match. ...
    (microsoft.public.sqlserver.datamining)
  • Re: About wrong winner predicted in the model
    ... India played 20 games with Japan and 5 games with all other countries. ... notices that Team1 is India and predicts, most likely, Japan is the winner ... In each record the most important columns are team1 and team2 for ... and winner that tell us who win this match. ...
    (microsoft.public.sqlserver.datamining)
  • Re: Bidirectional Binary Self-Joins
    ... constraints. ... Unfortunately we are left with that same issue - the choice of team1 ... and team2 is arbitrary, and as David or Paul pointed out, it means I ... I would actually add a surrogate identifier for the game if I had to ...
    (comp.databases.theory)