MELVYL CURRENT CONTENTS DATABASE TELNET STATISTICS
Time period: 06/22/02 through 06/28/02
1.0 SUMMARY STATISTICS
_______________________
1.1 Total sessions:
____________________
Location Library Remote Total
________ _______ ______ _____
Berkeley 19 408 427
Davis 152 7 159
Irvine 71 0 71
Los Angeles 0 127 127
Riverside 12 33 45
San Diego 25 112 137
San Francisco 85 0 85
Santa Barbara 2 62 64
Santa Cruz 10 44 54
LBL 0 97 97
LLL 0 32 32
Los Alamos n/a 0 0
Other - UC 0 42 42
U.S. Forestry 0
Other-Network UC n/a 226 226
_______ ______ _____
376 1,190 1,566
Per hour usage:
Time Sessions Finds Records Displayed
__________ __________ __________ _________________
12-2 a.m. 26 104 441
2-4 a.m. 19 98 443
4-6 a.m. 18 28 226
6-8 a.m. 29 79 424
8-10 a.m. 166 583 3,529
10-12 a.m. 357 1,274 9,496
12-2 p.m. 299 920 7,998
2-4 p.m. 288 740 7,327
4-6 p.m. 224 545 5,362
6-8 p.m. 52 179 1,733
8-10 p.m. 43 182 2,075
10-12 p.m. 45 107 1,236
__________ __________ __________ _________________
Total: 1,566 4,839 40,290
1.2 FIND commands
__________________
Number of FIND commands issued by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 30 1,322 1,352
Davis 425 16 441
Irvine 256 0 256
Los Angeles 0 334 334
Riverside 30 85 115
San Diego 64 266 330
San Francisco 626 0 626
Santa Barbara 6 219 225
Santa Cruz 22 177 199
LBL 0 176 176
LLL 0 62 62
Los Alamos n/a 0 0
Other - UC 0 109 109
U.S. Forestry 0
Other-Network UC n/a 614 614
_______ ______ _____
1,459 3,380 4,839
Number of FIND commands by database
CC database 4,709
CCT database 130
Total number of FIND commands 4,839
1.3 Records displayed
______________________
Number of Records Displayed by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 238 13,062 13,300
Davis 3,469 134 3,603
Irvine 1,933 0 1,933
Los Angeles 0 2,526 2,526
Riverside 87 558 645
San Diego 418 2,232 2,650
San Francisco 2,410 0 2,410
Santa Barbara 6 2,806 2,812
Santa Cruz 242 1,790 2,032
LBL 0 1,486 1,486
LLL 0 751 751
Los Alamos n/a 0 0
Other - UC 0 1,732 1,732
U.S. Forestry 0
Other-Network UC n/a 4,410 4,410
_______ ______ _____
8,803 31,487 40,290
Number of Records Displayed by database:
CC database 37,688
CCT database 2,602
Total number of Records Displayed 40,290
1.4 Relative Use of Databases
______________________________
Relative use of CC vs. CCT databases:
Percent of CC sessions 96.2%
Percent of CCT sessions 3.8%
Percent of searches done in the CC database 97.3%
Percent of searches done in the CCT database 2.7%
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 5.3
Display response time from receipt of command at
DLA until transmission of a complete screen:
Average in seconds 0.1
Standard deviation in seconds 5.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) 437:35
Average number of searches completed per session 3.1
Retrievals per search - median 8.0
Retrievals per search - average 323.1
Retrievals per search - standard deviation 1955.1
Percent of searches completed with 0 results 20.2%
Percent of searches entered that are long 0.5%
Percent of long searches completed
(includes partial results) 84.0%
Commands entered, by type, excluding errors:
Total Percentage
__________ __________
FIND 4,257 36.6%
DISPLAY (excluding automatic displays) 3,446 29.6%
HELP 66 0.6%
EXPLAIN 78 0.7%
SET/RESET 575 4.9%
SHOW 14 0.1%
ADD ON (AND, OR, AND NOT) 452 3.9%
LOGON or LOGOFF 1,942 16.7%
COMMENT 0 0.0%
SAVE 293 2.5%
USE 6 0.1%
OTHER 508 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 2,179 46.5% 282 12.9% 28 155.1 689.2
TITLE WORD 1,343 28.7% 433 32.2% 11 638.1 3285.8
EXACT TITLE 98 2.1% 42 42.9% 6 39.4 92.0
JOURNAL 194 4.1% 72 37.1% 827 3011.3 5892.1
EXACT JOURNAL 109 2.3% 40 36.7% 1,106 2333.2 3243.9
SUBJECT CAT 11 0.2% 2 18.2% 21 29.6 39.8
SUBFILE 14 0.3% 1 7.1% 16 346.2 999.1
PUBLICATION TYPE 9 0.2% 1 11.1% 12 31.6 42.0
LANGUAGE 4 0.1% 0 0.0% 19 719.8 1414.2
DATE 81 1.7% 14 17.3% 6 52.1 108.2
ADDED 51 1.1% 15 29.4% 3 6.8 11.7
PERIODICAL 366 7.8% 34 9.3% 4 28.5 80.2
EXACT PE 74 1.6% 6 8.1% 3 8.0 21.2
RPE 1 0.0% 0 0.0% 756 756.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 150 3.2% 41 27.3% 27 747.9 2801.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 425 10.0% 122 28.7% 4 70.7 355.7
Single 3,823 90.0% 734 19.2% 26 474.7 2393.3
DISPLAY commands, by type, excluding automatic displays:
REVIEW 2.8%
SHORT 71.3%
LONG 4.5%
FIELDS 3.2%
PERIODICALS 16.3%
COMMENTS 0.0%
Other 1.9%
2.1 CCT Database Statistics
____________________________
Median session length (minutes:seconds) 0:00
Average session length (minutes:seconds) 0:00
Longest session recorded (minutes:seconds) 47:14
Average number of searches completed per session 2.2
Retrievals per search - median 50.5
Retrievals per search - average 155.8
Retrievals per search - standard deviation 306.8
Percent of searches completed with 0 results 20.0%
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 130 24.1%
DISPLAY (excluding automatic displays) 255 47.2%
HELP 22 4.1%
EXPLAIN 14 2.6%
SET/RESET 39 7.2%
SHOW 7 1.3%
ADD ON (AND, OR, AND NOT) 0 0.0%
LOGON or LOGOFF 58 10.7%
COMMENT 0 0.0%
SAVE 0 0.0%
USE 0 0.0%
OTHER 15 2.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:
JOURNAL 86 66.2% 20 23.3% 103 212.8 285.0
EXACT JOURNAL 21 16.2% 4 19.0% 245 356.9 551.0
SUBJECT CAT 0 0.0% 0 0.0% 0 0.0 0.0
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 23 17.7% 2 8.7% 3 6.9 8.8
By number of indexes:
Multiple 0 0.0% 0 0.0% 0 0.0 0.0
Single 130 100% 26 20.0% 83 194.8 332.0
DISPLAY commands, by type, excluding automatic displays:
REVIEW 19.1%
ISSUES 26.6%
SHORT 36.3%
LONG 8.2%
PERIODICALS 9.0%
COMMENTS 0.0%
Other 0.7%
2.3 Error, EXPLAIN and HELP statistics (CC & CCT)
__________________________________________________
Percent of commands that contained errors 6.4%
Ten most frequent errors:
1. First word of command is invalid 28.3%
2. NS command - no next screen 27.6%
3. FIND command with invalid index name 10.6%
4. Index invalid in current database 3.8%
5. DISPLAY command - no FIND results 3.6%
6. DISPLAY command contains invalid word 3.5%
7. Search term missing from search command 2.8%
8. PS command - no previous screen 2.4%
9. Valid command at an inappropriate time 1.3%
10. Command contains escape or arrow key 1.3%
11. All others 14.7%
Ten most frequent EXPLAIN requests:
1. CC GUIDE 16.3%
2. CC INDEXES 10.9%
3. FIND (CC DB) 9.8%
4. Unrecognized term 7.6%
5. DATABASES 7.6%
6. LOCATE (ARTICLE DBS) 5.4%
7. Unrecognized term-reminders off 4.3%
8. MAIL 3.3%
9. ADD-ON SEARCH 3.3%
10. 5335 3.3%
11. All others 28.3%
Ten most frequent HELP situations:
1. First word of command is invalid 17.8%
2. Help requested from START CC command 10.6%
3. FIND command with invalid index name 7.8%
4. Help requested from SET DB command 7.8%
5. F/BR with index invalid in current DB 7.8%
6. DISPLAY command-first of >1 screen 5.6%
7. DISPLAY command - middle of >1 screen 5.0%
8. FIND command with zero results 3.9%
9. DISPLAY command - last of >1 screen 3.3%
10. FIND command retrieves 1 book 2.8%
11. All others 27.8%
Ten most frequent SHOW requests:
1. HISTORY 30.0%
2. CC NEWS 25.0%
3. SYSTEM NEWS 20.0%
4. GLOSSARY 5.0%
5. LIBRARY LOCATIONS 5.0%
6. CCT SETTINGS 5.0%
7. CC GLOSSARY 5.0%
8. SEARCH 5.0%
11. All others 0.0%
Cmm/yy cc MELVYL CURRENT CONTENTS DATABASE TELNET STATISTICS (monthly)