MELVYL CURRENT CONTENTS DATABASE TELNET STATISTICS
Time period: 02/01/00 through 02/29/00
1.0 SUMMARY STATISTICS
_______________________
1.1 Total sessions:
____________________
Location Library Remote Total
________ _______ ______ _____
Berkeley 976 4,400 5,376
Davis 2,389 175 2,564
Irvine 2,020 0 2,020
Los Angeles 656 1,898 2,554
Riverside 518 533 1,051
San Diego 339 1,703 2,042
San Francisco 1,341 0 1,341
Santa Barbara 437 1,156 1,593
Santa Cruz 622 616 1,238
LBL 0 686 686
LLL 0 674 674
Los Alamos n/a 4 4
Other - UC 29 192 221
U.S. Forestry 0
Other-Network UC n/a 2,840 2,840
_______ ______ _____
9,327 14,877 24,204
Per hour usage:
Time Sessions Finds Records Displayed
__________ __________ __________ _________________
12-2 a.m. 421 1,433 15,101
2-4 a.m. 320 1,063 34,958
4-6 a.m. 325 960 11,299
6-8 a.m. 746 3,510 31,483
8-10 a.m. 2,540 8,185 73,074
10-12 a.m. 4,199 11,226 104,175
12-2 p.m. 4,237 11,122 135,781
2-4 p.m. 4,942 14,317 131,532
4-6 p.m. 3,348 9,490 119,305
6-8 p.m. 1,522 4,515 45,714
8-10 p.m. 946 2,840 48,357
10-12 p.m. 658 2,219 20,521
__________ __________ __________ _________________
Total: 24,204 70,880 771,300
1.2 FIND commands
__________________
Number of FIND commands issued by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 2,650 13,171 15,821
Davis 7,353 461 7,814
Irvine 5,759 0 5,759
Los Angeles 1,580 5,229 6,809
Riverside 1,471 1,624 3,095
San Diego 1,122 5,028 6,150
San Francisco 3,503 0 3,503
Santa Barbara 1,392 4,070 5,462
Santa Cruz 1,366 1,863 3,229
LBL 0 2,129 2,129
LLL 0 4,250 4,250
Los Alamos n/a 8 8
Other - UC 49 425 474
U.S. Forestry 0
Other-Network UC n/a 6,377 6,377
_______ ______ _____
26,245 44,635 70,880
Number of FIND commands by database
CC database 69,556
CCT database 1,324
Total number of FIND commands 70,880
1.3 Records displayed
______________________
Number of Records Displayed by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 28,716 144,373 173,089
Davis 105,568 3,671 109,239
Irvine 70,951 0 70,951
Los Angeles 12,157 62,192 74,349
Riverside 10,556 14,869 25,425
San Diego 6,812 63,768 70,580
San Francisco 29,631 0 29,631
Santa Barbara 10,967 42,591 53,558
Santa Cruz 12,664 18,860 31,524
LBL 0 22,777 22,777
LLL 0 53,222 53,222
Los Alamos n/a 34 34
Other - UC 701 5,689 6,390
U.S. Forestry 0
Other-Network UC n/a 50,531 50,531
_______ ______ _____
288,723 482,577 771,300
Number of Records Displayed by database:
CC database 712,753
CCT database 58,547
Total number of Records Displayed 771,300
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 98.1%
Percent of searches done in the CCT database 1.9%
1.5 Response time
__________________
Search response time from receipt of command at
DLA until transmission of response:
Average in seconds 1.1
Standard deviation in seconds 5.3
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.3
2.0 CC Database Statistics
___________________________
Median session length (minutes:seconds) 0:00
Average session length (minutes:seconds) 0:00
Longest session recorded (minutes:seconds) 1202
Average number of searches completed per session 3.0
Retrievals per search - median 10.0
Retrievals per search - average 541.2
Retrievals per search - standard deviation 5141.2
Percent of searches completed with 0 results 23.9%
Percent of searches entered that are long 0.2%
Percent of long searches completed
(includes partial results) 52.8%
Commands entered, by type, excluding errors:
Total Percentage
__________ __________
FIND 64,522 37.0%
DISPLAY (excluding automatic displays) 49,540 28.4%
HELP 2,403 1.4%
EXPLAIN 2,398 1.4%
SET/RESET 8,832 5.1%
SHOW 402 0.2%
ADD ON (AND, OR, AND NOT) 5,034 2.9%
LOGON or LOGOFF 29,640 17.0%
COMMENT 1 0.0%
SAVE 3,303 1.9%
USE 96 0.1%
OTHER 8,341 4.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:
PERSONAL AUTHOR 30,211 42.3% 4,238 14.0% 31 224.5 1271.6
TITLE WORD 23,737 33.2% 6,911 29.1% 17 858.2 5652.5
EXACT TITLE 526 0.7% 260 49.4% 2 188.8 1068.1
JOURNAL 3,486 4.9% 1,440 41.3% 513 5099.6 21134.2
EXACT JOURNAL 2,608 3.7% 1,447 55.5% 70 2070.9 8008.4
SUBJECT CAT 334 0.5% 52 15.6% 22 130.5 540.0
SUBFILE 223 0.3% 14 6.3% 38 590.3 2291.8
PUBLICATION TYPE 364 0.5% 90 24.7% 11 1487.9 16748.1
LANGUAGE 31 0.0% 7 22.6% 69 2513.5 10801.4
DATE 960 1.3% 162 16.9% 8 134.4 599.8
ADDED 2,006 2.8% 1,377 68.6% 22 106.5 1097.0
PERIODICAL 1,958 2.7% 373 19.0% 5 160.6 1474.6
EXACT PE 481 0.7% 74 15.4% 3 17.8 77.6
RPE 0 0.0% 0 0.0% 0 0.0 0.0
XRP 1 0.0% 0 0.0% 6 6.0 0.0
COMMENTS 0 0.0% 0 0.0% 0 0.0 0.0
Other indexes 4,514 6.3% 1,401 31.0% 20 986.8 6106.6
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 7,025 10.9% 2,877 41.0% 8 86.6 640.8
Single 57,250 89.1% 12,047 21.0% 32 809.1 6330.4
DISPLAY commands, by type, excluding automatic displays:
REVIEW 4.5%
SHORT 80.4%
LONG 6.0%
FIELDS 1.3%
PERIODICALS 5.7%
COMMENTS 0.0%
Other 2.0%
2.1 CCT Database Statistics
____________________________
Median session length (minutes:seconds) 0:00
Average session length (minutes:seconds) 0:00
Longest session recorded (minutes:seconds) 153:50
Average number of searches completed per session 1.2
Retrievals per search - median 42.0
Retrievals per search - average 278.1
Retrievals per search - standard deviation 1124.6
Percent of searches completed with 0 results 27.7%
Percent of searches entered that are long 0.1%
Percent of long searches completed
(includes partial results) 0.0%
Commands entered, by type, excluding errors:
Total Percentage
__________ __________
FIND 1,317 19.8%
DISPLAY (excluding automatic displays) 2,217 33.4%
HELP 682 10.3%
EXPLAIN 325 4.9%
SET/RESET 731 11.0%
SHOW 106 1.6%
ADD ON (AND, OR, AND NOT) 7 0.1%
LOGON or LOGOFF 989 14.9%
COMMENT 0 0.0%
SAVE 27 0.4%
USE 9 0.1%
OTHER 227 3.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 778 58.6% 260 33.4% 122 347.3 867.1
EXACT JOURNAL 401 30.2% 87 21.7% 92 174.2 264.5
SUBJECT CAT 14 1.1% 0 0.0% 6,663 7899.1 4402.1
SUBFILE 1 0.1% 0 0.0% 103 103.0 0.0
DATE 11 0.8% 2 18.2% 1 1.0 0.0
ADDED 1 0.1% 0 0.0% 103 103.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 122 9.2% 17 13.9% 4 209.3 1245.2
By number of indexes:
Multiple 12 0.9% 2 16.7% 1 11.2 32.3
Single 1,304 99.1% 362 27.8% 92 389.8 1316.5
DISPLAY commands, by type, excluding automatic displays:
REVIEW 3.8%
ISSUES 50.9%
SHORT 12.1%
LONG 24.9%
PERIODICALS 7.3%
COMMENTS 0.0%
Other 1.0%
2.3 Error, EXPLAIN and HELP statistics (CC & CCT)
__________________________________________________
Percent of commands that contained errors 9.3%
Ten most frequent errors:
1. NS command - no next screen 30.0%
2. First word of command is invalid 29.3%
3. FIND command with invalid index name 10.5%
4. Index invalid in current database 5.9%
5. DISPLAY command contains invalid word 2.1%
6. Search term missing from search command 2.0%
7. D ABS command in database w/o abstracts 1.9%
8. PS command - no previous screen 1.8%
9. Valid command at an inappropriate time 1.4%
10. F SUB CAT search with invalid SC 1.3%
11. All others 13.9%
Ten most frequent EXPLAIN requests:
1. CC GUIDE 16.1%
2. FIND (CC DB) 12.4%
3. CC INDEXES 10.7%
4. LOCATE (ARTICLE DBS) 9.3%
5. COMMANDS 7.3%
6. Unrecognized term 4.0%
7. CCT INDEXES 3.1%
8. CC DATABASE 2.9%
9. DATABASES 2.9%
10. MAIL 2.7%
11. All others 28.6%
Ten most frequent HELP situations:
1. Help requested from START CC command 16.4%
2. First word of command is invalid 12.4%
3. F/BR with index invalid in current DB 10.3%
4. FIND command with invalid index name 7.5%
5. Help requested from SET DB command 6.3%
6. DISPLAY command - middle of >1 screen 4.7%
7. DISPLAY command-first of >1 screen 4.5%
8. FIND command with zero results 4.3%
9. FIND command retrieves >1 book 3.5%
10. DISPLAY command-complete in one screen 3.2%
11. All others 26.8%
Ten most frequent SHOW requests:
1. HISTORY 36.2%
2. MAIL STATUS 14.6%
3. SEARCH 14.0%
4. SYSTEM NEWS 7.9%
5. CC NEWS 5.2%
6. SC LIST (CC DBS) 5.0%
7. CC GLOSSARY 3.1%
8. CC SETTINGS 2.7%
9. LIBRARY NEWS 2.3%
10. CCT SETTINGS 0.8%
11. All others 7.9%
Cmm/yy cc MELVYL CURRENT CONTENTS DATABASE TELNET STATISTICS (monthly)