MELVYL CURRENT CONTENTS DATABASE TELNET STATISTICS
Time period: 11/01/99 through 11/30/99
1.0 SUMMARY STATISTICS
_______________________
1.1 Total sessions:
____________________
Location Library Remote Total
________ _______ ______ _____
Berkeley 1,456 5,260 6,716
Davis 2,743 286 3,029
Irvine 2,746 0 2,746
Los Angeles 744 2,271 3,015
Riverside 765 543 1,308
San Diego 417 1,851 2,268
San Francisco 1,245 8 1,253
Santa Barbara 523 1,169 1,692
Santa Cruz 850 781 1,631
LBL 0 709 709
LLL 0 924 924
Los Alamos n/a 5 5
Other - UC 8 334 342
U.S. Forestry 0
Other-Network UC n/a 2,629 2,629
_______ ______ _____
11,497 16,770 28,267
Per hour usage:
Time Sessions Finds Records Displayed
__________ __________ __________ _________________
12-2 a.m. 509 2,070 21,253
2-4 a.m. 333 1,369 66,042
4-6 a.m. 294 1,222 11,693
6-8 a.m. 699 2,849 26,599
8-10 a.m. 2,803 8,573 81,266
10-12 a.m. 4,929 14,546 151,263
12-2 p.m. 4,996 14,999 147,670
2-4 p.m. 5,755 16,609 150,634
4-6 p.m. 3,988 11,543 108,809
6-8 p.m. 1,938 5,977 52,793
8-10 p.m. 1,260 4,024 42,423
10-12 p.m. 763 2,743 25,661
__________ __________ __________ _________________
Total: 28,267 86,524 886,106
1.2 FIND commands
__________________
Number of FIND commands issued by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 4,152 16,616 20,768
Davis 8,405 788 9,193
Irvine 9,178 0 9,178
Los Angeles 2,722 6,470 9,192
Riverside 1,995 1,800 3,795
San Diego 1,215 5,373 6,588
San Francisco 3,468 18 3,486
Santa Barbara 1,328 3,610 4,938
Santa Cruz 1,985 2,177 4,162
LBL 0 2,554 2,554
LLL 0 5,183 5,183
Los Alamos n/a 28 28
Other - UC 23 754 777
U.S. Forestry 0
Other-Network UC n/a 6,682 6,682
_______ ______ _____
34,471 52,053 86,524
Number of FIND commands by database
CC database 84,935
CCT database 1,589
Total number of FIND commands 86,524
1.3 Records displayed
______________________
Number of Records Displayed by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 41,666 182,582 224,248
Davis 68,040 5,206 73,246
Irvine 122,966 0 122,966
Los Angeles 17,252 73,290 90,542
Riverside 20,677 17,247 37,924
San Diego 7,098 43,472 50,570
San Francisco 28,439 96 28,535
Santa Barbara 12,225 36,968 49,193
Santa Cruz 18,135 27,708 45,843
LBL 0 32,344 32,344
LLL 0 59,431 59,431
Los Alamos n/a 130 130
Other - UC 311 9,580 9,891
U.S. Forestry 0
Other-Network UC n/a 61,243 61,243
_______ ______ _____
336,809 549,297 886,106
Number of Records Displayed by database:
CC database 823,220
CCT database 62,886
Total number of Records Displayed 886,106
1.4 Relative Use of Databases
______________________________
Relative use of CC vs. CCT databases:
Percent of CC sessions 95.0%
Percent of CCT sessions 5.0%
Percent of searches done in the CC database 98.2%
Percent of searches done in the CCT database 1.8%
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) 475:27
Average number of searches completed per session 3.1
Retrievals per search - median 10.0
Retrievals per search - average 568.2
Retrievals per search - standard deviation 6999.6
Percent of searches completed with 0 results 24.2%
Percent of searches entered that are long 0.3%
Percent of long searches completed
(includes partial results) 52.3%
Commands entered, by type, excluding errors:
Total Percentage
__________ __________
FIND 79,044 37.3%
DISPLAY (excluding automatic displays) 60,497 28.6%
HELP 3,515 1.7%
EXPLAIN 3,426 1.6%
SET/RESET 9,596 4.5%
SHOW 549 0.3%
ADD ON (AND, OR, AND NOT) 5,891 2.8%
LOGON or LOGOFF 35,351 16.7%
COMMENT 4 0.0%
SAVE 3,791 1.8%
USE 100 0.0%
OTHER 10,040 4.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:
PERSONAL AUTHOR 35,485 40.8% 5,050 14.2% 30 228.2 1353.8
TITLE WORD 29,837 34.3% 8,435 28.3% 18 826.5 8244.4
EXACT TITLE 668 0.8% 369 55.2% 3 143.9 828.2
JOURNAL 4,112 4.7% 1,762 42.8% 527 6695.3 31009.1
EXACT JOURNAL 3,304 3.8% 1,930 58.4% 103 2387.5 6881.2
SUBJECT CAT 299 0.3% 34 11.4% 19 98.9 361.2
SUBFILE 238 0.3% 24 10.1% 31 272.1 993.8
PUBLICATION TYPE 341 0.4% 68 19.9% 14 1682.4 16305.2
LANGUAGE 137 0.2% 37 27.0% 15 1045.5 5922.0
DATE 967 1.1% 163 16.9% 15 134.7 427.7
ADDED 2,573 3.0% 1,871 72.7% 24 36.3 41.4
PERIODICAL 2,602 3.0% 527 20.3% 5 197.8 1579.1
EXACT PE 651 0.7% 82 12.6% 2 15.1 91.5
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 5,753 6.6% 1,758 30.6% 23 765.9 5454.3
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 8,051 10.2% 3,592 44.6% 9 83.5 686.1
Single 70,658 89.8% 14,863 21.0% 30 845.3 8595.6
DISPLAY commands, by type, excluding automatic displays:
REVIEW 4.0%
SHORT 81.6%
LONG 5.0%
FIELDS 1.3%
PERIODICALS 5.9%
COMMENTS 0.0%
Other 2.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) 396:19
Average number of searches completed per session 1.1
Retrievals per search - median 38.0
Retrievals per search - average 413.1
Retrievals per search - standard deviation 1985.0
Percent of searches completed with 0 results 35.7%
Percent of searches entered that are long 0.1%
Percent of long searches completed
(includes partial results) 100%
Commands entered, by type, excluding errors:
Total Percentage
__________ __________
FIND 1,571 19.6%
DISPLAY (excluding automatic displays) 2,214 27.6%
HELP 960 12.0%
EXPLAIN 459 5.7%
SET/RESET 947 11.8%
SHOW 163 2.0%
ADD ON (AND, OR, AND NOT) 18 0.2%
LOGON or LOGOFF 1,328 16.6%
COMMENT 1 0.0%
SAVE 7 0.1%
USE 9 0.1%
OTHER 346 4.3%
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 1,021 64.5% 421 41.2% 125 639.4 2476.1
EXACT JOURNAL 385 24.3% 113 29.3% 89 176.0 263.7
SUBJECT CAT 41 2.6% 4 9.8% 3,921 4666.5 4143.6
SUBFILE 0 0.0% 0 0.0% 0 0.0 0.0
DATE 23 1.5% 4 17.4% 35 2384.6 7499.6
ADDED 3 0.2% 0 0.0% 136 158.0 100.8
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 111 7.0% 20 18.0% 7 33.9 129.6
By number of indexes:
Multiple 22 1.4% 6 27.3% 24 55.0 79.0
Single 1,540 98.6% 550 35.7% 105 657.9 2475.9
DISPLAY commands, by type, excluding automatic displays:
REVIEW 3.4%
ISSUES 50.0%
SHORT 12.2%
LONG 26.4%
PERIODICALS 5.7%
COMMENTS 0.0%
Other 2.2%
2.3 Error, EXPLAIN and HELP statistics (CC & CCT)
__________________________________________________
Percent of commands that contained errors 10.4%
Ten most frequent errors:
1. First word of command is invalid 29.9%
2. NS command - no next screen 28.7%
3. FIND command with invalid index name 10.4%
4. Index invalid in current database 6.9%
5. PS command - no previous screen 2.0%
6. Search term missing from search command 1.9%
7. Valid command at an inappropriate time 1.8%
8. DISPLAY command contains invalid word 1.8%
9. F SUB CAT search with invalid SC 1.7%
10. D ABS command in database w/o abstracts 1.5%
11. All others 13.4%
Ten most frequent EXPLAIN requests:
1. CC GUIDE 17.8%
2. FIND (CC DB) 13.0%
3. CC INDEXES 10.8%
4. LOCATE (ARTICLE DBS) 9.6%
5. COMMANDS 6.5%
6. Unrecognized term 4.0%
7. CCT INDEXES 2.8%
8. DATABASES 2.6%
9. CC DATABASE 2.3%
10. CCT DATABASE 2.1%
11. All others 28.5%
Ten most frequent HELP situations:
1. Help requested from START CC command 15.4%
2. First word of command is invalid 13.5%
3. F/BR with index invalid in current DB 11.9%
4. FIND command with invalid index name 7.7%
5. Help requested from SET DB command 6.3%
6. FIND command with zero results 5.0%
7. DISPLAY command - middle of >1 screen 4.6%
8. DISPLAY command-first of >1 screen 4.4%
9. FIND command retrieves >1 book 2.9%
10. DISPLAY command-complete in one screen 2.8%
11. All others 25.6%
Ten most frequent SHOW requests:
1. HISTORY 36.1%
2. SEARCH 14.8%
3. MAIL STATUS 9.7%
4. SYSTEM NEWS 9.5%
5. SC LIST (CC DBS) 6.0%
6. CC NEWS 4.4%
7. CC GLOSSARY 3.8%
8. CC SETTINGS 2.4%
9. LIBRARY NEWS 2.1%
10. MAIL SETTINGS 1.7%
11. All others 9.5%