MELVYL IAC DATABASES TELNET STATISTICS
Time period: 06/15/02 through 06/21/02
1.0 SUMMARY STATISTICS
_______________________
1.1 Total sessions:
____________________
Location Library Remote Total
________ _______ ______ _____
Berkeley 21 120 141
Davis 26 0 26
Irvine 27 0 27
Los Angeles 2 24 26
Riverside 8 7 15
San Diego 11 28 39
San Francisco 15 0 15
Santa Barbara 3 10 13
Santa Cruz 4 4 8
LBL 0 7 7
LLL 0 3 3
Los Alamos n/a 0 0
Other - UC 0 16 16
Stanford 0
Other-Network UC n/a 49 49
_______ ______ _____
117 268 385
Per hour usage:
Time Sessions Finds Records Displayed
__________ __________ __________ _________________
12-2 a.m. 2 5 195
2-4 a.m. 3 8 49
4-6 a.m. 1 3 32
6-8 a.m. 8 16 127
8-10 a.m. 43 161 1,218
10-12 a.m. 94 324 4,242
12-2 p.m. 60 182 2,557
2-4 p.m. 99 233 4,168
4-6 p.m. 39 87 970
6-8 p.m. 12 35 407
8-10 p.m. 5 10 250
10-12 p.m. 19 51 259
__________ __________ __________ _________________
Total: 385 1,115 14,474
1.2 FIND commands
__________________
Number of FIND commands issued by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 42 411 453
Davis 90 0 90
Irvine 48 0 48
Los Angeles 12 44 56
Riverside 35 14 49
San Diego 67 48 115
San Francisco 30 0 30
Santa Barbara 4 13 17
Santa Cruz 6 6 12
LBL 0 13 13
LLL 0 9 9
Los Alamos n/a 0 0
Other - UC 0 43 43
Stanford 0
Other-Network UC n/a 180 180
_______ ______ _____
334 781 1,115
Number of FIND commands by database
MAGS database 1,037
NEWS database 68
COMP database 10
Total number of FIND commands 1,115
1.3 Records displayed
______________________
Number of Records Displayed by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 926 4,943 5,869
Davis 335 0 335
Irvine 250 0 250
Los Angeles 58 2,353 2,411
Riverside 549 115 664
San Diego 724 701 1,425
San Francisco 420 0 420
Santa Barbara 18 131 149
Santa Cruz 61 70 131
LBL 0 103 103
LLL 0 19 19
Los Alamos n/a 0 0
Other - UC 0 527 527
Stanford 0
Other-Network UC n/a 2,171 2,171
_______ ______ _____
3,341 11,133 14,474
Number of Records Displayed by database:
MAGS database 14,080
NEWS database 348
COMP database 46
Total number of Records Displayed 14,474
1.4 Relative Use of Databases
______________________________
Relative use of MAGS, NEWS, & COMP databases:
Percent of MAGS sessions 89.3%
Percent of NEWS sessions 8.8%
Percent of COMP sessions 1.8%
Percent of searches done in the MAGS database 93.0%
Percent of searches done in the NEWS database 6.1%
Percent of searches done in the COMP database 0.9%
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 4.6
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.6
2.0 Magazines & Journals Database Statistics
_____________________________________________
Median session length (minutes:seconds) 6:45
Average session length (minutes:seconds) 13:31
Longest session recorded (minutes:seconds) 170:26
Average number of searches completed per session 3.0
Retrievals per search - median 4.0
Retrievals per search - average 446.8
Retrievals per search - standard deviation 3271.4
Percent of searches completed with 0 results 32.6%
Percent of searches entered that are long 0.8%
Percent of long searches completed
(includes partial results) 87.5%
Commands entered, by type, excluding errors:
Total Percentage
__________ __________
FIND 979 28.4%
DISPLAY (excluding automatic displays) 1,245 36.1%
HELP 93 2.7%
EXPLAIN 56 1.6%
SET/RESET 142 4.1%
SHOW 15 0.4%
ADD ON (AND, OR, AND NOT) 58 1.7%
LOGON or LOGOFF 429 12.4%
COMMENT 0 0.0%
SAVE 147 4.3%
USE 2 0.1%
OTHER 282 8.2%
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 279 27.5% 104 37.3% 9 53.0 149.2
TITLE WORD 187 18.5% 63 33.7% 10 231.3 808.8
EXACT TITLE 15 1.5% 9 60.0% 6 36.8 54.7
JOURNAL 46 4.5% 19 41.3% 672 3268.2 5768.3
EXACT JOURNAL 27 2.7% 7 25.9% 3,084 10881.0 18867.8
SUBJECT 93 9.2% 27 29.0% 17 135.9 320.8
EXACT SUBJECT 7 0.7% 3 42.9% 3,937 3093.0 1688.0
KEYWORD 280 27.6% 91 32.5% 25 435.9 1931.3
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 8 0.8% 1 12.5% 98 186.6 314.1
ADDED 0 0.0% 0 0.0% 0 0.0 0.0
PERIODICAL 18 1.8% 4 22.2% 31 797.3 2841.2
EXACT PE 39 3.8% 6 15.4% 2 14.3 50.8
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 14 1.4% 6 42.9% 8 76.3 134.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 33 3.4% 17 51.5% 26 117.9 227.8
Single 945 96.6% 306 32.4% 14 716.0 4143.6
DISPLAY commands, by type, excluding automatic displays:
REVIEW 3.4%
SHORT 60.4%
LONG 1.7%
FIELDS 0.6%
PERIODICALS 3.6%
COMMENTS 0.0%
Other 30.3%
2.1 Computer Articles Database Statistics
__________________________________________
Median session length (minutes:seconds) 2:34
Average session length (minutes:seconds) 4:01
Longest session recorded (minutes:seconds) 13:09
Average number of searches completed per session 1.4
Retrievals per search - median 1.0
Retrievals per search - average 20.4
Retrievals per search - standard deviation 48.4
Percent of searches completed with 0 results 40.0%
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 8 26.7%
DISPLAY (excluding automatic displays) 4 13.3%
HELP 0 0.0%
EXPLAIN 0 0.0%
SET/RESET 3 10.0%
SHOW 0 0.0%
ADD ON (AND, OR, AND NOT) 2 6.7%
LOGON or LOGOFF 10 33.3%
COMMENT 0 0.0%
SAVE 0 0.0%
USE 0 0.0%
OTHER 3 10.0%
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 0 0.0% 0 0.0% 0 0.0 0.0
TITLE WORD 2 22.2% 0 0.0% 4 4.0 4.2
EXACT TITLE 0 0.0% 0 0.0% 0 0.0 0.0
JOURNAL 1 11.1% 1 100% 0 0.0 0.0
EXACT JOURNAL 0 0.0% 0 0.0% 0 0.0 0.0
SUBJECT 4 44.4% 1 25.0% 33 63.0 81.3
EXACT SUBJECT 1 11.1% 0 0.0% 7 7.0 0.0
KEYWORD 0 0.0% 0 0.0% 0 0.0 0.0
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 11.1% 0 0.0% 1 1.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 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 1 12.5% 0 0.0% 1 1.0 0.0
Single 7 87.5% 2 28.6% 7 40.6 65.1
DISPLAY commands, by type, excluding automatic displays:
REVIEW 0.0%
SHORT 38.5%
LONG 0.0%
FIELDS 7.7%
PERIODICALS 0.0%
COMMENTS 0.0%
Other 53.8%
2.1.1 Article Text
___________________
DISPLAY TEXT commands 245
TEXT included with CONTINUOUS, PRINT, CAPTURE, or SLOW 6
displays or when any of these paging options is set.
TEXT included with MAIL commands 104
SET DISPLAY TEXT commands 0
2.2 Newspaper Articles Database Statistics
___________________________________________
Median session length (minutes:seconds) 4:06
Average session length (minutes:seconds) 6:44
Longest session recorded (minutes:seconds) 25:02
Average number of searches completed per session 2.0
Retrievals per search - median 2.0
Retrievals per search - average 167.6
Retrievals per search - standard deviation 539.1
Percent of searches completed with 0 results 38.2%
Percent of searches entered that are long 1.5%
Percent of long searches completed
(includes partial results) 100%
Commands entered, by type, excluding errors:
Total Percentage
__________ __________
FIND 61 31.4%
DISPLAY (excluding automatic displays) 45 23.2%
HELP 4 2.1%
EXPLAIN 3 1.5%
SET/RESET 16 8.2%
SHOW 2 1.0%
ADD ON (AND, OR, AND NOT) 7 3.6%
LOGON or LOGOFF 40 20.6%
COMMENT 0 0.0%
SAVE 0 0.0%
USE 0 0.0%
OTHER 16 8.2%
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 12 17.4% 6 50.0% 11 531.3 825.7
TITLE WORD 24 34.8% 12 50.0% 19 72.7 111.9
EXACT TITLE 3 4.3% 2 66.7% 391 391.0 0.0
JOURNAL 0 0.0% 0 0.0% 0 0.0 0.0
EXACT JOURNAL 2 2.9% 2 100% 0 0.0 0.0
SUBJECT 7 10.1% 1 14.3% 175 732.0 1506.9
EXACT SUBJECT 1 1.4% 0 0.0% 332 332.0 0.0
KEYWORD 13 18.8% 3 23.1% 16 131.6 208.7
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 7.2% 1 20.0% 32 222.3 402.2
ADDED 0 0.0% 0 0.0% 0 0.0 0.0
PERIODICAL 1 1.4% 0 0.0% 10 10.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 1 1.4% 0 0.0% 1 1.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 8 13.1% 3 37.5% 2 17.0 26.7
Single 53 86.9% 21 39.6% 93 350.7 750.1
DISPLAY commands, by type, excluding automatic displays:
REVIEW 13.8%
SHORT 34.0%
LONG 2.1%
FIELDS 4.3%
PERIODICALS 1.1%
COMMENTS 0.0%
Other 44.7%
2.3 Error, EXPLAIN and HELP statistics (MAGS, COMP, & NEWS)
_______________________________________ ____________________
Percent of commands that contained errors 10.5%
Ten most frequent errors:
1. First word of command is invalid 31.6%
2. NS command - no next screen 28.4%
3. FIND command with invalid index name 13.6%
4. PS command - no previous screen 3.2%
5. Search term missing from search command 3.0%
6. DISPLAY command contains invalid word 2.1%
7. NS of SHOW/EXP command-no next screen 2.1%
8. Index invalid in current database 1.6%
9. Invalid SET DATABASE command issued 1.4%
10. Add-on search, no index name after verb 1.4%
11. All others 11.5%
Ten most frequent EXPLAIN requests:
1. LOCATE (ARTICLE DBS) 28.8%
2. FIND 16.9%
3. GUIDE 15.3%
4. COMMANDS 10.2%
5. INDEXES 6.8%
6. DISPLAYS (IAC DBS) 5.1%
7. 5341 3.4%
8. MAGS DATABASE 1.7%
9. NEWS DATABASE 1.7%
10. FULL TEXT 1.7%
11. All others 8.5%
Ten most frequent HELP situations:
1. First word of command is invalid 21.8%
2. Help requested from SET DB command 14.1%
3. FIND command with invalid index name 12.2%
4. FIND command with zero results 8.3%
5. DISPLAY command-first of >1 screen 8.3%
6. DISPLAY command-complete in one screen 6.4%
7. DISPLAY command - middle of >1 screen 4.5%
8. NS of SHOW/EXP command-no next screen 3.8%
9. NS command - no next screen 2.6%
10. PS command - no previous screen 1.9%
11. All others 16.0%
Ten most frequent SHOW requests:
1. SEARCH 58.8%
2. HISTORY 29.4%
3. SETTINGS (IAC DBS) 5.9%
4. GLOSSARY 5.9%
11. All others 0.0%
IACmm/dd iac MELVYL IAC DATABASES TELNET STATISTICS (weekly)