MELVYL CURRENT CONTENTS DATABASE TELNET STATISTICS
Time period: 12/01/99 through 12/31/99
1.0 SUMMARY STATISTICS
_______________________
1.1 Total sessions:
____________________
Location Library Remote Total
________ _______ ______ _____
Berkeley 638 3,551 4,189
Davis 2,066 205 2,271
Irvine 1,744 0 1,744
Los Angeles 574 1,536 2,110
Riverside 346 378 724
San Diego 350 1,498 1,848
San Francisco 1,052 5 1,057
Santa Barbara 278 953 1,231
Santa Cruz 327 436 763
LBL 0 425 425
LLL 0 612 612
Los Alamos n/a 2 2
Other - UC 22 199 221
U.S. Forestry 0
Other-Network UC n/a 2,263 2,263
_______ ______ _____
7,397 12,063 19,460
Per hour usage:
Time Sessions Finds Records Displayed
__________ __________ __________ _________________
12-2 a.m. 355 1,357 13,103
2-4 a.m. 258 1,209 53,501
4-6 a.m. 271 947 7,007
6-8 a.m. 524 2,109 15,596
8-10 a.m. 2,066 6,566 60,826
10-12 a.m. 3,737 10,741 100,369
12-2 p.m. 3,385 9,604 83,110
2-4 p.m. 3,924 11,460 108,113
4-6 p.m. 2,648 7,738 80,255
6-8 p.m. 1,093 3,567 42,188
8-10 p.m. 670 2,298 25,717
10-12 p.m. 529 2,022 21,879
__________ __________ __________ _________________
Total: 19,460 59,618 611,664
1.2 FIND commands
__________________
Number of FIND commands issued by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 1,639 11,510 13,149
Davis 6,132 477 6,609
Irvine 5,378 0 5,378
Los Angeles 1,695 4,679 6,374
Riverside 926 1,337 2,263
San Diego 990 4,339 5,329
San Francisco 2,923 5 2,928
Santa Barbara 936 3,049 3,985
Santa Cruz 784 1,304 2,088
LBL 0 1,463 1,463
LLL 0 4,023 4,023
Los Alamos n/a 7 7
Other - UC 45 841 886
U.S. Forestry 0
Other-Network UC n/a 5,136 5,136
_______ ______ _____
21,448 38,170 59,618
Number of FIND commands by database
CC database 58,464
CCT database 1,154
Total number of FIND commands 59,618
1.3 Records displayed
______________________
Number of Records Displayed by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 19,425 118,808 138,233
Davis 48,008 4,202 52,210
Irvine 84,840 0 84,840
Los Angeles 11,590 48,563 60,153
Riverside 5,506 12,312 17,818
San Diego 15,142 37,984 53,126
San Francisco 25,059 12 25,071
Santa Barbara 10,762 34,993 45,755
Santa Cruz 6,366 13,080 19,446
LBL 0 20,302 20,302
LLL 0 44,440 44,440
Los Alamos n/a 42 42
Other - UC 284 6,996 7,280
U.S. Forestry 0
Other-Network UC n/a 42,948 42,948
_______ ______ _____
226,982 384,682 611,664
Number of Records Displayed by database:
CC database 564,151
CCT database 47,513
Total number of Records Displayed 611,664
1.4 Relative Use of Databases
______________________________
Relative use of CC vs. CCT databases:
Percent of CC sessions 95.6%
Percent of CCT sessions 4.4%
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 4.6
Display response time from receipt of command at
DLA until transmission of a complete screen:
Average in seconds 0.2
Standard deviation in seconds 4.6
2.0 CC Database Statistics
___________________________
Median session length (minutes:seconds) 0:00
Average session length (minutes:seconds) 0:00
Longest session recorded (minutes:seconds) 1156
Average number of searches completed per session 3.1
Retrievals per search - median 10.0
Retrievals per search - average 559.8
Retrievals per search - standard deviation 6304.8
Percent of searches completed with 0 results 23.4%
Percent of searches entered that are long 0.3%
Percent of long searches completed
(includes partial results) 55.7%
Commands entered, by type, excluding errors:
Total Percentage
__________ __________
FIND 54,385 37.7%
DISPLAY (excluding automatic displays) 41,911 29.0%
HELP 1,641 1.1%
EXPLAIN 1,747 1.2%
SET/RESET 7,084 4.9%
SHOW 284 0.2%
ADD ON (AND, OR, AND NOT) 4,079 2.8%
LOGON or LOGOFF 23,864 16.5%
COMMENT 1 0.0%
SAVE 2,594 1.8%
USE 115 0.1%
OTHER 6,599 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 27,037 44.5% 3,801 14.1% 29 215.1 1416.4
TITLE WORD 19,650 32.4% 5,484 27.9% 18 865.9 6264.6
EXACT TITLE 401 0.7% 212 52.9% 2 142.9 809.4
JOURNAL 2,655 4.4% 1,125 42.4% 500 6384.2 28453.6
EXACT JOURNAL 2,305 3.8% 1,447 62.8% 82 2368.6 9931.1
SUBJECT CAT 223 0.4% 25 11.2% 12 146.4 666.8
SUBFILE 132 0.2% 21 15.9% 39 569.0 1892.1
PUBLICATION TYPE 265 0.4% 54 20.4% 17 2030.7 18656.9
LANGUAGE 68 0.1% 14 20.6% 19 456.1 1275.1
DATE 775 1.3% 137 17.7% 13 132.6 494.5
ADDED 2,013 3.3% 1,555 77.2% 24 42.9 49.0
PERIODICAL 1,642 2.7% 324 19.7% 4 109.1 812.5
EXACT PE 336 0.6% 46 13.7% 3 31.6 160.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 3,220 5.3% 983 30.5% 20 1068.4 9903.8
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 6,412 11.8% 2,923 45.6% 7 79.8 489.5
Single 47,723 88.2% 9,331 19.6% 31 825.9 7695.4
DISPLAY commands, by type, excluding automatic displays:
REVIEW 4.4%
SHORT 81.8%
LONG 5.4%
FIELDS 1.4%
PERIODICALS 5.3%
COMMENTS 0.0%
Other 1.7%
2.1 CCT Database Statistics
____________________________
Median session length (minutes:seconds) 0:00
Average session length (minutes:seconds) 0:00
Longest session recorded (minutes:seconds) 132:24
Average number of searches completed per session 1.3
Retrievals per search - median 36.0
Retrievals per search - average 354.2
Retrievals per search - standard deviation 1497.0
Percent of searches completed with 0 results 34.7%
Percent of searches entered that are long 0.2%
Percent of long searches completed
(includes partial results) 0.0%
Commands entered, by type, excluding errors:
Total Percentage
__________ __________
FIND 1,150 21.1%
DISPLAY (excluding automatic displays) 1,990 36.6%
HELP 431 7.9%
EXPLAIN 220 4.0%
SET/RESET 530 9.7%
SHOW 69 1.3%
ADD ON (AND, OR, AND NOT) 4 0.1%
LOGON or LOGOFF 803 14.8%
COMMENT 0 0.0%
SAVE 26 0.5%
USE 15 0.3%
OTHER 204 3.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 725 62.6% 278 38.3% 109 503.2 1565.1
EXACT JOURNAL 343 29.6% 115 33.5% 83 248.2 822.5
SUBJECT CAT 24 2.1% 8 33.3% 6,543 7584.7 5284.1
SUBFILE 1 0.1% 0 0.0% 850 850.0 0.0
DATE 6 0.5% 1 16.7% 10 165.2 243.1
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 60 5.2% 5 8.3% 4 70.0 273.2
By number of indexes:
Multiple 14 1.2% 9 64.3% 10 282.6 395.9
Single 1,131 98.8% 389 34.4% 91 546.6 1834.7
DISPLAY commands, by type, excluding automatic displays:
REVIEW 3.4%
ISSUES 45.6%
SHORT 24.0%
LONG 20.3%
PERIODICALS 4.5%
COMMENTS 0.0%
Other 2.0%
2.3 Error, EXPLAIN and HELP statistics (CC & CCT)
__________________________________________________
Percent of commands that contained errors 9.0%
Ten most frequent errors:
1. NS command - no next screen 31.9%
2. First word of command is invalid 28.6%
3. FIND command with invalid index name 10.4%
4. Index invalid in current database 5.2%
5. PS command - no previous screen 2.1%
6. DISPLAY command contains invalid word 2.0%
7. Search term missing from search command 1.9%
8. D ABS command in database w/o abstracts 1.8%
9. Valid command at an inappropriate time 1.4%
10. Add-on search, no index name after verb 1.3%
11. All others 13.4%
Ten most frequent EXPLAIN requests:
1. CC GUIDE 16.4%
2. FIND (CC DB) 13.8%
3. CC INDEXES 11.2%
4. LOCATE (ARTICLE DBS) 7.6%
5. COMMANDS 5.8%
6. Unrecognized term 4.2%
7. ADD-ON SEARCH 3.2%
8. CC DATABASE 3.0%
9. CCT INDEXES 2.9%
10. MAIL 2.3%
11. All others 29.6%
Ten most frequent HELP situations:
1. Help requested from START CC command 16.4%
2. First word of command is invalid 13.7%
3. F/BR with index invalid in current DB 9.2%
4. FIND command with invalid index name 6.8%
5. Help requested from SET DB command 5.8%
6. DISPLAY command-first of >1 screen 5.7%
7. DISPLAY command - middle of >1 screen 4.6%
8. FIND command with zero results 4.5%
9. FIND command retrieves >1 book 4.0%
10. DISPLAY command-complete in one screen 2.9%
11. All others 26.5%
Ten most frequent SHOW requests:
1. HISTORY 41.3%
2. SEARCH 17.8%
3. MAIL STATUS 9.5%
4. SYSTEM NEWS 5.7%
5. SC LIST (CC DBS) 4.0%
6. CC NEWS 3.7%
7. CC GLOSSARY 3.4%
8. CC SETTINGS 2.6%
9. CCT SETTINGS 2.3%
10. LIBRARY NEWS 2.0%
11. All others 7.7%
Cmm/yy cc MELVYL CURRENT CONTENTS DATABASE TELNET STATISTICS (monthly)