MELVYL CURRENT CONTENTS DATABASE TELNET STATISTICS
Time period: 04/01/02 through 04/30/02
1.0 SUMMARY STATISTICS
_______________________
1.1 Total sessions:
____________________
Location Library Remote Total
________ _______ ______ _____
Berkeley 272 2,152 2,424
Davis 920 69 989
Irvine 631 0 631
Los Angeles 2 602 604
Riverside 68 168 236
San Diego 135 561 696
San Francisco 563 0 563
Santa Barbara 22 223 245
Santa Cruz 99 171 270
LBL 0 315 315
LLL 0 180 180
Los Alamos n/a 0 0
Other - UC 4 226 230
U.S. Forestry 0
Other-Network UC n/a 1,594 1,594
_______ ______ _____
2,716 6,261 8,977
Per hour usage:
Time Sessions Finds Records Displayed
__________ __________ __________ _________________
12-2 a.m. 124 394 5,087
2-4 a.m. 91 428 10,223
4-6 a.m. 75 242 2,349
6-8 a.m. 214 686 4,749
8-10 a.m. 1,109 3,259 22,541
10-12 a.m. 1,841 5,942 46,558
12-2 p.m. 1,480 4,268 38,650
2-4 p.m. 1,769 4,787 46,974
4-6 p.m. 1,279 3,246 32,752
6-8 p.m. 491 1,574 13,110
8-10 p.m. 281 959 11,407
10-12 p.m. 223 699 5,398
__________ __________ __________ _________________
Total: 8,977 26,484 239,798
1.2 FIND commands
__________________
Number of FIND commands issued by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 668 6,374 7,042
Davis 2,669 248 2,917
Irvine 1,958 0 1,958
Los Angeles 16 1,953 1,969
Riverside 156 516 672
San Diego 277 1,651 1,928
San Francisco 2,882 0 2,882
Santa Barbara 48 629 677
Santa Cruz 177 475 652
LBL 0 789 789
LLL 0 603 603
Los Alamos n/a 0 0
Other - UC 4 674 678
U.S. Forestry 0
Other-Network UC n/a 3,717 3,717
_______ ______ _____
8,855 17,629 26,484
Number of FIND commands by database
CC database 26,063
CCT database 421
Total number of FIND commands 26,484
1.3 Records displayed
______________________
Number of Records Displayed by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 5,528 60,612 66,140
Davis 22,118 1,162 23,280
Irvine 20,612 0 20,612
Los Angeles 109 20,160 20,269
Riverside 723 3,821 4,544
San Diego 1,758 13,395 15,153
San Francisco 27,050 0 27,050
Santa Barbara 463 6,951 7,414
Santa Cruz 1,457 4,659 6,116
LBL 0 10,183 10,183
LLL 0 5,411 5,411
Los Alamos n/a 0 0
Other - UC 6 6,985 6,991
U.S. Forestry 0
Other-Network UC n/a 26,635 26,635
_______ ______ _____
79,824 159,974 239,798
Number of Records Displayed by database:
CC database 224,711
CCT database 15,087
Total number of Records Displayed 239,798
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 98.4%
Percent of searches done in the CCT database 1.6%
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 4.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 4.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) 780:59
Average number of searches completed per session 3.0
Retrievals per search - median 8.0
Retrievals per search - average 665.7
Retrievals per search - standard deviation 6593.7
Percent of searches completed with 0 results 21.6%
Percent of searches entered that are long 0.4%
Percent of long searches completed
(includes partial results) 78.4%
Commands entered, by type, excluding errors:
Total Percentage
__________ __________
FIND 23,477 36.5%
DISPLAY (excluding automatic displays) 18,958 29.5%
HELP 557 0.9%
EXPLAIN 578 0.9%
SET/RESET 3,571 5.6%
SHOW 92 0.1%
ADD ON (AND, OR, AND NOT) 2,586 4.0%
LOGON or LOGOFF 10,525 16.4%
COMMENT 0 0.0%
SAVE 1,213 1.9%
USE 9 0.0%
OTHER 2,700 4.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:
PERSONAL AUTHOR 10,356 40.7% 1,544 14.9% 30 227.8 1656.1
TITLE WORD 7,904 31.0% 2,453 31.0% 10 925.8 6262.5
EXACT TITLE 515 2.0% 210 40.8% 2 29.7 126.3
JOURNAL 1,615 6.3% 429 26.6% 1,329 5406.5 24145.6
EXACT JOURNAL 607 2.4% 183 30.1% 2,013 4626.1 11821.9
SUBJECT CAT 101 0.4% 14 13.9% 26 2281.7 19436.6
SUBFILE 64 0.3% 10 15.6% 20 96.5 263.4
PUBLICATION TYPE 69 0.3% 20 29.0% 18 5047.0 16803.4
LANGUAGE 8 0.0% 0 0.0% 39 153.9 286.1
DATE 445 1.7% 98 22.0% 7 76.3 218.7
ADDED 134 0.5% 44 32.8% 4 8.6 13.4
PERIODICAL 2,186 8.6% 263 12.0% 4 83.1 1007.0
EXACT PE 427 1.7% 42 9.8% 3 11.5 37.4
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 1,041 4.1% 283 27.2% 19 1290.5 7955.2
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 2,013 8.6% 601 29.9% 5 46.7 199.0
Single 21,394 91.4% 4,371 20.4% 25 994.2 8106.9
DISPLAY commands, by type, excluding automatic displays:
REVIEW 4.4%
SHORT 70.5%
LONG 4.8%
FIELDS 1.8%
PERIODICALS 16.9%
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) 51:16
Average number of searches completed per session 1.2
Retrievals per search - median 51.0
Retrievals per search - average 434.2
Retrievals per search - standard deviation 2539.6
Percent of searches completed with 0 results 27.8%
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 420 21.3%
DISPLAY (excluding automatic displays) 666 33.7%
HELP 168 8.5%
EXPLAIN 82 4.2%
SET/RESET 243 12.3%
SHOW 22 1.1%
ADD ON (AND, OR, AND NOT) 1 0.1%
LOGON or LOGOFF 303 15.3%
COMMENT 0 0.0%
SAVE 0 0.0%
USE 1 0.1%
OTHER 69 3.5%
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 308 72.6% 98 31.8% 136 706.7 3417.9
EXACT JOURNAL 81 19.1% 15 18.5% 116 288.1 515.7
SUBJECT CAT 1 0.2% 0 0.0% 14,800 14800.0 0.0
SUBFILE 0 0.0% 0 0.0% 0 0.0 0.0
DATE 4 0.9% 1 25.0% 13 22.3 17.9
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 30 7.1% 4 13.3% 6 22.8 50.7
By number of indexes:
Multiple 4 1.0% 1 25.0% 13 22.3 17.9
Single 416 99.0% 116 27.9% 123 609.2 2992.2
DISPLAY commands, by type, excluding automatic displays:
REVIEW 9.9%
ISSUES 41.4%
SHORT 21.1%
LONG 19.3%
PERIODICALS 7.2%
COMMENTS 0.0%
Other 1.1%
2.3 Error, EXPLAIN and HELP statistics (CC & CCT)
__________________________________________________
Percent of commands that contained errors 7.7%
Ten most frequent errors:
1. First word of command is invalid 30.4%
2. NS command - no next screen 30.1%
3. FIND command with invalid index name 10.2%
4. Index invalid in current database 4.7%
5. DISPLAY command contains invalid word 2.9%
6. Search term missing from search command 2.1%
7. PS command - no previous screen 1.7%
8. DISPLAY command - no FIND results 1.7%
9. D ABS command in database w/o abstracts 1.5%
10. Valid command at an inappropriate time 1.4%
11. All others 13.3%
Ten most frequent EXPLAIN requests:
1. CC GUIDE 17.6%
2. FIND (CC DB) 11.8%
3. CC INDEXES 10.0%
4. LOCATE (ARTICLE DBS) 9.5%
5. COMMANDS 7.7%
6. Unrecognized term 5.0%
7. DATABASES 3.0%
8. DISPLAY 3.0%
9. FIND (CCT DB) 2.7%
10. CC DATABASE 2.4%
11. All others 27.1%
Ten most frequent HELP situations:
1. First word of command is invalid 14.9%
2. Help requested from START CC command 13.7%
3. F/BR with index invalid in current DB 10.5%
4. FIND command with invalid index name 8.3%
5. Help requested from SET DB command 6.1%
6. DISPLAY command-complete in one screen 4.6%
7. FIND command with zero results 4.5%
8. DISPLAY command - middle of >1 screen 4.2%
9. DISPLAY command-first of >1 screen 4.0%
10. FIND command retrieves >1 book 3.9%
11. All others 25.4%
Ten most frequent SHOW requests:
1. HISTORY 33.6%
2. CC NEWS 15.9%
3. SEARCH 15.0%
4. SYSTEM NEWS 10.6%
5. SC LIST (CC DBS) 6.2%
6. TIME 4.4%
7. CC SETTINGS 4.4%
8. CC GLOSSARY 4.4%
9. MAIL STATUS 1.8%
10. DATABASES 1.8%
11. All others 1.8%
Cmm/yy cc MELVYL CURRENT CONTENTS DATABASE TELNET STATISTICS (monthly)