MELVYL CURRENT CONTENTS DATABASE TELNET STATISTICS
Time period: 05/01/99 through 05/31/99
1.0 SUMMARY STATISTICS
_______________________
1.1 Total sessions:
____________________
Location Library Remote Total
________ _______ ______ _____
Berkeley 1,224 5,720 6,944
Davis 4,030 357 4,387
Irvine 3,434 0 3,434
Los Angeles 951 3,200 4,151
Riverside 1,208 694 1,902
San Diego 309 2,518 2,827
San Francisco 1,639 12 1,651
Santa Barbara 1,284 1,338 2,622
Santa Cruz 1,385 913 2,298
LBL 0 921 921
LLL 0 1,042 1,042
Los Alamos n/a 23 23
Other - UC 18 364 382
U.S. Forestry 5
Other-Network UC n/a 3,425 3,425
_______ ______ _____
15,482 20,527 36,014
Per hour usage:
Time Sessions Finds Records Displayed
__________ __________ __________ _________________
12-2 a.m. 624 2,458 32,063
2-4 a.m. 376 1,559 60,489
4-6 a.m. 348 1,181 13,005
6-8 a.m. 892 3,041 29,266
8-10 a.m. 3,415 9,547 84,009
10-12 a.m. 6,116 17,852 153,042
12-2 p.m. 6,011 18,112 172,469
2-4 p.m. 7,447 22,164 194,531
4-6 p.m. 5,365 15,881 152,378
6-8 p.m. 2,447 7,860 72,854
8-10 p.m. 1,767 5,846 59,426
10-12 p.m. 1,206 4,459 53,468
__________ __________ __________ _________________
Total: 36,014 109,960 1,077,000
1.2 FIND commands
__________________
Number of FIND commands issued by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 3,272 18,760 22,032
Davis 12,241 993 13,234
Irvine 10,585 0 10,585
Los Angeles 2,790 9,845 12,635
Riverside 3,182 2,088 5,270
San Diego 903 7,544 8,447
San Francisco 4,776 28 4,804
Santa Barbara 3,781 4,533 8,314
Santa Cruz 3,863 2,250 6,113
LBL 0 3,134 3,134
LLL 0 5,119 5,119
Los Alamos n/a 41 41
Other - UC 48 1,090 1,138
U.S. Forestry 6
Other-Network UC n/a 9,088 9,088
_______ ______ _____
45,441 64,513 109,960
Number of FIND commands by database
CC database 107,990
CCT database 1,970
Total number of FIND commands 109,960
1.3 Records displayed
______________________
Number of Records Displayed by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 32,032 210,296 242,328
Davis 91,573 7,153 98,726
Irvine 124,876 0 124,876
Los Angeles 24,337 102,969 127,306
Riverside 21,547 24,059 45,606
San Diego 7,366 66,497 73,863
San Francisco 40,554 770 41,324
Santa Barbara 33,842 47,137 80,979
Santa Cruz 22,659 21,358 44,017
LBL 0 35,492 35,492
LLL 0 57,851 57,851
Los Alamos n/a 384 384
Other - UC 253 12,309 12,562
U.S. Forestry 6
Other-Network UC n/a 91,598 91,598
_______ ______ _____
399,039 677,873 1,076,918
Number of Records Displayed by database:
CC database 1,006,945
CCT database 70,055
Total number of Records Displayed 1,076,918
1.4 Relative Use of Databases
______________________________
Relative use of CC vs. CCT databases:
Percent of CC sessions 95.1%
Percent of CCT sessions 4.9%
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 0.9
Standard deviation in seconds 3.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 3.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) 967:15
Average number of searches completed per session 3.1
Retrievals per search - median 10.0
Retrievals per search - average 556.8
Retrievals per search - standard deviation 5715.3
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) 50.0%
Commands entered, by type, excluding errors:
Total Percentage
__________ __________
FIND 100,358 36.7%
DISPLAY (excluding automatic displays) 77,608 28.4%
HELP 5,198 1.9%
EXPLAIN 4,969 1.8%
SET/RESET 11,842 4.3%
SHOW 744 0.3%
ADD ON (AND, OR, AND NOT) 7,632 2.8%
LOGON or LOGOFF 45,946 16.8%
COMMENT 5 0.0%
SAVE 5,313 1.9%
USE 173 0.1%
OTHER 13,663 5.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 43,690 40.2% 6,225 14.2% 29 211.1 1218.0
TITLE WORD 37,635 34.6% 10,696 28.4% 19 714.4 4753.4
EXACT TITLE 1,102 1.0% 622 56.4% 3 190.3 1100.0
JOURNAL 4,960 4.6% 1,991 40.1% 729 6480.4 27603.9
EXACT JOURNAL 3,085 2.8% 1,469 47.6% 210 2921.2 9526.1
SUBJECT CAT 378 0.3% 61 16.1% 11 55.8 185.5
SUBFILE 416 0.4% 48 11.5% 31 471.4 2300.3
PUBLICATION TYPE 481 0.4% 127 26.4% 14 2841.2 20999.7
LANGUAGE 109 0.1% 19 17.4% 102 3686.4 29320.5
DATE 1,466 1.3% 228 15.6% 12 148.2 540.5
ADDED 1,738 1.6% 1,094 62.9% 26 46.6 90.1
PERIODICAL 3,229 3.0% 718 22.2% 7 337.9 2722.0
EXACT PE 659 0.6% 99 15.0% 3 52.7 371.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 2 0.0% 1 50.0% 4,066 4066.0 0.0
Other indexes 9,840 9.0% 3,095 31.5% 20 857.1 4297.0
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,649 8.7% 3,246 37.5% 9 170.9 3925.9
Single 91,316 91.3% 19,947 21.8% 30 809.4 6902.6
DISPLAY commands, by type, excluding automatic displays:
REVIEW 3.7%
SHORT 81.7%
LONG 4.2%
FIELDS 1.2%
PERIODICALS 5.5%
COMMENTS 0.0%
Other 3.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) 399:36
Average number of searches completed per session 1.1
Retrievals per search - median 38.0
Retrievals per search - average 374.2
Retrievals per search - standard deviation 1867.2
Percent of searches completed with 0 results 34.0%
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,964 19.1%
DISPLAY (excluding automatic displays) 2,910 28.4%
HELP 1,255 12.2%
EXPLAIN 596 5.8%
SET/RESET 1,193 11.6%
SHOW 200 1.9%
ADD ON (AND, OR, AND NOT) 6 0.1%
LOGON or LOGOFF 1,621 15.8%
COMMENT 0 0.0%
SAVE 29 0.3%
USE 17 0.2%
OTHER 468 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:
JOURNAL 1,248 63.3% 496 39.7% 96 538.4 2323.5
EXACT JOURNAL 572 29.0% 142 24.8% 64 153.4 570.8
SUBJECT CAT 36 1.8% 1 2.8% 6,166 7304.7 4802.1
SUBFILE 2 0.1% 0 0.0% 62 61.5 21.9
DATE 5 0.3% 3 60.0% 22 21.5 27.6
ADDED 4 0.2% 0 0.0% 168 186.3 97.5
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 106 5.4% 26 24.5% 4 123.0 857.4
By number of indexes:
Multiple 10 0.5% 2 20.0% 83 113.9 102.3
Single 1,952 99.5% 663 34.0% 82 570.6 2283.0
DISPLAY commands, by type, excluding automatic displays:
REVIEW 3.4%
ISSUES 47.5%
SHORT 16.0%
LONG 25.5%
PERIODICALS 4.0%
COMMENTS 0.0%
Other 3.6%
2.3 Error, EXPLAIN and HELP statistics (CC & CCT)
__________________________________________________
Percent of commands that contained errors 10.9%
Ten most frequent errors:
1. First word of command is invalid 30.0%
2. NS command - no next screen 28.2%
3. FIND command with invalid index name 10.4%
4. Index invalid in current database 7.6%
5. Search term missing from search command 1.9%
6. PS command - no previous screen 1.9%
7. DISPLAY command contains invalid word 1.8%
8. F SUB CAT search with invalid SC 1.8%
9. Valid command at an inappropriate time 1.8%
10. D ABS command in database w/o abstracts 1.6%
11. All others 13.1%
Ten most frequent EXPLAIN requests:
1. CC GUIDE 16.6%
2. FIND (CC DB) 12.6%
3. CC INDEXES 11.1%
4. LOCATE (ARTICLE DBS) 10.5%
5. COMMANDS 7.3%
6. Unrecognized term 4.0%
7. DATABASES 3.1%
8. ADD-ON SEARCH 2.7%
9. CCT INDEXES 2.4%
10. CC DATABASE 2.4%
11. All others 27.5%
Ten most frequent HELP situations:
1. Help requested from START CC command 15.3%
2. First word of command is invalid 13.8%
3. F/BR with index invalid in current DB 11.6%
4. FIND command with invalid index name 7.7%
5. Help requested from SET DB command 5.9%
6. DISPLAY command - middle of >1 screen 5.4%
7. DISPLAY command-first of >1 screen 4.6%
8. FIND command with zero results 4.2%
9. FIND command retrieves >1 book 3.6%
10. DISPLAY command-complete in one screen 2.8%
11. All others 25.0%
Ten most frequent SHOW requests:
1. HISTORY 40.7%
2. SEARCH 16.1%
3. SYSTEM NEWS 7.5%
4. MAIL STATUS 6.8%
5. CC NEWS 6.1%
6. CC GLOSSARY 4.6%
7. SC LIST (CC DBS) 4.5%
8. CC SETTINGS 1.8%
9. MAIL SETTINGS 1.5%
10. CCT SETTINGS 1.4%
11. All others 9.0%