MELVYL CURRENT CONTENTS DATABASE TELNET STATISTICS
Time period: 04/13/02 through 04/19/02
1.0 SUMMARY STATISTICS
_______________________
1.1 Total sessions:
____________________
Location Library Remote Total
________ _______ ______ _____
Berkeley 61 512 573
Davis 199 14 213
Irvine 173 0 173
Los Angeles 0 137 137
Riverside 21 44 65
San Diego 34 122 156
San Francisco 142 0 142
Santa Barbara 1 55 56
Santa Cruz 27 37 64
LBL 0 88 88
LLL 0 59 59
Los Alamos n/a 0 0
Other - UC 1 47 48
U.S. Forestry 0
Other-Network UC n/a 387 387
_______ ______ _____
659 1,502 2,161
Per hour usage:
Time Sessions Finds Records Displayed
__________ __________ __________ _________________
12-2 a.m. 26 98 673
2-4 a.m. 21 121 608
4-6 a.m. 19 34 240
6-8 a.m. 51 137 1,180
8-10 a.m. 249 697 4,629
10-12 a.m. 441 1,610 13,250
12-2 p.m. 390 1,202 11,947
2-4 p.m. 438 1,275 14,216
4-6 p.m. 305 729 7,504
6-8 p.m. 104 343 2,909
8-10 p.m. 65 187 2,317
10-12 p.m. 52 140 1,013
__________ __________ __________ _________________
Total: 2,161 6,573 60,486
1.2 FIND commands
__________________
Number of FIND commands issued by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 178 1,525 1,703
Davis 602 23 625
Irvine 630 0 630
Los Angeles 0 402 402
Riverside 37 116 153
San Diego 87 324 411
San Francisco 859 0 859
Santa Barbara 1 173 174
Santa Cruz 37 72 109
LBL 0 212 212
LLL 0 245 245
Los Alamos n/a 0 0
Other - UC 0 127 127
U.S. Forestry 0
Other-Network UC n/a 923 923
_______ ______ _____
2,431 4,142 6,573
Number of FIND commands by database
CC database 6,499
CCT database 74
Total number of FIND commands 6,573
1.3 Records displayed
______________________
Number of Records Displayed by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 1,549 11,789 13,338
Davis 5,250 502 5,752
Irvine 4,539 0 4,539
Los Angeles 0 4,714 4,714
Riverside 309 1,016 1,325
San Diego 465 2,267 2,732
San Francisco 11,966 0 11,966
Santa Barbara 15 2,427 2,442
Santa Cruz 416 807 1,223
LBL 0 3,513 3,513
LLL 0 1,898 1,898
Los Alamos n/a 0 0
Other - UC 0 1,094 1,094
U.S. Forestry 0
Other-Network UC n/a 5,950 5,950
_______ ______ _____
24,509 35,977 60,486
Number of Records Displayed by database:
CC database 57,288
CCT database 3,198
Total number of Records Displayed 60,486
1.4 Relative Use of Databases
______________________________
Relative use of CC vs. CCT databases:
Percent of CC sessions 96.1%
Percent of CCT sessions 3.9%
Percent of searches done in the CC database 98.9%
Percent of searches done in the CCT database 1.1%
1.5 Response time
__________________
Search response time from receipt of command at
DLA until transmission of response:
Average in seconds 0.8
Standard deviation in seconds 3.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 3.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) 340:40
Average number of searches completed per session 3.1
Retrievals per search - median 7.0
Retrievals per search - average 507.4
Retrievals per search - standard deviation 3781.4
Percent of searches completed with 0 results 21.3%
Percent of searches entered that are long 0.4%
Percent of long searches completed
(includes partial results) 75.0%
Commands entered, by type, excluding errors:
Total Percentage
__________ __________
FIND 5,932 36.6%
DISPLAY (excluding automatic displays) 4,948 30.6%
HELP 145 0.9%
EXPLAIN 162 1.0%
SET/RESET 866 5.3%
SHOW 36 0.2%
ADD ON (AND, OR, AND NOT) 567 3.5%
LOGON or LOGOFF 2,515 15.5%
COMMENT 0 0.0%
SAVE 390 2.4%
USE 2 0.0%
OTHER 630 3.9%
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,484 38.6% 356 14.3% 31 214.6 1181.7
TITLE WORD 2,098 32.6% 652 31.1% 8 729.0 5234.3
EXACT TITLE 109 1.7% 40 36.7% 2 36.2 161.6
JOURNAL 384 6.0% 92 24.0% 1,140 3843.4 7662.0
EXACT JOURNAL 130 2.0% 41 31.5% 2,251 5407.5 16635.4
SUBJECT CAT 12 0.2% 2 16.7% 15 51.4 81.9
SUBFILE 10 0.2% 1 10.0% 17 142.6 324.3
PUBLICATION TYPE 10 0.2% 2 20.0% 7 73.4 175.5
LANGUAGE 1 0.0% 0 0.0% 9 9.0 0.0
DATE 117 1.8% 27 23.1% 7 59.6 204.8
ADDED 67 1.0% 23 34.3% 4 9.3 14.1
PERIODICAL 609 9.5% 69 11.3% 4 73.8 1272.3
EXACT PE 132 2.0% 16 12.1% 3 9.5 34.3
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 280 4.3% 72 25.7% 18 548.8 2781.7
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 518 8.8% 143 27.6% 4 29.5 120.9
Single 5,398 91.2% 1,102 20.4% 22 758.4 4624.3
DISPLAY commands, by type, excluding automatic displays:
REVIEW 5.5%
SHORT 67.5%
LONG 5.9%
FIELDS 1.7%
PERIODICALS 17.7%
COMMENTS 0.0%
Other 1.6%
2.1 CCT Database Statistics
____________________________
Median session length (minutes:seconds) 0:00
Average session length (minutes:seconds) 0:00
Longest session recorded (minutes:seconds) 38:09
Average number of searches completed per session 0.9
Retrievals per search - median 98.0
Retrievals per search - average 235.9
Retrievals per search - standard deviation 438.1
Percent of searches completed with 0 results 18.9%
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 74 18.5%
DISPLAY (excluding automatic displays) 117 29.2%
HELP 48 12.0%
EXPLAIN 18 4.5%
SET/RESET 59 14.7%
SHOW 4 1.0%
ADD ON (AND, OR, AND NOT) 0 0.0%
LOGON or LOGOFF 68 17.0%
COMMENT 0 0.0%
SAVE 0 0.0%
USE 0 0.0%
OTHER 13 3.2%
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 55 74.3% 12 21.8% 155 305.8 435.8
EXACT JOURNAL 13 17.6% 2 15.4% 154 387.9 668.9
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 6 8.1% 0 0.0% 3 6.3 8.4
By number of indexes:
Multiple 0 0.0% 0 0.0% 0 0.0 0.0
Single 74 100% 14 18.9% 155 290.9 470.3
DISPLAY commands, by type, excluding automatic displays:
REVIEW 3.3%
ISSUES 58.5%
SHORT 10.6%
LONG 20.3%
PERIODICALS 7.3%
COMMENTS 0.0%
Other 0.0%
2.3 Error, EXPLAIN and HELP statistics (CC & CCT)
__________________________________________________
Percent of commands that contained errors 7.6%
Ten most frequent errors:
1. NS command - no next screen 29.4%
2. First word of command is invalid 28.8%
3. FIND command with invalid index name 10.6%
4. Index invalid in current database 5.9%
5. DISPLAY command contains invalid word 3.5%
6. Search term missing from search command 2.2%
7. PS command - no previous screen 2.1%
8. DISPLAY command - no FIND results 2.0%
9. Valid command at an inappropriate time 1.7%
10. D ABS command in database w/o abstracts 1.5%
11. All others 12.4%
Ten most frequent EXPLAIN requests:
1. LOCATE (ARTICLE DBS) 14.4%
2. FIND (CC DB) 13.9%
3. CC GUIDE 12.8%
4. CC INDEXES 11.1%
5. COMMANDS 6.7%
6. DATABASES 4.4%
7. DISPLAY 4.4%
8. CCT INDEXES 4.4%
9. SUBJECT CATEGORY 3.3%
10. ADD-ON SEARCH 2.8%
11. All others 21.7%
Ten most frequent HELP situations:
1. First word of command is invalid 15.8%
2. F/BR with index invalid in current DB 15.3%
3. Help requested from START CC command 11.5%
4. FIND command with invalid index name 7.8%
5. Help requested from SET DB command 6.7%
6. FIND command with zero results 4.6%
7. FIND command retrieves >1 book 3.8%
8. DISPLAY command-complete in one screen 3.8%
9. DISPLAY command-first of >1 screen 3.8%
10. DISPLAY command - middle of >1 screen 2.4%
11. All others 24.7%
Ten most frequent SHOW requests:
1. HISTORY 32.5%
2. SEARCH 20.0%
3. CC NEWS 17.5%
4. SC LIST (CC DBS) 17.5%
5. MAIL STATUS 5.0%
6. SYSTEM NEWS 2.5%
7. CC SETTINGS 2.5%
8. DATABASES 2.5%
11. All others 0.0%
Cmm/yy cc MELVYL CURRENT CONTENTS DATABASE TELNET STATISTICS (monthly)