MELVYL CURRENT CONTENTS DATABASE TELNET STATISTICS
Time period: 05/04/02 through 05/10/02
1.0 SUMMARY STATISTICS
_______________________
1.1 Total sessions:
____________________
Location Library Remote Total
________ _______ ______ _____
Berkeley 57 410 467
Davis 218 11 229
Irvine 111 0 111
Los Angeles 6 140 146
Riverside 8 36 44
San Diego 36 165 201
San Francisco 110 0 110
Santa Barbara 2 62 64
Santa Cruz 5 56 61
LBL 0 127 127
LLL 0 48 48
Los Alamos n/a 0 0
Other - UC 2 79 81
U.S. Forestry 0
Other-Network UC n/a 152 152
_______ ______ _____
555 1,286 1,841
Per hour usage:
Time Sessions Finds Records Displayed
__________ __________ __________ _________________
12-2 a.m. 33 72 759
2-4 a.m. 24 119 800
4-6 a.m. 21 58 481
6-8 a.m. 44 122 1,657
8-10 a.m. 190 479 4,879
10-12 a.m. 330 1,211 10,028
12-2 p.m. 332 899 10,201
2-4 p.m. 369 1,034 10,782
4-6 p.m. 281 704 7,813
6-8 p.m. 103 259 2,018
8-10 p.m. 68 182 1,982
10-12 p.m. 46 62 413
__________ __________ __________ _________________
Total: 1,841 5,201 51,813
1.2 FIND commands
__________________
Number of FIND commands issued by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 68 1,145 1,213
Davis 572 17 589
Irvine 424 0 424
Los Angeles 8 368 376
Riverside 8 191 199
San Diego 75 391 466
San Francisco 578 0 578
Santa Barbara 3 179 182
Santa Cruz 3 148 151
LBL 0 298 298
LLL 0 104 104
Los Alamos n/a 0 0
Other - UC 2 176 178
U.S. Forestry 0
Other-Network UC n/a 443 443
_______ ______ _____
1,741 3,460 5,201
Number of FIND commands by database
CC database 5,049
CCT database 152
Total number of FIND commands 5,201
1.3 Records displayed
______________________
Number of Records Displayed by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 1,200 9,224 10,424
Davis 6,376 74 6,450
Irvine 3,587 0 3,587
Los Angeles 42 4,711 4,753
Riverside 382 1,393 1,775
San Diego 1,006 4,169 5,175
San Francisco 2,948 0 2,948
Santa Barbara 1 1,452 1,453
Santa Cruz 66 1,141 1,207
LBL 0 3,245 3,245
LLL 0 1,458 1,458
Los Alamos n/a 0 0
Other - UC 9 2,459 2,468
U.S. Forestry 0
Other-Network UC n/a 6,870 6,870
_______ ______ _____
15,617 36,196 51,813
Number of Records Displayed by database:
CC database 46,110
CCT database 5,703
Total number of Records Displayed 51,813
1.4 Relative Use of Databases
______________________________
Relative use of CC vs. CCT databases:
Percent of CC sessions 95.2%
Percent of CCT sessions 4.8%
Percent of searches done in the CC database 97.1%
Percent of searches done in the CCT database 2.9%
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 3.5
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.5
2.0 CC Database Statistics
___________________________
Median session length (minutes:seconds) 0:00
Average session length (minutes:seconds) 0:00
Longest session recorded (minutes:seconds) 342:47
Average number of searches completed per session 2.9
Retrievals per search - median 13.0
Retrievals per search - average 643.1
Retrievals per search - standard deviation 4505.3
Percent of searches completed with 0 results 19.5%
Percent of searches entered that are long 0.1%
Percent of long searches completed
(includes partial results) 50.0%
Commands entered, by type, excluding errors:
Total Percentage
__________ __________
FIND 4,621 35.4%
DISPLAY (excluding automatic displays) 3,893 29.8%
HELP 134 1.0%
EXPLAIN 142 1.1%
SET/RESET 566 4.3%
SHOW 26 0.2%
ADD ON (AND, OR, AND NOT) 428 3.3%
LOGON or LOGOFF 2,434 18.6%
COMMENT 0 0.0%
SAVE 184 1.4%
USE 1 0.0%
OTHER 625 4.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:
PERSONAL AUTHOR 2,188 43.6% 279 12.8% 32 202.1 1166.8
TITLE WORD 1,577 31.4% 446 28.3% 14 818.2 6091.7
EXACT TITLE 84 1.7% 32 38.1% 2 20.9 106.5
JOURNAL 321 6.4% 94 29.3% 1,641 4723.3 10760.0
EXACT JOURNAL 103 2.1% 19 18.4% 2,571 7177.9 12621.2
SUBJECT CAT 27 0.5% 3 11.1% 25 90.4 157.5
SUBFILE 15 0.3% 1 6.7% 41 59.9 67.0
PUBLICATION TYPE 16 0.3% 3 18.8% 8 205.8 501.5
LANGUAGE 2 0.0% 0 0.0% 6 5.5 0.7
DATE 102 2.0% 22 21.6% 11 89.3 237.8
ADDED 42 0.8% 14 33.3% 2 4.9 7.0
PERIODICAL 304 6.1% 34 11.2% 4 51.4 253.7
EXACT PE 60 1.2% 0 0.0% 4 12.7 30.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 179 3.6% 66 36.9% 49 516.3 1324.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 399 8.7% 112 28.1% 6 50.7 176.7
Single 4,209 91.3% 786 18.7% 31 889.3 5175.8
DISPLAY commands, by type, excluding automatic displays:
REVIEW 3.8%
SHORT 76.5%
LONG 5.0%
FIELDS 1.9%
PERIODICALS 11.8%
COMMENTS 0.0%
Other 1.0%
2.1 CCT Database Statistics
____________________________
Median session length (minutes:seconds) 0:00
Average session length (minutes:seconds) 0:00
Longest session recorded (minutes:seconds) 20:47
Average number of searches completed per session 1.7
Retrievals per search - median 5.0
Retrievals per search - average 305.9
Retrievals per search - standard deviation 1351.8
Percent of searches completed with 0 results 21.1%
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 152 26.7%
DISPLAY (excluding automatic displays) 187 32.8%
HELP 42 7.4%
EXPLAIN 12 2.1%
SET/RESET 57 10.0%
SHOW 7 1.2%
ADD ON (AND, OR, AND NOT) 0 0.0%
LOGON or LOGOFF 95 16.7%
COMMENT 0 0.0%
SAVE 0 0.0%
USE 0 0.0%
OTHER 18 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 57 37.5% 19 33.3% 232 310.4 293.6
EXACT JOURNAL 20 13.2% 8 40.0% 61 211.8 317.7
SUBJECT CAT 4 2.6% 0 0.0% 7,640 7818.3 3505.1
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 71 46.7% 5 7.0% 3 13.5 68.5
By number of indexes:
Multiple 0 0.0% 0 0.0% 0 0.0 0.0
Single 152 100% 32 21.1% 19 387.5 1512.3
DISPLAY commands, by type, excluding automatic displays:
REVIEW 3.3%
ISSUES 42.3%
SHORT 4.7%
LONG 16.3%
PERIODICALS 33.5%
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 30.0%
2. First word of command is invalid 27.8%
3. FIND command with invalid index name 10.1%
4. Index invalid in current database 6.4%
5. DISPLAY command - no FIND results 3.4%
6. DISPLAY command contains invalid word 2.5%
7. Valid command at an inappropriate time 2.1%
8. Search term missing from search command 1.9%
9. D ABS command in database w/o abstracts 1.9%
10. NS of SHOW/EXP command-no next screen 1.5%
11. All others 12.5%
Ten most frequent EXPLAIN requests:
1. CC INDEXES 16.2%
2. LOCATE (ARTICLE DBS) 15.6%
3. FIND (CC DB) 11.0%
4. CC GUIDE 8.4%
5. COMMANDS 6.5%
6. CC DATABASE 6.5%
7. Unrecognized term 3.2%
8. DATABASES 3.2%
9. MAIL 2.6%
10. 5342 2.6%
11. All others 24.0%
Ten most frequent HELP situations:
1. Help requested from START CC command 19.4%
2. F/BR with index invalid in current DB 13.6%
3. Help requested from SET DB command 9.7%
4. First word of command is invalid 9.4%
5. FIND command with invalid index name 7.9%
6. DISPLAY command - middle of >1 screen 6.7%
7. DISPLAY command-first of >1 screen 3.9%
8. DISPLAY command-complete in one screen 3.6%
9. NS of SHOW/EXP command-no next screen 2.7%
10. FIND command with zero results 2.1%
11. All others 20.9%
Ten most frequent SHOW requests:
1. HISTORY 42.4%
2. SYSTEM NEWS 9.1%
3. CC NEWS 9.1%
4. SC LIST (CC DBS) 9.1%
5. SEARCH 9.1%
6. MAIL STATUS 6.1%
7. UPDATE 6.1%
8. SYSTEM2 NEWS 3.0%
9. CC STATISTICS 3.0%
10. DATABASES 3.0%
11. All others 0.0%
Cmm/yy cc MELVYL CURRENT CONTENTS DATABASE TELNET STATISTICS (monthly)