MELVYL CURRENT CONTENTS DATABASE TELNET STATISTICS
Time period: 11/03/01 through 11/09/01
1.0 SUMMARY STATISTICS
_______________________
1.1 Total sessions:
____________________
Location Library Remote Total
________ _______ ______ _____
Berkeley 72 595 667
Davis 355 19 374
Irvine 145 0 145
Los Angeles 0 182 182
Riverside 22 40 62
San Diego 32 180 212
San Francisco 161 0 161
Santa Barbara 14 111 125
Santa Cruz 7 47 54
LBL 0 152 152
LLL 0 34 34
Los Alamos n/a 0 0
Other - UC 1 41 42
U.S. Forestry 0
Other-Network UC n/a 474 474
_______ ______ _____
809 1,875 2,684
Per hour usage:
Time Sessions Finds Records Displayed
__________ __________ __________ _________________
12-2 a.m. 40 141 1,602
2-4 a.m. 18 41 7,449
4-6 a.m. 41 81 399
6-8 a.m. 89 293 2,227
8-10 a.m. 367 910 5,869
10-12 a.m. 504 1,448 14,191
12-2 p.m. 471 1,284 10,138
2-4 p.m. 492 1,215 26,387
4-6 p.m. 335 887 9,505
6-8 p.m. 154 613 10,561
8-10 p.m. 106 282 2,047
10-12 p.m. 67 219 2,821
__________ __________ __________ _________________
Total: 2,684 7,414 93,196
1.2 FIND commands
__________________
Number of FIND commands issued by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 125 1,720 1,845
Davis 1,065 62 1,127
Irvine 415 0 415
Los Angeles 0 435 435
Riverside 47 138 185
San Diego 82 622 704
San Francisco 390 0 390
Santa Barbara 25 284 309
Santa Cruz 8 162 170
LBL 0 328 328
LLL 0 108 108
Los Alamos n/a 0 0
Other - UC 2 108 110
U.S. Forestry 0
Other-Network UC n/a 1,288 1,288
_______ ______ _____
2,159 5,255 7,414
Number of FIND commands by database
CC database 7,070
CCT database 344
Total number of FIND commands 7,414
1.3 Records displayed
______________________
Number of Records Displayed by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 728 18,926 19,654
Davis 29,803 287 30,090
Irvine 10,316 0 10,316
Los Angeles 0 3,807 3,807
Riverside 518 1,209 1,727
San Diego 274 5,506 5,780
San Francisco 2,531 0 2,531
Santa Barbara 86 4,153 4,239
Santa Cruz 73 1,064 1,137
LBL 0 3,343 3,343
LLL 0 493 493
Los Alamos n/a 0 0
Other - UC 5 1,455 1,460
U.S. Forestry 0
Other-Network UC n/a 8,619 8,619
_______ ______ _____
44,334 48,862 93,196
Number of Records Displayed by database:
CC database 81,877
CCT database 11,319
Total number of Records Displayed 93,196
1.4 Relative Use of Databases
______________________________
Relative use of CC vs. CCT databases:
Percent of CC sessions 95.4%
Percent of CCT sessions 4.6%
Percent of searches done in the CC database 95.4%
Percent of searches done in the CCT database 4.6%
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 5.2
Display response time from receipt of command at
DLA until transmission of a complete screen:
Average in seconds 0.2
Standard deviation in seconds 5.2
2.0 CC Database Statistics
___________________________
Median session length (minutes:seconds) 0:00
Average session length (minutes:seconds) 0:00
Longest session recorded (minutes:seconds) 710:27
Average number of searches completed per session 2.7
Retrievals per search - median 9.0
Retrievals per search - average 495.3
Retrievals per search - standard deviation 4510.2
Percent of searches completed with 0 results 22.3%
Percent of searches entered that are long 0.5%
Percent of long searches completed
(includes partial results) 75.8%
Commands entered, by type, excluding errors:
Total Percentage
__________ __________
FIND 6,480 36.4%
DISPLAY (excluding automatic displays) 5,324 29.9%
HELP 97 0.5%
EXPLAIN 127 0.7%
SET/RESET 1,131 6.4%
SHOW 34 0.2%
ADD ON (AND, OR, AND NOT) 590 3.3%
LOGON or LOGOFF 3,012 16.9%
COMMENT 0 0.0%
SAVE 179 1.0%
USE 4 0.0%
OTHER 827 4.6%
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,268 46.2% 503 15.4% 30 207.0 1541.0
TITLE WORD 1,943 27.5% 617 31.8% 13 823.5 4890.7
EXACT TITLE 124 1.8% 58 46.8% 4 72.2 506.7
JOURNAL 347 4.9% 141 40.6% 447 3453.6 9810.1
EXACT JOURNAL 165 2.3% 52 31.5% 1,081 5607.3 11354.3
SUBJECT CAT 35 0.5% 9 25.7% 13 22.6 31.2
SUBFILE 24 0.3% 4 16.7% 38 159.3 490.9
PUBLICATION TYPE 18 0.3% 3 16.7% 117 17107.4 63817.4
LANGUAGE 3 0.0% 2 66.7% 3,678 3678.0 0.0
DATE 157 2.2% 25 15.9% 14 161.3 747.5
ADDED 9 0.1% 2 22.2% 7 11.0 9.5
PERIODICAL 512 7.2% 49 9.6% 4 27.2 87.2
EXACT PE 126 1.8% 21 16.7% 3 10.4 31.8
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 344 4.9% 107 31.1% 18 637.1 3809.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 602 9.3% 180 29.9% 8 100.4 524.3
Single 5,848 90.7% 1,225 20.9% 25 730.2 5538.5
DISPLAY commands, by type, excluding automatic displays:
REVIEW 4.9%
SHORT 72.1%
LONG 6.9%
FIELDS 0.8%
PERIODICALS 14.0%
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) 74:25
Average number of searches completed per session 2.8
Retrievals per search - median 57.0
Retrievals per search - average 175.6
Retrievals per search - standard deviation 408.6
Percent of searches completed with 0 results 25.6%
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 335 27.8%
DISPLAY (excluding automatic displays) 574 47.7%
HELP 53 4.4%
EXPLAIN 20 1.7%
SET/RESET 95 7.9%
SHOW 5 0.4%
ADD ON (AND, OR, AND NOT) 9 0.7%
LOGON or LOGOFF 91 7.6%
COMMENT 0 0.0%
SAVE 0 0.0%
USE 0 0.0%
OTHER 21 1.7%
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 260 77.4% 82 31.5% 102 239.7 476.2
EXACT JOURNAL 50 14.9% 6 12.0% 151 339.4 514.2
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 1 0.3% 0 0.0% 18 18.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 25 7.4% 0 0.0% 6 14.0 21.4
By number of indexes:
Multiple 1 0.3% 0 0.0% 18 18.0 0.0
Single 334 99.7% 88 26.3% 89 235.5 465.9
DISPLAY commands, by type, excluding automatic displays:
REVIEW 12.0%
ISSUES 42.6%
SHORT 16.1%
LONG 21.5%
PERIODICALS 7.7%
COMMENTS 0.0%
Other 0.2%
2.3 Error, EXPLAIN and HELP statistics (CC & CCT)
__________________________________________________
Percent of commands that contained errors 7.4%
Ten most frequent errors:
1. NS command - no next screen 31.9%
2. First word of command is invalid 27.8%
3. FIND command with invalid index name 9.5%
4. Index invalid in current database 5.9%
5. DISPLAY command contains invalid word 2.6%
6. Search term missing from search command 2.4%
7. Valid command at an inappropriate time 1.8%
8. PS command - no previous screen 1.8%
9. DISPLAY command - no FIND results 1.2%
10. 422 1.2%
11. All others 13.6%
Ten most frequent EXPLAIN requests:
1. CC GUIDE 27.9%
2. LOCATE (ARTICLE DBS) 10.9%
3. FIND (CC DB) 10.2%
4. CC INDEXES 7.5%
5. CC DATABASE 4.8%
6. CCT INDEXES 4.8%
7. MAGS TEXT 4.1%
8. Unrecognized term 3.4%
9. FIND (CCT DB) 3.4%
10. COMMANDS 2.7%
11. All others 20.4%
Ten most frequent HELP situations:
1. Help requested from START CC command 19.2%
2. First word of command is invalid 14.8%
3. Help requested from SET DB command 10.4%
4. F/BR with index invalid in current DB 8.1%
5. FIND command with invalid index name 7.7%
6. DISPLAY command-complete in one screen 4.4%
7. DISPLAY command-first of >1 screen 4.0%
8. DISPLAY command - middle of >1 screen 3.7%
9. FIND command retrieves >1 book 3.4%
10. FIND command with zero results 2.7%
11. All others 21.5%
Ten most frequent SHOW requests:
1. HISTORY 46.2%
2. TIME 15.4%
3. SYSTEM NEWS 12.8%
4. SEARCH 5.1%
5. MAIL STATUS 5.1%
6. LIBRARY NEWS 2.6%
7. MAIL SETTINGS 2.6%
8. CC LOADING STATISTICS 2.6%
9. CC NEWS 2.6%
10. SC LIST (CC DBS) 2.6%
11. All others 2.6%
Cmm/yy cc MELVYL CURRENT CONTENTS DATABASE TELNET STATISTICS (monthly)