MELVYL CURRENT CONTENTS DATABASE TELNET STATISTICS
Time period: 06/23/01 through 06/29/01
1.0 SUMMARY STATISTICS
_______________________
1.1 Total sessions:
____________________
Location Library Remote Total
________ _______ ______ _____
Berkeley 63 498 561
Davis 282 26 308
Irvine 190 0 190
Los Angeles 1 213 214
Riverside 23 56 79
San Diego 28 180 208
San Francisco 147 0 147
Santa Barbara 8 115 123
Santa Cruz 15 57 72
LBL 0 100 100
LLL 0 52 52
Los Alamos n/a 0 0
Other - UC 0 36 36
U.S. Forestry 0
Other-Network UC n/a 641 641
_______ ______ _____
757 1,974 2,731
Per hour usage:
Time Sessions Finds Records Displayed
__________ __________ __________ _________________
12-2 a.m. 56 280 1,779
2-4 a.m. 25 141 1,373
4-6 a.m. 31 116 893
6-8 a.m. 91 755 5,730
8-10 a.m. 272 964 6,776
10-12 a.m. 561 1,434 11,667
12-2 p.m. 437 1,244 11,432
2-4 p.m. 504 1,351 12,695
4-6 p.m. 373 1,004 12,466
6-8 p.m. 171 579 4,386
8-10 p.m. 98 336 3,049
10-12 p.m. 112 390 2,360
__________ __________ __________ _________________
Total: 2,731 8,594 74,606
1.2 FIND commands
__________________
Number of FIND commands issued by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 161 1,384 1,545
Davis 749 59 808
Irvine 541 0 541
Los Angeles 3 598 601
Riverside 43 139 182
San Diego 109 465 574
San Francisco 368 0 368
Santa Barbara 17 378 395
Santa Cruz 28 202 230
LBL 0 323 323
LLL 0 778 778
Los Alamos n/a 0 0
Other - UC 0 98 98
U.S. Forestry 0
Other-Network UC n/a 2,151 2,151
_______ ______ _____
2,019 6,575 8,594
Number of FIND commands by database
CC database 8,465
CCT database 129
Total number of FIND commands 8,594
1.3 Records displayed
______________________
Number of Records Displayed by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 2,312 12,054 14,366
Davis 7,798 281 8,079
Irvine 5,401 0 5,401
Los Angeles 4 5,082 5,086
Riverside 348 845 1,193
San Diego 2,295 4,493 6,788
San Francisco 3,703 0 3,703
Santa Barbara 145 3,367 3,512
Santa Cruz 232 2,072 2,304
LBL 0 2,976 2,976
LLL 0 6,938 6,938
Los Alamos n/a 0 0
Other - UC 0 953 953
U.S. Forestry 0
Other-Network UC n/a 13,307 13,307
_______ ______ _____
22,238 52,368 74,606
Number of Records Displayed by database:
CC database 66,835
CCT database 7,771
Total number of Records Displayed 74,606
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.5%
Percent of searches done in the CCT database 1.5%
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 4.2
Display response time from receipt of command at
DLA until transmission of a complete screen:
Average in seconds 0.1
Standard deviation in seconds 4.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) 519:51
Average number of searches completed per session 3.2
Retrievals per search - median 6.0
Retrievals per search - average 480.1
Retrievals per search - standard deviation 4149.6
Percent of searches completed with 0 results 27.2%
Percent of searches entered that are long 0.3%
Percent of long searches completed
(includes partial results) 73.1%
Commands entered, by type, excluding errors:
Total Percentage
__________ __________
FIND 7,607 38.7%
DISPLAY (excluding automatic displays) 5,588 28.5%
HELP 100 0.5%
EXPLAIN 105 0.5%
SET/RESET 1,203 6.1%
SHOW 28 0.1%
ADD ON (AND, OR, AND NOT) 858 4.4%
LOGON or LOGOFF 3,067 15.6%
COMMENT 0 0.0%
SAVE 270 1.4%
USE 16 0.1%
OTHER 789 4.0%
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,458 39.2% 547 15.8% 30 294.9 1636.4
TITLE WORD 2,502 28.4% 809 32.3% 13 892.6 5191.9
EXACT TITLE 139 1.6% 57 41.0% 3 342.0 1133.0
JOURNAL 358 4.1% 173 48.3% 182 5310.7 19548.9
EXACT JOURNAL 489 5.5% 315 64.4% 38 2912.8 9086.2
SUBJECT CAT 25 0.3% 9 36.0% 15 20.9 15.9
SUBFILE 15 0.2% 0 0.0% 28 3577.8 7660.7
PUBLICATION TYPE 23 0.3% 3 13.0% 18 459.7 1083.4
LANGUAGE 5 0.1% 0 0.0% 751 1594.0 1839.1
DATE 125 1.4% 26 20.8% 5 105.2 481.8
ADDED 611 6.9% 455 74.5% 20 31.3 39.4
PERIODICAL 593 6.7% 100 16.9% 4 69.5 682.6
EXACT PE 117 1.3% 14 12.0% 5 16.3 40.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 363 4.1% 119 32.8% 14 409.1 1527.9
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 1,218 16.1% 641 52.6% 7 140.9 1352.2
Single 6,368 83.9% 1,340 21.0% 26 783.4 5335.4
DISPLAY commands, by type, excluding automatic displays:
REVIEW 5.7%
SHORT 72.8%
LONG 3.4%
FIELDS 2.2%
PERIODICALS 14.1%
COMMENTS 0.0%
Other 1.8%
2.1 CCT Database Statistics
____________________________
Median session length (minutes:seconds) 0:00
Average session length (minutes:seconds) 0:00
Longest session recorded (minutes:seconds) 59:25
Average number of searches completed per session 1.5
Retrievals per search - median 47.0
Retrievals per search - average 649.9
Retrievals per search - standard deviation 2936.9
Percent of searches completed with 0 results 24.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 129 18.1%
DISPLAY (excluding automatic displays) 330 46.2%
HELP 57 8.0%
EXPLAIN 34 4.8%
SET/RESET 52 7.3%
SHOW 6 0.8%
ADD ON (AND, OR, AND NOT) 0 0.0%
LOGON or LOGOFF 93 13.0%
COMMENT 0 0.0%
SAVE 0 0.0%
USE 0 0.0%
OTHER 13 1.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 85 65.4% 25 29.4% 100 878.9 3558.3
EXACT JOURNAL 15 11.5% 1 6.7% 128 307.3 467.4
SUBJECT CAT 2 1.5% 0 0.0% 13,000 13000.0 4767.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 1 0.8% 0 0.0% 1 1.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 27 20.8% 5 18.5% 3 36.4 107.0
By number of indexes:
Multiple 1 0.8% 0 0.0% 1 1.0 0.0
Single 128 99.2% 31 24.2% 92 864.3 3363.5
DISPLAY commands, by type, excluding automatic displays:
REVIEW 7.4%
ISSUES 43.8%
SHORT 22.0%
LONG 12.9%
PERIODICALS 13.2%
COMMENTS 0.0%
Other 0.6%
2.3 Error, EXPLAIN and HELP statistics (CC & CCT)
__________________________________________________
Percent of commands that contained errors 8.1%
Ten most frequent errors:
1. NS command - no next screen 30.9%
2. First word of command is invalid 27.7%
3. FIND command with invalid index name 8.1%
4. Max. # of ports to a Z39 db are in use 6.3%
5. DISPLAY command contains invalid word 2.6%
6. Index invalid in current database 2.4%
7. DISPLAY command - no FIND results 2.2%
8. Search term missing from search command 2.1%
9. D ABS command in database w/o abstracts 1.5%
10. PS command - no previous screen 1.4%
11. All others 14.7%
Ten most frequent EXPLAIN requests:
1. CC GUIDE 13.7%
2. FIND (CC DB) 8.6%
3. COMMANDS 7.2%
4. CC INDEXES 6.5%
5. CC DATABASE 5.0%
6. LOCATE (ARTICLE DBS) 4.3%
7. DATABASES 4.3%
8. CCT DATABASE 4.3%
9. Unrecognized term 3.6%
10. MAIL 2.2%
11. All others 40.3%
Ten most frequent HELP situations:
1. Help requested from START CC command 13.9%
2. First word of command is invalid 11.1%
3. Help requested from SET DB command 7.8%
4. FIND command with invalid index name 6.4%
5. DISPLAY command - middle of >1 screen 6.4%
6. DISPLAY command-first of >1 screen 5.4%
7. DISPLAY command contains invalid word 4.1%
8. FIND command with zero results 4.1%
9. Multi-index search with zero results 4.1%
10. F/BR with index invalid in current DB 3.7%
11. All others 33.1%
Ten most frequent SHOW requests:
1. HISTORY 44.1%
2. SEARCH 11.8%
3. SC LIST (CC DBS) 8.8%
4. UPDATE 5.9%
5. GLOSSARY 2.9%
6. SYSTEM NEWS 2.9%
7. MAIL SETTINGS 2.9%
8. STATISTICS 2.9%
9. CC SETTINGS 2.9%
10. CCT SETTINGS 2.9%
11. All others 11.8%
Cmm/yy cc MELVYL CURRENT CONTENTS DATABASE TELNET STATISTICS (monthly)