MELVYL IAC DATABASES TELNET STATISTICS
               Time period: 12/01/99 through 12/31/99

1.0  SUMMARY STATISTICS
_______________________

1.1  Total sessions:
____________________

Location             Library              Remote               Total
________             _______              ______               _____
Berkeley                 799               1,737               2,536
Davis                  1,569                  77               1,646
Irvine                 1,318                   0               1,318
Los Angeles              197               1,282               1,479
Riverside                400                  89                 489
San Diego                258                 326                 584
San Francisco            304                   0                 304
Santa Barbara            646                 494               1,140
Santa Cruz               832                 400               1,232
LBL                        0                  91                  91
LLL                        0                  32                  32
Los Alamos               n/a                   1                   1
Other - UC                48                 271                 319
Stanford                                                         297
Other-Network UC         n/a                 764                 764
                     _______              ______               _____
                       6,371               5,564              12,232
Per hour usage:
          Time         Sessions            Finds      Records Displayed
    __________       __________       __________      _________________
    12-2  a.m.              256            1,074                 13,413
     2-4  a.m.              101              442                  5,690
     4-6  a.m.               65              177                  2,595
     6-8  a.m.              144              393                  4,718
     8-10 a.m.              891            2,579                 36,510
    10-12 a.m.            1,878            5,163                 57,880
    12-2  p.m.            2,172            6,603                 69,620
     2-4  p.m.            2,606            8,254                100,095
     4-6  p.m.            1,881            5,816                 84,975
     6-8  p.m.              906            3,053                 39,193
     8-10 p.m.              805            2,591                 30,304
    10-12 p.m.              527            1,834                 23,207
    __________       __________       __________      _________________
        Total:           12,232           37,979                468,200

1.2  FIND commands
__________________

Number of FIND commands issued by location:
Location             Library              Remote               Total
________             _______              ______               _____
Berkeley               2,476               5,189               7,665
Davis                  4,637                 289               4,926
Irvine                 4,348                   0               4,348
Los Angeles              593               3,503               4,096
Riverside              1,069                 239               1,308
San Diego                882                 974               1,856
San Francisco            892                   0                 892
Santa Barbara          2,067               1,570               3,637
Santa Cruz             2,866               1,111               3,977
LBL                        0                 205                 205
LLL                        0                  97                  97
Los Alamos               n/a                   2                   2
Other - UC                87                 875                 962
Stanford                                                       1,122
Other-Network UC         n/a               2,886               2,886
                     _______              ______               _____
                      19,917              16,940              37,979
Number of FIND commands by database
  MAGS database                                               33,985
  NEWS database                                                2,668
  COMP database                                                1,326

Total number of FIND commands                                 37,979

1.3  Records displayed
______________________

Number of Records Displayed by location:

Location             Library              Remote               Total
________             _______              ______               _____
Berkeley              30,176              57,369              87,545
Davis                 40,606               1,446              42,052
Irvine                67,536                   0              67,536
Los Angeles            8,722              54,382              63,104
Riverside              9,594               2,096              11,690
San Diego              7,379              22,344              29,723
San Francisco         10,882                   0              10,882
Santa Barbara         24,181              19,724              43,905
Santa Cruz            29,286              11,874              41,160
LBL                        0               2,312               2,312
LLL                        0                 847                 847
Los Alamos               n/a                   0                   0
Other - UC             1,401              11,643              13,044
Stanford                                                       1,848
Other-Network UC         n/a              41,385              41,385
                     _______              ______               _____
                     229,763             225,422             457,033

Number of Records Displayed by database:
  MAGS database                                              424,798
  NEWS database                                               18,943
  COMP database                                               24,459

Total number of Records Displayed                            457,033


1.4  Relative Use of Databases
______________________________

Relative use of MAGS, NEWS, & COMP databases:
  Percent of MAGS sessions                                  87.2%
  Percent of NEWS sessions                                   9.3%
  Percent of COMP sessions                                   3.5%

  Percent of searches done in the MAGS database             89.5%
  Percent of searches done in the NEWS database              7.0%
  Percent of searches done in the COMP database              3.5%

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                              4.0

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

Median session length (minutes:seconds)                     7:08
Average session length (minutes:seconds)                   12:45
Longest session recorded (minutes:seconds)                572:41
Average number of searches completed per session             3.2
Retrievals per search - median                               6.0
Retrievals per search - average                            608.7
Retrievals per search - standard deviation                8152.8
Percent of searches completed with 0 results                29.3%

Percent of searches entered that are long                    1.5%
Percent of long searches completed
  (includes partial results)                                51.3%

Commands entered, by type, excluding errors:
                                                   Total       Percentage
                                              __________     __________
  FIND                                            31,781          27.3%
  DISPLAY (excluding automatic displays)          48,803          41.9%
  HELP                                             3,274           2.8%
  EXPLAIN                                          2,463           2.1%
  SET/RESET                                        3,544           3.0%
  SHOW                                               598           0.5%
  ADD ON (AND, OR, AND NOT)                        2,204           1.9%
  LOGON or LOGOFF                                 15,015          12.9%
  COMMENT                                              3           0.0%
  SAVE                                             2,213           1.9%
  USE                                                 24           0.0%
  OTHER                                            6,674           5.7%


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  6,438  19.6%   1,759   27.3%       9    72.6   326.9
  TITLE WORD       5,998  18.2%   1,741   29.0%      12   436.0  2528.5
  EXACT TITLE        824   2.5%     420   51.0%       4   113.6   386.1
  JOURNAL          1,520   4.6%     686   45.1%     897  6408.5 18134.3
  EXACT JOURNAL      741   2.3%     339   45.7%     874  5116.7 10277.8
  SUBJECT          6,556  19.9%   2,460   37.5%      35   310.0  1558.2
  EXACT SUBJECT      375   1.1%     150   40.0%      24   457.5  1404.2
  KEYWORD          8,988  27.3%   1,887   21.0%      29  1205.2 15996.6
  SUBFILE              4   0.0%       0    0.0%      21    50.0    72.0
  PUBLICATION TYPE    68   0.2%      13   19.1%      13   325.8   918.8
  DATE               308   0.9%      70   22.7%      26   316.7  1020.2
  ADDED               11   0.0%       0    0.0%  35,188 26228.8 12636.9
  PERIODICAL         466   1.4%     114   24.5%      11   234.7  1316.6
  EXACT PE           301   0.9%      54   17.9%       4    42.5   165.6
  RPE                  1   0.0%       0    0.0%      22    22.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      286   0.9%      55   19.2%     505  3018.7  8978.9
                                                    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,309   4.2%     415   31.7%      11   855.0  5032.8
  Single          30,189  95.8%   8,885   29.4%      20   901.4 10149.5


DISPLAY commands, by type, excluding  automatic displays:
  REVIEW                                                     2.1%
  SHORT                                                     65.3%
  LONG                                                       1.8%
  FIELDS                                                     0.8%
  PERIODICALS                                                1.2%
  COMMENTS                                                   0.0%
  Other                                                     28.9%

2.1  Computer Articles Database Statistics
__________________________________________

Median session length (minutes:seconds)                     6:15
Average session length (minutes:seconds)                   10:12
Longest session recorded (minutes:seconds)                 79:28
Average number of searches completed per session             3.1
Retrievals per search - median                               7.0
Retrievals per search - average                            779.3
Retrievals per search - standard deviation                6260.1
Percent of searches completed with 0 results                30.5%

Percent of searches entered that are long                    1.4%
Percent of long searches completed
  (includes partial results)                                50.0%

Commands entered, by type, excluding errors:
                                                   Total       Percentage
                                              __________     __________
  FIND                                             1,166          26.9%
  DISPLAY (excluding automatic displays)           1,673          38.6%
  HELP                                               131           3.0%
  EXPLAIN                                            118           2.7%
  SET/RESET                                          141           3.2%
  SHOW                                                23           0.5%
  ADD ON (AND, OR, AND NOT)                          160           3.7%
  LOGON or LOGOFF                                    616          14.2%
  COMMENT                                              0           0.0%
  SAVE                                                76           1.8%
  USE                                                  1           0.0%
  OTHER                                              234           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    106   8.6%      61   57.5%       3    40.3    88.7
  TITLE WORD         280  22.8%      79   28.2%      19   679.3  3311.1
  EXACT TITLE          9   0.7%       8   88.9%       1     1.0     0.0
  JOURNAL             34   2.8%      15   44.1%   1,896 21455.1 42571.6
  EXACT JOURNAL        7   0.6%       5   71.4%  14,861 14861.0 16370.9
  SUBJECT            209  17.0%      74   35.4%      44  1072.0  3711.1
  EXACT SUBJECT        7   0.6%       6   85.7%  27,505 27505.0     0.0
  KEYWORD            523  42.7%     136   26.0%      54   636.3  3536.6
  SUBFILE              0   0.0%       0    0.0%       0     0.0     0.0
  PUBLICATION TYPE     5   0.4%       0    0.0%       3   139.4   228.8
  DATE                38   3.1%       8   21.1%      64   127.4   258.3
  ADDED                0   0.0%       0    0.0%       0     0.0     0.0
  PERIODICAL           8   0.7%       0    0.0%       3     5.4     6.4
  EXACT PE             0   0.0%       0    0.0%       0     0.0     0.0
  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        0   0.0%       0    0.0%       0     0.0     0.0

  By number of indexes:
  Multiple            70   6.1%      14   20.0%      28    96.0   210.6
  Single           1,083  93.9%     364   33.6%      36  1374.1  8406.9


DISPLAY commands, by type, excluding  automatic displays:
  REVIEW                                                     6.6%
  SHORT                                                     57.7%
  LONG                                                       2.2%
  FIELDS                                                     1.9%
  PERIODICALS                                                0.6%
  COMMENTS                                                   0.0%
  Other                                                     31.0%


2.1.1  Article Text
___________________

DISPLAY TEXT commands                                      9,260

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

TEXT included with MAIL commands                           1,944

SET DISPLAY TEXT commands                                      0


2.2  Newspaper Articles Database Statistics
___________________________________________

Median session length (minutes:seconds)                     4:09
Average session length (minutes:seconds)                    8:23
Longest session recorded (minutes:seconds)                135:34
Average number of searches completed per session             2.3
Retrievals per search - median                               2.0
Retrievals per search - average                           1100.9
Retrievals per search - standard deviation                 31960
Percent of searches completed with 0 results                39.9%

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

Commands entered, by type, excluding errors:
                                                   Total       Percentage
                                              __________     __________
  FIND                                             2,530          34.6%
  DISPLAY (excluding automatic displays)           1,652          22.6%
  HELP                                               299           4.1%
  EXPLAIN                                            228           3.1%
  SET/RESET                                          458           6.3%
  SHOW                                                43           0.6%
  ADD ON (AND, OR, AND NOT)                          138           1.9%
  LOGON or LOGOFF                                  1,485          20.3%
  COMMENT                                              0           0.0%
  SAVE                                                46           0.6%
  USE                                                  2           0.0%
  OTHER                                              421           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    266  10.1%     152   57.1%      14   228.5   493.7
  TITLE WORD         571  21.7%     185   32.4%      22   478.1  2592.7
  EXACT TITLE         66   2.5%      34   51.5%       4    28.8    58.0
  JOURNAL             42   1.6%      36   85.7%     141  328880  637239
  EXACT JOURNAL       22   0.8%      13   59.1%     228  2002.1  4622.1
  SUBJECT            703  26.7%     290   41.3%      39   703.6  3006.1
  EXACT SUBJECT       34   1.3%      18   52.9%      22   365.6   605.5
  KEYWORD            835  31.7%     294   35.2%      19   742.7  3404.4
  SUBFILE              0   0.0%       0    0.0%       0     0.0     0.0
  PUBLICATION TYPE     9   0.3%       2   22.2%       4     5.9     6.0
  DATE                57   2.2%      14   24.6%      23   149.1   483.9
  ADDED                1   0.0%       1    100%       0     0.0     0.0
  PERIODICAL          12   0.5%       4   33.3%      21    22.6    17.9
  EXACT PE             8   0.3%       2   25.0%       9    23.5    34.6
  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        6   0.2%       3   50.0%   2,852  2611.0   417.4
                                                    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           126   5.0%      44   34.9%      13   298.0  1611.8
  Single           2,373  95.0%     958   40.4%      24  2025.7 43588.5


DISPLAY commands, by type, excluding  automatic displays:
  REVIEW                                                     4.0%
  SHORT                                                     47.5%
  LONG                                                       3.0%
  FIELDS                                                     1.0%
  PERIODICALS                                                0.4%
  COMMENTS                                                   0.0%
  Other                                                     44.1%


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

Percent of commands that contained errors               13.2%

Ten most frequent errors:
  1. First word of command is invalid                   36.1%
  2. NS command - no next screen                        25.9%
  3. FIND command with invalid index name               10.6%
  4. PS command - no previous screen                     5.0%
  5. DISPLAY command contains invalid word               3.8%
  6. Valid command at an inappropriate time              2.8%
  7. Search term missing from search command             1.7%
  8. MAIL command issued w/o email address               1.1%
  9. DISPLAY command-record numbers too large            1.0%
 10. NS of SHOW/EXP command-no next screen               1.0%
 11. All others                                         10.9%

Ten most frequent EXPLAIN requests:
  1. GUIDE                                              22.4%
  2. LOCATE (ARTICLE DBS)                               18.0%
  3. FIND                                                9.4%
  4. INDEXES                                             7.8%
  5. COMMANDS                                            7.5%
  6. Unrecognized term                                   5.4%
  7. MAGS DATABASE                                       4.2%
  8. ADDON SEARCH                                        3.3%
  9. DISPLAYS (IAC DBS)                                  3.0%
 10. MAIL                                                1.9%
 11. All others                                         17.0%

Ten most frequent HELP situations:
  1. Help requested from SET DB command                 24.0%
  2. First word of command is invalid                   18.6%
  3. FIND command with invalid index name                9.4%
  4. FIND command with zero results                      7.0%
  5. DISPLAY command - middle of >1 screen               5.5%
  6. DISPLAY command-first of >1 screen                  5.2%
  7. DISPLAY command-complete in one screen              5.0%
  8. FIND command retrieves >1 book                      3.4%
  9. NS command - no next screen                         3.0%
 10. PS command - no previous screen                     2.0%
 11. All others                                         16.8%

Ten most frequent SHOW requests:
  1. SEARCH                                             43.1%
  2. HISTORY                                            30.9%
  3. MAIL STATUS                                         7.6%
  4. GLOSSARY                                            4.2%
  5. SETTINGS (IAC DBS)                                  3.6%
  6. IAC NEWS                                            2.4%
  7. SYSTEM NEWS                                         2.4%
  8. MAIL SETTINGS                                       1.6%
  9. LIBRARY NEWS                                        0.5%
 10. DISPLAY                                             0.5%
 11. All others                                          3.1%
IACmm/dd iac      MELVYL IAC DATABASES TELNET STATISTICS (weekly)