Oracle representing hierarchy of data combinations -

i'm having oracle volume of data issue, think being caused data representation problem. have hierarchy made 7 different lists, , need store unique potential combinations of these elements. need store potential combinations, because need store additional information along them.

historically, we've been managing 4 lists, came few thousand combinations. fine, requirements have changed wont do, , running 7 lists. in real environment, lists store between 20 , 200 items. total number of combinations now, incredibly, 350 billion.

as example of we're trying represent this, have selection of lists like:

colours:red, green, blue

shapes: circle, square, triangle

flavours: peach, banana, raspberry

these stored separate tables in oracle colours, shapes, flavours, etc, , we'd doing multiplying them (via cartesian join) exploded table: we're storing in oracle @ moment.

colour    shape   flavour    data_1 data_2 red       circle  peach      -- these hold additional information red       circle  banana red       circle  raspberry red       square  peach red       square  banana ... 

and on.

we've found can't store billions of records within oracle table , have operation performed upon them in timely fashion. i've tried think of different ways store information brain keeps jamming on number of combinations. there can store records differently? bearing in mind they're unique combinations, , need store data along them.

thanks help!

what storing data non-relational database?

i recommend mongodb or hypertable.