MELVYL IAC DATABASES TELNET STATISTICS
Time period: 12/01/01 through 12/31/01
1.0 SUMMARY STATISTICS
_______________________
1.1 Total sessions:
____________________
Location Library Remote Total
________ _______ ______ _____
Berkeley 296 716 1,012
Davis 336 4 340
Irvine 237 0 237
Los Angeles 5 197 202
Riverside 54 43 97
San Diego 46 119 165
San Francisco 76 0 76
Santa Barbara 21 57 78
Santa Cruz 13 104 117
LBL 0 25 25
LLL 0 11 11
Los Alamos n/a 6 6
Other - UC 5 93 98
Stanford 18
Other-Network UC n/a 286 286
_______ ______ _____
1,089 1,661 2,768
Per hour usage:
Time Sessions Finds Records Displayed
__________ __________ __________ _________________
12-2 a.m. 62 163 3,571
2-4 a.m. 35 83 1,285
4-6 a.m. 27 53 686
6-8 a.m. 55 159 1,179
8-10 a.m. 256 610 5,107
10-12 a.m. 477 1,267 182,559
12-2 p.m. 483 1,463 253,375
2-4 p.m. 594 1,773 102,418
4-6 p.m. 369 958 48,888
6-8 p.m. 180 500 6,382
8-10 p.m. 137 499 6,129
10-12 p.m. 93 343 3,631
__________ __________ __________ _________________
Total: 2,768 7,871 615,210
1.2 FIND commands
__________________
Number of FIND commands issued by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 733 1,978 2,711
Davis 972 7 979
Irvine 903 0 903
Los Angeles 11 592 603
Riverside 125 170 295
San Diego 64 417 481
San Francisco 181 0 181
Santa Barbara 45 135 180
Santa Cruz 32 250 282
LBL 0 53 53
LLL 0 49 49
Los Alamos n/a 24 24
Other - UC 10 340 350
Stanford 52
Other-Network UC n/a 728 728
_______ ______ _____
3,076 4,743 7,871
Number of FIND commands by database
MAGS database 7,193
NEWS database 426
COMP database 252
Total number of FIND commands 7,871
1.3 Records displayed
______________________
Number of Records Displayed by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 12,343 19,192 31,535
Davis 8,762 220 8,982
Irvine 4,289 0 4,289
Los Angeles 375 8,859 9,234
Riverside 765 1,713 2,478
San Diego 505 531,872 532,377
San Francisco 2,231 0 2,231
Santa Barbara 609 3,621 4,230
Santa Cruz 172 3,462 3,634
LBL 0 578 578
LLL 0 882 882
Los Alamos n/a 462 462
Other - UC 111 3,276 3,387
Stanford 52
Other-Network UC n/a 10,567 10,567
_______ ______ _____
30,162 584,704 614,918
Number of Records Displayed by database:
MAGS database 568,968
NEWS database 4,455
COMP database 41,787
Total number of Records Displayed 614,918
1.4 Relative Use of Databases
______________________________
Relative use of MAGS, NEWS, & COMP databases:
Percent of MAGS sessions 87.8%
Percent of NEWS sessions 8.2%
Percent of COMP sessions 4.0%
Percent of searches done in the MAGS database 91.4%
Percent of searches done in the NEWS database 5.4%
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 3.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 3.4
2.0 Magazines & Journals Database Statistics
_____________________________________________
Median session length (minutes:seconds) 5:30
Average session length (minutes:seconds) 14:26
Longest session recorded (minutes:seconds) 712:03
Average number of searches completed per session 2.9
Retrievals per search - median 5.0
Retrievals per search - average 626.3
Retrievals per search - standard deviation 7080.6
Percent of searches completed with 0 results 29.9%
Percent of searches entered that are long 1.3%
Percent of long searches completed
(includes partial results) 58.8%
Commands entered, by type, excluding errors:
Total Percentage
__________ __________
FIND 6,670 30.1%
DISPLAY (excluding automatic displays) 8,203 37.0%
HELP 560 2.5%
EXPLAIN 435 2.0%
SET/RESET 1,017 4.6%
SHOW 83 0.4%
ADD ON (AND, OR, AND NOT) 523 2.4%
LOGON or LOGOFF 3,173 14.3%
COMMENT 0 0.0%
SAVE 425 1.9%
USE 4 0.0%
OTHER 1,067 4.8%
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,685 23.9% 432 25.6% 11 57.5 212.7
TITLE WORD 1,611 22.8% 507 31.5% 10 323.3 3914.9
EXACT TITLE 237 3.4% 123 51.9% 3 73.9 548.1
JOURNAL 423 6.0% 167 39.5% 966 6068.5 22232.5
EXACT JOURNAL 220 3.1% 93 42.3% 1,125 5526.4 9404.0
SUBJECT 1,170 16.6% 427 36.5% 37 261.3 825.7
EXACT SUBJECT 42 0.6% 11 26.2% 67 517.9 994.6
KEYWORD 1,155 16.4% 226 19.6% 26 1310.8 11654.1
SUBFILE 0 0.0% 0 0.0% 0 0.0 0.0
PUBLICATION TYPE 18 0.3% 2 11.1% 25 234.4 469.6
DATE 187 2.7% 29 15.5% 83 477.0 924.5
ADDED 0 0.0% 0 0.0% 0 0.0 0.0
PERIODICAL 132 1.9% 35 26.5% 12 196.5 531.5
EXACT PE 63 0.9% 12 19.0% 5 72.1 204.3
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 112 1.6% 36 32.1% 146 1988.5 5974.7
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 405 6.1% 108 26.7% 29 687.7 3164.1
Single 6,214 93.9% 1,878 30.2% 18 908.2 8167.6
DISPLAY commands, by type, excluding automatic displays:
REVIEW 3.1%
SHORT 58.5%
LONG 2.0%
FIELDS 0.9%
PERIODICALS 1.7%
COMMENTS 0.0%
Other 33.9%
2.1 Computer Articles Database Statistics
__________________________________________
Median session length (minutes:seconds) 6:37
Average session length (minutes:seconds) 12:30
Longest session recorded (minutes:seconds) 90:33
Average number of searches completed per session 2.3
Retrievals per search - median 10.5
Retrievals per search - average 1331.4
Retrievals per search - standard deviation 10746
Percent of searches completed with 0 results 32.4%
Percent of searches entered that are long 9.1%
Percent of long searches completed
(includes partial results) 91.3%
Commands entered, by type, excluding errors:
Total Percentage
__________ __________
FIND 219 20.8%
DISPLAY (excluding automatic displays) 446 42.3%
HELP 28 2.7%
EXPLAIN 38 3.6%
SET/RESET 58 5.5%
SHOW 2 0.2%
ADD ON (AND, OR, AND NOT) 33 3.1%
LOGON or LOGOFF 128 12.1%
COMMENT 0 0.0%
SAVE 48 4.5%
USE 1 0.1%
OTHER 54 5.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 22 9.1% 11 50.0% 10 176.0 445.8
TITLE WORD 50 20.7% 13 26.0% 59 492.6 1350.9
EXACT TITLE 4 1.7% 3 75.0% 1 1.0 0.0
JOURNAL 11 4.6% 5 45.5% 7,112 37771.8 61492.9
EXACT JOURNAL 0 0.0% 0 0.0% 0 0.0 0.0
SUBJECT 75 31.1% 22 29.3% 65 351.7 1650.4
EXACT SUBJECT 0 0.0% 0 0.0% 0 0.0 0.0
KEYWORD 59 24.5% 18 30.5% 85 644.5 1399.4
SUBFILE 0 0.0% 0 0.0% 0 0.0 0.0
PUBLICATION TYPE 2 0.8% 0 0.0% 77 76.5 58.7
DATE 12 5.0% 4 33.3% 63 80.3 100.9
ADDED 0 0.0% 0 0.0% 0 0.0 0.0
PERIODICAL 4 1.7% 1 25.0% 3 5.7 5.5
EXACT PE 1 0.4% 0 0.0% 274 274.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.4% 0 0.0% 146 146.0 0.0
By number of indexes:
Multiple 24 11.1% 5 20.8% 60 102.6 147.0
Single 193 88.9% 67 34.7% 70 2295.2 14730.4
DISPLAY commands, by type, excluding automatic displays:
REVIEW 7.2%
SHORT 64.4%
LONG 0.9%
FIELDS 1.4%
PERIODICALS 1.2%
COMMENTS 0.0%
Other 25.0%
2.1.1 Article Text
___________________
DISPLAY TEXT commands 1,749
TEXT included with CONTINUOUS, PRINT, CAPTURE, or SLOW 167
displays or when any of these paging options is set.
TEXT included with MAIL commands 247
SET DISPLAY TEXT commands 0
2.2 Newspaper Articles Database Statistics
___________________________________________
Median session length (minutes:seconds) 3:13
Average session length (minutes:seconds) 10:07
Longest session recorded (minutes:seconds) 114:10
Average number of searches completed per session 1.9
Retrievals per search - median 4.0
Retrievals per search - average 276.3
Retrievals per search - standard deviation 1637.3
Percent of searches completed with 0 results 30.5%
Percent of searches entered that are long 2.1%
Percent of long searches completed
(includes partial results) 66.7%
Commands entered, by type, excluding errors:
Total Percentage
__________ __________
FIND 403 30.4%
DISPLAY (excluding automatic displays) 348 26.3%
HELP 40 3.0%
EXPLAIN 30 2.3%
SET/RESET 127 9.6%
SHOW 9 0.7%
ADD ON (AND, OR, AND NOT) 23 1.7%
LOGON or LOGOFF 254 19.2%
COMMENT 0 0.0%
SAVE 7 0.5%
USE 0 0.0%
OTHER 83 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 75 14.8% 20 26.7% 11 369.2 725.0
TITLE WORD 139 27.5% 45 32.4% 10 99.1 311.9
EXACT TITLE 18 3.6% 10 55.6% 1 26.4 68.6
JOURNAL 4 0.8% 2 50.0% 6,256 6255.5 8650.0
EXACT JOURNAL 38 7.5% 5 13.2% 10 34.2 71.6
SUBJECT 82 16.2% 29 35.4% 35 593.6 3067.5
EXACT SUBJECT 0 0.0% 0 0.0% 0 0.0 0.0
KEYWORD 77 15.2% 20 26.0% 11 737.4 2756.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 67 13.2% 6 9.0% 7 47.0 171.5
ADDED 2 0.4% 2 100% 0 0.0 0.0
PERIODICAL 1 0.2% 0 0.0% 86 86.0 0.0
EXACT PE 3 0.6% 0 0.0% 28 26.3 23.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 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 77 19.2% 12 15.6% 7 51.7 168.0
Single 323 80.7% 113 35.0% 20 538.3 2294.9
DISPLAY commands, by type, excluding automatic displays:
REVIEW 5.4%
SHORT 42.4%
LONG 2.7%
FIELDS 1.8%
PERIODICALS 0.8%
COMMENTS 0.0%
Other 47.0%
2.3 Error, EXPLAIN and HELP statistics (MAGS, COMP, & NEWS)
_______________________________________ ____________________
Percent of commands that contained errors 11.5%
Ten most frequent errors:
1. First word of command is invalid 33.6%
2. NS command - no next screen 26.5%
3. FIND command with invalid index name 12.3%
4. PS command - no previous screen 3.6%
5. DISPLAY command contains invalid word 3.1%
6. Valid command at an inappropriate time 2.2%
7. Search term missing from search command 2.2%
8. DISPLAY command - no FIND results 1.5%
9. NS of SHOW/EXP command-no next screen 1.0%
10. Index invalid in current database 0.9%
11. All others 13.2%
Ten most frequent EXPLAIN requests:
1. GUIDE 24.3%
2. LOCATE (ARTICLE DBS) 15.7%
3. FIND 11.5%
4. COMMANDS 8.9%
5. INDEXES 7.6%
6. Unrecognized term 5.2%
7. MAGS DATABASE 4.0%
8. DISPLAYS (IAC DBS) 2.4%
9. MAIL 2.2%
10. ADDON SEARCH 1.8%
11. All others 16.5%
Ten most frequent HELP situations:
1. Help requested from SET DB command 23.8%
2. First word of command is invalid 19.5%
3. FIND command with invalid index name 10.5%
4. FIND command with zero results 7.8%
5. DISPLAY command-complete in one screen 5.6%
6. DISPLAY command-first of >1 screen 5.0%
7. DISPLAY command - middle of >1 screen 5.0%
8. NS command - no next screen 2.6%
9. FIND command retrieves >1 book 2.5%
10. PS command - no previous screen 1.7%
11. All others 16.2%
Ten most frequent SHOW requests:
1. HISTORY 38.3%
2. SEARCH 18.1%
3. IAC NEWS 17.0%
4. SETTINGS (IAC DBS) 6.4%
5. GLOSSARY 3.2%
6. MAIL SETTINGS 3.2%
7. UCB LIBRARY HOURS 2.1%
8. TIMEOUT SETTING 2.1%
9. DATABASES 2.1%
10. STANFORD UNIVERSITY PASSWORDS 1.1%
11. All others 6.4%
IACmm/dd iac MELVYL IAC DATABASES TELNET STATISTICS (weekly)