MELVYL IAC DATABASES TELNET STATISTICS
               Time period: 03/01/00 through 03/31/00

1.0  SUMMARY STATISTICS
_______________________

1.1  Total sessions:
____________________

Location             Library              Remote               Total
________             _______              ______               _____
Berkeley               1,915               2,575               4,490
Davis                  1,899                  83               1,982
Irvine                 2,257                   0               2,257
Los Angeles              196               1,342               1,538
Riverside              1,367                 170               1,537
San Diego                287                 252                 539
San Francisco            352                   0                 352
Santa Barbara            753                 499               1,252
Santa Cruz             1,459                 236               1,695
LBL                        0                  98                  98
LLL                        0                  22                  22
Los Alamos               n/a                   6                   6
Other - UC                63                 407                 470
Stanford                                                         413
Other-Network UC         n/a                 990                 990
                     _______              ______               _____
                      10,548               6,680              17,641
Per hour usage:
          Time         Sessions            Finds      Records Displayed
    __________       __________       __________      _________________
    12-2  a.m.              241              955                 11,534
     2-4  a.m.               73              330                  5,460
     4-6  a.m.               65              155                  2,149
     6-8  a.m.              207              563                  8,131
     8-10 a.m.            1,300            3,717                 39,502
    10-12 a.m.            2,716            7,999                 80,093
    12-2  p.m.            3,251           10,673                105,591
     2-4  p.m.            3,649           11,364                127,549
     4-6  p.m.            2,760            9,387                107,948
     6-8  p.m.            1,539            5,510                 55,382
     8-10 p.m.            1,166            4,716                 55,189
    10-12 p.m.              674            2,684                 33,144
    __________       __________       __________      _________________
        Total:           17,641           58,053                631,672

1.2  FIND commands
__________________

Number of FIND commands issued by location:
Location             Library              Remote               Total
________             _______              ______               _____
Berkeley               6,257               7,381              13,638
Davis                  6,088                 254               6,342
Irvine                 7,505                   0               7,505
Los Angeles              587               4,547               5,134
Riverside              4,387                 454               4,841
San Diego                938                 594               1,532
San Francisco          1,031                   0               1,031
Santa Barbara          2,648               1,612               4,260
Santa Cruz             5,196                 703               5,899
LBL                        0                 241                 241
LLL                        0                  72                  72
Los Alamos               n/a                  17                  17
Other - UC               132               1,342               1,474
Stanford                                                       1,343
Other-Network UC         n/a               4,724               4,724
                     _______              ______               _____
                      34,769              21,941              58,053
Number of FIND commands by database
  MAGS database                                               52,253
  NEWS database                                                4,427
  COMP database                                                1,373

Total number of FIND commands                                 58,053

1.3  Records displayed
______________________

Number of Records Displayed by location:

Location             Library              Remote               Total
________             _______              ______               _____
Berkeley              63,762              92,820             156,582
Davis                 55,288               1,674              56,962
Irvine                64,274                   0              64,274
Los Angeles            8,813              63,064              71,877
Riverside             41,013               4,991              46,004
San Diego              8,974              10,939              19,913
San Francisco         14,002                   0              14,002
Santa Barbara         23,022              18,716              41,738
Santa Cruz            45,114               6,443              51,557
LBL                        0               2,736               2,736
LLL                        0                 423                 423
Los Alamos               n/a                 139                 139
Other - UC             2,131              20,696              22,827
Stanford                                                       1,981
Other-Network UC         n/a              70,753              70,753
                     _______              ______               _____
                     326,393             293,394             621,768

Number of Records Displayed by database:
  MAGS database                                              586,396
  NEWS database                                               30,725
  COMP database                                               14,551

Total number of Records Displayed                            621,768


1.4  Relative Use of Databases
______________________________

Relative use of MAGS, NEWS, & COMP databases:
  Percent of MAGS sessions                                  87.4%
  Percent of NEWS sessions                                   9.6%
  Percent of COMP sessions                                   3.0%

  Percent of searches done in the MAGS database             90.0%
  Percent of searches done in the NEWS database              7.6%
  Percent of searches done in the COMP database              2.4%

1.5  Response time
__________________

Search response time from receipt of command at
DLA until transmission of response:
  Average in seconds                                         0.7
  Standard deviation in seconds                              3.7

Display response time from receipt of command at
DLA until transmission of a complete screen:
  Average in seconds                                         0.2
  Standard deviation in seconds                              3.7
2.0  Magazines & Journals Database Statistics
_____________________________________________

Median session length (minutes:seconds)                     7:13
Average session length (minutes:seconds)                   12:33
Longest session recorded (minutes:seconds)                882:15
Average number of searches completed per session             3.4
Retrievals per search - median                               5.0
Retrievals per search - average                            529.4
Retrievals per search - standard deviation                4329.0
Percent of searches completed with 0 results                31.2%

Percent of searches entered that are long                    1.6%
Percent of long searches completed
  (includes partial results)                                49.1%

Commands entered, by type, excluding errors:
                                                   Total       Percentage
                                              __________     __________
  FIND                                            49,372          28.4%
  DISPLAY (excluding automatic displays)          70,934          40.8%
  HELP                                             5,716           3.3%
  EXPLAIN                                          4,095           2.4%
  SET/RESET                                        4,812           2.8%
  SHOW                                               695           0.4%
  ADD ON (AND, OR, AND NOT)                        2,881           1.7%
  LOGON or LOGOFF                                 22,092          12.7%
  COMMENT                                              3           0.0%
  SAVE                                             2,809           1.6%
  USE                                                 24           0.0%
  OTHER                                           10,253           5.9%


FINDs completed:                                    RETRIEVALS PER NON-
                          TOTAL    ZERO RESULTS    ZERO RESULT SEARCHES
                  _____________  ______________  ______________________
                           % of            % of
                            all         all for                    Std.
                     No.  FINDs     No.   Index  Median    Avg.    Dev.
                  ______ ______  ______ _______  ______ _______ _______
  By index:
  PERSONAL AUTHOR  7,784  15.3%   2,306   29.6%       9    70.6   270.4
  TITLE WORD       9,817  19.3%   2,938   29.9%      14   584.4  5158.0
  EXACT TITLE      1,385   2.7%     734   53.0%       3    95.2   560.4
  JOURNAL          2,249   4.4%   1,176   52.3%     981  5276.4 12913.1
  EXACT JOURNAL    1,337   2.6%     573   42.9%     932  4435.6  9706.4
  SUBJECT         12,044  23.7%   4,908   40.8%      40   352.4  2468.2
  EXACT SUBJECT      550   1.1%     254   46.2%      62   657.3  1357.8
  KEYWORD         13,570  26.7%   2,677   19.7%      28   840.0  5772.8
  SUBFILE              5   0.0%       1   20.0%     258   751.3  1159.4
  PUBLICATION TYPE   122   0.2%      38   31.1%      11   121.3   434.3
  DATE               443   0.9%     102   23.0%      39   286.3  1589.6
  ADDED               21   0.0%       0    0.0%  35,360 33749.0 19301.9
  PERIODICAL         884   1.7%     140   15.8%       9   219.9  1658.0
  EXACT PE           272   0.5%      39   14.3%       4    51.4   193.6
  RPE                  1   0.0%       0    0.0%     439   439.0     0.0
  XRP                  0   0.0%       0    0.0%       0     0.0     0.0
  COMMENTS             0   0.0%       0    0.0%       0     0.0     0.0
  Other indexes      294   0.6%      83   28.2%     146  2679.6  7495.5
                                                    RETRIEVALS PER NON-
                          TOTAL    ZERO RESULTS    ZERO RESULT SEARCHES
                  _____________  ______________  ______________________
                           % of            % of
                            all         all for                    Std.
                     No.  FINDs     No.   Index  Median    Avg.    Dev.
                  ______ ______  ______ _______  ______ _______ _______
  By number of indexes:
  Multiple         1,781   3.6%     599   33.6%      12   447.8  2582.3
  Single          47,111  96.4%  14,725   31.3%      22   798.9  5295.0


DISPLAY commands, by type, excluding  automatic displays:
  REVIEW                                                     1.9%
  SHORT                                                     65.3%
  LONG                                                       1.1%
  FIELDS                                                     0.7%
  PERIODICALS                                                1.5%
  COMMENTS                                                   0.0%
  Other                                                     29.6%

2.1  Computer Articles Database Statistics
__________________________________________

Median session length (minutes:seconds)                     5:51
Average session length (minutes:seconds)                   11:42
Longest session recorded (minutes:seconds)                293:46
Average number of searches completed per session             2.5
Retrievals per search - median                               5.0
Retrievals per search - average                           1039.7
Retrievals per search - standard deviation                7816.7
Percent of searches completed with 0 results                34.1%

Percent of searches entered that are long                    1.8%
Percent of long searches completed
  (includes partial results)                                52.0%

Commands entered, by type, excluding errors:
                                                   Total       Percentage
                                              __________     __________
  FIND                                             1,232          24.8%
  DISPLAY (excluding automatic displays)           1,894          38.2%
  HELP                                               186           3.7%
  EXPLAIN                                            161           3.2%
  SET/RESET                                          184           3.7%
  SHOW                                                31           0.6%
  ADD ON (AND, OR, AND NOT)                          141           2.8%
  LOGON or LOGOFF                                    717          14.5%
  COMMENT                                              0           0.0%
  SAVE                                               127           2.6%
  USE                                                  0           0.0%
  OTHER                                              288           5.8%
FINDs completed:                                    RETRIEVALS PER NON-
                          TOTAL    ZERO RESULTS    ZERO RESULT SEARCHES
                  _____________  ______________  ______________________
                           % of            % of
                            all         all for                    Std.
                     No.  FINDs     No.   Index  Median    Avg.    Dev.
                  ______ ______  ______ _______  ______ _______ _______
  By index:
  PERSONAL AUTHOR    124   9.5%      83   66.9%       3    45.0   156.3
  TITLE WORD         245  18.8%      83   33.9%      33  1145.6  5778.2
  EXACT TITLE         15   1.2%       6   40.0%       1    91.8   266.0
  JOURNAL             61   4.7%      38   62.3%   3,116  7721.8 12294.0
  EXACT JOURNAL       17   1.3%       6   35.3%  12,908 48065.6 65874.6
  SUBJECT            235  18.0%      94   40.0%      85  1102.6  3418.0
  EXACT SUBJECT       11   0.8%       7   63.6%      64   567.3  1044.5
  KEYWORD            510  39.1%     117   22.9%      50   874.7  2864.5
  SUBFILE              0   0.0%       0    0.0%       0     0.0     0.0
  PUBLICATION TYPE     7   0.5%       3   42.9%      48    74.3    88.0
  DATE                44   3.4%      12   27.3%      23    44.5    61.3
  ADDED                0   0.0%       0    0.0%       0     0.0     0.0
  PERIODICAL          19   1.5%       6   31.6%      19    76.2   117.4
  EXACT PE             4   0.3%       1   25.0%       2     4.0     4.4
  RPE                  4   0.3%       4    100%       0     0.0     0.0
  XRP                  0   0.0%       0    0.0%       0     0.0     0.0
  COMMENTS             0   0.0%       0    0.0%       0     0.0     0.0
  Other indexes        8   0.6%       1   12.5%       4  3041.7  6837.2

  By number of indexes:
  Multiple            80   6.6%      33   41.2%      19   507.6  2694.1
  Single           1,139  93.4%     394   34.6%      50  1842.0 10469.4


DISPLAY commands, by type, excluding  automatic displays:
  REVIEW                                                     5.0%
  SHORT                                                     62.7%
  LONG                                                       1.0%
  FIELDS                                                     2.1%
  PERIODICALS                                                0.9%
  COMMENTS                                                   0.0%
  Other                                                     28.3%


2.1.1  Article Text
___________________

DISPLAY TEXT commands                                     13,985

TEXT included with CONTINUOUS, PRINT, CAPTURE, or SLOW       632
displays or when any of these paging options is set.

TEXT included with MAIL commands                           3,384

SET DISPLAY TEXT commands                                      1


2.2  Newspaper Articles Database Statistics
___________________________________________

Median session length (minutes:seconds)                     5:05
Average session length (minutes:seconds)                    9:47
Longest session recorded (minutes:seconds)                386:08
Average number of searches completed per session             2.6
Retrievals per search - median                               3.0
Retrievals per search - average                           1951.8
Retrievals per search - standard deviation                 33153
Percent of searches completed with 0 results                37.6%

Percent of searches entered that are long                    2.4%
Percent of long searches completed
  (includes partial results)                                52.4%

Commands entered, by type, excluding errors:
                                                   Total       Percentage
                                              __________     __________
  FIND                                             4,165          35.3%
  DISPLAY (excluding automatic displays)           2,626          22.3%
  HELP                                               616           5.2%
  EXPLAIN                                            402           3.4%
  SET/RESET                                          620           5.3%
  SHOW                                                80           0.7%
  ADD ON (AND, OR, AND NOT)                          262           2.2%
  LOGON or LOGOFF                                  2,294          19.5%
  COMMENT                                              0           0.0%
  SAVE                                                73           0.6%
  USE                                                  4           0.0%
  OTHER                                              642           5.4%


FINDs completed:                                    RETRIEVALS PER NON-
                          TOTAL    ZERO RESULTS    ZERO RESULT SEARCHES
                  _____________  ______________  ______________________
                           % of            % of
                            all         all for                    Std.
                     No.  FINDs     No.   Index  Median    Avg.    Dev.
                  ______ ______  ______ _______  ______ _______ _______
  By index:
  PERSONAL AUTHOR    300   6.9%     145   48.3%      17   322.8   638.0
  TITLE WORD         892  20.6%     306   34.3%      10   346.3  2188.3
  EXACT TITLE         65   1.5%      42   64.6%       3    21.7    43.4
  JOURNAL             39   0.9%      15   38.5%   5,068  256477  369903
  EXACT JOURNAL       22   0.5%      12   54.5%     101  8333.1 15635.1
  SUBJECT          1,435  33.1%     669   46.6%      31   712.6  3254.6
  EXACT SUBJECT       85   2.0%      39   45.9%      31   992.5  2546.7
  KEYWORD          1,339  30.9%     334   24.9%      20  1450.1  8385.2
  SUBFILE              0   0.0%       0    0.0%       0     0.0     0.0
  PUBLICATION TYPE     6   0.1%       2   33.3%      17    77.3   128.1
  DATE               118   2.7%      27   22.9%       9   338.2  1337.6
  ADDED                0   0.0%       0    0.0%       0     0.0     0.0
  PERIODICAL          20   0.5%       4   20.0%      20    55.1    77.0
  EXACT PE             3   0.1%       0    0.0%       6    12.7    14.2
  RPE                  0   0.0%       0    0.0%       0     0.0     0.0
  XRP                  0   0.0%       0    0.0%       0     0.0     0.0
  COMMENTS             0   0.0%       0    0.0%       0     0.0     0.0
  Other indexes        5   0.1%       3   60.0%      36    35.5     9.2
                                                    RETRIEVALS PER NON-
                          TOTAL    ZERO RESULTS    ZERO RESULT SEARCHES
                  _____________  ______________  ______________________
                           % of            % of
                            all         all for                    Std.
                     No.  FINDs     No.   Index  Median    Avg.    Dev.
                  ______ ______  ______ _______  ______ _______ _______

  By number of indexes:
  Multiple           208   5.1%      56   26.9%       9   827.0  4464.9
  Single           3,905  94.9%   1,483   38.0%      23  3435.8 44427.2


DISPLAY commands, by type, excluding  automatic displays:
  REVIEW                                                     3.4%
  SHORT                                                     46.8%
  LONG                                                       2.4%
  FIELDS                                                     0.9%
  PERIODICALS                                                0.5%
  COMMENTS                                                   0.0%
  Other                                                     46.0%


2.3  Error, EXPLAIN and HELP statistics (MAGS, COMP, & NEWS)
_______________________________________ ____________________

Percent of commands that contained errors               14.4%

Ten most frequent errors:
  1. First word of command is invalid                   36.8%
  2. NS command - no next screen                        23.9%
  3. FIND command with invalid index name               11.8%
  4. PS command - no previous screen                     5.1%
  5. DISPLAY command contains invalid word               3.6%
  6. Valid command at an inappropriate time              2.5%
  7. Search term missing from search command             2.0%
  8. NS of SHOW/EXP command-no next screen               1.5%
  9. MAIL command issued w/o email address               1.1%
 10. DISPLAY command-record numbers too large            0.9%
 11. All others                                         10.8%

Ten most frequent EXPLAIN requests:
  1. GUIDE                                              23.4%
  2. LOCATE (ARTICLE DBS)                               20.6%
  3. FIND                                                8.7%
  4. COMMANDS                                            8.0%
  5. INDEXES                                             6.3%
  6. MAGS DATABASE                                       5.4%
  7. Unrecognized term                                   5.3%
  8. DISPLAYS (IAC DBS)                                  3.0%
  9. ADDON SEARCH                                        2.2%
 10. MAIL                                                1.7%
 11. All others                                         15.4%

Ten most frequent HELP situations:
  1. Help requested from SET DB command                 22.9%
  2. First word of command is invalid                   20.0%
  3. FIND command with invalid index name               10.2%
  4. FIND command with zero results                      6.5%
  5. DISPLAY command - middle of >1 screen               5.6%
  6. DISPLAY command-complete in one screen              5.1%
  7. DISPLAY command-first of >1 screen                  5.0%
  8. FIND command retrieves >1 book                      3.1%
  9. NS command - no next screen                         2.9%
 10. PS command - no previous screen                     2.1%
 11. All others                                         16.5%

Ten most frequent SHOW requests:
  1. SEARCH                                             38.5%
  2. HISTORY                                            35.1%
  3. MAIL STATUS                                         8.0%
  4. GLOSSARY                                            4.2%
  5. IAC NEWS                                            3.5%
  6. SETTINGS (IAC DBS)                                  3.2%
  7. MAIL SETTINGS                                       2.4%
  8. SYSTEM NEWS                                         2.3%
  9. LIBRARY NEWS                                        0.5%
 10. DISPLAY                                             0.5%
 11. All others                                          1.9%
IACmm/dd iac      MELVYL IAC DATABASES TELNET STATISTICS (weekly)