API methods + binary link + M:M tables

[Olivier]

>
> I do not think you need COUNTS table.
>
> I see only reason to have it, if you prepare some DB for CD and you 
> want
> optimize of for speed as much as possible.
>
> If you develop regular db that will change runtime then I think this 
> will
> make things more complex then needed.
>
> No no no.
>
> All should be natural and mirror the real world entities.
>

I believe that I badly expressed myself.

Originally I import in my database the data such which (a sort of array 
for two dimensions) :

City 		 	Surname1 	 Surname2 	 Surname3 	 Surname1522...

PARIS 		 300 	 		220 	 		145
BORDEAUX 	 122 	 		240 			 90
City36600
......

thus 300 persons having the surname1 at Paris.

The data are thus already grouped by surname and city.
It is from these data that I work.
Thus, I have to translate this enormous array into tables.

For example, my application verifies the surnames, the first names and 
the addresses of the directory of the customer.
It compares the surnames of the directory with the surnames of the 
database (it is a database (described higher) which contains all the 
French surnames and which contains for every surname the number of 
times when it is present in every city).
If the surname of the directory is included in the database: OK.
If it is not included, the application indicates that it does not know 
this surname, that there is credibly a spelling mistake.
According to the city, the application proposes a true name which looks 
like the most possible of that of the directory (the one who has a 
spelling mistake).
If there are several surnames looking like that of the directory, the 
application will propose then in the first one, the surname the most 
used in this city, then the following ones, in the order. (used array 
(tables) described higher)

Here we are, for example, to what will be of use this DB.

How to make than without "counts" table ?

olivier
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: text/enriched
Size: 1963 bytes
Desc: not available
Url : http://lists.macserve.net/pipermail/valentina-beta/attachments/20050131/e0dd0422/attachment.bin