MELVYL IAC DATABASES TELNET STATISTICS
Time period: 07/14/01 through 07/20/01
1.0 SUMMARY STATISTICS
_______________________
1.1 Total sessions:
____________________
Location Library Remote Total
________ _______ ______ _____
Berkeley 71 239 310
Davis 129 1 130
Irvine 100 0 100
Los Angeles 1 75 76
Riverside 27 20 47
San Diego 10 46 56
San Francisco 35 0 35
Santa Barbara 3 30 33
Santa Cruz 17 23 40
LBL 0 11 11
LLL 0 5 5
Los Alamos n/a 1 1
Other - UC 0 22 22
Stanford 39
Other-Network UC n/a 105 105
_______ ______ _____
393 578 1,010
Per hour usage:
Time Sessions Finds Records Displayed
__________ __________ __________ _________________
12-2 a.m. 11 92 421
2-4 a.m. 7 14 349
4-6 a.m. 7 17 4
6-8 a.m. 21 43 469
8-10 a.m. 107 231 2,151
10-12 a.m. 204 443 72,780
12-2 p.m. 176 433 49,402
2-4 p.m. 199 501 53,772
4-6 p.m. 158 442 20,058
6-8 p.m. 63 131 28,746
8-10 p.m. 41 171 3,062
10-12 p.m. 16 177 1,160
__________ __________ __________ _________________
Total: 1,010 2,695 232,374
1.2 FIND commands
__________________
Number of FIND commands issued by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 187 524 711
Davis 270 2 272
Irvine 334 0 334
Los Angeles 6 175 181
Riverside 48 62 110
San Diego 29 124 153
San Francisco 75 0 75
Santa Barbara 14 96 110
Santa Cruz 44 55 99
LBL 0 36 36
LLL 0 7 7
Los Alamos n/a 1 1
Other - UC 0 51 51
Stanford 233
Other-Network UC n/a 322 322
_______ ______ _____
1,007 1,455 2,695
Number of FIND commands by database
MAGS database 2,291
NEWS database 317
COMP database 87
Total number of FIND commands 2,695
1.3 Records displayed
______________________
Number of Records Displayed by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 2,720 5,967 8,687
Davis 3,073 80 3,153
Irvine 1,677 0 1,677
Los Angeles 165 1,629 1,794
Riverside 1,072 466 1,538
San Diego 554 161,294 161,848
San Francisco 1,717 0 1,717
Santa Barbara 209 1,721 1,930
Santa Cruz 626 749 1,375
LBL 0 652 652
LLL 0 120 120
Los Alamos n/a 0 0
Other - UC 0 28,777 28,777
Stanford 208
Other-Network UC n/a 17,614 17,614
_______ ______ _____
11,813 219,069 231,090
Number of Records Displayed by database:
MAGS database 227,647
NEWS database 1,858
COMP database 2,869
Total number of Records Displayed 231,090
1.4 Relative Use of Databases
______________________________
Relative use of MAGS, NEWS, & COMP databases:
Percent of MAGS sessions 85.5%
Percent of NEWS sessions 10.1%
Percent of COMP sessions 4.4%
Percent of searches done in the MAGS database 85.0%
Percent of searches done in the NEWS database 11.8%
Percent of searches done in the COMP database 3.2%
1.5 Response time
__________________
Search response time from receipt of command at
DLA until transmission of response:
Average in seconds 0.6
Standard deviation in seconds 1.9
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.9
2.0 Magazines & Journals Database Statistics
_____________________________________________
Median session length (minutes:seconds) 6:12
Average session length (minutes:seconds) 12:29
Longest session recorded (minutes:seconds) 400:02
Average number of searches completed per session 2.6
Retrievals per search - median 7.0
Retrievals per search - average 811.2
Retrievals per search - standard deviation 11581
Percent of searches completed with 0 results 24.8%
Percent of searches entered that are long 1.2%
Percent of long searches completed
(includes partial results) 57.1%
Commands entered, by type, excluding errors:
Total Percentage
__________ __________
FIND 2,135 28.0%
DISPLAY (excluding automatic displays) 2,897 38.0%
HELP 150 2.0%
EXPLAIN 119 1.6%
SET/RESET 363 4.8%
SHOW 13 0.2%
ADD ON (AND, OR, AND NOT) 156 2.0%
LOGON or LOGOFF 1,132 14.9%
COMMENT 0 0.0%
SAVE 217 2.8%
USE 0 0.0%
OTHER 434 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 572 25.4% 122 21.3% 10 63.1 288.9
TITLE WORD 562 24.9% 157 27.9% 10 436.3 2872.1
EXACT TITLE 33 1.5% 13 39.4% 4 34.8 109.4
JOURNAL 164 7.3% 52 31.7% 992 6244.7 18092.1
EXACT JOURNAL 39 1.7% 10 25.6% 1,278 4891.2 11428.8
SUBJECT 309 13.7% 83 26.9% 35 221.4 691.6
EXACT SUBJECT 9 0.4% 4 44.4% 60 415.0 531.7
KEYWORD 457 20.3% 101 22.1% 25 1832.1 26603.8
SUBFILE 0 0.0% 0 0.0% 0 0.0 0.0
PUBLICATION TYPE 2 0.1% 0 0.0% 11 10.5 7.8
DATE 43 1.9% 5 11.6% 56 579.5 1001.5
ADDED 0 0.0% 0 0.0% 0 0.0 0.0
PERIODICAL 25 1.1% 7 28.0% 13 32.1 40.1
EXACT PE 15 0.7% 2 13.3% 5 13.2 16.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 23 1.0% 0 0.0% 2,135 3401.0 5364.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 132 6.2% 24 18.2% 24 949.4 2823.3
Single 1,983 93.8% 505 25.5% 18 1114.5 14211.0
DISPLAY commands, by type, excluding automatic displays:
REVIEW 2.8%
SHORT 61.4%
LONG 1.1%
FIELDS 1.0%
PERIODICALS 1.1%
COMMENTS 0.0%
Other 32.6%
2.1 Computer Articles Database Statistics
__________________________________________
Median session length (minutes:seconds) 5:39
Average session length (minutes:seconds) 9:47
Longest session recorded (minutes:seconds) 85:27
Average number of searches completed per session 2.0
Retrievals per search - median 8.0
Retrievals per search - average 296.4
Retrievals per search - standard deviation 951.4
Percent of searches completed with 0 results 25.3%
Percent of searches entered that are long 0.0%
Percent of long searches completed
(includes partial results) 0.0%
Commands entered, by type, excluding errors:
Total Percentage
__________ __________
FIND 72 20.9%
DISPLAY (excluding automatic displays) 122 35.5%
HELP 7 2.0%
EXPLAIN 6 1.7%
SET/RESET 19 5.5%
SHOW 0 0.0%
ADD ON (AND, OR, AND NOT) 15 4.4%
LOGON or LOGOFF 69 20.1%
COMMENT 0 0.0%
SAVE 11 3.2%
USE 0 0.0%
OTHER 23 6.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 5 6.5% 3 60.0% 2 1.5 0.7
TITLE WORD 11 14.3% 4 36.4% 6 806.6 2051.7
EXACT TITLE 0 0.0% 0 0.0% 0 0.0 0.0
JOURNAL 4 5.2% 3 75.0% 1,218 1218.0 0.0
EXACT JOURNAL 0 0.0% 0 0.0% 0 0.0 0.0
SUBJECT 16 20.8% 7 43.8% 7 210.9 591.9
EXACT SUBJECT 0 0.0% 0 0.0% 0 0.0 0.0
KEYWORD 36 46.8% 3 8.3% 79 498.7 1154.8
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 5 6.5% 2 40.0% 6 7.3 3.2
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
By number of indexes:
Multiple 5 6.9% 2 40.0% 6 7.3 3.2
Single 67 93.1% 18 26.9% 30 514.3 1228.3
DISPLAY commands, by type, excluding automatic displays:
REVIEW 2.7%
SHORT 56.3%
LONG 4.9%
FIELDS 6.0%
PERIODICALS 0.0%
COMMENTS 0.0%
Other 30.1%
2.1.1 Article Text
___________________
DISPLAY TEXT commands 613
TEXT included with CONTINUOUS, PRINT, CAPTURE, or SLOW 47
displays or when any of these paging options is set.
TEXT included with MAIL commands 151
SET DISPLAY TEXT commands 0
2.2 Newspaper Articles Database Statistics
___________________________________________
Median session length (minutes:seconds) 2:09
Average session length (minutes:seconds) 7:09
Longest session recorded (minutes:seconds) 93:25
Average number of searches completed per session 3.1
Retrievals per search - median 1.0
Retrievals per search - average 426.6
Retrievals per search - standard deviation 3285.7
Percent of searches completed with 0 results 42.2%
Percent of searches entered that are long 0.3%
Percent of long searches completed
(includes partial results) 0.0%
Commands entered, by type, excluding errors:
Total Percentage
__________ __________
FIND 315 40.6%
DISPLAY (excluding automatic displays) 199 25.7%
HELP 19 2.5%
EXPLAIN 24 3.1%
SET/RESET 38 4.9%
SHOW 1 0.1%
ADD ON (AND, OR, AND NOT) 2 0.3%
LOGON or LOGOFF 138 17.8%
COMMENT 0 0.0%
SAVE 15 1.9%
USE 0 0.0%
OTHER 24 3.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 28 8.2% 9 32.1% 123 698.7 924.3
TITLE WORD 175 51.2% 85 48.6% 5 206.6 1636.0
EXACT TITLE 6 1.8% 0 0.0% 6 6.8 6.7
JOURNAL 4 1.2% 4 100% 0 0.0 0.0
EXACT JOURNAL 0 0.0% 0 0.0% 0 0.0 0.0
SUBJECT 35 10.2% 16 45.7% 10 20.1 21.9
EXACT SUBJECT 0 0.0% 0 0.0% 0 0.0 0.0
KEYWORD 66 19.3% 12 18.2% 26 1893.1 7479.6
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 22 6.4% 4 18.2% 12 17.7 21.2
ADDED 0 0.0% 0 0.0% 0 0.0 0.0
PERIODICAL 6 1.8% 5 83.3% 5 5.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 31 10.0% 4 12.9% 19 48.9 57.6
Single 280 90.0% 127 45.4% 10 864.1 4667.1
DISPLAY commands, by type, excluding automatic displays:
REVIEW 4.6%
SHORT 46.4%
LONG 3.1%
FIELDS 0.2%
PERIODICALS 0.2%
COMMENTS 0.0%
Other 45.5%
2.3 Error, EXPLAIN and HELP statistics (MAGS, COMP, & NEWS)
_______________________________________ ____________________
Percent of commands that contained errors 11.4%
Ten most frequent errors:
1. First word of command is invalid 34.4%
2. NS command - no next screen 28.3%
3. FIND command with invalid index name 14.1%
4. PS command - no previous screen 3.4%
5. DISPLAY command contains invalid word 3.1%
6. Search term missing from search command 2.6%
7. Valid command at an inappropriate time 1.3%
8. DISPLAY command-record numbers too large 1.1%
9. 1243 0.9%
10. Command contains escape or arrow key 0.8%
11. All others 10.0%
Ten most frequent EXPLAIN requests:
1. GUIDE 38.3%
2. LOCATE (ARTICLE DBS) 11.4%
3. MAGS DATABASE 6.7%
4. INDEXES 6.7%
5. COMMANDS 6.0%
6. FIND 5.4%
7. 1242 3.4%
8. Unrecognized term 2.0%
9. DATABASES 2.0%
10. A014 1.3%
11. All others 16.8%
Ten most frequent HELP situations:
1. Help requested from SET DB command 29.2%
2. First word of command is invalid 17.5%
3. FIND command with invalid index name 10.8%
4. FIND command with zero results 7.4%
5. DISPLAY command - middle of >1 screen 4.3%
6. FIND command retrieves >1 book 3.4%
7. DISPLAY command-complete in one screen 3.4%
8. NS command - no next screen 3.1%
9. DISPLAY command-first of >1 screen 2.5%
10. 3 HELP commands issued from same code 1.8%
11. All others 16.6%
Ten most frequent SHOW requests:
1. HISTORY 64.3%
2. SETTINGS (IAC DBS) 14.3%
3. SEARCH 14.3%
4. MAIL STATUS 7.1%
11. All others 0.0%
IACmm/dd iac MELVYL IAC DATABASES TELNET STATISTICS (weekly)