MELVYL CURRENT CONTENTS DATABASE TELNET STATISTICS
Time period: 03/23/02 through 03/29/02
1.0 SUMMARY STATISTICS
_______________________
1.1 Total sessions:
____________________
Location Library Remote Total
________ _______ ______ _____
Berkeley 45 433 478
Davis 170 10 180
Irvine 110 0 110
Los Angeles 5 181 186
Riverside 8 31 39
San Diego 15 134 149
San Francisco 133 0 133
Santa Barbara 4 65 69
Santa Cruz 16 29 45
LBL 0 72 72
LLL 0 36 36
Los Alamos n/a 0 0
Other - UC 0 40 40
U.S. Forestry 0
Other-Network UC n/a 417 417
_______ ______ _____
506 1,448 1,954
Per hour usage:
Time Sessions Finds Records Displayed
__________ __________ __________ _________________
12-2 a.m. 22 75 544
2-4 a.m. 25 96 8,225
4-6 a.m. 27 77 834
6-8 a.m. 54 113 1,068
8-10 a.m. 248 640 4,497
10-12 a.m. 401 1,264 13,467
12-2 p.m. 336 954 12,254
2-4 p.m. 388 1,124 10,311
4-6 p.m. 278 860 8,461
6-8 p.m. 81 295 2,348
8-10 p.m. 65 243 1,585
10-12 p.m. 29 63 458
__________ __________ __________ _________________
Total: 1,954 5,804 64,052
1.2 FIND commands
__________________
Number of FIND commands issued by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 103 1,155 1,258
Davis 497 20 517
Irvine 330 0 330
Los Angeles 20 747 767
Riverside 16 96 112
San Diego 36 446 482
San Francisco 647 0 647
Santa Barbara 11 228 239
Santa Cruz 29 81 110
LBL 0 221 221
LLL 0 126 126
Los Alamos n/a 0 0
Other - UC 0 130 130
U.S. Forestry 0
Other-Network UC n/a 865 865
_______ ______ _____
1,689 4,115 5,804
Number of FIND commands by database
CC database 5,729
CCT database 75
Total number of FIND commands 5,804
1.3 Records displayed
______________________
Number of Records Displayed by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 1,294 10,947 12,241
Davis 3,970 131 4,101
Irvine 10,709 0 10,709
Los Angeles 382 6,611 6,993
Riverside 193 504 697
San Diego 298 4,945 5,243
San Francisco 6,183 0 6,183
Santa Barbara 69 2,087 2,156
Santa Cruz 1,364 725 2,089
LBL 0 2,706 2,706
LLL 0 1,195 1,195
Los Alamos n/a 0 0
Other - UC 0 1,161 1,161
U.S. Forestry 0
Other-Network UC n/a 8,578 8,578
_______ ______ _____
24,462 39,590 64,052
Number of Records Displayed by database:
CC database 58,310
CCT database 5,742
Total number of Records Displayed 64,052
1.4 Relative Use of Databases
______________________________
Relative use of CC vs. CCT databases:
Percent of CC sessions 96.6%
Percent of CCT sessions 3.4%
Percent of searches done in the CC database 98.7%
Percent of searches done in the CCT database 1.3%
1.5 Response time
__________________
Search response time from receipt of command at
DLA until transmission of response:
Average in seconds 0.7
Standard deviation in seconds 2.8
Display response time from receipt of command at
DLA until transmission of a complete screen:
Average in seconds 0.1
Standard deviation in seconds 2.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) 293:05
Average number of searches completed per session 3.0
Retrievals per search - median 8.0
Retrievals per search - average 561.6
Retrievals per search - standard deviation 3501.7
Percent of searches completed with 0 results 21.8%
Percent of searches entered that are long 0.6%
Percent of long searches completed
(includes partial results) 71.9%
Commands entered, by type, excluding errors:
Total Percentage
__________ __________
FIND 5,196 36.9%
DISPLAY (excluding automatic displays) 4,281 30.4%
HELP 90 0.6%
EXPLAIN 98 0.7%
SET/RESET 790 5.6%
SHOW 12 0.1%
ADD ON (AND, OR, AND NOT) 533 3.8%
LOGON or LOGOFF 2,327 16.5%
COMMENT 0 0.0%
SAVE 195 1.4%
USE 4 0.0%
OTHER 559 4.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 2,324 41.0% 344 14.8% 27 221.2 1066.7
TITLE WORD 1,930 34.0% 602 31.2% 12 554.6 3311.5
EXACT TITLE 48 0.8% 34 70.8% 4 49.3 121.5
JOURNAL 380 6.7% 107 28.2% 1,490 5326.7 11806.8
EXACT JOURNAL 105 1.9% 31 29.5% 3,426 4291.7 5871.6
SUBJECT CAT 14 0.2% 2 14.3% 27 128.2 271.3
SUBFILE 25 0.4% 9 36.0% 33 76.3 120.6
PUBLICATION TYPE 17 0.3% 2 11.8% 9 31.6 70.5
LANGUAGE 0 0.0% 0 0.0% 0 0.0 0.0
DATE 107 1.9% 13 12.1% 8 79.0 257.7
ADDED 15 0.3% 2 13.3% 6 9.8 9.7
PERIODICAL 416 7.3% 54 13.0% 4 200.3 2385.8
EXACT PE 94 1.7% 13 13.8% 2 9.8 20.8
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 195 3.4% 50 25.6% 38 1053.0 4298.1
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 476 9.2% 131 27.5% 5 37.8 152.1
Single 4,703 90.8% 996 21.2% 27 851.8 4316.3
DISPLAY commands, by type, excluding automatic displays:
REVIEW 4.0%
SHORT 73.1%
LONG 5.0%
FIELDS 1.1%
PERIODICALS 15.3%
COMMENTS 0.0%
Other 1.5%
2.1 CCT Database Statistics
____________________________
Median session length (minutes:seconds) 0:00
Average session length (minutes:seconds) 0:00
Longest session recorded (minutes:seconds) 27:33
Average number of searches completed per session 1.1
Retrievals per search - median 99.0
Retrievals per search - average 312.1
Retrievals per search - standard deviation 572.4
Percent of searches completed with 0 results 25.3%
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 75 20.0%
DISPLAY (excluding automatic displays) 128 34.1%
HELP 29 7.7%
EXPLAIN 21 5.6%
SET/RESET 47 12.5%
SHOW 4 1.1%
ADD ON (AND, OR, AND NOT) 0 0.0%
LOGON or LOGOFF 57 15.2%
COMMENT 0 0.0%
SAVE 0 0.0%
USE 0 0.0%
OTHER 14 3.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:
JOURNAL 64 85.3% 16 25.0% 196 464.0 661.0
EXACT JOURNAL 9 12.0% 3 33.3% 54 184.7 310.1
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 2 2.7% 0 0.0% 15 14.5 14.8
By number of indexes:
Multiple 0 0.0% 0 0.0% 0 0.0 0.0
Single 75 100% 19 25.3% 161 418.0 629.1
DISPLAY commands, by type, excluding automatic displays:
REVIEW 4.5%
ISSUES 65.9%
SHORT 11.4%
LONG 12.1%
PERIODICALS 1.5%
COMMENTS 0.0%
Other 4.5%
2.3 Error, EXPLAIN and HELP statistics (CC & CCT)
__________________________________________________
Percent of commands that contained errors 6.9%
Ten most frequent errors:
1. NS command - no next screen 31.6%
2. First word of command is invalid 25.2%
3. FIND command with invalid index name 11.2%
4. Index invalid in current database 4.4%
5. Valid command at an inappropriate time 2.3%
6. DISPLAY command contains invalid word 2.2%
7. Search term missing from search command 2.2%
8. D ABS command in database w/o abstracts 2.1%
9. PS command - no previous screen 1.9%
10. DISPLAY command - no FIND results 1.2%
11. All others 15.7%
Ten most frequent EXPLAIN requests:
1. CC INDEXES 15.1%
2. COMMANDS 13.4%
3. CC GUIDE 9.2%
4. FIND (CC DB) 9.2%
5. CC DATABASE 9.2%
6. LOCATE (ARTICLE DBS) 7.6%
7. DATABASES 5.0%
8. MAIL 3.4%
9. CCT INDEXES 3.4%
10. Unrecognized term 2.5%
11. All others 21.8%
Ten most frequent HELP situations:
1. Help requested from START CC command 21.0%
2. Help requested from SET DB command 9.7%
3. FIND command with invalid index name 8.4%
4. First word of command is invalid 7.1%
5. F/BR with index invalid in current DB 7.1%
6. FIND command with zero results 5.0%
7. FIND command retrieves >1 book 4.6%
8. DISPLAY command - middle of >1 screen 4.6%
9. DISPLAY command-complete in one screen 3.4%
10. DISPLAY command-first of >1 screen 3.4%
11. All others 25.6%
Ten most frequent SHOW requests:
1. HISTORY 68.8%
2. SEARCH 18.8%
3. SYSTEM NEWS 6.3%
4. MAIL STATUS 6.3%
11. All others 0.0%
Cmm/yy cc MELVYL CURRENT CONTENTS DATABASE TELNET STATISTICS (monthly)