MELVYL CURRENT CONTENTS DATABASE TELNET STATISTICS
Time period: 04/06/02 through 04/12/02
1.0 SUMMARY STATISTICS
_______________________
1.1 Total sessions:
____________________
Location Library Remote Total
________ _______ ______ _____
Berkeley 41 508 549
Davis 215 16 231
Irvine 140 0 140
Los Angeles 0 159 159
Riverside 8 32 40
San Diego 35 130 165
San Francisco 104 0 104
Santa Barbara 2 28 30
Santa Cruz 4 43 47
LBL 0 54 54
LLL 0 29 29
Los Alamos n/a 0 0
Other - UC 2 54 56
U.S. Forestry 0
Other-Network UC n/a 397 397
_______ ______ _____
551 1,450 2,001
Per hour usage:
Time Sessions Finds Records Displayed
__________ __________ __________ _________________
12-2 a.m. 27 78 891
2-4 a.m. 11 50 177
4-6 a.m. 16 104 962
6-8 a.m. 30 121 836
8-10 a.m. 247 826 5,974
10-12 a.m. 415 1,150 9,474
12-2 p.m. 302 784 6,794
2-4 p.m. 400 1,175 10,502
4-6 p.m. 316 950 9,685
6-8 p.m. 127 438 3,214
8-10 p.m. 61 182 2,079
10-12 p.m. 49 154 1,295
__________ __________ __________ _________________
Total: 2,001 6,012 51,883
1.2 FIND commands
__________________
Number of FIND commands issued by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 73 1,461 1,534
Davis 664 46 710
Irvine 375 0 375
Los Angeles 0 600 600
Riverside 26 135 161
San Diego 86 390 476
San Francisco 524 0 524
Santa Barbara 2 63 65
Santa Cruz 20 165 185
LBL 0 146 146
LLL 0 88 88
Los Alamos n/a 0 0
Other - UC 2 192 194
U.S. Forestry 0
Other-Network UC n/a 954 954
_______ ______ _____
1,772 4,240 6,012
Number of FIND commands by database
CC database 5,906
CCT database 106
Total number of FIND commands 6,012
1.3 Records displayed
______________________
Number of Records Displayed by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 598 15,223 15,821
Davis 7,515 213 7,728
Irvine 2,669 0 2,669
Los Angeles 0 7,072 7,072
Riverside 56 906 962
San Diego 644 3,654 4,298
San Francisco 1,381 0 1,381
Santa Barbara 0 885 885
Santa Cruz 101 1,210 1,311
LBL 0 939 939
LLL 0 681 681
Los Alamos n/a 0 0
Other - UC 3 1,703 1,706
U.S. Forestry 0
Other-Network UC n/a 6,430 6,430
_______ ______ _____
12,967 38,916 51,883
Number of Records Displayed by database:
CC database 47,643
CCT database 4,240
Total number of Records Displayed 51,883
1.4 Relative Use of Databases
______________________________
Relative use of CC vs. CCT databases:
Percent of CC sessions 96.1%
Percent of CCT sessions 3.8%
Percent of searches done in the CC database 98.2%
Percent of searches done in the CCT database 1.8%
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 6.1
Display response time from receipt of command at
DLA until transmission of a complete screen:
Average in seconds 0.1
Standard deviation in seconds 6.1
2.0 CC Database Statistics
___________________________
Median session length (minutes:seconds) 0:00
Average session length (minutes:seconds) 0:00
Longest session recorded (minutes:seconds) 354:32
Average number of searches completed per session 3.1
Retrievals per search - median 7.0
Retrievals per search - average 670.2
Retrievals per search - standard deviation 6623.1
Percent of searches completed with 0 results 21.9%
Percent of searches entered that are long 0.4%
Percent of long searches completed
(includes partial results) 83.3%
Commands entered, by type, excluding errors:
Total Percentage
__________ __________
FIND 5,325 36.4%
DISPLAY (excluding automatic displays) 4,483 30.6%
HELP 98 0.7%
EXPLAIN 130 0.9%
SET/RESET 773 5.3%
SHOW 15 0.1%
ADD ON (AND, OR, AND NOT) 581 4.0%
LOGON or LOGOFF 2,378 16.2%
COMMENT 0 0.0%
SAVE 244 1.7%
USE 3 0.0%
OTHER 615 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 2,222 38.4% 333 15.0% 30 253.3 1612.6
TITLE WORD 1,871 32.3% 603 32.2% 10 610.9 4110.6
EXACT TITLE 92 1.6% 35 38.0% 5 47.4 172.1
JOURNAL 346 6.0% 85 24.6% 1,521 5716.1 25656.2
EXACT JOURNAL 127 2.2% 32 25.2% 1,920 5559.4 11521.2
SUBJECT CAT 24 0.4% 4 16.7% 25 408.6 844.9
SUBFILE 12 0.2% 4 33.3% 85 301.8 563.0
PUBLICATION TYPE 23 0.4% 7 30.4% 26 15272.1 27163.8
LANGUAGE 1 0.0% 0 0.0% 839 839.0 0.0
DATE 109 1.9% 24 22.0% 4 77.2 220.8
ADDED 16 0.3% 6 37.5% 4 4.4 2.7
PERIODICAL 608 10.5% 72 11.8% 5 31.8 140.9
EXACT PE 135 2.3% 13 9.6% 3 11.4 32.7
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 202 3.5% 52 25.7% 21 2394.9 12292.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 472 8.9% 141 29.9% 4 61.2 270.1
Single 4,836 91.1% 984 20.3% 23 1005.9 8157.5
DISPLAY commands, by type, excluding automatic displays:
REVIEW 3.5%
SHORT 67.6%
LONG 4.7%
FIELDS 1.5%
PERIODICALS 21.2%
COMMENTS 0.0%
Other 1.4%
2.1 CCT Database Statistics
____________________________
Median session length (minutes:seconds) 0:00
Average session length (minutes:seconds) 0:00
Longest session recorded (minutes:seconds) 33:04
Average number of searches completed per session 1.4
Retrievals per search - median 80.5
Retrievals per search - average 513.0
Retrievals per search - standard deviation 2822.9
Percent of searches completed with 0 results 25.5%
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 106 23.0%
DISPLAY (excluding automatic displays) 160 34.7%
HELP 40 8.7%
EXPLAIN 11 2.4%
SET/RESET 53 11.5%
SHOW 6 1.3%
ADD ON (AND, OR, AND NOT) 0 0.0%
LOGON or LOGOFF 71 15.4%
COMMENT 0 0.0%
SAVE 0 0.0%
USE 1 0.2%
OTHER 13 2.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:
JOURNAL 62 58.5% 22 35.5% 186 1139.1 4540.0
EXACT JOURNAL 36 34.0% 4 11.1% 144 272.3 456.4
SUBJECT CAT 0 0.0% 0 0.0% 0 0.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 8 7.5% 1 12.5% 9 14.7 14.3
By number of indexes:
Multiple 0 0.0% 0 0.0% 0 0.0 0.0
Single 106 100% 27 25.5% 153 688.4 3256.5
DISPLAY commands, by type, excluding automatic displays:
REVIEW 2.6%
ISSUES 45.6%
SHORT 13.8%
LONG 29.2%
PERIODICALS 7.2%
COMMENTS 0.0%
Other 1.5%
2.3 Error, EXPLAIN and HELP statistics (CC & CCT)
__________________________________________________
Percent of commands that contained errors 8.3%
Ten most frequent errors:
1. First word of command is invalid 38.0%
2. NS command - no next screen 26.5%
3. FIND command with invalid index name 9.2%
4. Index invalid in current database 3.3%
5. DISPLAY command contains invalid word 3.2%
6. Search term missing from search command 2.0%
7. D ABS command in database w/o abstracts 1.7%
8. PS command - no previous screen 1.2%
9. Valid command at an inappropriate time 1.1%
10. Add-on search, no index name after verb 1.0%
11. All others 12.7%
Ten most frequent EXPLAIN requests:
1. CC GUIDE 16.3%
2. FIND (CC DB) 12.1%
3. CC INDEXES 9.9%
4. LOCATE (ARTICLE DBS) 7.8%
5. COMMANDS 7.8%
6. Unrecognized term 6.4%
7. MAIL 3.5%
8. FIND LOCATION 3.5%
9. DISPLAY 2.8%
10. 5341 2.1%
11. All others 27.7%
Ten most frequent HELP situations:
1. First word of command is invalid 13.3%
2. Help requested from START CC command 11.8%
3. FIND command with invalid index name 11.1%
4. F/BR with index invalid in current DB 8.6%
5. DISPLAY command-complete in one screen 5.4%
6. Help requested from SET DB command 5.4%
7. DISPLAY command - middle of >1 screen 4.7%
8. DISPLAY command-first of >1 screen 4.3%
9. FIND command with zero results 3.9%
10. DISPLAY command - last of >1 screen 3.2%
11. All others 28.3%
Ten most frequent SHOW requests:
1. HISTORY 45.0%
2. CC NEWS 15.0%
3. SYSTEM NEWS 10.0%
4. CC GLOSSARY 10.0%
5. SEARCH 10.0%
6. TIME 5.0%
7. 5404 5.0%
11. All others 0.0%
Cmm/yy cc MELVYL CURRENT CONTENTS DATABASE TELNET STATISTICS (monthly)