Computer Chess Club Archives


Search

Terms

Messages

Subject: Re: SQL for Dann

Author: Dann Corbit

Date: 12:04:22 03/06/06

Go up one level in this thread


On March 06, 2006 at 01:46:49, Mark Boylan wrote:

>Hi Dann,
>
>Sorry I didn't do this earlier. It was a busy weekend.
>
>Anyway, I wrote a SQL script for an opening book database similar to the one you
>showed me on Friday.
>
>I added a structure where you can store any number of engine configuration
>parameters. I also made an abstraction called analyst with human_analyst and
>automated_analyst subtypes. This let me keep all of the common opinion &
>evaluation in one place. But I kept the opinion & evaluation tables to hold the
>information that the two don't have in common. Also, by adding human_analyst, I
>no longer make the assumption that the book author is the analyst. It also makes
>it easy for book authors to include analyses from other sources, like engines.
>
>Please let me know what you think.
>
>
>http://www.markboylan.com/openingbook.pdf
>
>http://www.markboylan.com/openingbook.sql

It looks like parts of a several different chess SQL projects that I was working
on.

I also have this one for modeling games:
Model:
http://cap.connx.com/database/CHESS2.ER1
SQL:
http://cap.connx.com/database/chess.sql

And this for modeling Chess Engine parameters:
Model image:
http://cap.connx.com/chess-engines/new-approach/chess.jpg
MS-Access Implementation:
http://cap.connx.com/chess-engines/new-approach/chess.mdb

And the afore-mentioned opening book:
Model:
http://cap.connx.com/OPENINGBOOK.ER1
SQL:
http://cap.connx.com/openingbook.sql


Maybe what is really wanted is a SQL model for the whole ball of wax.





This page took 0 seconds to execute

Last modified: Thu, 15 Apr 21 08:11:13 -0700

Current Computer Chess Club Forums at Talkchess. This site by Sean Mintz.