MELVYL CURRENT CONTENTS DATABASE TELNET STATISTICS
Time period: 02/16/02 through 02/22/02
1.0 SUMMARY STATISTICS
_______________________
1.1 Total sessions:
____________________
Location Library Remote Total
________ _______ ______ _____
Berkeley 79 590 669
Davis 246 16 262
Irvine 106 0 106
Los Angeles 0 148 148
Riverside 8 44 52
San Diego 34 157 191
San Francisco 142 0 142
Santa Barbara 8 70 78
Santa Cruz 8 38 46
LBL 0 74 74
LLL 0 33 33
Los Alamos n/a 0 0
Other - UC 1 42 43
U.S. Forestry 0
Other-Network UC n/a 530 530
_______ ______ _____
632 1,742 2,374
Per hour usage:
Time Sessions Finds Records Displayed
__________ __________ __________ _________________
12-2 a.m. 59 167 1,066
2-4 a.m. 44 136 8,716
4-6 a.m. 25 68 576
6-8 a.m. 108 306 1,869
8-10 a.m. 257 697 4,192
10-12 a.m. 429 1,341 9,907
12-2 p.m. 435 1,333 18,685
2-4 p.m. 464 1,650 17,886
4-6 p.m. 269 728 7,140
6-8 p.m. 133 340 2,680
8-10 p.m. 71 313 2,407
10-12 p.m. 80 269 1,983
__________ __________ __________ _________________
Total: 2,374 7,348 77,107
1.2 FIND commands
__________________
Number of FIND commands issued by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 182 2,407 2,589
Davis 783 41 824
Irvine 310 0 310
Los Angeles 0 402 402
Riverside 35 102 137
San Diego 44 508 552
San Francisco 547 0 547
Santa Barbara 19 217 236
Santa Cruz 7 88 95
LBL 0 181 181
LLL 0 106 106
Los Alamos n/a 0 0
Other - UC 2 123 125
U.S. Forestry 0
Other-Network UC n/a 1,244 1,244
_______ ______ _____
1,929 5,419 7,348
Number of FIND commands by database
CC database 7,245
CCT database 103
Total number of FIND commands 7,348
1.3 Records displayed
______________________
Number of Records Displayed by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 1,602 19,583 21,185
Davis 18,605 231 18,836
Irvine 10,264 0 10,264
Los Angeles 0 3,042 3,042
Riverside 429 756 1,185
San Diego 300 3,883 4,183
San Francisco 3,194 0 3,194
Santa Barbara 175 2,144 2,319
Santa Cruz 49 1,103 1,152
LBL 0 1,623 1,623
LLL 0 697 697
Los Alamos n/a 0 0
Other - UC 2 1,029 1,031
U.S. Forestry 0
Other-Network UC n/a 8,396 8,396
_______ ______ _____
34,620 42,487 77,107
Number of Records Displayed by database:
CC database 73,829
CCT database 3,278
Total number of Records Displayed 77,107
1.4 Relative Use of Databases
______________________________
Relative use of CC vs. CCT databases:
Percent of CC sessions 96.8%
Percent of CCT sessions 3.2%
Percent of searches done in the CC database 98.6%
Percent of searches done in the CCT database 1.4%
1.5 Response time
__________________
Search response time from receipt of command at
DLA until transmission of response:
Average in seconds 0.7
Standard deviation in seconds 2.9
Display response time from receipt of command at
DLA until transmission of a complete screen:
Average in seconds 0.1
Standard deviation in seconds 2.9
2.0 CC Database Statistics
___________________________
Median session length (minutes:seconds) 0:00
Average session length (minutes:seconds) 0:00
Longest session recorded (minutes:seconds) 392:42
Average number of searches completed per session 3.1
Retrievals per search - median 8.0
Retrievals per search - average 505.8
Retrievals per search - standard deviation 4717.9
Percent of searches completed with 0 results 22.0%
Percent of searches entered that are long 0.4%
Percent of long searches completed
(includes partial results) 86.7%
Commands entered, by type, excluding errors:
Total Percentage
__________ __________
FIND 6,436 34.8%
DISPLAY (excluding automatic displays) 6,192 33.5%
HELP 145 0.8%
EXPLAIN 173 0.9%
SET/RESET 941 5.1%
SHOW 28 0.2%
ADD ON (AND, OR, AND NOT) 809 4.4%
LOGON or LOGOFF 2,823 15.3%
COMMENT 0 0.0%
SAVE 229 1.2%
USE 3 0.0%
OTHER 716 3.9%
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 3,048 44.1% 451 14.8% 30 172.9 730.3
TITLE WORD 2,278 32.9% 681 29.9% 13 581.7 3561.0
EXACT TITLE 106 1.5% 41 38.7% 2 45.0 121.0
JOURNAL 270 3.9% 91 33.7% 1,072 5540.6 12538.9
EXACT JOURNAL 184 2.7% 42 22.8% 1,430 3959.9 7171.0
SUBJECT CAT 31 0.4% 0 0.0% 13 43.1 81.6
SUBFILE 6 0.1% 0 0.0% 69 176.7 251.8
PUBLICATION TYPE 19 0.3% 3 15.8% 60 16166.4 63992.5
LANGUAGE 6 0.1% 2 33.3% 181 528.8 820.9
DATE 138 2.0% 36 26.1% 11 152.8 742.2
ADDED 0 0.0% 0 0.0% 0 0.0 0.0
PERIODICAL 411 5.9% 53 12.9% 5 64.3 700.6
EXACT PE 142 2.1% 14 9.9% 3 21.3 58.9
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 276 4.0% 105 38.0% 17 1571.0 13299.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 476 7.4% 143 30.0% 7 72.3 426.3
Single 5,937 92.6% 1,223 20.6% 26 733.5 5806.0
DISPLAY commands, by type, excluding automatic displays:
REVIEW 3.6%
SHORT 67.7%
LONG 15.0%
FIELDS 1.9%
PERIODICALS 10.4%
COMMENTS 0.0%
Other 1.3%
2.1 CCT Database Statistics
____________________________
Median session length (minutes:seconds) 0:00
Average session length (minutes:seconds) 0:00
Longest session recorded (minutes:seconds) 31:20
Average number of searches completed per session 1.4
Retrievals per search - median 87.0
Retrievals per search - average 258.8
Retrievals per search - standard deviation 751.5
Percent of searches completed with 0 results 27.2%
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 103 20.1%
DISPLAY (excluding automatic displays) 213 41.5%
HELP 38 7.4%
EXPLAIN 13 2.5%
SET/RESET 57 11.1%
SHOW 4 0.8%
ADD ON (AND, OR, AND NOT) 0 0.0%
LOGON or LOGOFF 65 12.7%
COMMENT 0 0.0%
SAVE 0 0.0%
USE 0 0.0%
OTHER 20 3.9%
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 47 45.6% 18 38.3% 161 256.9 294.4
EXACT JOURNAL 53 51.5% 10 18.9% 152 278.3 329.1
SUBJECT CAT 1 1.0% 0 0.0% 7,231 7231.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 2 1.9% 0 0.0% 5 5.0 2.8
By number of indexes:
Multiple 0 0.0% 0 0.0% 0 0.0 0.0
Single 103 100% 28 27.2% 156 355.4 862.4
DISPLAY commands, by type, excluding automatic displays:
REVIEW 0.9%
ISSUES 40.0%
SHORT 41.7%
LONG 14.5%
PERIODICALS 2.6%
COMMENTS 0.0%
Other 0.4%
2.3 Error, EXPLAIN and HELP statistics (CC & CCT)
__________________________________________________
Percent of commands that contained errors 7.1%
Ten most frequent errors:
1. NS command - no next screen 30.3%
2. First word of command is invalid 28.8%
3. FIND command with invalid index name 10.7%
4. Index invalid in current database 4.6%
5. Search term missing from search command 2.5%
6. PS command - no previous screen 2.3%
7. DISPLAY command contains invalid word 2.2%
8. Valid command at an inappropriate time 1.6%
9. DISPLAY command - no FIND results 1.5%
10. Add-on search, no index name after verb 1.4%
11. All others 14.2%
Ten most frequent EXPLAIN requests:
1. LOCATE (ARTICLE DBS) 12.9%
2. FIND (CC DB) 11.8%
3. CC GUIDE 11.3%
4. CC INDEXES 7.0%
5. MAIL 5.9%
6. COMMANDS 5.4%
7. DISPLAY 4.3%
8. Unrecognized term 3.2%
9. DATABASES 2.2%
10. SAVE 1.6%
11. All others 34.4%
Ten most frequent HELP situations:
1. Help requested from START CC command 14.6%
2. First word of command is invalid 10.8%
3. FIND command with invalid index name 8.1%
4. F/BR with index invalid in current DB 7.6%
5. Help requested from SET DB command 6.0%
6. DISPLAY command-first of >1 screen 5.4%
7. DISPLAY command-complete in one screen 4.1%
8. DISPLAY command - middle of >1 screen 3.3%
9. FIND command with zero results 2.7%
10. DISPLAY command contains invalid word 1.9%
11. All others 35.5%
Ten most frequent SHOW requests:
1. HISTORY 26.7%
2. SYSTEM NEWS 20.0%
3. CC NEWS 10.0%
4. SYSTEM1 NEWS 6.7%
5. SC LIST (CC DBS) 6.7%
6. SEARCH 6.7%
7. MAIL STATUS 6.7%
8. CC SETTINGS 3.3%
9. SC 3.3%
10. CC LOADING STATISTICS 3.3%
11. All others 6.7%
Cmm/yy cc MELVYL CURRENT CONTENTS DATABASE TELNET STATISTICS (monthly)