In order to test graph structures, I needed a large set of random data. In some ways, this data will resemble the IMDB database I will include later in this chapter, but to make it one, controllable in size and two, random, I created this random dataset. I loaded a set of values for an account into a table and a set of interests. I wanted then to be able to load a set of random data into edge, related one account to another (one follows the other), and then an account to a random set of interests.
In this article, I will discuss a few techniques I used, starting with the simplest method using ordering by
NEWID(), then using
RAND()to allow the code to generate a fixed set of data.
There’s a lot of code needed to do it but if it’s something you’ve got to do, that’s the cost of doing business.