MELVYL IAC DATABASES TELNET STATISTICS
Time period: 03/01/02 through 03/31/02
1.0 SUMMARY STATISTICS
_______________________
1.1 Total sessions:
____________________
Location Library Remote Total
________ _______ ______ _____
Berkeley 427 981 1,408
Davis 449 3 452
Irvine 212 0 212
Los Angeles 2 264 266
Riverside 31 51 82
San Diego 114 138 252
San Francisco 43 0 43
Santa Barbara 36 67 103
Santa Cruz 31 112 143
LBL 0 23 23
LLL 0 5 5
Los Alamos n/a 3 3
Other - UC 6 147 153
Stanford 15
Other-Network UC n/a 363 363
_______ ______ _____
1,351 2,157 3,523
Per hour usage:
Time Sessions Finds Records Displayed
__________ __________ __________ _________________
12-2 a.m. 72 251 4,925
2-4 a.m. 41 185 1,879
4-6 a.m. 10 44 204
6-8 a.m. 66 176 3,275
8-10 a.m. 286 695 9,388
10-12 a.m. 622 1,527 19,531
12-2 p.m. 689 1,724 20,083
2-4 p.m. 740 1,776 19,388
4-6 p.m. 493 1,319 16,933
6-8 p.m. 241 639 6,488
8-10 p.m. 147 454 5,310
10-12 p.m. 116 326 5,032
__________ __________ __________ _________________
Total: 3,523 9,116 112,436
1.2 FIND commands
__________________
Number of FIND commands issued by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 987 2,652 3,639
Davis 1,121 9 1,130
Irvine 558 0 558
Los Angeles 28 740 768
Riverside 83 115 198
San Diego 268 328 596
San Francisco 111 0 111
Santa Barbara 97 180 277
Santa Cruz 73 256 329
LBL 0 67 67
LLL 0 15 15
Los Alamos n/a 20 20
Other - UC 32 400 432
Stanford 57
Other-Network UC n/a 919 919
_______ ______ _____
3,358 5,701 9,116
Number of FIND commands by database
MAGS database 8,242
NEWS database 683
COMP database 191
Total number of FIND commands 9,116
1.3 Records displayed
______________________
Number of Records Displayed by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 12,970 40,484 53,454
Davis 10,914 211 11,125
Irvine 2,935 0 2,935
Los Angeles 273 8,110 8,383
Riverside 964 1,074 2,038
San Diego 4,193 2,034 6,227
San Francisco 1,894 0 1,894
Santa Barbara 873 2,598 3,471
Santa Cruz 261 3,518 3,779
LBL 0 917 917
LLL 0 420 420
Los Alamos n/a 207 207
Other - UC 389 5,753 6,142
Stanford 69
Other-Network UC n/a 11,044 11,044
_______ ______ _____
35,666 76,370 112,105
Number of Records Displayed by database:
MAGS database 104,935
NEWS database 5,209
COMP database 2,292
Total number of Records Displayed 112,105
1.4 Relative Use of Databases
______________________________
Relative use of MAGS, NEWS, & COMP databases:
Percent of MAGS sessions 87.9%
Percent of NEWS sessions 9.1%
Percent of COMP sessions 3.0%
Percent of searches done in the MAGS database 90.4%
Percent of searches done in the NEWS database 7.5%
Percent of searches done in the COMP database 2.1%
1.5 Response time
__________________
Search response time from receipt of command at
DLA until transmission of response:
Average in seconds 0.4
Standard deviation in seconds 2.1
Display response time from receipt of command at
DLA until transmission of a complete screen:
Average in seconds 0.1
Standard deviation in seconds 2.1
2.0 Magazines & Journals Database Statistics
_____________________________________________
Median session length (minutes:seconds) 6:07
Average session length (minutes:seconds) 12:48
Longest session recorded (minutes:seconds) 436:52
Average number of searches completed per session 2.6
Retrievals per search - median 4.0
Retrievals per search - average 457.3
Retrievals per search - standard deviation 4161.6
Percent of searches completed with 0 results 30.6%
Percent of searches entered that are long 1.5%
Percent of long searches completed
(includes partial results) 51.6%
Commands entered, by type, excluding errors:
Total Percentage
__________ __________
FIND 7,905 28.3%
DISPLAY (excluding automatic displays) 10,378 37.2%
HELP 913 3.3%
EXPLAIN 642 2.3%
SET/RESET 1,104 4.0%
SHOW 100 0.4%
ADD ON (AND, OR, AND NOT) 337 1.2%
LOGON or LOGOFF 4,213 15.1%
COMMENT 0 0.0%
SAVE 736 2.6%
USE 4 0.0%
OTHER 1,594 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 1,839 22.5% 505 27.5% 10 65.1 235.0
TITLE WORD 1,887 23.1% 580 30.7% 11 600.0 5405.6
EXACT TITLE 259 3.2% 120 46.3% 4 115.0 613.2
JOURNAL 395 4.8% 201 50.9% 691 4120.5 9706.2
EXACT JOURNAL 169 2.1% 83 49.1% 1,065 6524.9 12167.0
SUBJECT 1,652 20.2% 581 35.2% 31 290.6 1446.0
EXACT SUBJECT 78 1.0% 39 50.0% 25 535.4 1049.7
KEYWORD 1,365 16.7% 296 21.7% 33 994.8 7598.3
SUBFILE 0 0.0% 0 0.0% 0 0.0 0.0
PUBLICATION TYPE 17 0.2% 4 23.5% 7 164.5 502.6
DATE 108 1.3% 15 13.9% 20 88.1 246.3
ADDED 0 0.0% 0 0.0% 0 0.0 0.0
PERIODICAL 197 2.4% 33 16.8% 11 377.4 3059.0
EXACT PE 156 1.9% 22 14.1% 4 28.2 120.5
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 63 0.8% 12 19.0% 146 441.7 962.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 344 4.4% 82 23.8% 15 136.9 485.9
Single 7,492 95.6% 2,324 31.0% 16 710.1 5213.9
DISPLAY commands, by type, excluding automatic displays:
REVIEW 1.5%
SHORT 61.6%
LONG 1.5%
FIELDS 0.9%
PERIODICALS 2.9%
COMMENTS 0.0%
Other 31.6%
2.1 Computer Articles Database Statistics
__________________________________________
Median session length (minutes:seconds) 3:07
Average session length (minutes:seconds) 20:14
Longest session recorded (minutes:seconds) 530:26
Average number of searches completed per session 1.8
Retrievals per search - median 3.0
Retrievals per search - average 671.5
Retrievals per search - standard deviation 3377.0
Percent of searches completed with 0 results 35.6%
Percent of searches entered that are long 3.1%
Percent of long searches completed
(includes partial results) 66.7%
Commands entered, by type, excluding errors:
Total Percentage
__________ __________
FIND 182 24.2%
DISPLAY (excluding automatic displays) 261 34.7%
HELP 39 5.2%
EXPLAIN 29 3.9%
SET/RESET 36 4.8%
SHOW 3 0.4%
ADD ON (AND, OR, AND NOT) 9 1.2%
LOGON or LOGOFF 139 18.5%
COMMENT 0 0.0%
SAVE 0 0.0%
USE 0 0.0%
OTHER 55 7.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 20 9.9% 12 60.0% 11 33.3 66.2
TITLE WORD 59 29.1% 20 33.9% 40 885.4 2306.5
EXACT TITLE 1 0.5% 0 0.0% 20 20.0 0.0
JOURNAL 14 6.9% 11 78.6% 11,706 17542.7 21072.2
EXACT JOURNAL 0 0.0% 0 0.0% 0 0.0 0.0
SUBJECT 34 16.7% 17 50.0% 35 885.2 2009.1
EXACT SUBJECT 1 0.5% 1 100% 0 0.0 0.0
KEYWORD 54 26.6% 9 16.7% 18 410.9 1173.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 12 5.9% 3 25.0% 9 24.3 40.8
ADDED 0 0.0% 0 0.0% 0 0.0 0.0
PERIODICAL 6 3.0% 0 0.0% 4 6.0 5.7
EXACT PE 2 1.0% 0 0.0% 5 5.0 1.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 23 12.8% 8 34.8% 4 16.5 32.5
Single 156 87.1% 57 36.5% 29 1219.7 4565.7
DISPLAY commands, by type, excluding automatic displays:
REVIEW 2.4%
SHORT 61.6%
LONG 0.7%
FIELDS 1.9%
PERIODICALS 2.8%
COMMENTS 0.0%
Other 30.7%
2.1.1 Article Text
___________________
DISPLAY TEXT commands 2,284
TEXT included with CONTINUOUS, PRINT, CAPTURE, or SLOW 108
displays or when any of these paging options is set.
TEXT included with MAIL commands 476
SET DISPLAY TEXT commands 0
2.2 Newspaper Articles Database Statistics
___________________________________________
Median session length (minutes:seconds) 3:47
Average session length (minutes:seconds) 9:26
Longest session recorded (minutes:seconds) 254:50
Average number of searches completed per session 2.1
Retrievals per search - median 2.0
Retrievals per search - average 2233.4
Retrievals per search - standard deviation 32166
Percent of searches completed with 0 results 41.1%
Percent of searches entered that are long 3.5%
Percent of long searches completed
(includes partial results) 83.3%
Commands entered, by type, excluding errors:
Total Percentage
__________ __________
FIND 648 33.0%
DISPLAY (excluding automatic displays) 458 23.3%
HELP 61 3.1%
EXPLAIN 54 2.7%
SET/RESET 134 6.8%
SHOW 13 0.7%
ADD ON (AND, OR, AND NOT) 35 1.8%
LOGON or LOGOFF 403 20.5%
COMMENT 0 0.0%
SAVE 53 2.7%
USE 0 0.0%
OTHER 107 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 49 6.9% 25 51.0% 13 226.9 414.1
TITLE WORD 164 23.0% 60 36.6% 22 447.7 1861.8
EXACT TITLE 16 2.2% 10 62.5% 4 4.2 2.5
JOURNAL 17 2.4% 8 47.1% 189 145863 252743
EXACT JOURNAL 26 3.6% 11 42.3% 12 135.7 393.0
SUBJECT 202 28.3% 105 52.0% 36 663.8 2234.4
EXACT SUBJECT 9 1.3% 4 44.4% 798 4383.0 7868.4
KEYWORD 186 26.0% 53 28.5% 13 305.2 2031.3
SUBFILE 0 0.0% 0 0.0% 0 0.0 0.0
PUBLICATION TYPE 2 0.3% 1 50.0% 6 6.0 0.0
DATE 34 4.8% 7 20.6% 16 77.1 153.9
ADDED 0 0.0% 0 0.0% 0 0.0 0.0
PERIODICAL 5 0.7% 0 0.0% 5 21.2 36.6
EXACT PE 3 0.4% 2 66.7% 29 29.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 1 0.1% 1 100% 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 57 8.9% 19 33.3% 15 124.1 295.8
Single 587 91.1% 247 42.1% 25 4371.2 45370.4
DISPLAY commands, by type, excluding automatic displays:
REVIEW 2.7%
SHORT 46.8%
LONG 2.7%
FIELDS 3.6%
PERIODICALS 0.7%
COMMENTS 0.0%
Other 43.4%
2.3 Error, EXPLAIN and HELP statistics (MAGS, COMP, & NEWS)
_______________________________________ ____________________
Percent of commands that contained errors 12.7%
Ten most frequent errors:
1. First word of command is invalid 35.0%
2. NS command - no next screen 24.4%
3. FIND command with invalid index name 15.4%
4. PS command - no previous screen 4.4%
5. DISPLAY command contains invalid word 3.2%
6. Valid command at an inappropriate time 2.8%
7. Search term missing from search command 2.3%
8. DISPLAY command - no FIND results 1.3%
9. MAIL command issued w/o email address 1.0%
10. NS of SHOW/EXP command-no next screen 0.8%
11. All others 9.4%
Ten most frequent EXPLAIN requests:
1. GUIDE 29.7%
2. LOCATE (ARTICLE DBS) 16.0%
3. FIND 9.2%
4. COMMANDS 8.3%
5. INDEXES 5.7%
6. MAGS DATABASE 4.7%
7. Unrecognized term 4.3%
8. DISPLAYS (IAC DBS) 3.9%
9. ADDON SEARCH 3.4%
10. MAIL 1.9%
11. All others 13.0%
Ten most frequent HELP situations:
1. Help requested from SET DB command 25.2%
2. First word of command is invalid 20.0%
3. FIND command with invalid index name 12.2%
4. FIND command with zero results 6.3%
5. DISPLAY command-first of >1 screen 5.9%
6. DISPLAY command - middle of >1 screen 4.6%
7. DISPLAY command-complete in one screen 4.0%
8. FIND command retrieves >1 book 3.2%
9. NS command - no next screen 2.4%
10. DISPLAY command - last of >1 screen 1.9%
11. All others 14.4%
Ten most frequent SHOW requests:
1. SEARCH 38.8%
2. HISTORY 19.0%
3. IAC NEWS 18.1%
4. LOCATION 6.9%
5. MAIL STATUS 5.2%
6. GLOSSARY 3.4%
7. SYSTEM NEWS 2.6%
8. MAIL SETTINGS 2.6%
9. SETTINGS (IAC DBS) 1.7%
10. DISPLAY 0.9%
11. All others 0.9%
IACmm/dd iac MELVYL IAC DATABASES TELNET STATISTICS (weekly)