开发者

How to map relations in large data set "real-life" scenario

For performance related tests, I'm trying to create a large amount of data (250k,500k,1mill records) and insert it into a DB, while emulating a "real-life" scenario.

I was wondering if there were studies/anyone knows how to best emulate a real-life scenario of data-relations. For example, if I had X amount of different classes, how many of them would be referencing other classes.

The only thing I'开发者_运维技巧m not sure about is how to emulate the relations (inheritence,reference, etc).

Thanks in advanced, Ben.


one-to-many relationship is usually implemented by a column on the "many" side, which identifies the "one" side.

many-to-many relationship is usually implemented by a separate table which identifies pairs of parent-child.

Based on your question, you're probably dealing with the latter case.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜