1 Billion 11 Byte Words... Need to Check Uniqueness with Oracle
Date: Fri, 08 Feb 2002 15:44:31 GMT
Message-ID: <v3s76uciii2742r4sgm19gruvtn5bcja9p_at_4ax.com>
I have a group that is currently using Oracle but is considering
moving to SQL Server to save some money. One of the business cases
they're working with is the testing of 1 billion 11 character words
for uniqueness. Apparently they've been sold on the idea that SQL
Server will rock their monkey.
I tend to disagree and believe that Oracle will handle this task much
more elegantly.
So that I can give this group some guidance: How would you go about
testing uniqueness on 1 Billion 11 character words using oracle?
Ideas to get you started:
1) Write small clients to do database inserts and distribute them
2) Install Oracle on 10 boxes and split the 1 Billion words into 10 segments. Insert the numbers into the database and check for uniqueness. This won't prove uniqueness across the entire set so you'd then have to bulk insert or import all data from each Oracle database into one master database that checks uniqueness. Maybe this would be faster than checking uniqueness on every insert.
3) ??? Any other ideas? Received on Fri Feb 08 2002 - 16:44:31 CET