MELVYL CURRENT CONTENTS DATABASE TELNET STATISTICS
Time period: 09/01/99 through 09/30/99
1.0 SUMMARY STATISTICS
_______________________
1.1 Total sessions:
____________________
Location Library Remote Total
________ _______ ______ _____
Berkeley 1,505 5,497 7,002
Davis 2,612 315 2,927
Irvine 2,181 0 2,181
Los Angeles 519 2,046 2,565
Riverside 412 559 971
San Diego 666 1,539 2,205
San Francisco 1,447 11 1,458
Santa Barbara 378 1,192 1,570
Santa Cruz 374 645 1,019
LBL 0 740 740
LLL 0 772 772
Los Alamos n/a 5 5
Other - UC 35 279 314
U.S. Forestry 0
Other-Network UC n/a 2,732 2,732
_______ ______ _____
10,129 16,332 26,461
Per hour usage:
Time Sessions Finds Records Displayed
__________ __________ __________ _________________
12-2 a.m. 450 1,984 22,012
2-4 a.m. 294 1,281 50,723
4-6 a.m. 308 980 49,647
6-8 a.m. 665 2,779 27,807
8-10 a.m. 2,748 8,120 77,575
10-12 a.m. 4,993 14,267 120,580
12-2 p.m. 4,620 13,141 123,059
2-4 p.m. 5,515 16,549 147,579
4-6 p.m. 3,788 10,909 112,917
6-8 p.m. 1,473 4,738 44,859
8-10 p.m. 890 3,601 36,251
10-12 p.m. 717 3,085 26,036
__________ __________ __________ _________________
Total: 26,461 81,434 839,045
1.2 FIND commands
__________________
Number of FIND commands issued by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 3,936 17,116 21,052
Davis 8,207 844 9,051
Irvine 7,010 0 7,010
Los Angeles 1,457 6,634 8,091
Riverside 1,178 2,115 3,293
San Diego 1,967 4,650 6,617
San Francisco 4,034 23 4,057
Santa Barbara 959 3,879 4,838
Santa Cruz 995 1,616 2,611
LBL 0 2,500 2,500
LLL 0 4,078 4,078
Los Alamos n/a 12 12
Other - UC 62 733 795
U.S. Forestry 0
Other-Network UC n/a 7,429 7,429
_______ ______ _____
29,805 51,629 81,434
Number of FIND commands by database
CC database 79,921
CCT database 1,513
Total number of FIND commands 81,434
1.3 Records displayed
______________________
Number of Records Displayed by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 42,588 191,332 233,920
Davis 67,223 5,955 73,178
Irvine 127,380 0 127,380
Los Angeles 10,254 58,044 68,298
Riverside 7,270 19,579 26,849
San Diego 11,775 37,505 49,280
San Francisco 28,836 172 29,008
Santa Barbara 9,335 40,724 50,059
Santa Cruz 13,041 18,660 31,701
LBL 0 32,280 32,280
LLL 0 43,899 43,899
Los Alamos n/a 20 20
Other - UC 749 8,793 9,542
U.S. Forestry 0
Other-Network UC n/a 63,631 63,631
_______ ______ _____
318,451 520,594 839,045
Number of Records Displayed by database:
CC database 780,236
CCT database 58,809
Total number of Records Displayed 839,045
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.3
Standard deviation in seconds 4.8
Display response time from receipt of command at
DLA until transmission of a complete screen:
Average in seconds 0.3
Standard deviation in seconds 4.8
2.0 CC Database Statistics
___________________________
Median session length (minutes:seconds) 0:00
Average session length (minutes:seconds) 0:00
Longest session recorded (minutes:seconds) 1084
Average number of searches completed per session 3.2
Retrievals per search - median 10.0
Retrievals per search - average 522.5
Retrievals per search - standard deviation 8378.5
Percent of searches completed with 0 results 22.8%
Percent of searches entered that are long 0.2%
Percent of long searches completed
(includes partial results) 60.2%
Commands entered, by type, excluding errors:
Total Percentage
__________ __________
FIND 73,119 36.9%
DISPLAY (excluding automatic displays) 56,257 28.4%
HELP 2,565 1.3%
EXPLAIN 2,754 1.4%
SET/RESET 9,184 4.6%
SHOW 460 0.2%
ADD ON (AND, OR, AND NOT) 6,802 3.4%
LOGON or LOGOFF 33,042 16.7%
COMMENT 3 0.0%
SAVE 4,344 2.2%
USE 77 0.0%
OTHER 9,589 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 35,759 44.6% 5,151 14.4% 30 197.3 1094.4
TITLE WORD 26,613 33.2% 7,484 28.1% 18 955.5 15272.2
EXACT TITLE 653 0.8% 398 60.9% 2 91.4 502.5
JOURNAL 3,798 4.7% 1,454 38.3% 417 4666.1 17709.8
EXACT JOURNAL 2,578 3.2% 1,400 54.3% 186 2251.0 6646.7
SUBJECT CAT 225 0.3% 56 24.9% 7 187.3 908.8
SUBFILE 215 0.3% 18 8.4% 35 513.9 4211.4
PUBLICATION TYPE 286 0.4% 80 28.0% 12 1858.7 18130.3
LANGUAGE 65 0.1% 12 18.5% 84 3671.7 10993.5
DATE 1,142 1.4% 195 17.1% 10 100.7 509.3
ADDED 1,623 2.0% 1,128 69.5% 26 38.0 42.8
PERIODICAL 2,327 2.9% 437 18.8% 6 107.0 781.7
EXACT PE 499 0.6% 67 13.4% 3 20.7 106.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 4,326 5.4% 1,247 28.8% 21 815.2 7311.4
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,111 9.8% 2,906 40.9% 7 104.2 1356.9
Single 65,646 90.2% 13,254 20.2% 31 773.7 10299.2
DISPLAY commands, by type, excluding automatic displays:
REVIEW 3.9%
SHORT 81.4%
LONG 4.8%
FIELDS 1.3%
PERIODICALS 5.8%
COMMENTS 0.0%
Other 2.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) 370:44
Average number of searches completed per session 1.2
Retrievals per search - median 39.0
Retrievals per search - average 369.6
Retrievals per search - standard deviation 1863.4
Percent of searches completed with 0 results 32.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 1,490 20.9%
DISPLAY (excluding automatic displays) 2,285 32.1%
HELP 676 9.5%
EXPLAIN 402 5.6%
SET/RESET 827 11.6%
SHOW 92 1.3%
ADD ON (AND, OR, AND NOT) 23 0.3%
LOGON or LOGOFF 1,041 14.6%
COMMENT 0 0.0%
SAVE 10 0.1%
USE 2 0.0%
OTHER 276 3.9%
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 927 61.7% 333 35.9% 106 425.3 1712.8
EXACT JOURNAL 414 27.5% 133 32.1% 99 243.2 575.9
SUBJECT CAT 33 2.2% 4 12.1% 6,471 6564.8 4684.2
SUBFILE 2 0.1% 0 0.0% 81 80.5 57.3
DATE 11 0.7% 3 27.3% 4 5101.0 14168.4
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 116 7.7% 14 12.1% 5 47.3 199.1
By number of indexes:
Multiple 18 1.2% 7 38.9% 9 85.1 158.4
Single 1,467 98.8% 473 32.2% 82 558.6 2272.4
DISPLAY commands, by type, excluding automatic displays:
REVIEW 2.7%
ISSUES 47.9%
SHORT 11.8%
LONG 27.4%
PERIODICALS 7.9%
COMMENTS 0.0%
Other 2.3%
2.3 Error, EXPLAIN and HELP statistics (CC & CCT)
__________________________________________________
Percent of commands that contained errors 9.2%
Ten most frequent errors:
1. NS command - no next screen 30.3%
2. First word of command is invalid 30.2%
3. FIND command with invalid index name 9.8%
4. Index invalid in current database 5.4%
5. DISPLAY command contains invalid word 2.1%
6. PS command - no previous screen 1.9%
7. Search term missing from search command 1.8%
8. D ABS command in database w/o abstracts 1.7%
9. Valid command at an inappropriate time 1.6%
10. Add-on search, no index name after verb 1.3%
11. All others 13.9%
Ten most frequent EXPLAIN requests:
1. CC GUIDE 15.0%
2. FIND (CC DB) 13.0%
3. CC INDEXES 9.9%
4. LOCATE (ARTICLE DBS) 8.0%
5. COMMANDS 6.5%
6. Unrecognized term 5.0%
7. CC DATABASE 3.5%
8. ADD-ON SEARCH 2.8%
9. CCT INDEXES 2.8%
10. DATABASES 2.5%
11. All others 30.9%
Ten most frequent HELP situations:
1. Help requested from START CC command 16.4%
2. First word of command is invalid 11.6%
3. F/BR with index invalid in current DB 9.8%
4. FIND command with invalid index name 6.4%
5. Help requested from SET DB command 5.8%
6. DISPLAY command - middle of >1 screen 5.3%
7. FIND command with zero results 5.2%
8. DISPLAY command-first of >1 screen 4.8%
9. FIND command retrieves >1 book 4.0%
10. DISPLAY command-complete in one screen 3.1%
11. All others 27.6%
Ten most frequent SHOW requests:
1. HISTORY 43.0%
2. MAIL STATUS 14.5%
3. SEARCH 13.0%
4. SC LIST (CC DBS) 6.2%
5. SYSTEM NEWS 5.5%
6. CC NEWS 4.6%
7. CC GLOSSARY 3.5%
8. CC SETTINGS 1.8%
9. MAIL SETTINGS 1.1%
10. CCT SETTINGS 1.1%
11. All others 5.7%