awinkler@zodiac.ADS.COM (Adam Winkler) (09/01/89)
Looking for a database that can handle 2200 Megbytes of data in the format after this note. The would like to run off either Mac, 386 PC, or Sun. The reporting and the user interface does not have to be complex. About 400k is going to be added to the database per day (so database should be able to import and export in ASCII). If you have any suggestions about what database will work, please send me information (including phone numbers and your experience) directly to me as I am not on the net. Gary Kremen (89.kremen@gsb-how.stanford.edu) transaction = RECORD pid_number : STRING[6]; transaction_type : CHAR; number_of_transactions : STING[3] END; number of transactions = 4500 number of stores = 4000 transactions : transaction monthly_update : ARRAY[1..number_of_transactions] of transactions; one_store_history : array[1..12] of monthly_update; all_data : array [1..number_of_stores] of one_store_history end; Estimate of each record size in the future is 9-11 characters. Estimated number of records will be 4,500 (average). Estimated number of stores is 4,000. 6 - 12 Months historical might be needed. Estimate of storage requirements of entire data base is 10 * 4k * 4.5K * 12=