MELVYL CURRENT CONTENTS DATABASE TELNET STATISTICS
Time period: 05/25/02 through 05/31/02
1.0 SUMMARY STATISTICS
_______________________
1.1 Total sessions:
____________________
Location Library Remote Total
________ _______ ______ _____
Berkeley 21 370 391
Davis 152 13 165
Irvine 108 0 108
Los Angeles 0 168 168
Riverside 8 22 30
San Diego 34 106 140
San Francisco 84 0 84
Santa Barbara 8 54 62
Santa Cruz 7 31 38
LBL 0 90 90
LLL 0 46 46
Los Alamos n/a 0 0
Other - UC 0 45 45
U.S. Forestry 0
Other-Network UC n/a 186 186
_______ ______ _____
422 1,131 1,553
Per hour usage:
Time Sessions Finds Records Displayed
__________ __________ __________ _________________
12-2 a.m. 34 153 1,187
2-4 a.m. 24 56 382
4-6 a.m. 21 58 227
6-8 a.m. 48 111 1,078
8-10 a.m. 164 457 3,955
10-12 a.m. 258 998 7,964
12-2 p.m. 270 797 7,507
2-4 p.m. 321 1,015 7,776
4-6 p.m. 213 503 3,857
6-8 p.m. 95 321 2,291
8-10 p.m. 73 184 2,685
10-12 p.m. 32 109 667
__________ __________ __________ _________________
Total: 1,553 4,762 39,576
1.2 FIND commands
__________________
Number of FIND commands issued by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 39 1,073 1,112
Davis 442 22 464
Irvine 336 0 336
Los Angeles 0 455 455
Riverside 14 177 191
San Diego 120 227 347
San Francisco 597 0 597
Santa Barbara 7 154 161
Santa Cruz 13 66 79
LBL 0 190 190
LLL 0 127 127
Los Alamos n/a 0 0
Other - UC 0 179 179
U.S. Forestry 0
Other-Network UC n/a 524 524
_______ ______ _____
1,568 3,194 4,762
Number of FIND commands by database
CC database 4,698
CCT database 64
Total number of FIND commands 4,762
1.3 Records displayed
______________________
Number of Records Displayed by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 222 8,930 9,152
Davis 3,335 81 3,416
Irvine 2,471 0 2,471
Los Angeles 0 5,202 5,202
Riverside 35 898 933
San Diego 878 1,578 2,456
San Francisco 2,631 0 2,631
Santa Barbara 10 1,216 1,226
Santa Cruz 320 481 801
LBL 0 2,771 2,771
LLL 0 1,870 1,870
Los Alamos n/a 0 0
Other - UC 0 1,891 1,891
U.S. Forestry 0
Other-Network UC n/a 4,756 4,756
_______ ______ _____
9,902 29,674 39,576
Number of Records Displayed by database:
CC database 37,407
CCT database 2,169
Total number of Records Displayed 39,576
1.4 Relative Use of Databases
______________________________
Relative use of CC vs. CCT databases:
Percent of CC sessions 95.9%
Percent of CCT sessions 4.1%
Percent of searches done in the CC database 98.7%
Percent of searches done in the CCT database 1.3%
1.5 Response time
__________________
Search response time from receipt of command at
DLA until transmission of response:
Average in seconds 0.9
Standard deviation in seconds 3.7
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.7
2.0 CC Database Statistics
___________________________
Median session length (minutes:seconds) 0:00
Average session length (minutes:seconds) 0:00
Longest session recorded (minutes:seconds) 282:51
Average number of searches completed per session 3.1
Retrievals per search - median 7.0
Retrievals per search - average 448.3
Retrievals per search - standard deviation 3496.1
Percent of searches completed with 0 results 20.9%
Percent of searches entered that are long 0.9%
Percent of long searches completed
(includes partial results) 70.0%
Commands entered, by type, excluding errors:
Total Percentage
__________ __________
FIND 4,218 37.0%
DISPLAY (excluding automatic displays) 3,300 29.0%
HELP 75 0.7%
EXPLAIN 78 0.7%
SET/RESET 563 4.9%
SHOW 19 0.2%
ADD ON (AND, OR, AND NOT) 480 4.2%
LOGON or LOGOFF 1,950 17.1%
COMMENT 0 0.0%
SAVE 222 1.9%
USE 1 0.0%
OTHER 483 4.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 1,990 42.6% 304 15.3% 23 138.9 680.4
TITLE WORD 1,285 27.5% 398 31.0% 12 910.9 5468.3
EXACT TITLE 72 1.5% 34 47.2% 3 14.0 35.9
JOURNAL 174 3.7% 51 29.3% 953 3298.1 6972.8
EXACT JOURNAL 143 3.1% 25 17.5% 1,017 3133.2 6909.5
SUBJECT CAT 28 0.6% 5 17.9% 7 36.5 84.1
SUBFILE 12 0.3% 1 8.3% 37 75.8 72.2
PUBLICATION TYPE 7 0.1% 1 14.3% 3 6.8 7.6
LANGUAGE 12 0.3% 1 8.3% 3 5.6 6.9
DATE 122 2.6% 17 13.9% 14 198.7 414.7
ADDED 17 0.4% 7 41.2% 2 2.6 1.5
PERIODICAL 476 10.2% 65 13.7% 4 163.4 1797.6
EXACT PE 100 2.1% 11 11.0% 3 12.4 26.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 230 4.9% 62 27.0% 14 888.0 9103.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 448 10.7% 128 28.6% 6 77.8 253.6
Single 3,747 89.3% 721 19.2% 19 663.7 4303.0
DISPLAY commands, by type, excluding automatic displays:
REVIEW 3.4%
SHORT 70.6%
LONG 3.0%
FIELDS 1.0%
PERIODICALS 20.4%
COMMENTS 0.0%
Other 1.5%
2.1 CCT Database Statistics
____________________________
Median session length (minutes:seconds) 0:00
Average session length (minutes:seconds) 0:00
Longest session recorded (minutes:seconds) 70:34
Average number of searches completed per session 1.0
Retrievals per search - median 48.5
Retrievals per search - average 360.0
Retrievals per search - standard deviation 1395.8
Percent of searches completed with 0 results 20.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 64 19.4%
DISPLAY (excluding automatic displays) 94 28.5%
HELP 24 7.3%
EXPLAIN 16 4.8%
SET/RESET 44 13.3%
SHOW 7 2.1%
ADD ON (AND, OR, AND NOT) 0 0.0%
LOGON or LOGOFF 64 19.4%
COMMENT 0 0.0%
SAVE 0 0.0%
USE 0 0.0%
OTHER 17 5.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:
JOURNAL 40 62.5% 11 27.5% 225 336.9 341.9
EXACT JOURNAL 9 14.1% 2 22.2% 112 274.1 431.5
SUBJECT CAT 1 1.6% 0 0.0% 11,081 11081.0 0.0
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 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 14 21.9% 0 0.0% 6 19.5 48.3
By number of indexes:
Multiple 0 0.0% 0 0.0% 0 0.0 0.0
Single 64 100% 13 20.3% 126 451.8 1553.2
DISPLAY commands, by type, excluding automatic displays:
REVIEW 3.0%
ISSUES 49.5%
SHORT 9.1%
LONG 15.2%
PERIODICALS 21.2%
COMMENTS 0.0%
Other 2.0%
2.3 Error, EXPLAIN and HELP statistics (CC & CCT)
__________________________________________________
Percent of commands that contained errors 7.0%
Ten most frequent errors:
1. NS command - no next screen 32.5%
2. First word of command is invalid 28.4%
3. FIND command with invalid index name 9.9%
4. Index invalid in current database 3.1%
5. DISPLAY command contains invalid word 2.5%
6. Search term missing from search command 2.4%
7. PS command - no previous screen 2.2%
8. Valid command at an inappropriate time 1.3%
9. 177 1.3%
10. D ABS command in database w/o abstracts 1.3%
11. All others 15.4%
Ten most frequent EXPLAIN requests:
1. CC GUIDE 14.9%
2. FIND (CC DB) 13.8%
3. CC INDEXES 12.8%
4. LOCATE (ARTICLE DBS) 7.4%
5. FIND (CCT DB) 7.4%
6. COMMANDS 6.4%
7. Unrecognized term 4.3%
8. DATABASES 4.3%
9. ADD-ON SEARCH 3.2%
10. CCT GUIDE 3.2%
11. All others 22.3%
Ten most frequent HELP situations:
1. Help requested from START CC command 15.5%
2. First word of command is invalid 14.0%
3. FIND command with zero results 8.3%
4. DISPLAY command-first of >1 screen 7.8%
5. FIND command with invalid index name 5.7%
6. Help requested from START CCT command 5.7%
7. NS command - no next screen 4.1%
8. Help requested from SET DB command 4.1%
9. DISPLAY command - middle of >1 screen 3.6%
10. F/BR with index invalid in current DB 3.6%
11. All others 27.5%
Ten most frequent SHOW requests:
1. SEARCH 36.0%
2. SYSTEM NEWS 16.0%
3. HISTORY 12.0%
4. CC NEWS 8.0%
5. MAIL STATUS 8.0%
6. MAIL SETTINGS 4.0%
7. CC SETTINGS 4.0%
8. CC GLOSSARY 4.0%
9. SC LIST (CC DBS) 4.0%
10. UPDATE 4.0%
11. All others 0.0%
Cmm/yy cc MELVYL CURRENT CONTENTS DATABASE TELNET STATISTICS (monthly)