MELVYL CURRENT CONTENTS DATABASE TELNET STATISTICS
Time period: 04/20/02 through 04/26/02
1.0 SUMMARY STATISTICS
_______________________
1.1 Total sessions:
____________________
Location Library Remote Total
________ _______ ______ _____
Berkeley 75 453 528
Davis 232 22 254
Irvine 142 0 142
Los Angeles 0 111 111
Riverside 19 50 69
San Diego 33 133 166
San Francisco 138 0 138
Santa Barbara 8 73 81
Santa Cruz 17 30 47
LBL 0 89 89
LLL 0 56 56
Los Alamos n/a 0 0
Other - UC 0 72 72
U.S. Forestry 0
Other-Network UC n/a 279 279
_______ ______ _____
664 1,368 2,032
Per hour usage:
Time Sessions Finds Records Displayed
__________ __________ __________ _________________
12-2 a.m. 30 108 2,514
2-4 a.m. 27 173 693
4-6 a.m. 10 40 326
6-8 a.m. 51 165 763
8-10 a.m. 243 761 5,559
10-12 a.m. 417 1,333 10,930
12-2 p.m. 319 881 7,584
2-4 p.m. 379 1,006 10,991
4-6 p.m. 296 727 9,229
6-8 p.m. 122 333 2,977
8-10 p.m. 68 264 2,209
10-12 p.m. 70 222 1,826
__________ __________ __________ _________________
Total: 2,032 6,013 55,601
1.2 FIND commands
__________________
Number of FIND commands issued by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 180 1,335 1,515
Davis 626 136 762
Irvine 464 0 464
Los Angeles 0 321 321
Riverside 55 123 178
San Diego 59 423 482
San Francisco 690 0 690
Santa Barbara 21 223 244
Santa Cruz 20 114 134
LBL 0 261 261
LLL 0 176 176
Los Alamos n/a 0 0
Other - UC 0 164 164
U.S. Forestry 0
Other-Network UC n/a 622 622
_______ ______ _____
2,115 3,898 6,013
Number of FIND commands by database
CC database 5,938
CCT database 75
Total number of FIND commands 6,013
1.3 Records displayed
______________________
Number of Records Displayed by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 1,248 14,375 15,623
Davis 4,085 250 4,335
Irvine 2,964 0 2,964
Los Angeles 0 2,448 2,448
Riverside 236 973 1,209
San Diego 264 3,942 4,206
San Francisco 7,950 0 7,950
Santa Barbara 96 2,553 2,649
Santa Cruz 144 848 992
LBL 0 4,291 4,291
LLL 0 1,628 1,628
Los Alamos n/a 0 0
Other - UC 0 2,284 2,284
U.S. Forestry 0
Other-Network UC n/a 5,022 5,022
_______ ______ _____
16,987 38,614 55,601
Number of Records Displayed by database:
CC database 52,574
CCT database 3,027
Total number of Records Displayed 55,601
1.4 Relative Use of Databases
______________________________
Relative use of CC vs. CCT databases:
Percent of CC sessions 96.1%
Percent of CCT sessions 3.9%
Percent of searches done in the CC database 98.8%
Percent of searches done in the CCT database 1.2%
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.6
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.6
2.0 CC Database Statistics
___________________________
Median session length (minutes:seconds) 0:00
Average session length (minutes:seconds) 0:00
Longest session recorded (minutes:seconds) 780:59
Average number of searches completed per session 3.0
Retrievals per search - median 11.0
Retrievals per search - average 581.4
Retrievals per search - standard deviation 6188.3
Percent of searches completed with 0 results 21.6%
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,345 36.9%
DISPLAY (excluding automatic displays) 4,121 28.5%
HELP 139 1.0%
EXPLAIN 130 0.9%
SET/RESET 774 5.3%
SHOW 22 0.2%
ADD ON (AND, OR, AND NOT) 593 4.1%
LOGON or LOGOFF 2,476 17.1%
COMMENT 0 0.0%
SAVE 239 1.7%
USE 3 0.0%
OTHER 638 4.4%
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,593 44.7% 400 15.4% 34 164.8 826.9
TITLE WORD 1,743 30.0% 539 30.9% 12 710.2 3766.9
EXACT TITLE 89 1.5% 48 53.9% 1 13.0 32.2
JOURNAL 404 7.0% 119 29.5% 1,255 5260.7 23268.4
EXACT JOURNAL 113 1.9% 31 27.4% 2,279 3779.1 5585.1
SUBJECT CAT 26 0.4% 4 15.4% 57 8353.5 38655.3
SUBFILE 30 0.5% 4 13.3% 14 31.7 54.1
PUBLICATION TYPE 17 0.3% 4 23.5% 18 41.4 49.9
LANGUAGE 4 0.1% 0 0.0% 39 34.0 25.9
DATE 106 1.8% 21 19.8% 9 74.4 209.5
ADDED 42 0.7% 13 30.9% 3 5.3 8.1
PERIODICAL 337 5.8% 37 11.0% 4 113.1 1079.7
EXACT PE 68 1.2% 8 11.8% 3 16.0 59.2
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 229 3.9% 75 32.8% 18 1129.7 8355.5
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 459 8.6% 154 33.6% 6 39.1 122.8
Single 4,871 91.4% 990 20.3% 31 876.8 7627.6
DISPLAY commands, by type, excluding automatic displays:
REVIEW 4.4%
SHORT 75.3%
LONG 3.6%
FIELDS 2.8%
PERIODICALS 12.3%
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) 51:16
Average number of searches completed per session 0.9
Retrievals per search - median 28.0
Retrievals per search - average 119.1
Retrievals per search - standard deviation 213.6
Percent of searches completed with 0 results 36.0%
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 74 18.4%
DISPLAY (excluding automatic displays) 121 30.1%
HELP 31 7.7%
EXPLAIN 15 3.7%
SET/RESET 63 15.7%
SHOW 8 2.0%
ADD ON (AND, OR, AND NOT) 1 0.2%
LOGON or LOGOFF 71 17.7%
COMMENT 0 0.0%
SAVE 0 0.0%
USE 0 0.0%
OTHER 18 4.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 58 78.4% 23 39.7% 135 194.3 205.9
EXACT JOURNAL 9 12.2% 2 22.2% 169 290.7 424.9
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 7 9.5% 2 28.6% 4 19.4 24.8
By number of indexes:
Multiple 0 0.0% 0 0.0% 0 0.0 0.0
Single 74 100% 27 36.5% 129 190.1 244.2
DISPLAY commands, by type, excluding automatic displays:
REVIEW 1.5%
ISSUES 50.7%
SHORT 18.4%
LONG 14.7%
PERIODICALS 11.0%
COMMENTS 0.0%
Other 3.7%
2.3 Error, EXPLAIN and HELP statistics (CC & CCT)
__________________________________________________
Percent of commands that contained errors 7.6%
Ten most frequent errors:
1. NS command - no next screen 30.1%
2. First word of command is invalid 27.0%
3. FIND command with invalid index name 10.5%
4. Index invalid in current database 5.3%
5. NS of SHOW/EXP command-no next screen 3.5%
6. DISPLAY command - no FIND results 2.8%
7. DISPLAY command contains invalid word 2.2%
8. Search term missing from search command 2.1%
9. PS command - no previous screen 1.6%
10. D ABS command in database w/o abstracts 1.5%
11. All others 13.3%
Ten most frequent EXPLAIN requests:
1. CC GUIDE 24.8%
2. CC INDEXES 11.0%
3. FIND (CC DB) 9.0%
4. LOCATE (ARTICLE DBS) 7.6%
5. Unrecognized term 6.9%
6. COMMANDS 6.9%
7. DISPLAY 4.1%
8. ADD-ON SEARCH 2.8%
9. CC DATABASE 2.8%
10. DISPLAY PE 2.1%
11. All others 22.1%
Ten most frequent HELP situations:
1. First word of command is invalid 13.0%
2. Help requested from START CC command 12.7%
3. FIND command with invalid index name 8.6%
4. F/BR with index invalid in current DB 7.3%
5. FIND command retrieves >1 book 6.3%
6. Help requested from SET DB command 6.3%
7. DISPLAY command-complete in one screen 6.0%
8. FIND command with zero results 4.1%
9. DISPLAY command-first of >1 screen 4.1%
10. NS command - no next screen 3.8%
11. All others 27.6%
Ten most frequent SHOW requests:
1. HISTORY 26.7%
2. SYSTEM NEWS 20.0%
3. CC NEWS 20.0%
4. SEARCH 16.7%
5. CC SETTINGS 10.0%
6. CC GLOSSARY 6.7%
11. All others 0.0%
Cmm/yy cc MELVYL CURRENT CONTENTS DATABASE TELNET STATISTICS (monthly)