开发者

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

开发者 https://www.devze.com 2023-04-09 04:15 出处:网络
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.

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

精彩评论

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