Upgrade to Chess.com Premium!

The Use of Databases for Chess Research


  • 17 months ago · Quote · #1

    MyCowsCanFly

    What database and database tools can I use to answer questions like the following:

    What is the win/loss/draw result of games using:

    • Ruy Lopez Exchange Variation – Lasker Variation (1.e4 e5 2.Nf3 Nc6 3.Bb5 a6 4.Bxc6 dxc6 5.d4 exd4 6.Qxd4 Qxd4 7.Nxd4). (aka Ruy Lopez Exchange Variation - Alekhine Variation.)
    • limited to games longer than 20 moves
    • both players FIDE 2300+
    • games played between 2003-Present

    I use SCID for postmortem but it's unclear if it can do these types of searches. Yes, I probably have too much time on my hands to be asking such a question.

    Thanks!

  • 17 months ago · Quote · #2

    rooperi

    Scid can do all that.

    First,do a position search, then set up the header searh like this:

    (I only get 2 results)

  • 17 months ago · Quote · #3

    MyCowsCanFly

    rooperi, I've noticed your posts on SCID and was hoping you'd respond. How about downloading a database to search, any ideas?

  • 17 months ago · Quote · #4

    fredm73

    You can do that query in SCID.  First, do a search/header on your 4 bullets in some big database.  Mine, of 5M games, returns 337,000 hits. Then, move the hits to a dummy database that you set up. To do that, create a new db in file/new, then open the database switcher window and drag your filtered hits to the dummy db. Then, use the dummy db as a tree (file/open recent base as tree).  Then open the clipbase to make your opening moves.  Doing all that, I get: 76% were draws, of the non-draws, white won 46% of the time.

  • 17 months ago · Quote · #5

    fredm73

    Maybe I will beat rooperi this time: database to download:

    http://icofy-blog.de/

  • 17 months ago · Quote · #6

    rooperi

    There are some options:

    Icofy base: http://sourceforge.net/projects/icofybase/

    Pros: Large, around 4,5 million games

    Cons: Very little information, often does not show much more than player names and dates. No rating, info, noevent info etc etc...

    PGNMENTOR: http://www.pgnmentor.com/files.html

    Pros: Much more information

    Cons: Smaller, around 1,5 million games

    Also, it's not 1 big download, I downloaded a few dozen files I had to join to make 1 large db. (although, this might also be a plus, because files are by opening, so it's possible to work with smaller files which makes it faster)

    Overall, the pgnmentor is better quality, but more work to set up

  • 17 months ago · Quote · #7

    MyCowsCanFly

    It doesn't sound like icofy base has enough information to answer questions like the one I posed. Is that correct?

    Does PGMENTOR have enough information? Is that what you used in your illustration above?

  • 17 months ago · Quote · #8

    rooperi

    pgn mentor looks like this:

    And yes, i think the information is more complete

  • 17 months ago · Quote · #9

    transpo

    Post

  • 17 months ago · Quote · #10

    MyCowsCanFly

    Thanks rooperi. Thanks fredm73.

  • 17 months ago · Quote · #11

    DrFrank124c

    May I recommend a good free online database? http://www.365chess.com

  • 17 months ago · Quote · #12

    MyCowsCanFly

    frank124c wrote:

    May I recommend a good free online database? http://www.365chess.com

    I hadn't noticed the "advanced" search options before. It might require some hand culling. I can't tell how much until I join. Ten bucks seems more than reasonable. Thanks for the suggestion.

  • 17 months ago · Quote · #13

    MyCowsCanFly

    I posted the following in another thread. I just came across a relevant book that I am enjoying: Smith, Robin (2004), Modern Chess Analysis. It's scope includes the use of databases.

    It's amusing to think one of the uses of computer technology in chess is to research the use of computer technology in chess."

    If anyone else is interested in such things, here's a link to a review:

    http://www.goodreads.com/book/show/2564306-modern-chess-analysis


    [Edit: I changed the title of the forum from one that asked for recommendations for database tools. 12-15-12]


  • 15 months ago · Quote · #14

    matematicaxadre

    quem fez esta pergunta idiota?

  • 15 months ago · Quote · #15

    MyCowsCanFly

    Ouch


Back to Top

Post your reply: