[dba-Tech] Questions about 2 Unusual Databases

Stuart McLachlan stuart at lexacorp.com.pg
Thu Oct 28 00:26:07 CDT 2004


On 27 Oct 2004 at 23:28, Drew Wutka wrote:

> Every 'setting' of the board would be represented by those 32 characters.
> So if there are two times where someone is in the same position as another
> game, the strings will match.  To determine the moves made, simply put a
> Game ID, and a Move Number field in.  It wouldn't be that difficult to whip
> up some code to determine what was moved between the two strings.
> 
> If you index the string field, you can immediately determine what other
> games had the peices in the same position, by doing a simple query based on
> that particular string.
> 

Not only that but you can use Hamming Distance functions on the strings to 
locate similar board layouts.



-- 
Stuart





More information about the dba-Tech mailing list