MELVYL CURRENT CONTENTS DATABASE TELNET STATISTICS
Time period: 08/01/01 through 08/31/01
1.0 SUMMARY STATISTICS
_______________________
1.1 Total sessions:
____________________
Location Library Remote Total
________ _______ ______ _____
Berkeley 208 2,350 2,558
Davis 1,168 157 1,325
Irvine 659 0 659
Los Angeles 5 940 945
Riverside 102 237 339
San Diego 124 727 851
San Francisco 682 0 682
Santa Barbara 11 369 380
Santa Cruz 75 274 349
LBL 0 320 320
LLL 0 178 178
Los Alamos n/a 0 0
Other - UC 7 114 121
U.S. Forestry 0
Other-Network UC n/a 2,459 2,459
_______ ______ _____
3,041 8,125 11,166
Per hour usage:
Time Sessions Finds Records Displayed
__________ __________ __________ _________________
12-2 a.m. 201 1,226 7,985
2-4 a.m. 135 640 4,908
4-6 a.m. 128 530 3,861
6-8 a.m. 354 2,266 23,144
8-10 a.m. 1,389 4,555 38,809
10-12 a.m. 2,211 5,890 45,510
12-2 p.m. 1,824 5,275 42,088
2-4 p.m. 2,212 5,967 56,434
4-6 p.m. 1,480 4,064 35,520
6-8 p.m. 576 1,587 13,488
8-10 p.m. 363 1,140 9,998
10-12 p.m. 293 1,410 10,656
__________ __________ __________ _________________
Total: 11,166 34,550 292,401
1.2 FIND commands
__________________
Number of FIND commands issued by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 548 6,789 7,337
Davis 4,162 385 4,547
Irvine 2,022 0 2,022
Los Angeles 5 2,811 2,816
Riverside 225 752 977
San Diego 465 1,891 2,356
San Francisco 1,947 0 1,947
Santa Barbara 40 988 1,028
Santa Cruz 159 749 908
LBL 0 882 882
LLL 0 2,704 2,704
Los Alamos n/a 0 0
Other - UC 10 343 353
U.S. Forestry 0
Other-Network UC n/a 6,673 6,673
_______ ______ _____
9,583 24,967 34,550
Number of FIND commands by database
CC database 33,968
CCT database 582
Total number of FIND commands 34,550
1.3 Records displayed
______________________
Number of Records Displayed by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 4,734 64,066 68,800
Davis 28,378 2,279 30,657
Irvine 13,331 0 13,331
Los Angeles 19 26,101 26,120
Riverside 1,802 8,621 10,423
San Diego 2,188 14,953 17,141
San Francisco 24,362 0 24,362
Santa Barbara 158 11,126 11,284
Santa Cruz 2,138 6,823 8,961
LBL 0 13,903 13,903
LLL 0 25,905 25,905
Los Alamos n/a 0 0
Other - UC 46 2,238 2,284
U.S. Forestry 0
Other-Network UC n/a 39,230 39,230
_______ ______ _____
77,156 215,245 292,401
Number of Records Displayed by database:
CC database 272,370
CCT database 20,031
Total number of Records Displayed 292,401
1.4 Relative Use of Databases
______________________________
Relative use of CC vs. CCT databases:
Percent of CC sessions 96.8%
Percent of CCT sessions 3.2%
Percent of searches done in the CC database 98.3%
Percent of searches done in the CCT database 1.7%
1.5 Response time
__________________
Search response time from receipt of command at
DLA until transmission of response:
Average in seconds 1.1
Standard deviation in seconds 5.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 5.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) 998:46
Average number of searches completed per session 3.1
Retrievals per search - median 7.0
Retrievals per search - average 499.6
Retrievals per search - standard deviation 5550.2
Percent of searches completed with 0 results 26.2%
Percent of searches entered that are long 0.6%
Percent of long searches completed
(includes partial results) 79.3%
Commands entered, by type, excluding errors:
Total Percentage
__________ __________
FIND 30,625 38.7%
DISPLAY (excluding automatic displays) 22,417 28.3%
HELP 462 0.6%
EXPLAIN 470 0.6%
SET/RESET 5,003 6.3%
SHOW 74 0.1%
ADD ON (AND, OR, AND NOT) 3,343 4.2%
LOGON or LOGOFF 12,345 15.6%
COMMENT 0 0.0%
SAVE 1,101 1.4%
USE 29 0.0%
OTHER 3,255 4.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:
PERSONAL AUTHOR 13,966 39.1% 2,230 16.0% 30 381.1 4336.9
TITLE WORD 9,947 27.8% 3,029 30.4% 11 670.1 5384.3
EXACT TITLE 537 1.5% 268 49.9% 2 151.3 1339.1
JOURNAL 1,854 5.2% 790 42.6% 395 4904.2 21790.6
EXACT JOURNAL 2,137 6.0% 1,341 62.8% 52 1592.4 5690.1
SUBJECT CAT 233 0.7% 20 8.6% 10 139.1 682.6
SUBFILE 65 0.2% 9 13.8% 41 586.5 1497.2
PUBLICATION TYPE 131 0.4% 20 15.3% 13 330.1 1845.5
LANGUAGE 21 0.1% 2 9.5% 79 283.4 354.4
DATE 709 2.0% 121 17.1% 10 109.3 429.5
ADDED 2,472 6.9% 1,632 66.0% 19 29.3 30.8
PERIODICAL 1,742 4.9% 288 16.5% 4 58.3 1014.0
EXACT PE 506 1.4% 47 9.3% 4 28.3 177.8
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,425 4.0% 453 31.8% 17 911.7 7932.0
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 5,107 16.7% 2,387 46.7% 9 68.7 378.4
Single 25,426 83.3% 5,439 21.4% 27 822.3 7194.5
DISPLAY commands, by type, excluding automatic displays:
REVIEW 5.3%
SHORT 75.9%
LONG 5.2%
FIELDS 1.8%
PERIODICALS 10.6%
COMMENTS 0.0%
Other 1.1%
2.1 CCT Database Statistics
____________________________
Median session length (minutes:seconds) 0:00
Average session length (minutes:seconds) 0:00
Longest session recorded (minutes:seconds) 56:14
Average number of searches completed per session 1.6
Retrievals per search - median 52.0
Retrievals per search - average 233.9
Retrievals per search - standard deviation 1202.4
Percent of searches completed with 0 results 28.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 577 25.1%
DISPLAY (excluding automatic displays) 984 42.7%
HELP 89 3.9%
EXPLAIN 59 2.6%
SET/RESET 252 10.9%
SHOW 18 0.8%
ADD ON (AND, OR, AND NOT) 5 0.2%
LOGON or LOGOFF 261 11.3%
COMMENT 0 0.0%
SAVE 2 0.1%
USE 0 0.0%
OTHER 55 2.4%
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 408 70.1% 130 31.9% 128 365.4 1646.2
EXACT JOURNAL 130 22.3% 30 23.1% 125 245.9 401.4
SUBJECT CAT 5 0.9% 0 0.0% 214 1721.2 3414.1
SUBFILE 0 0.0% 0 0.0% 0 0.0 0.0
DATE 2 0.3% 0 0.0% 110 109.5 147.8
ADDED 3 0.5% 0 0.0% 168 188.3 108.9
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 34 5.8% 6 17.6% 6 48.6 133.9
By number of indexes:
Multiple 5 0.9% 0 0.0% 168 156.8 115.1
Single 572 99.1% 166 29.0% 119 333.4 1428.6
DISPLAY commands, by type, excluding automatic displays:
REVIEW 12.1%
ISSUES 38.8%
SHORT 22.5%
LONG 19.7%
PERIODICALS 6.4%
COMMENTS 0.0%
Other 0.5%
2.3 Error, EXPLAIN and HELP statistics (CC & CCT)
__________________________________________________
Percent of commands that contained errors 7.4%
Ten most frequent errors:
1. NS command - no next screen 35.5%
2. First word of command is invalid 26.1%
3. FIND command with invalid index name 9.3%
4. Index invalid in current database 3.2%
5. Max. # of ports to a Z39 db are in use 2.6%
6. Search term missing from search command 2.2%
7. DISPLAY command - no FIND results 2.2%
8. DISPLAY command contains invalid word 2.1%
9. PS command - no previous screen 1.7%
10. D ABS command in database w/o abstracts 1.4%
11. All others 13.8%
Ten most frequent EXPLAIN requests:
1. FIND (CC DB) 16.4%
2. CC INDEXES 14.0%
3. CC GUIDE 12.7%
4. COMMANDS 7.4%
5. LOCATE (ARTICLE DBS) 6.4%
6. CC DATABASE 4.7%
7. Unrecognized term 3.8%
8. MAIL 3.0%
9. CCT INDEXES 3.0%
10. SUBJECT CATEGORY 2.1%
11. All others 26.5%
Ten most frequent HELP situations:
1. Help requested from START CC command 16.3%
2. First word of command is invalid 11.9%
3. Help requested from SET DB command 8.3%
4. FIND command with invalid index name 6.3%
5. FIND command with zero results 6.1%
6. F/BR with index invalid in current DB 5.9%
7. DISPLAY command-first of >1 screen 5.4%
8. DISPLAY command - middle of >1 screen 4.1%
9. DISPLAY command-complete in one screen 4.0%
10. FIND command retrieves >1 book 3.8%
11. All others 28.0%
Ten most frequent SHOW requests:
1. HISTORY 47.8%
2. SEARCH 7.6%
3. CC GLOSSARY 6.5%
4. CC SETTINGS 5.4%
5. CC NEWS 5.4%
6. MAIL STATUS 5.4%
7. UPDATE 4.3%
8. SYSTEM NEWS 3.3%
9. SC LIST (CC DBS) 3.3%
10. CCT SETTINGS 2.2%
11. All others 8.7%
Cmm/yy cc MELVYL CURRENT CONTENTS DATABASE TELNET STATISTICS (monthly)