MELVYL CURRENT CONTENTS DATABASE TELNET STATISTICS
Time period: 06/01/02 through 06/30/02
1.0 SUMMARY STATISTICS
_______________________
1.1 Total sessions:
____________________
Location Library Remote Total
________ _______ ______ _____
Berkeley 72 1,494 1,566
Davis 735 41 776
Irvine 361 0 361
Los Angeles 0 574 574
Riverside 39 136 175
San Diego 113 527 640
San Francisco 381 0 381
Santa Barbara 8 223 231
Santa Cruz 17 142 159
LBL 0 392 392
LLL 0 119 119
Los Alamos n/a 0 0
Other - UC 0 181 181
U.S. Forestry 0
Other-Network UC n/a 886 886
_______ ______ _____
1,726 4,715 6,441
Per hour usage:
Time Sessions Finds Records Displayed
__________ __________ __________ _________________
12-2 a.m. 118 413 2,714
2-4 a.m. 67 375 2,581
4-6 a.m. 61 159 1,641
6-8 a.m. 151 368 3,209
8-10 a.m. 695 2,102 15,593
10-12 a.m. 1,350 4,499 36,335
12-2 p.m. 1,157 3,627 35,710
2-4 p.m. 1,236 3,245 32,656
4-6 p.m. 898 2,319 25,024
6-8 p.m. 328 971 8,466
8-10 p.m. 215 891 8,794
10-12 p.m. 165 536 6,063
__________ __________ __________ _________________
Total: 6,441 19,505 178,786
1.2 FIND commands
__________________
Number of FIND commands issued by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 138 4,680 4,818
Davis 2,124 109 2,233
Irvine 1,206 0 1,206
Los Angeles 0 1,751 1,751
Riverside 107 442 549
San Diego 282 1,398 1,680
San Francisco 1,964 0 1,964
Santa Barbara 10 806 816
Santa Cruz 34 478 512
LBL 0 858 858
LLL 0 284 284
Los Alamos n/a 0 0
Other - UC 5 527 532
U.S. Forestry 0
Other-Network UC n/a 2,302 2,302
_______ ______ _____
5,870 13,635 19,505
Number of FIND commands by database
CC database 19,122
CCT database 383
Total number of FIND commands 19,505
1.3 Records displayed
______________________
Number of Records Displayed by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 1,411 47,912 49,323
Davis 20,148 504 20,652
Irvine 9,183 0 9,183
Los Angeles 0 18,495 18,495
Riverside 991 3,686 4,677
San Diego 2,066 12,226 14,292
San Francisco 10,976 0 10,976
Santa Barbara 43 9,655 9,698
Santa Cruz 251 5,086 5,337
LBL 0 9,199 9,199
LLL 0 4,819 4,819
Los Alamos n/a 0 0
Other - UC 6 6,406 6,412
U.S. Forestry 0
Other-Network UC n/a 15,723 15,723
_______ ______ _____
45,075 133,711 178,786
Number of Records Displayed by database:
CC database 165,190
CCT database 13,596
Total number of Records Displayed 178,786
1.4 Relative Use of Databases
______________________________
Relative use of CC vs. CCT databases:
Percent of CC sessions 96.3%
Percent of CCT sessions 3.7%
Percent of searches done in the CC database 98.0%
Percent of searches done in the CCT database 2.0%
1.5 Response time
__________________
Search response time from receipt of command at
DLA until transmission of response:
Average in seconds 1.0
Standard deviation in seconds 4.3
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.3
2.0 CC Database Statistics
___________________________
Median session length (minutes:seconds) 0:00
Average session length (minutes:seconds) 0:00
Longest session recorded (minutes:seconds) 593:00
Average number of searches completed per session 3.1
Retrievals per search - median 9.0
Retrievals per search - average 457.3
Retrievals per search - standard deviation 5087.9
Percent of searches completed with 0 results 20.0%
Percent of searches entered that are long 0.4%
Percent of long searches completed
(includes partial results) 79.0%
Commands entered, by type, excluding errors:
Total Percentage
__________ __________
FIND 17,414 36.5%
DISPLAY (excluding automatic displays) 14,461 30.3%
HELP 308 0.6%
EXPLAIN 352 0.7%
SET/RESET 2,360 4.9%
SHOW 61 0.1%
ADD ON (AND, OR, AND NOT) 1,708 3.6%
LOGON or LOGOFF 8,101 17.0%
COMMENT 0 0.0%
SAVE 887 1.9%
USE 8 0.0%
OTHER 2,063 4.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 8,425 43.7% 1,168 13.9% 29 167.5 891.4
TITLE WORD 5,651 29.3% 1,699 30.1% 12 576.3 3540.6
EXACT TITLE 308 1.6% 130 42.2% 3 33.2 152.9
JOURNAL 899 4.7% 273 30.4% 1,005 4109.9 21731.2
EXACT JOURNAL 516 2.7% 134 26.0% 1,962 5640.3 17295.7
SUBJECT CAT 72 0.4% 8 11.1% 12 84.4 494.0
SUBFILE 53 0.3% 1 1.9% 16 144.9 531.4
PUBLICATION TYPE 69 0.4% 7 10.1% 25 55.0 118.0
LANGUAGE 30 0.2% 2 6.7% 5 224.4 601.3
DATE 486 2.5% 72 14.8% 5 164.4 663.3
ADDED 224 1.2% 61 27.2% 3 7.8 12.0
PERIODICAL 1,464 7.6% 136 9.3% 4 29.5 100.7
EXACT PE 306 1.6% 25 8.2% 3 25.5 133.8
RPE 1 0.0% 0 0.0% 756 756.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 760 3.9% 236 31.1% 19 622.7 3888.2
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 1,827 10.5% 471 25.8% 4 94.8 475.9
Single 15,532 89.5% 2,993 19.3% 28 672.6 6256.1
DISPLAY commands, by type, excluding automatic displays:
REVIEW 3.2%
SHORT 72.9%
LONG 4.1%
FIELDS 2.6%
PERIODICALS 15.6%
COMMENTS 0.0%
Other 1.6%
2.1 CCT Database Statistics
____________________________
Median session length (minutes:seconds) 0:00
Average session length (minutes:seconds) 0:00
Longest session recorded (minutes:seconds) 75:33
Average number of searches completed per session 1.6
Retrievals per search - median 57.0
Retrievals per search - average 301.0
Retrievals per search - standard deviation 1445.3
Percent of searches completed with 0 results 26.1%
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 381 23.2%
DISPLAY (excluding automatic displays) 678 41.3%
HELP 84 5.1%
EXPLAIN 37 2.3%
SET/RESET 163 9.9%
SHOW 12 0.7%
ADD ON (AND, OR, AND NOT) 2 0.1%
LOGON or LOGOFF 228 13.9%
COMMENT 0 0.0%
SAVE 0 0.0%
USE 0 0.0%
OTHER 58 3.5%
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:
JOURNAL 235 61.0% 73 31.1% 136 469.6 2152.5
EXACT JOURNAL 107 27.8% 25 23.4% 202 431.7 622.8
SUBJECT CAT 3 0.8% 0 0.0% 181 204.7 133.1
SUBFILE 0 0.0% 0 0.0% 0 0.0 0.0
DATE 0 0.0% 0 0.0% 0 0.0 0.0
ADDED 3 0.8% 0 0.0% 181 204.7 133.1
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 37 9.6% 2 5.4% 4 9.4 14.1
By number of indexes:
Multiple 4 1.0% 0 0.0% 133 155.0 147.2
Single 377 98.9% 100 26.5% 129 403.6 1684.6
DISPLAY commands, by type, excluding automatic displays:
REVIEW 9.5%
ISSUES 39.3%
SHORT 26.2%
LONG 18.6%
PERIODICALS 5.8%
COMMENTS 0.0%
Other 0.5%
2.3 Error, EXPLAIN and HELP statistics (CC & CCT)
__________________________________________________
Percent of commands that contained errors 7.4%
Ten most frequent errors:
1. NS command - no next screen 30.1%
2. First word of command is invalid 29.3%
3. FIND command with invalid index name 9.9%
4. DISPLAY command - no FIND results 3.2%
5. DISPLAY command contains invalid word 3.1%
6. Index invalid in current database 3.1%
7. PS command - no previous screen 2.7%
8. Search term missing from search command 2.2%
9. Valid command at an inappropriate time 1.3%
10. 167 1.1%
11. All others 14.0%
Ten most frequent EXPLAIN requests:
1. CC GUIDE 15.7%
2. FIND (CC DB) 14.4%
3. CC INDEXES 10.5%
4. Unrecognized term 6.9%
5. LOCATE (ARTICLE DBS) 6.2%
6. COMMANDS 3.9%
7. MAIL 3.3%
8. DATABASES 3.3%
9. DISPLAY 3.3%
10. CC DATABASE 3.1%
11. All others 29.3%
Ten most frequent HELP situations:
1. First word of command is invalid 15.4%
2. Help requested from START CC command 15.1%
3. F/BR with index invalid in current DB 6.9%
4. FIND command with invalid index name 6.8%
5. Help requested from SET DB command 6.1%
6. DISPLAY command-first of >1 screen 6.0%
7. FIND command with zero results 5.0%
8. DISPLAY command - middle of >1 screen 4.2%
9. DISPLAY command-complete in one screen 3.3%
10. FIND command retrieves >1 book 3.2%
11. All others 27.9%
Ten most frequent SHOW requests:
1. HISTORY 54.9%
2. SYSTEM NEWS 12.7%
3. CC NEWS 12.7%
4. MAIL STATUS 7.0%
5. CC GLOSSARY 2.8%
6. SEARCH 2.8%
7. IAC STATISTICS 1.4%
8. GLOSSARY 1.4%
9. LIBRARY LOCATIONS 1.4%
10. CCT SETTINGS 1.4%
11. All others 1.4%
Cmm/yy cc MELVYL CURRENT CONTENTS DATABASE TELNET STATISTICS (monthly)