MELVYL CURRENT CONTENTS DATABASE TELNET STATISTICS
Time period: 01/12/02 through 01/18/02
1.0 SUMMARY STATISTICS
_______________________
1.1 Total sessions:
____________________
Location Library Remote Total
________ _______ ______ _____
Berkeley 31 500 531
Davis 220 26 246
Irvine 110 0 110
Los Angeles 1 223 224
Riverside 9 42 51
San Diego 30 173 203
San Francisco 166 0 166
Santa Barbara 2 67 69
Santa Cruz 5 79 84
LBL 0 98 98
LLL 0 19 19
Los Alamos n/a 0 0
Other - UC 6 33 39
U.S. Forestry 0
Other-Network UC n/a 503 503
_______ ______ _____
580 1,763 2,343
Per hour usage:
Time Sessions Finds Records Displayed
__________ __________ __________ _________________
12-2 a.m. 34 144 1,612
2-4 a.m. 27 68 8,882
4-6 a.m. 23 74 868
6-8 a.m. 67 160 2,438
8-10 a.m. 290 736 5,626
10-12 a.m. 496 1,386 10,985
12-2 p.m. 408 1,184 10,185
2-4 p.m. 471 1,205 9,788
4-6 p.m. 281 742 5,824
6-8 p.m. 114 393 3,741
8-10 p.m. 64 248 11,189
10-12 p.m. 68 158 1,634
__________ __________ __________ _________________
Total: 2,343 6,498 72,772
1.2 FIND commands
__________________
Number of FIND commands issued by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 76 1,332 1,408
Davis 552 74 626
Irvine 277 0 277
Los Angeles 2 615 617
Riverside 20 106 126
San Diego 71 454 525
San Francisco 616 0 616
Santa Barbara 4 185 189
Santa Cruz 4 232 236
LBL 0 308 308
LLL 0 46 46
Los Alamos n/a 0 0
Other - UC 1 99 100
U.S. Forestry 0
Other-Network UC n/a 1,424 1,424
_______ ______ _____
1,623 4,875 6,498
Number of FIND commands by database
CC database 6,426
CCT database 72
Total number of FIND commands 6,498
1.3 Records displayed
______________________
Number of Records Displayed by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 567 13,734 14,301
Davis 4,806 544 5,350
Irvine 10,905 0 10,905
Los Angeles 20 4,542 4,562
Riverside 153 1,200 1,353
San Diego 875 3,354 4,229
San Francisco 5,545 0 5,545
Santa Barbara 23 2,149 2,172
Santa Cruz 19 1,680 1,699
LBL 0 2,326 2,326
LLL 0 579 579
Los Alamos n/a 0 0
Other - UC 11 1,531 1,542
U.S. Forestry 0
Other-Network UC n/a 18,209 18,209
_______ ______ _____
22,924 49,848 72,772
Number of Records Displayed by database:
CC database 70,522
CCT database 2,250
Total number of Records Displayed 72,772
1.4 Relative Use of Databases
______________________________
Relative use of CC vs. CCT databases:
Percent of CC sessions 97.7%
Percent of CCT sessions 2.3%
Percent of searches done in the CC database 98.9%
Percent of searches done in the CCT database 1.1%
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.1
Display response time from receipt of command at
DLA until transmission of a complete screen:
Average in seconds 0.2
Standard deviation in seconds 5.1
2.0 CC Database Statistics
___________________________
Median session length (minutes:seconds) 0:00
Average session length (minutes:seconds) 0:00
Longest session recorded (minutes:seconds) 527:50
Average number of searches completed per session 2.8
Retrievals per search - median 9.0
Retrievals per search - average 602.1
Retrievals per search - standard deviation 4169.1
Percent of searches completed with 0 results 22.0%
Percent of searches entered that are long 0.7%
Percent of long searches completed
(includes partial results) 71.1%
Commands entered, by type, excluding errors:
Total Percentage
__________ __________
FIND 5,577 34.8%
DISPLAY (excluding automatic displays) 4,569 28.5%
HELP 111 0.7%
EXPLAIN 106 0.7%
SET/RESET 916 5.7%
SHOW 23 0.1%
ADD ON (AND, OR, AND NOT) 849 5.3%
LOGON or LOGOFF 2,905 18.1%
COMMENT 0 0.0%
SAVE 278 1.7%
USE 5 0.0%
OTHER 701 4.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:
PERSONAL AUTHOR 2,640 42.6% 425 16.1% 33 227.8 811.2
TITLE WORD 1,793 28.9% 535 29.8% 16 944.2 7141.1
EXACT TITLE 95 1.5% 38 40.0% 2 31.2 95.8
JOURNAL 418 6.7% 149 35.6% 1,088 4628.5 9606.0
EXACT JOURNAL 115 1.9% 25 21.7% 3,010 5758.6 9600.4
SUBJECT CAT 32 0.5% 4 12.5% 22 46.2 64.9
SUBFILE 10 0.2% 2 20.0% 29 128.0 259.1
PUBLICATION TYPE 24 0.4% 6 25.0% 10 64.6 104.7
LANGUAGE 19 0.3% 4 21.1% 6 412.2 1217.3
DATE 174 2.8% 35 20.1% 9 89.5 346.6
ADDED 9 0.1% 2 22.2% 22 28.4 18.6
PERIODICAL 502 8.1% 72 14.3% 4 78.0 675.9
EXACT PE 98 1.6% 9 9.2% 3 7.8 10.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 273 4.4% 75 27.5% 41 819.6 2319.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 630 11.4% 192 30.5% 6 60.0 306.8
Single 4,920 88.6% 985 20.0% 31 920.9 5202.7
DISPLAY commands, by type, excluding automatic displays:
REVIEW 5.0%
SHORT 70.8%
LONG 4.4%
FIELDS 1.4%
PERIODICALS 16.0%
COMMENTS 0.0%
Other 2.4%
2.1 CCT Database Statistics
____________________________
Median session length (minutes:seconds) 0:00
Average session length (minutes:seconds) 0:00
Longest session recorded (minutes:seconds) 54:15
Average number of searches completed per session 1.3
Retrievals per search - median 45.5
Retrievals per search - average 200.0
Retrievals per search - standard deviation 299.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 68 20.1%
DISPLAY (excluding automatic displays) 111 32.8%
HELP 23 6.8%
EXPLAIN 15 4.4%
SET/RESET 35 10.4%
SHOW 17 5.0%
ADD ON (AND, OR, AND NOT) 4 1.2%
LOGON or LOGOFF 55 16.3%
COMMENT 0 0.0%
SAVE 0 0.0%
USE 0 0.0%
OTHER 10 3.0%
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 45 63.4% 15 33.3% 200 334.7 360.8
EXACT JOURNAL 19 26.8% 4 21.1% 148 251.1 248.2
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 3 4.2% 0 0.0% 3 3.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 4 5.6% 0 0.0% 8 8.3 8.0
By number of indexes:
Multiple 3 4.4% 0 0.0% 3 3.0 0.0
Single 65 95.6% 19 29.2% 172 300.7 326.1
DISPLAY commands, by type, excluding automatic displays:
REVIEW 0.8%
ISSUES 61.9%
SHORT 21.2%
LONG 11.9%
PERIODICALS 4.2%
COMMENTS 0.0%
Other 0.0%
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 35.0%
2. NS command - no next screen 25.7%
3. FIND command with invalid index name 9.5%
4. Index invalid in current database 4.2%
5. DISPLAY command contains invalid word 3.1%
6. Search term missing from search command 2.2%
7. PS command - no previous screen 1.7%
8. 1281 1.7%
9. 761 1.5%
10. DISPLAY command - no FIND results 1.4%
11. All others 14.0%
Ten most frequent EXPLAIN requests:
1. CC GUIDE 17.4%
2. LOCATE (ARTICLE DBS) 13.2%
3. CC INDEXES 11.6%
4. FIND (CC DB) 8.3%
5. SUBJECT CATEGORY 7.4%
6. Unrecognized term 6.6%
7. CC DATABASE 4.1%
8. MAIL 3.3%
9. Unrecognized term-reminders off 3.3%
10. COMMANDS 3.3%
11. All others 21.5%
Ten most frequent HELP situations:
1. Help requested from START CC command 21.2%
2. First word of command is invalid 14.9%
3. FIND command with invalid index name 9.4%
4. F/BR with index invalid in current DB 9.4%
5. DISPLAY command - middle of >1 screen 6.3%
6. FIND command with zero results 4.3%
7. DISPLAY command-first of >1 screen 4.3%
8. Help requested from SET DB command 4.3%
9. FIND command retrieves >1 book 3.9%
10. DISPLAY command-complete in one screen 2.0%
11. All others 20.0%
Ten most frequent SHOW requests:
1. HISTORY 30.0%
2. SC LIST (CC DBS) 17.5%
3. SYSTEM NEWS 10.0%
4. UPDATE 7.5%
5. UCSF NEWS 5.0%
6. LIBRARY NEWS 5.0%
7. CCT SETTINGS 5.0%
8. 0210 2.5%
9. GLOSSARY 2.5%
10. SYSTEM1 NEWS 2.5%
11. All others 12.5%
Cmm/yy cc MELVYL CURRENT CONTENTS DATABASE TELNET STATISTICS (monthly)