MELVYL CURRENT CONTENTS DATABASE TELNET STATISTICS
Time period: 11/25/00 through 12/01/00
1.0 SUMMARY STATISTICS
_______________________
1.1 Total sessions:
____________________
Location Library Remote Total
________ _______ ______ _____
Berkeley 155 872 1,027
Davis 437 69 506
Irvine 299 0 299
Los Angeles 66 286 352
Riverside 88 63 151
San Diego 57 285 342
San Francisco 248 0 248
Santa Barbara 61 179 240
Santa Cruz 42 106 148
LBL 0 117 117
LLL 0 74 74
Los Alamos n/a 0 0
Other - UC 0 47 47
U.S. Forestry 0
Other-Network UC n/a 412 412
_______ ______ _____
1,453 2,510 3,963
Per hour usage:
Time Sessions Finds Records Displayed
__________ __________ __________ _________________
12-2 a.m. 59 182 1,499
2-4 a.m. 42 149 1,101
4-6 a.m. 47 107 806
6-8 a.m. 111 726 11,753
8-10 a.m. 421 1,406 62,726
10-12 a.m. 715 2,165 22,204
12-2 p.m. 632 1,792 16,944
2-4 p.m. 780 2,019 19,003
4-6 p.m. 561 1,461 16,300
6-8 p.m. 279 858 7,657
8-10 p.m. 174 637 10,622
10-12 p.m. 142 433 5,129
__________ __________ __________ _________________
Total: 3,963 11,935 175,744
1.2 FIND commands
__________________
Number of FIND commands issued by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 442 2,296 2,738
Davis 1,541 82 1,623
Irvine 883 0 883
Los Angeles 191 866 1,057
Riverside 188 187 375
San Diego 154 854 1,008
San Francisco 848 0 848
Santa Barbara 120 643 763
Santa Cruz 79 230 309
LBL 0 260 260
LLL 0 676 676
Los Alamos n/a 0 0
Other - UC 0 108 108
U.S. Forestry 0
Other-Network UC n/a 1,287 1,287
_______ ______ _____
4,446 7,489 11,935
Number of FIND commands by database
CC database 11,516
CCT database 419
Total number of FIND commands 11,935
1.3 Records displayed
______________________
Number of Records Displayed by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 5,173 24,469 29,642
Davis 62,016 651 62,667
Irvine 7,272 0 7,272
Los Angeles 1,179 9,067 10,246
Riverside 1,421 1,604 3,025
San Diego 1,834 7,682 9,516
San Francisco 6,657 0 6,657
Santa Barbara 1,229 7,258 8,487
Santa Cruz 808 2,571 3,379
LBL 0 4,885 4,885
LLL 0 8,939 8,939
Los Alamos n/a 0 0
Other - UC 0 1,607 1,607
U.S. Forestry 0
Other-Network UC n/a 19,422 19,422
_______ ______ _____
87,589 88,155 175,744
Number of Records Displayed by database:
CC database 160,012
CCT database 15,732
Total number of Records Displayed 175,744
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 96.5%
Percent of searches done in the CCT database 3.5%
1.5 Response time
__________________
Search response time from receipt of command at
DLA until transmission of response:
Average in seconds 0.9
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) 353:10
Average number of searches completed per session 3.0
Retrievals per search - median 12.0
Retrievals per search - average 562.4
Retrievals per search - standard deviation 5361.8
Percent of searches completed with 0 results 23.4%
Percent of searches entered that are long 0.4%
Percent of long searches completed
(includes partial results) 59.5%
Commands entered, by type, excluding errors:
Total Percentage
__________ __________
FIND 10,703 37.0%
DISPLAY (excluding automatic displays) 8,388 29.0%
HELP 375 1.3%
EXPLAIN 369 1.3%
SET/RESET 1,312 4.5%
SHOW 59 0.2%
ADD ON (AND, OR, AND NOT) 813 2.8%
LOGON or LOGOFF 5,056 17.5%
COMMENT 0 0.0%
SAVE 490 1.7%
USE 8 0.0%
OTHER 1,376 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 5,315 44.8% 703 13.2% 32 235.0 1274.7
TITLE WORD 3,653 30.8% 1,113 30.5% 19 1023.0 8044.1
EXACT TITLE 63 0.5% 25 39.7% 6 326.4 1340.9
JOURNAL 522 4.4% 235 45.0% 699 4040.1 10547.0
EXACT JOURNAL 553 4.7% 315 57.0% 50 2135.3 6264.8
SUBJECT CAT 31 0.3% 6 19.4% 12 18.4 27.0
SUBFILE 26 0.2% 4 15.4% 44 444.7 1250.9
PUBLICATION TYPE 74 0.6% 11 14.9% 13 7120.3 38658.2
LANGUAGE 10 0.1% 4 40.0% 3,342 10158.5 18874.2
DATE 133 1.1% 21 15.8% 19 210.1 662.2
ADDED 506 4.3% 347 68.6% 26 36.9 34.7
PERIODICAL 296 2.5% 48 16.2% 5 85.0 379.9
EXACT PE 64 0.5% 9 14.1% 2 6.7 12.9
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 619 5.2% 171 27.6% 22 994.9 4921.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 1,189 11.2% 553 46.5% 13 186.6 1979.4
Single 9,466 88.8% 1,898 20.0% 31 811.4 6516.2
DISPLAY commands, by type, excluding automatic displays:
REVIEW 3.9%
SHORT 81.4%
LONG 5.4%
FIELDS 1.5%
PERIODICALS 6.1%
COMMENTS 0.0%
Other 1.8%
2.1 CCT Database Statistics
____________________________
Median session length (minutes:seconds) 0:00
Average session length (minutes:seconds) 0:00
Longest session recorded (minutes:seconds) 87:58
Average number of searches completed per session 2.2
Retrievals per search - median 36.0
Retrievals per search - average 250.5
Retrievals per search - standard deviation 1049.2
Percent of searches completed with 0 results 30.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 419 25.8%
DISPLAY (excluding automatic displays) 679 41.8%
HELP 103 6.3%
EXPLAIN 50 3.1%
SET/RESET 140 8.6%
SHOW 17 1.0%
ADD ON (AND, OR, AND NOT) 0 0.0%
LOGON or LOGOFF 165 10.2%
COMMENT 0 0.0%
SAVE 0 0.0%
USE 0 0.0%
OTHER 51 3.1%
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 294 70.2% 114 38.8% 68 313.9 875.2
EXACT JOURNAL 94 22.4% 14 14.9% 138 282.5 402.8
SUBJECT CAT 2 0.5% 0 0.0% 4,571 4571.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 29 6.9% 1 3.4% 3 597.4 3106.9
By number of indexes:
Multiple 0 0.0% 0 0.0% 0 0.0 0.0
Single 419 100% 129 30.8% 68 362.0 1245.7
DISPLAY commands, by type, excluding automatic displays:
REVIEW 9.7%
ISSUES 41.2%
SHORT 27.5%
LONG 15.8%
PERIODICALS 5.3%
COMMENTS 0.0%
Other 0.4%
2.3 Error, EXPLAIN and HELP statistics (CC & CCT)
__________________________________________________
Percent of commands that contained errors 8.8%
Ten most frequent errors:
1. First word of command is invalid 30.7%
2. NS command - no next screen 30.6%
3. FIND command with invalid index name 9.4%
4. Index invalid in current database 5.3%
5. Search term missing from search command 2.5%
6. PS command - no previous screen 2.4%
7. DISPLAY command contains invalid word 2.3%
8. D ABS command in database w/o abstracts 1.8%
9. F SUB CAT search with invalid SC 1.6%
10. Valid command at an inappropriate time 1.3%
11. All others 12.2%
Ten most frequent EXPLAIN requests:
1. CC GUIDE 15.5%
2. LOCATE (ARTICLE DBS) 11.2%
3. FIND (CC DB) 11.2%
4. CC INDEXES 10.3%
5. COMMANDS 8.1%
6. Unrecognized term 3.3%
7. DATABASES 2.4%
8. ADD-ON SEARCH 2.4%
9. CC DATABASE 2.4%
10. FIND (CCT DB) 2.4%
11. All others 30.8%
Ten most frequent HELP situations:
1. Help requested from START CC command 15.1%
2. First word of command is invalid 12.6%
3. FIND command with invalid index name 9.8%
4. F/BR with index invalid in current DB 9.7%
5. Help requested from SET DB command 6.7%
6. DISPLAY command-first of >1 screen 5.7%
7. DISPLAY command - middle of >1 screen 4.7%
8. FIND command with zero results 3.6%
9. FIND command retrieves >1 book 3.3%
10. DISPLAY command-complete in one screen 3.2%
11. All others 25.6%
Ten most frequent SHOW requests:
1. HISTORY 40.8%
2. SYSTEM NEWS 13.2%
3. SEARCH 9.2%
4. SC LIST (CC DBS) 7.9%
5. LIBRARY NEWS 5.3%
6. CC GLOSSARY 5.3%
7. CC NEWS 5.3%
8. CC SETTINGS 2.6%
9. MAIL STATUS 2.6%
10. UCI NEWS 1.3%
11. All others 6.6%
Cmm/yy cc MELVYL CURRENT CONTENTS DATABASE TELNET STATISTICS (monthly)