I've a sports application where the captain can register his team for a tournament. There can be multiple tournaments in an year and each tournament requires registration. Now, I want to support the below in registration process
- If a Player has already participated in the previous tournament then the app need to reuse the existing details rather forcing the registration.
- Need to make sure that a Player is not playing for two teams.
I am wondering how can we best implement the name match feature. It it makes any difference, most of the names are from Indian origin.
I am using Neo4j as the data store.
You use db4o and use unickey feature for field name in player class.
Tornament class have a (Set) field with players name (and at least a reference indexed name, date name may also be indexed).
Then with two fields : the last tournament and the registration for the next one you have for one player only one tournament.
Using SODA query you can select player with last referenced tournament, and register the others