16 Oct
2009
16 Oct
'09
7:55 p.m.
On 10/14/2009 01:52 PM, EBIHARA, Yuichiro wrote:
Guillaume, Ludovic,
Thank you for your quick responses and kind advices.
What I'm planning is a bibliographical database system.
Briefly speaking, the database will finally have 15,000,000+
bibliographical records and 2,000,000+ author records. Both of them
have small number of fields (at most 10?) and one long text field that
users can freely edit.
Since they have N:N relations each other, based on relational model
design, the table to store the relations can also become large.
One possible issue I can see is the fact that each entity uses a 64bit
hash as its identifier, which can cause collisions. Normally that rarely
happens, but as the number of entities increases, so does the chance of
it happening.
This means that some pairs of document names could not be used at the
same time, so you'll have to rename one of them.
--
Sergiu Dumitriu
http://purl.org/net/sergiu/