MELVYL CURRENT CONTENTS DATABASE TELNET STATISTICS
Time period: 06/09/01 through 06/15/01
1.0 SUMMARY STATISTICS
_______________________
1.1 Total sessions:
____________________
Location Library Remote Total
________ _______ ______ _____
Berkeley 40 498 538
Davis 302 33 335
Irvine 213 0 213
Los Angeles 1 257 258
Riverside 16 44 60
San Diego 27 246 273
San Francisco 153 0 153
Santa Barbara 5 118 123
Santa Cruz 16 50 66
LBL 0 73 73
LLL 0 59 59
Los Alamos n/a 0 0
Other - UC 1 37 38
U.S. Forestry 0
Other-Network UC n/a 523 523
_______ ______ _____
774 1,938 2,712
Per hour usage:
Time Sessions Finds Records Displayed
__________ __________ __________ _________________
12-2 a.m. 49 137 1,410
2-4 a.m. 36 205 851
4-6 a.m. 38 144 1,276
6-8 a.m. 107 575 5,308
8-10 a.m. 318 1,132 11,118
10-12 a.m. 488 1,327 15,978
12-2 p.m. 472 1,931 16,915
2-4 p.m. 468 1,328 14,024
4-6 p.m. 367 1,088 10,121
6-8 p.m. 142 487 4,211
8-10 p.m. 126 420 8,843
10-12 p.m. 101 438 4,082
__________ __________ __________ _________________
Total: 2,712 9,212 94,137
1.2 FIND commands
__________________
Number of FIND commands issued by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 160 1,507 1,667
Davis 1,077 86 1,163
Irvine 778 0 778
Los Angeles 1 757 758
Riverside 27 125 152
San Diego 93 660 753
San Francisco 448 0 448
Santa Barbara 10 319 329
Santa Cruz 45 132 177
LBL 0 249 249
LLL 0 1,060 1,060
Los Alamos n/a 0 0
Other - UC 2 153 155
U.S. Forestry 0
Other-Network UC n/a 1,523 1,523
_______ ______ _____
2,641 6,571 9,212
Number of FIND commands by database
CC database 9,050
CCT database 162
Total number of FIND commands 9,212
1.3 Records displayed
______________________
Number of Records Displayed by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 1,808 14,372 16,180
Davis 9,703 1,075 10,778
Irvine 4,299 0 4,299
Los Angeles 7 6,310 6,317
Riverside 73 929 1,002
San Diego 439 4,973 5,412
San Francisco 16,816 0 16,816
Santa Barbara 218 2,824 3,042
Santa Cruz 283 1,371 1,654
LBL 0 2,406 2,406
LLL 0 12,217 12,217
Los Alamos n/a 0 0
Other - UC 12 1,110 1,122
U.S. Forestry 0
Other-Network UC n/a 12,892 12,892
_______ ______ _____
33,658 60,479 94,137
Number of Records Displayed by database:
CC database 79,459
CCT database 14,678
Total number of Records Displayed 94,137
1.4 Relative Use of Databases
______________________________
Relative use of CC vs. CCT databases:
Percent of CC sessions 96.8%
Percent of CCT sessions 3.2%
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 4.1
Display response time from receipt of command at
DLA until transmission of a complete screen:
Average in seconds 0.1
Standard deviation in seconds 4.1
2.0 CC Database Statistics
___________________________
Median session length (minutes:seconds) 0:00
Average session length (minutes:seconds) 0:00
Longest session recorded (minutes:seconds) 226:12
Average number of searches completed per session 3.4
Retrievals per search - median 8.0
Retrievals per search - average 3553.7
Retrievals per search - standard deviation 29951
Percent of searches completed with 0 results 28.4%
Percent of searches entered that are long 0.4%
Percent of long searches completed
(includes partial results) 60.6%
Commands entered, by type, excluding errors:
Total Percentage
__________ __________
FIND 8,161 39.5%
DISPLAY (excluding automatic displays) 5,702 27.6%
HELP 111 0.5%
EXPLAIN 131 0.6%
SET/RESET 1,070 5.2%
SHOW 24 0.1%
ADD ON (AND, OR, AND NOT) 889 4.3%
LOGON or LOGOFF 3,295 15.9%
COMMENT 0 0.0%
SAVE 370 1.8%
USE 7 0.0%
OTHER 920 4.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:
PERSONAL AUTHOR 3,593 36.7% 618 17.2% 31 248.0 1517.9
TITLE WORD 2,771 28.3% 953 34.4% 16 818.4 4714.1
EXACT TITLE 76 0.8% 45 59.2% 5 2474.2 13293.3
JOURNAL 485 5.0% 223 46.0% 335 5042.9 29582.3
EXACT JOURNAL 792 8.1% 499 63.0% 44 1519.9 5777.9
SUBJECT CAT 18 0.2% 1 5.6% 5 54.3 161.6
SUBFILE 26 0.3% 3 11.5% 18 297.0 1180.7
PUBLICATION TYPE 24 0.2% 4 16.7% 54 2946.6 12365.1
LANGUAGE 6 0.1% 2 33.3% 127 126.5 140.3
DATE 175 1.8% 25 14.3% 10 177.1 642.9
ADDED 962 9.8% 690 71.7% 22 36.7 47.3
PERIODICAL 347 3.5% 62 17.9% 4 172.4 1057.5
EXACT PE 107 1.1% 13 12.1% 4 11.2 20.2
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 395 4.0% 123 31.1% 21 423.4 1984.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 1,615 19.9% 891 55.2% 12 93.6 447.3
Single 6,518 80.1% 1,463 22.4% 32 831.2 7710.1
DISPLAY commands, by type, excluding automatic displays:
REVIEW 4.8%
SHORT 79.7%
LONG 3.9%
FIELDS 1.8%
PERIODICALS 8.0%
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) 66:05
Average number of searches completed per session 1.9
Retrievals per search - median 68.5
Retrievals per search - average 475.0
Retrievals per search - standard deviation 1102.3
Percent of searches completed with 0 results 23.5%
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 162 24.3%
DISPLAY (excluding automatic displays) 317 47.6%
HELP 27 4.1%
EXPLAIN 13 2.0%
SET/RESET 59 8.9%
SHOW 5 0.8%
ADD ON (AND, OR, AND NOT) 0 0.0%
LOGON or LOGOFF 69 10.4%
COMMENT 1 0.2%
SAVE 0 0.0%
USE 0 0.0%
OTHER 13 2.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:
JOURNAL 122 75.3% 34 27.9% 96 357.9 839.3
EXACT JOURNAL 20 12.3% 3 15.0% 231 451.7 576.5
SUBJECT CAT 9 5.6% 0 0.0% 4,251 3913.3 1152.6
SUBFILE 0 0.0% 0 0.0% 0 0.0 0.0
DATE 0 0.0% 0 0.0% 0 0.0 0.0
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 11 6.8% 1 9.1% 60 255.6 438.1
By number of indexes:
Multiple 0 0.0% 0 0.0% 0 0.0 0.0
Single 162 100% 38 23.5% 131 620.6 1224.5
DISPLAY commands, by type, excluding automatic displays:
REVIEW 19.0%
ISSUES 25.2%
SHORT 37.4%
LONG 7.4%
PERIODICALS 7.4%
COMMENTS 0.0%
Other 3.6%
2.3 Error, EXPLAIN and HELP statistics (CC & CCT)
__________________________________________________
Percent of commands that contained errors 7.7%
Ten most frequent errors:
1. NS command - no next screen 32.1%
2. First word of command is invalid 25.4%
3. FIND command with invalid index name 10.0%
4. Index invalid in current database 4.1%
5. Max. # of ports to a Z39 db are in use 3.4%
6. DISPLAY command - no FIND results 2.8%
7. PS command - no previous screen 2.1%
8. DISPLAY command contains invalid word 2.0%
9. Search term missing from search command 2.0%
10. D ABS command in database w/o abstracts 1.5%
11. All others 14.5%
Ten most frequent EXPLAIN requests:
1. CC GUIDE 15.3%
2. FIND (CC DB) 13.2%
3. CC INDEXES 13.2%
4. LOCATE (ARTICLE DBS) 11.1%
5. DATABASES 6.9%
6. COMMANDS 5.6%
7. Unrecognized term 4.2%
8. CCT INDEXES 4.2%
9. DISPLAY 3.5%
10. CC DATABASE 2.8%
11. All others 20.1%
Ten most frequent HELP situations:
1. First word of command is invalid 14.9%
2. Help requested from START CC command 13.5%
3. FIND command with invalid index name 10.3%
4. F/BR with index invalid in current DB 8.2%
5. DISPLAY command-first of >1 screen 6.0%
6. Help requested from SET DB command 5.3%
7. DISPLAY command - middle of >1 screen 4.3%
8. FIND command with zero results 3.5%
9. FIND command retrieves >1 book 3.5%
10. Help requested from START CCT command 2.8%
11. All others 27.7%
Ten most frequent SHOW requests:
1. HISTORY 37.0%
2. SC LIST (CC DBS) 18.5%
3. SYSTEM NEWS 11.1%
4. CC LOADING STATISTICS 7.4%
5. CC NEWS 7.4%
6. LIBRARY NEWS 3.7%
7. 3350 3.7%
8. SEARCH 3.7%
9. UPDATE 3.7%
10. DATABASES 3.7%
11. All others 0.0%
Cmm/yy cc MELVYL CURRENT CONTENTS DATABASE TELNET STATISTICS (monthly)