SupportDB

Mission: Reduce duplicated database effort between CDF and D0

So far, the following topics have been identified:

• Test Lob storage vs. File storage of binary data
• Replication
• Data distribution to collaborations via lightweight databases

Lob vs File Storage Tests

• Initial numbers for Blobs

 KILOBYTES       TIME (sec)
----------    ----------
        10    .247757003
        20    .380939007
        30    .72635603
        40    .441902995
        50    .496659011
        60    .491418004
        70    .649249017
        80    .642412007
        90   1.13299406
       100    .815425992
       200   1.457937
       300   2.53635693
       400   3.1855619
       500   3.7770431
       600   5.69169092
       700   6.008955
       800   6.9280591
       900   7.81076813
      1000   9.11369991
      2000  17.8596878
      3000  26.4882641
      4000  36.0399399
      5000  42.6421738
      6000  52.4785042
      7000  67.4935532
      8000  72.8273773
      9000  91.1581192
     10000 105.587097
     20000 252.003464
     30000 309.399109
     40000 432.378265
     50000 600.050354
     60000 780.590454
     70000 853.705872
     80000 972.984924

Replication Testing

• Waiting on disk installation

Lightweight client data distribution

• msql, mySql have been installed on fncduh
• data transfer from msql to oracle very straightforward
• utilities to query, select, and distribute data envisioned.