MELVYL CURRENT CONTENTS DATABASE TELNET STATISTICS
Time period: 04/21/01 through 04/27/01
1.0 SUMMARY STATISTICS
_______________________
1.1 Total sessions:
____________________
Location Library Remote Total
________ _______ ______ _____
Berkeley 103 787 890
Davis 361 10 371
Irvine 222 0 222
Los Angeles 6 226 232
Riverside 40 63 103
San Diego 53 251 304
San Francisco 135 0 135
Santa Barbara 9 150 159
Santa Cruz 23 90 113
LBL 0 96 96
LLL 0 75 75
Los Alamos n/a 0 0
Other - UC 2 70 72
U.S. Forestry 0
Other-Network UC n/a 525 525
_______ ______ _____
954 2,343 3,297
Per hour usage:
Time Sessions Finds Records Displayed
__________ __________ __________ _________________
12-2 a.m. 41 123 1,240
2-4 a.m. 43 104 789
4-6 a.m. 32 157 792
6-8 a.m. 58 479 5,973
8-10 a.m. 360 1,126 10,572
10-12 a.m. 615 1,531 12,714
12-2 p.m. 569 1,373 15,948
2-4 p.m. 675 1,858 18,101
4-6 p.m. 484 1,264 15,356
6-8 p.m. 198 590 6,426
8-10 p.m. 120 412 4,146
10-12 p.m. 102 319 2,786
__________ __________ __________ _________________
Total: 3,297 9,336 94,843
1.2 FIND commands
__________________
Number of FIND commands issued by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 318 1,923 2,241
Davis 954 45 999
Irvine 750 0 750
Los Angeles 14 663 677
Riverside 87 152 239
San Diego 132 761 893
San Francisco 387 0 387
Santa Barbara 24 498 522
Santa Cruz 58 251 309
LBL 0 264 264
LLL 0 768 768
Los Alamos n/a 0 0
Other - UC 4 183 187
U.S. Forestry 0
Other-Network UC n/a 1,100 1,100
_______ ______ _____
2,728 6,608 9,336
Number of FIND commands by database
CC database 9,106
CCT database 230
Total number of FIND commands 9,336
1.3 Records displayed
______________________
Number of Records Displayed by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 2,807 19,015 21,822
Davis 15,289 203 15,492
Irvine 4,714 0 4,714
Los Angeles 80 5,223 5,303
Riverside 358 1,395 1,753
San Diego 970 5,334 6,304
San Francisco 3,848 0 3,848
Santa Barbara 152 5,567 5,719
Santa Cruz 659 2,700 3,359
LBL 0 3,605 3,605
LLL 0 9,664 9,664
Los Alamos n/a 0 0
Other - UC 17 1,185 1,202
U.S. Forestry 0
Other-Network UC n/a 12,058 12,058
_______ ______ _____
28,894 65,949 94,843
Number of Records Displayed by database:
CC database 86,942
CCT database 7,901
Total number of Records Displayed 94,843
1.4 Relative Use of Databases
______________________________
Relative use of CC vs. CCT databases:
Percent of CC sessions 93.6%
Percent of CCT sessions 6.4%
Percent of searches done in the CC database 97.5%
Percent of searches done in the CCT database 2.5%
1.5 Response time
__________________
Search response time from receipt of command at
DLA until transmission of response:
Average in seconds 1.0
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) 251:55
Average number of searches completed per session 2.9
Retrievals per search - median 9.0
Retrievals per search - average 450.1
Retrievals per search - standard deviation 3444.2
Percent of searches completed with 0 results 25.4%
Percent of searches entered that are long 0.3%
Percent of long searches completed
(includes partial results) 41.7%
Commands entered, by type, excluding errors:
Total Percentage
__________ __________
FIND 8,539 38.1%
DISPLAY (excluding automatic displays) 6,265 27.9%
HELP 243 1.1%
EXPLAIN 241 1.1%
SET/RESET 1,224 5.5%
SHOW 55 0.2%
ADD ON (AND, OR, AND NOT) 567 2.5%
LOGON or LOGOFF 3,918 17.5%
COMMENT 0 0.0%
SAVE 288 1.3%
USE 13 0.1%
OTHER 1,070 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 3,912 39.3% 591 15.1% 30 271.4 1802.1
TITLE WORD 3,107 31.2% 949 30.5% 15 586.6 3888.2
EXACT TITLE 98 1.0% 53 54.1% 3 9.0 14.4
JOURNAL 428 4.3% 197 46.0% 283 3801.8 10140.0
EXACT JOURNAL 510 5.1% 293 57.4% 66 2541.9 9063.3
SUBJECT CAT 20 0.2% 2 10.0% 16 238.0 699.7
SUBFILE 36 0.4% 5 13.9% 51 254.5 1016.4
PUBLICATION TYPE 37 0.4% 10 27.0% 16 63.8 138.1
LANGUAGE 33 0.3% 3 9.1% 3 47.6 71.8
DATE 209 2.1% 31 14.8% 10 156.0 572.5
ADDED 622 6.2% 403 64.8% 21 38.9 53.0
PERIODICAL 296 3.0% 51 17.2% 4 41.1 195.9
EXACT PE 56 0.6% 14 25.0% 2 10.3 16.6
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 590 5.9% 165 28.0% 21 1107.5 6781.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 1,395 16.4% 619 44.4% 11 117.0 1284.4
Single 7,116 83.6% 1,517 21.3% 30 705.2 4336.7
DISPLAY commands, by type, excluding automatic displays:
REVIEW 4.0%
SHORT 81.7%
LONG 3.6%
FIELDS 2.3%
PERIODICALS 6.9%
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) 59:32
Average number of searches completed per session 1.1
Retrievals per search - median 62.5
Retrievals per search - average 366.0
Retrievals per search - standard deviation 1848.5
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 230 21.7%
DISPLAY (excluding automatic displays) 368 34.6%
HELP 49 4.6%
EXPLAIN 33 3.1%
SET/RESET 141 13.3%
SHOW 14 1.3%
ADD ON (AND, OR, AND NOT) 0 0.0%
LOGON or LOGOFF 191 18.0%
COMMENT 0 0.0%
SAVE 0 0.0%
USE 1 0.1%
OTHER 35 3.3%
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 165 71.7% 56 33.9% 139 625.9 2646.9
EXACT JOURNAL 47 20.4% 3 6.4% 117 358.1 438.4
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 18 7.8% 5 27.8% 2 14.3 39.9
By number of indexes:
Multiple 0 0.0% 0 0.0% 0 0.0 0.0
Single 230 100% 64 27.8% 117 507.0 2161.1
DISPLAY commands, by type, excluding automatic displays:
REVIEW 3.4%
ISSUES 46.1%
SHORT 31.2%
LONG 13.4%
PERIODICALS 4.4%
COMMENTS 0.0%
Other 1.5%
2.3 Error, EXPLAIN and HELP statistics (CC & CCT)
__________________________________________________
Percent of commands that contained errors 8.9%
Ten most frequent errors:
1. NS command - no next screen 30.5%
2. First word of command is invalid 29.2%
3. FIND command with invalid index name 10.5%
4. Index invalid in current database 5.4%
5. Search term missing from search command 1.8%
6. Valid command at an inappropriate time 1.8%
7. PS command - no previous screen 1.8%
8. DISPLAY command contains invalid word 1.6%
9. Max. # of ports to a Z39 db are in use 1.6%
10. DISPLAY command - no FIND results 1.6%
11. All others 14.2%
Ten most frequent EXPLAIN requests:
1. CC GUIDE 21.2%
2. LOCATE (ARTICLE DBS) 15.0%
3. CC INDEXES 10.6%
4. FIND (CC DB) 7.7%
5. COMMANDS 7.3%
6. CCT DATABASE 5.1%
7. Unrecognized term 4.0%
8. CC DATABASE 3.3%
9. DATABASES 2.9%
10. MAIL 2.6%
11. All others 20.4%
Ten most frequent HELP situations:
1. Help requested from START CC command 16.3%
2. First word of command is invalid 12.7%
3. F/BR with index invalid in current DB 11.8%
4. FIND command with invalid index name 9.7%
5. DISPLAY command - middle of >1 screen 5.1%
6. DISPLAY command-first of >1 screen 4.8%
7. Help requested from SET DB command 4.8%
8. DISPLAY command-complete in one screen 3.4%
9. NS command - no next screen 3.2%
10. 3 HELP commands issued from same code 2.5%
11. All others 25.8%
Ten most frequent SHOW requests:
1. HISTORY 42.4%
2. SEARCH 15.2%
3. SYSTEM NEWS 7.6%
4. MAIL STATUS 6.1%
5. CC NEWS 4.5%
6. SC LIST (CC DBS) 4.5%
7. UPDATE 4.5%
8. GLOSSARY 3.0%
9. CC SETTINGS 3.0%
10. CC GLOSSARY 3.0%
11. All others 6.1%
Cmm/yy cc MELVYL CURRENT CONTENTS DATABASE TELNET STATISTICS (monthly)