MELVYL IAC DATABASES TELNET STATISTICS
Time period: 12/08/01 through 12/14/01
1.0 SUMMARY STATISTICS
_______________________
1.1 Total sessions:
____________________
Location Library Remote Total
________ _______ ______ _____
Berkeley 87 205 292
Davis 51 0 51
Irvine 80 0 80
Los Angeles 3 62 65
Riverside 9 11 20
San Diego 8 36 44
San Francisco 19 0 19
Santa Barbara 5 13 18
Santa Cruz 3 14 17
LBL 0 19 19
LLL 0 1 1
Los Alamos n/a 2 2
Other - UC 4 16 20
Stanford 0
Other-Network UC n/a 66 66
_______ ______ _____
269 445 714
Per hour usage:
Time Sessions Finds Records Displayed
__________ __________ __________ _________________
12-2 a.m. 11 22 201
2-4 a.m. 6 11 49
4-6 a.m. 8 11 89
6-8 a.m. 17 61 160
8-10 a.m. 69 177 1,427
10-12 a.m. 146 351 3,555
12-2 p.m. 122 327 107,353
2-4 p.m. 137 373 45,524
4-6 p.m. 101 268 39,735
6-8 p.m. 37 125 1,576
8-10 p.m. 36 105 1,757
10-12 p.m. 24 96 838
__________ __________ __________ _________________
Total: 714 1,927 202,264
1.2 FIND commands
__________________
Number of FIND commands issued by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 209 535 744
Davis 129 0 129
Irvine 232 0 232
Los Angeles 7 157 164
Riverside 31 41 72
San Diego 13 137 150
San Francisco 62 0 62
Santa Barbara 7 28 35
Santa Cruz 3 50 53
LBL 0 42 42
LLL 0 8 8
Los Alamos n/a 3 3
Other - UC 8 62 70
Stanford 0
Other-Network UC n/a 163 163
_______ ______ _____
701 1,226 1,927
Number of FIND commands by database
MAGS database 1,814
NEWS database 87
COMP database 26
Total number of FIND commands 1,927
1.3 Records displayed
______________________
Number of Records Displayed by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 2,850 5,655 8,505
Davis 1,582 0 1,582
Irvine 1,264 0 1,264
Los Angeles 160 3,236 3,396
Riverside 133 570 703
San Diego 161 181,711 181,872
San Francisco 913 0 913
Santa Barbara 93 253 346
Santa Cruz 32 800 832
LBL 0 478 478
LLL 0 107 107
Los Alamos n/a 16 16
Other - UC 66 324 390
Stanford 0
Other-Network UC n/a 1,860 1,860
_______ ______ _____
7,254 195,010 202,264
Number of Records Displayed by database:
MAGS database 201,445
NEWS database 687
COMP database 132
Total number of Records Displayed 202,264
1.4 Relative Use of Databases
______________________________
Relative use of MAGS, NEWS, & COMP databases:
Percent of MAGS sessions 89.8%
Percent of NEWS sessions 7.3%
Percent of COMP sessions 2.9%
Percent of searches done in the MAGS database 94.1%
Percent of searches done in the NEWS database 4.5%
Percent of searches done in the COMP database 1.3%
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.4
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.4
2.0 Magazines & Journals Database Statistics
_____________________________________________
Median session length (minutes:seconds) 4:54
Average session length (minutes:seconds) 13:43
Longest session recorded (minutes:seconds) 604:04
Average number of searches completed per session 2.8
Retrievals per search - median 5.0
Retrievals per search - average 411.8
Retrievals per search - standard deviation 2855.6
Percent of searches completed with 0 results 28.6%
Percent of searches entered that are long 1.6%
Percent of long searches completed
(includes partial results) 55.2%
Commands entered, by type, excluding errors:
Total Percentage
__________ __________
FIND 1,690 29.5%
DISPLAY (excluding automatic displays) 2,106 36.8%
HELP 142 2.5%
EXPLAIN 111 1.9%
SET/RESET 292 5.1%
SHOW 20 0.3%
ADD ON (AND, OR, AND NOT) 124 2.2%
LOGON or LOGOFF 818 14.3%
COMMENT 0 0.0%
SAVE 121 2.1%
USE 1 0.0%
OTHER 303 5.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 435 24.1% 122 28.0% 10 55.9 138.1
TITLE WORD 373 20.7% 102 27.3% 12 198.2 759.6
EXACT TITLE 68 3.8% 38 55.9% 2 50.5 155.5
JOURNAL 107 5.9% 40 37.4% 417 3292.4 6946.0
EXACT JOURNAL 91 5.0% 35 38.5% 1,037 3489.4 5990.2
SUBJECT 231 12.8% 84 36.4% 23 336.1 1041.8
EXACT SUBJECT 11 0.6% 4 36.4% 12 142.7 264.8
KEYWORD 302 16.7% 50 16.6% 23 726.5 5593.3
SUBFILE 0 0.0% 0 0.0% 0 0.0 0.0
PUBLICATION TYPE 7 0.4% 2 28.6% 11 201.6 349.4
DATE 74 4.1% 9 12.2% 137 671.5 1184.8
ADDED 0 0.0% 0 0.0% 0 0.0 0.0
PERIODICAL 27 1.5% 2 7.4% 6 275.1 622.1
EXACT PE 31 1.7% 5 16.1% 6 82.5 149.1
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 46 2.6% 21 45.6% 5 118.3 258.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 7.5% 29 23.0% 76 482.0 1015.1
Single 1,546 92.5% 452 29.2% 15 626.5 3625.0
DISPLAY commands, by type, excluding automatic displays:
REVIEW 2.8%
SHORT 57.6%
LONG 1.2%
FIELDS 1.4%
PERIODICALS 2.5%
COMMENTS 0.0%
Other 34.6%
2.1 Computer Articles Database Statistics
__________________________________________
Median session length (minutes:seconds) 2:40
Average session length (minutes:seconds) 5:12
Longest session recorded (minutes:seconds) 16:56
Average number of searches completed per session 1.2
Retrievals per search - median 4.5
Retrievals per search - average 572.8
Retrievals per search - standard deviation 2363.3
Percent of searches completed with 0 results 42.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 25 22.5%
DISPLAY (excluding automatic displays) 30 27.0%
HELP 8 7.2%
EXPLAIN 4 3.6%
SET/RESET 6 5.4%
SHOW 0 0.0%
ADD ON (AND, OR, AND NOT) 1 0.9%
LOGON or LOGOFF 28 25.2%
COMMENT 0 0.0%
SAVE 0 0.0%
USE 0 0.0%
OTHER 9 8.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 8 28.6% 5 62.5% 10 38.0 56.5
TITLE WORD 4 14.3% 1 25.0% 11 633.0 1079.9
EXACT TITLE 1 3.6% 1 100% 0 0.0 0.0
JOURNAL 0 0.0% 0 0.0% 0 0.0 0.0
EXACT JOURNAL 0 0.0% 0 0.0% 0 0.0 0.0
SUBJECT 3 10.7% 0 0.0% 676 4236.7 6736.2
EXACT SUBJECT 0 0.0% 0 0.0% 0 0.0 0.0
KEYWORD 9 32.1% 3 33.3% 13 28.3 32.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 3 10.7% 2 66.7% 10 10.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 3 12.0% 2 66.7% 10 10.0 0.0
Single 22 88.0% 8 36.4% 22 1063.1 3190.6
DISPLAY commands, by type, excluding automatic displays:
REVIEW 0.0%
SHORT 60.0%
LONG 4.0%
FIELDS 4.0%
PERIODICALS 0.0%
COMMENTS 0.0%
Other 32.0%
2.1.1 Article Text
___________________
DISPLAY TEXT commands 376
TEXT included with CONTINUOUS, PRINT, CAPTURE, or SLOW 42
displays or when any of these paging options is set.
TEXT included with MAIL commands 65
SET DISPLAY TEXT commands 0
2.2 Newspaper Articles Database Statistics
___________________________________________
Median session length (minutes:seconds) 2:37
Average session length (minutes:seconds) 13:03
Longest session recorded (minutes:seconds) 65:14
Average number of searches completed per session 1.7
Retrievals per search - median 2.0
Retrievals per search - average 513.7
Retrievals per search - standard deviation 2284.9
Percent of searches completed with 0 results 29.1%
Percent of searches entered that are long 4.6%
Percent of long searches completed
(includes partial results) 75.0%
Commands entered, by type, excluding errors:
Total Percentage
__________ __________
FIND 84 30.0%
DISPLAY (excluding automatic displays) 77 27.5%
HELP 5 1.8%
EXPLAIN 4 1.4%
SET/RESET 30 10.7%
SHOW 3 1.1%
ADD ON (AND, OR, AND NOT) 3 1.1%
LOGON or LOGOFF 61 21.8%
COMMENT 0 0.0%
SAVE 0 0.0%
USE 0 0.0%
OTHER 13 4.6%
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 13 14.8% 2 15.4% 4 459.9 1015.6
TITLE WORD 37 42.0% 15 40.5% 7 38.0 65.7
EXACT TITLE 2 2.3% 0 0.0% 1 1.0 0.0
JOURNAL 0 0.0% 0 0.0% 0 0.0 0.0
EXACT JOURNAL 1 1.1% 1 100% 0 0.0 0.0
SUBJECT 9 10.2% 2 22.2% 16 79.1 115.9
EXACT SUBJECT 0 0.0% 0 0.0% 0 0.0 0.0
KEYWORD 19 21.6% 5 26.3% 8 2688.9 5206.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 5 5.7% 0 0.0% 2 9.8 18.6
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 2 2.3% 0 0.0% 15 15.0 18.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
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 5 6.0% 0 0.0% 2 9.8 18.6
Single 78 94.0% 25 32.1% 7 831.6 2875.0
DISPLAY commands, by type, excluding automatic displays:
REVIEW 2.8%
SHORT 42.8%
LONG 5.5%
FIELDS 4.1%
PERIODICALS 1.4%
COMMENTS 0.0%
Other 43.4%
2.3 Error, EXPLAIN and HELP statistics (MAGS, COMP, & NEWS)
_______________________________________ ____________________
Percent of commands that contained errors 12.0%
Ten most frequent errors:
1. First word of command is invalid 34.7%
2. NS command - no next screen 24.7%
3. FIND command with invalid index name 13.7%
4. DISPLAY command contains invalid word 3.7%
5. PS command - no previous screen 3.5%
6. Search term missing from search command 2.2%
7. Valid command at an inappropriate time 1.6%
8. NS of SHOW/EXP command-no next screen 1.4%
9. 790 1.1%
10. Index invalid in current database 1.0%
11. All others 12.6%
Ten most frequent EXPLAIN requests:
1. GUIDE 22.7%
2. LOCATE (ARTICLE DBS) 16.8%
3. FIND 12.6%
4. COMMANDS 8.4%
5. DISPLAYS (IAC DBS) 5.9%
6. MAGS DATABASE 5.0%
7. INDEXES 5.0%
8. Unrecognized term 5.0%
9. MAIL 3.4%
10. ABI TEXT 2.5%
11. All others 12.6%
Ten most frequent HELP situations:
1. First word of command is invalid 23.7%
2. Help requested from SET DB command 20.1%
3. FIND command with zero results 10.2%
4. FIND command with invalid index name 8.8%
5. DISPLAY command-complete in one screen 7.7%
6. DISPLAY command - middle of >1 screen 5.5%
7. DISPLAY command-first of >1 screen 4.4%
8. DISPLAY command - last of >1 screen 2.9%
9. NS command - no next screen 2.6%
10. FIND command retrieves >1 book 2.6%
11. All others 11.7%
Ten most frequent SHOW requests:
1. HISTORY 43.5%
2. IAC NEWS 13.0%
3. TIMEOUT SETTING 8.7%
4. SEARCH 8.7%
5. SETTINGS (IAC DBS) 4.3%
6. UCB LIBRARY HOURS 4.3%
7. GLOSSARY 4.3%
8. 3002 4.3%
9. 5010 4.3%
10. 5040 4.3%
11. All others 0.0%
IACmm/dd iac MELVYL IAC DATABASES TELNET STATISTICS (weekly)