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/