MELVYL CURRENT CONTENTS DATABASE TELNET STATISTICS
Time period: 10/20/01 through 10/26/01
1.0 SUMMARY STATISTICS
_______________________
1.1 Total sessions:
____________________
Location Library Remote Total
________ _______ ______ _____
Berkeley 54 508 562
Davis 317 25 342
Irvine 183 0 183
Los Angeles 0 169 169
Riverside 15 59 74
San Diego 24 182 206
San Francisco 158 0 158
Santa Barbara 5 108 113
Santa Cruz 13 66 79
LBL 0 86 86
LLL 0 31 31
Los Alamos n/a 0 0
Other - UC 3 65 68
U.S. Forestry 0
Other-Network UC n/a 645 645
_______ ______ _____
772 1,944 2,716
Per hour usage:
Time Sessions Finds Records Displayed
__________ __________ __________ _________________
12-2 a.m. 74 280 1,764
2-4 a.m. 29 105 7,932
4-6 a.m. 40 126 1,073
6-8 a.m. 92 218 1,000
8-10 a.m. 332 830 8,418
10-12 a.m. 537 1,403 11,184
12-2 p.m. 429 990 6,844
2-4 p.m. 526 1,310 14,696
4-6 p.m. 359 990 7,862
6-8 p.m. 123 364 3,674
8-10 p.m. 83 212 2,311
10-12 p.m. 92 254 1,741
__________ __________ __________ _________________
Total: 2,716 7,082 68,499
1.2 FIND commands
__________________
Number of FIND commands issued by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 163 1,481 1,644
Davis 955 41 996
Irvine 531 0 531
Los Angeles 0 379 379
Riverside 25 139 164
San Diego 115 534 649
San Francisco 405 0 405
Santa Barbara 6 271 277
Santa Cruz 36 135 171
LBL 0 238 238
LLL 0 65 65
Los Alamos n/a 0 0
Other - UC 6 153 159
U.S. Forestry 0
Other-Network UC n/a 1,404 1,404
_______ ______ _____
2,242 4,840 7,082
Number of FIND commands by database
CC database 6,982
CCT database 100
Total number of FIND commands 7,082
1.3 Records displayed
______________________
Number of Records Displayed by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 1,552 14,092 15,644
Davis 6,069 277 6,346
Irvine 11,500 0 11,500
Los Angeles 0 2,780 2,780
Riverside 482 1,119 1,601
San Diego 411 5,042 5,453
San Francisco 5,370 0 5,370
Santa Barbara 93 2,919 3,012
Santa Cruz 281 1,408 1,689
LBL 0 1,835 1,835
LLL 0 516 516
Los Alamos n/a 0 0
Other - UC 116 1,396 1,512
U.S. Forestry 0
Other-Network UC n/a 11,241 11,241
_______ ______ _____
25,874 42,625 68,499
Number of Records Displayed by database:
CC database 64,669
CCT database 3,830
Total number of Records Displayed 68,499
1.4 Relative Use of Databases
______________________________
Relative use of CC vs. CCT databases:
Percent of CC sessions 96.6%
Percent of CCT sessions 3.4%
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 1.2
Standard deviation in seconds 7.0
Display response time from receipt of command at
DLA until transmission of a complete screen:
Average in seconds 0.2
Standard deviation in seconds 7.0
2.0 CC Database Statistics
___________________________
Median session length (minutes:seconds) 0:00
Average session length (minutes:seconds) 0:00
Longest session recorded (minutes:seconds) 325:54
Average number of searches completed per session 2.7
Retrievals per search - median 9.0
Retrievals per search - average 421.9
Retrievals per search - standard deviation 3776.9
Percent of searches completed with 0 results 22.1%
Percent of searches entered that are long 0.4%
Percent of long searches completed
(includes partial results) 88.0%
Commands entered, by type, excluding errors:
Total Percentage
__________ __________
FIND 6,309 36.0%
DISPLAY (excluding automatic displays) 5,125 29.2%
HELP 147 0.8%
EXPLAIN 172 1.0%
SET/RESET 1,269 7.2%
SHOW 20 0.1%
ADD ON (AND, OR, AND NOT) 673 3.8%
LOGON or LOGOFF 2,897 16.5%
COMMENT 1 0.0%
SAVE 200 1.1%
USE 9 0.1%
OTHER 714 4.1%
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,001 42.7% 448 14.9% 30 203.9 1267.5
TITLE WORD 2,224 31.7% 707 31.8% 13 666.4 5048.4
EXACT TITLE 115 1.6% 51 44.3% 3 31.6 94.1
JOURNAL 284 4.0% 96 33.8% 542 3494.7 9117.8
EXACT JOURNAL 151 2.1% 53 35.1% 524 3919.0 9672.0
SUBJECT CAT 33 0.5% 5 15.2% 20 35.1 47.0
SUBFILE 33 0.5% 0 0.0% 28 58.8 79.6
PUBLICATION TYPE 25 0.4% 2 8.0% 8 40.2 103.8
LANGUAGE 1 0.0% 1 100% 0 0.0 0.0
DATE 230 3.3% 33 14.3% 13 110.0 308.3
ADDED 14 0.2% 2 14.3% 2 2.3 1.2
PERIODICAL 546 7.8% 70 12.8% 4 51.2 253.4
EXACT PE 121 1.7% 5 4.1% 3 13.4 32.6
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 246 3.5% 103 41.9% 12 1463.5 14053.1
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 679 10.8% 181 26.7% 7 53.1 202.5
Single 5,617 89.2% 1,204 21.4% 26 630.1 4726.1
DISPLAY commands, by type, excluding automatic displays:
REVIEW 6.2%
SHORT 71.6%
LONG 5.5%
FIELDS 1.1%
PERIODICALS 14.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) 44:01
Average number of searches completed per session 1.1
Retrievals per search - median 63.0
Retrievals per search - average 606.5
Retrievals per search - standard deviation 2345.2
Percent of searches completed with 0 results 28.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 100 20.3%
DISPLAY (excluding automatic displays) 160 32.5%
HELP 39 7.9%
EXPLAIN 34 6.9%
SET/RESET 71 14.4%
SHOW 10 2.0%
ADD ON (AND, OR, AND NOT) 0 0.0%
LOGON or LOGOFF 65 13.2%
COMMENT 0 0.0%
SAVE 1 0.2%
USE 0 0.0%
OTHER 12 2.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:
JOURNAL 71 71.0% 23 32.4% 158 238.9 259.0
EXACT JOURNAL 16 16.0% 5 31.3% 146 234.3 237.8
SUBJECT CAT 5 5.0% 0 0.0% 7,992 9311.4 5931.3
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 8.0% 0 0.0% 4 6.4 8.4
By number of indexes:
Multiple 0 0.0% 0 0.0% 0 0.0 0.0
Single 100 100% 28 28.0% 152 842.4 2732.7
DISPLAY commands, by type, excluding automatic displays:
REVIEW 1.8%
ISSUES 53.8%
SHORT 21.6%
LONG 17.0%
PERIODICALS 4.7%
COMMENTS 0.0%
Other 1.2%
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 34.3%
2. NS command - no next screen 28.6%
3. FIND command with invalid index name 9.6%
4. Index invalid in current database 4.5%
5. PS command - no previous screen 2.0%
6. DISPLAY command contains invalid word 1.5%
7. Search term missing from search command 1.5%
8. Valid command at an inappropriate time 1.4%
9. D ABS command in database w/o abstracts 1.3%
10. Command contains escape or arrow key 1.0%
11. All others 14.2%
Ten most frequent EXPLAIN requests:
1. CC GUIDE 16.5%
2. LOCATE (ARTICLE DBS) 12.1%
3. CC INDEXES 11.7%
4. FIND (CC DB) 9.2%
5. FIND (CCT DB) 4.4%
6. 5475 4.4%
7. CC DATABASE 3.9%
8. Unrecognized term 3.4%
9. DISPLAY 3.4%
10. COMMANDS 3.4%
11. All others 27.7%
Ten most frequent HELP situations:
1. Help requested from START CC command 16.8%
2. First word of command is invalid 16.1%
3. F/BR with index invalid in current DB 9.4%
4. FIND command with invalid index name 7.9%
5. Help requested from SET DB command 6.1%
6. DISPLAY command-first of >1 screen 5.6%
7. DISPLAY command - middle of >1 screen 5.1%
8. FIND command with zero results 4.1%
9. FIND command retrieves >1 book 4.1%
10. DISPLAY command-complete in one screen 2.8%
11. All others 21.9%
Ten most frequent SHOW requests:
1. HISTORY 34.6%
2. GLOSSARY 11.5%
3. SYSTEM NEWS 11.5%
4. SEARCH 11.5%
5. CC NEWS 7.7%
6. MAIL STATUS 7.7%
7. LIBRARY NEWS 3.8%
8. MAIL SETTINGS 3.8%
9. CC SETTINGS 3.8%
10. SC LIST (CC DBS) 3.8%
11. All others 0.0%
Cmm/yy cc MELVYL CURRENT CONTENTS DATABASE TELNET STATISTICS (monthly)