MELVYL IAC DATABASES TELNET STATISTICS
Time period: 11/17/01 through 11/23/01
1.0 SUMMARY STATISTICS
_______________________
1.1 Total sessions:
____________________
Location Library Remote Total
________ _______ ______ _____
Berkeley 126 242 368
Davis 156 1 157
Irvine 93 0 93
Los Angeles 2 51 53
Riverside 28 21 49
San Diego 8 41 49
San Francisco 10 0 10
Santa Barbara 17 16 33
Santa Cruz 18 22 40
LBL 0 2 2
LLL 0 1 1
Los Alamos n/a 0 0
Other - UC 1 48 49
Stanford 4
Other-Network UC n/a 59 59
_______ ______ _____
459 504 967
Per hour usage:
Time Sessions Finds Records Displayed
__________ __________ __________ _________________
12-2 a.m. 14 40 812
2-4 a.m. 5 16 68
4-6 a.m. 7 32 428
6-8 a.m. 14 78 1,100
8-10 a.m. 61 127 627
10-12 a.m. 161 493 4,122
12-2 p.m. 202 490 4,844
2-4 p.m. 213 571 6,047
4-6 p.m. 136 504 4,426
6-8 p.m. 67 239 1,775
8-10 p.m. 62 175 2,524
10-12 p.m. 25 56 854
__________ __________ __________ _________________
Total: 967 2,821 27,627
1.2 FIND commands
__________________
Number of FIND commands issued by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 316 737 1,053
Davis 448 5 453
Irvine 297 0 297
Los Angeles 1 142 143
Riverside 93 59 152
San Diego 33 118 151
San Francisco 30 0 30
Santa Barbara 21 68 89
Santa Cruz 79 36 115
LBL 0 21 21
LLL 0 5 5
Los Alamos n/a 0 0
Other - UC 1 160 161
Stanford 8
Other-Network UC n/a 143 143
_______ ______ _____
1,319 1,494 2,821
Number of FIND commands by database
MAGS database 2,637
NEWS database 114
COMP database 70
Total number of FIND commands 2,821
1.3 Records displayed
______________________
Number of Records Displayed by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 4,087 7,248 11,335
Davis 4,204 1 4,205
Irvine 3,033 0 3,033
Los Angeles 0 1,362 1,362
Riverside 860 426 1,286
San Diego 76 781 857
San Francisco 696 0 696
Santa Barbara 243 503 746
Santa Cruz 252 343 595
LBL 0 310 310
LLL 0 61 61
Los Alamos n/a 0 0
Other - UC 47 1,176 1,223
Stanford 2
Other-Network UC n/a 1,916 1,916
_______ ______ _____
13,498 14,127 27,627
Number of Records Displayed by database:
MAGS database 26,067
NEWS database 1,135
COMP database 425
Total number of Records Displayed 27,627
1.4 Relative Use of Databases
______________________________
Relative use of MAGS, NEWS, & COMP databases:
Percent of MAGS sessions 90.1%
Percent of NEWS sessions 7.0%
Percent of COMP sessions 2.9%
Percent of searches done in the MAGS database 93.5%
Percent of searches done in the NEWS database 4.0%
Percent of searches done in the COMP database 2.5%
1.5 Response time
__________________
Search response time from receipt of command at
DLA until transmission of response:
Average in seconds 0.5
Standard deviation in seconds 1.3
Display response time from receipt of command at
DLA until transmission of a complete screen:
Average in seconds 0.1
Standard deviation in seconds 1.3
2.0 Magazines & Journals Database Statistics
_____________________________________________
Median session length (minutes:seconds) 5:47
Average session length (minutes:seconds) 11:42
Longest session recorded (minutes:seconds) 339:03
Average number of searches completed per session 3.0
Retrievals per search - median 4.0
Retrievals per search - average 473.2
Retrievals per search - standard deviation 3477.6
Percent of searches completed with 0 results 32.8%
Percent of searches entered that are long 2.3%
Percent of long searches completed
(includes partial results) 50.8%
Commands entered, by type, excluding errors:
Total Percentage
__________ __________
FIND 2,444 29.9%
DISPLAY (excluding automatic displays) 2,856 34.9%
HELP 329 4.0%
EXPLAIN 211 2.6%
SET/RESET 296 3.6%
SHOW 68 0.8%
ADD ON (AND, OR, AND NOT) 193 2.4%
LOGON or LOGOFF 1,235 15.1%
COMMENT 0 0.0%
SAVE 137 1.7%
USE 1 0.0%
OTHER 404 4.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 491 19.3% 142 28.9% 10 70.8 314.2
TITLE WORD 504 19.8% 155 30.8% 13 223.0 960.1
EXACT TITLE 88 3.5% 49 55.7% 2 22.8 104.0
JOURNAL 188 7.4% 97 51.6% 1,104 4598.7 9839.2
EXACT JOURNAL 53 2.1% 27 50.9% 2,822 8836.0 12544.4
SUBJECT 635 24.9% 240 37.8% 41 397.9 3813.7
EXACT SUBJECT 15 0.6% 8 53.3% 39 123.3 203.9
KEYWORD 407 16.0% 92 22.6% 21 952.9 5347.5
SUBFILE 0 0.0% 0 0.0% 0 0.0 0.0
PUBLICATION TYPE 8 0.3% 2 25.0% 27 44.8 57.0
DATE 48 1.9% 11 22.9% 17 73.0 122.6
ADDED 0 0.0% 0 0.0% 0 0.0 0.0
PERIODICAL 44 1.7% 7 15.9% 18 85.9 165.7
EXACT PE 56 2.2% 8 14.3% 2 39.8 143.9
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 8 0.3% 3 37.5% 21 71.0 76.1
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 121 5.0% 39 32.2% 17 51.7 89.2
Single 2,296 95.0% 758 33.0% 19 786.6 4497.1
DISPLAY commands, by type, excluding automatic displays:
REVIEW 1.6%
SHORT 60.4%
LONG 1.3%
FIELDS 0.8%
PERIODICALS 2.6%
COMMENTS 0.0%
Other 33.3%
2.1 Computer Articles Database Statistics
__________________________________________
Median session length (minutes:seconds) 4:08
Average session length (minutes:seconds) 10:04
Longest session recorded (minutes:seconds) 58:12
Average number of searches completed per session 2.5
Retrievals per search - median 3.0
Retrievals per search - average 991.8
Retrievals per search - standard deviation 6567.9
Percent of searches completed with 0 results 33.3%
Percent of searches entered that are long 7.1%
Percent of long searches completed
(includes partial results) 80.0%
Commands entered, by type, excluding errors:
Total Percentage
__________ __________
FIND 60 26.8%
DISPLAY (excluding automatic displays) 67 29.9%
HELP 11 4.9%
EXPLAIN 11 4.9%
SET/RESET 9 4.0%
SHOW 0 0.0%
ADD ON (AND, OR, AND NOT) 10 4.5%
LOGON or LOGOFF 41 18.3%
COMMENT 0 0.0%
SAVE 1 0.4%
USE 0 0.0%
OTHER 14 6.3%
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 8 12.7% 2 25.0% 13 22.5 31.4
TITLE WORD 30 47.6% 11 36.7% 28 379.6 822.7
EXACT TITLE 0 0.0% 0 0.0% 0 0.0 0.0
JOURNAL 4 6.3% 2 50.0% 757 757.0 953.2
EXACT JOURNAL 2 3.2% 2 100% 0 0.0 0.0
SUBJECT 11 17.5% 4 36.4% 9 758.3 1268.7
EXACT SUBJECT 0 0.0% 0 0.0% 0 0.0 0.0
KEYWORD 4 6.3% 1 25.0% 27 165.0 259.2
SUBFILE 0 0.0% 0 0.0% 0 0.0 0.0
PUBLICATION TYPE 0 0.0% 0 0.0% 0 0.0 0.0
DATE 1 1.6% 1 100% 0 0.0 0.0
ADDED 0 0.0% 0 0.0% 0 0.0 0.0
PERIODICAL 0 0.0% 0 0.0% 0 0.0 0.0
EXACT PE 3 4.8% 0 0.0% 6 11.7 14.4
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 4 6.8% 2 50.0% 1,309 1308.5 1733.1
Single 55 93.2% 19 34.5% 18 262.9 666.3
DISPLAY commands, by type, excluding automatic displays:
REVIEW 2.8%
SHORT 51.9%
LONG 0.9%
FIELDS 3.7%
PERIODICALS 3.7%
COMMENTS 0.0%
Other 37.0%
2.1.1 Article Text
___________________
DISPLAY TEXT commands 566
TEXT included with CONTINUOUS, PRINT, CAPTURE, or SLOW 46
displays or when any of these paging options is set.
TEXT included with MAIL commands 116
SET DISPLAY TEXT commands 0
2.2 Newspaper Articles Database Statistics
___________________________________________
Median session length (minutes:seconds) 2:27
Average session length (minutes:seconds) 6:07
Longest session recorded (minutes:seconds) 46:04
Average number of searches completed per session 1.7
Retrievals per search - median 1.0
Retrievals per search - average 373.5
Retrievals per search - standard deviation 1464.6
Percent of searches completed with 0 results 44.7%
Percent of searches entered that are long 0.9%
Percent of long searches completed
(includes partial results) 100%
Commands entered, by type, excluding errors:
Total Percentage
__________ __________
FIND 113 31.0%
DISPLAY (excluding automatic displays) 73 20.1%
HELP 28 7.7%
EXPLAIN 11 3.0%
SET/RESET 23 6.3%
SHOW 1 0.3%
ADD ON (AND, OR, AND NOT) 1 0.3%
LOGON or LOGOFF 99 27.2%
COMMENT 0 0.0%
SAVE 0 0.0%
USE 0 0.0%
OTHER 15 4.1%
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 10 8.4% 3 30.0% 5 34.1 52.9
TITLE WORD 30 25.2% 16 53.3% 24 122.2 239.0
EXACT TITLE 0 0.0% 0 0.0% 0 0.0 0.0
JOURNAL 3 2.5% 1 33.3% 1 1.0 0.0
EXACT JOURNAL 5 4.2% 5 100% 0 0.0 0.0
SUBJECT 43 36.1% 21 48.8% 68 646.7 1494.9
EXACT SUBJECT 3 2.5% 1 33.3% 3,341 3341.0 4702.3
KEYWORD 22 18.5% 4 18.2% 410 1096.3 2819.1
SUBFILE 0 0.0% 0 0.0% 0 0.0 0.0
PUBLICATION TYPE 0 0.0% 0 0.0% 0 0.0 0.0
DATE 3 2.5% 0 0.0% 1 2.3 2.3
ADDED 0 0.0% 0 0.0% 0 0.0 0.0
PERIODICAL 0 0.0% 0 0.0% 0 0.0 0.0
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
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 4 3.5% 0 0.0% 3 5.8 7.1
Single 109 96.5% 51 46.8% 64 733.7 1995.9
DISPLAY commands, by type, excluding automatic displays:
REVIEW 1.4%
SHORT 46.6%
LONG 3.4%
FIELDS 2.7%
PERIODICALS 0.0%
COMMENTS 0.0%
Other 45.9%
2.3 Error, EXPLAIN and HELP statistics (MAGS, COMP, & NEWS)
_______________________________________ ____________________
Percent of commands that contained errors 14.0%
Ten most frequent errors:
1. First word of command is invalid 38.9%
2. NS command - no next screen 20.1%
3. FIND command with invalid index name 14.7%
4. PS command - no previous screen 6.4%
5. Search term missing from search command 3.2%
6. Valid command at an inappropriate time 2.9%
7. NS of SHOW/EXP command-no next screen 2.4%
8. DISPLAY command contains invalid word 2.2%
9. Valid command, invalid in current DB 0.8%
10. DISPLAY command - no FIND results 0.6%
11. All others 7.8%
Ten most frequent EXPLAIN requests:
1. GUIDE 29.2%
2. LOCATE (ARTICLE DBS) 19.3%
3. FIND 9.0%
4. COMMANDS 7.7%
5. MAGS DATABASE 5.2%
6. INDEXES 3.9%
7. Unrecognized term 2.6%
8. ADDON SEARCH 2.6%
9. DISPLAYS (IAC DBS) 2.1%
10. MAIL 2.1%
11. All others 16.3%
Ten most frequent HELP situations:
1. Help requested from SET DB command 23.5%
2. First word of command is invalid 20.5%
3. FIND command with invalid index name 13.1%
4. FIND command with zero results 7.2%
5. DISPLAY command-first of >1 screen 4.7%
6. DISPLAY command - middle of >1 screen 4.3%
7. DISPLAY command-complete in one screen 3.5%
8. PS command - no previous screen 2.8%
9. NS command - no next screen 2.3%
10. FIND command retrieves >1 book 2.3%
11. All others 15.8%
Ten most frequent SHOW requests:
1. HISTORY 44.1%
2. SEARCH 25.0%
3. IAC NEWS 13.2%
4. SETTINGS (IAC DBS) 2.9%
5. MAIL SETTINGS 2.9%
6. LOCAL INFORMATION 2.9%
7. UCB LIBRARY HOURS 1.5%
8. GLOSSARY 1.5%
9. LIBRARY LOCATIONS 1.5%
10. MAIL STATUS 1.5%
11. All others 2.9%
IACmm/dd iac MELVYL IAC DATABASES TELNET STATISTICS (weekly)