MELVYL CURRENT CONTENTS DATABASE TELNET STATISTICS
Time period: 02/01/02 through 02/28/02
1.0 SUMMARY STATISTICS
_______________________
1.1 Total sessions:
____________________
Location Library Remote Total
________ _______ ______ _____
Berkeley 243 2,098 2,341
Davis 1,000 71 1,071
Irvine 451 0 451
Los Angeles 6 639 645
Riverside 58 172 230
San Diego 149 668 817
San Francisco 523 0 523
Santa Barbara 21 294 315
Santa Cruz 23 163 186
LBL 0 375 375
LLL 0 142 142
Los Alamos n/a 0 0
Other - UC 4 155 159
U.S. Forestry 0
Other-Network UC n/a 2,033 2,033
_______ ______ _____
2,478 6,810 9,288
Per hour usage:
Time Sessions Finds Records Displayed
__________ __________ __________ _________________
12-2 a.m. 218 603 4,727
2-4 a.m. 137 384 33,136
4-6 a.m. 107 341 2,923
6-8 a.m. 319 888 5,799
8-10 a.m. 1,071 2,803 23,837
10-12 a.m. 1,862 5,825 40,640
12-2 p.m. 1,561 4,769 50,407
2-4 p.m. 1,776 5,603 53,271
4-6 p.m. 1,077 3,023 30,299
6-8 p.m. 505 1,464 12,349
8-10 p.m. 349 1,190 8,738
10-12 p.m. 306 893 7,003
__________ __________ __________ _________________
Total: 9,288 27,786 273,129
1.2 FIND commands
__________________
Number of FIND commands issued by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 477 7,089 7,566
Davis 2,874 176 3,050
Irvine 1,391 0 1,391
Los Angeles 16 1,881 1,897
Riverside 148 521 669
San Diego 334 1,795 2,129
San Francisco 2,604 0 2,604
Santa Barbara 61 805 866
Santa Cruz 41 462 503
LBL 0 817 817
LLL 0 465 465
Los Alamos n/a 0 0
Other - UC 8 599 607
U.S. Forestry 0
Other-Network UC n/a 5,222 5,222
_______ ______ _____
7,954 19,832 27,786
Number of FIND commands by database
CC database 27,282
CCT database 504
Total number of FIND commands 27,786
1.3 Records displayed
______________________
Number of Records Displayed by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 3,813 64,678 68,491
Davis 38,171 1,176 39,347
Irvine 41,654 0 41,654
Los Angeles 73 14,507 14,580
Riverside 1,712 7,103 8,815
San Diego 3,720 14,447 18,167
San Francisco 13,365 0 13,365
Santa Barbara 324 10,257 10,581
Santa Cruz 494 4,687 5,181
LBL 0 8,997 8,997
LLL 0 4,232 4,232
Los Alamos n/a 0 0
Other - UC 19 5,252 5,271
U.S. Forestry 0
Other-Network UC n/a 34,448 34,448
_______ ______ _____
103,345 169,784 273,129
Number of Records Displayed by database:
CC database 257,450
CCT database 15,679
Total number of Records Displayed 273,129
1.4 Relative Use of Databases
______________________________
Relative use of CC vs. CCT databases:
Percent of CC sessions 96.6%
Percent of CCT sessions 3.4%
Percent of searches done in the CC database 98.2%
Percent of searches done in the CCT database 1.8%
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.7
Display response time from receipt of command at
DLA until transmission of a complete screen:
Average in seconds 0.2
Standard deviation in seconds 3.7
2.0 CC Database Statistics
___________________________
Median session length (minutes:seconds) 0:00
Average session length (minutes:seconds) 0:00
Longest session recorded (minutes:seconds) 392:42
Average number of searches completed per session 3.0
Retrievals per search - median 9.0
Retrievals per search - average 568.5
Retrievals per search - standard deviation 5772.2
Percent of searches completed with 0 results 22.0%
Percent of searches entered that are long 0.5%
Percent of long searches completed
(includes partial results) 79.2%
Commands entered, by type, excluding errors:
Total Percentage
__________ __________
FIND 24,377 36.0%
DISPLAY (excluding automatic displays) 20,834 30.7%
HELP 491 0.7%
EXPLAIN 517 0.8%
SET/RESET 3,661 5.4%
SHOW 76 0.1%
ADD ON (AND, OR, AND NOT) 2,905 4.3%
LOGON or LOGOFF 11,104 16.4%
COMMENT 0 0.0%
SAVE 1,022 1.5%
USE 8 0.0%
OTHER 2,797 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 11,098 41.7% 1,697 15.3% 30 195.8 998.6
TITLE WORD 8,577 32.2% 2,550 29.7% 12 799.3 9793.4
EXACT TITLE 343 1.3% 159 46.4% 3 164.7 1441.9
JOURNAL 1,414 5.3% 432 30.6% 1,130 5062.6 11529.2
EXACT JOURNAL 687 2.6% 203 29.5% 1,578 4739.1 9487.8
SUBJECT CAT 99 0.4% 6 6.1% 21 71.8 174.1
SUBFILE 31 0.1% 4 12.9% 49 201.1 609.8
PUBLICATION TYPE 75 0.3% 21 28.0% 23 5956.6 35632.8
LANGUAGE 68 0.3% 5 7.4% 4 76.9 292.0
DATE 627 2.4% 122 19.5% 7 96.2 419.4
ADDED 94 0.4% 17 18.1% 9 16.0 21.8
PERIODICAL 1,975 7.4% 250 12.7% 5 61.6 692.5
EXACT PE 361 1.4% 25 6.9% 3 18.5 69.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,174 4.4% 398 33.9% 17 896.8 7104.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 2,173 8.9% 637 29.3% 5 53.3 273.3
Single 22,121 91.1% 4,579 20.7% 27 854.1 7157.8
DISPLAY commands, by type, excluding automatic displays:
REVIEW 4.8%
SHORT 69.9%
LONG 7.8%
FIELDS 1.4%
PERIODICALS 14.6%
COMMENTS 0.0%
Other 1.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) 91:36
Average number of searches completed per session 1.6
Retrievals per search - median 72.0
Retrievals per search - average 283.3
Retrievals per search - standard deviation 913.3
Percent of searches completed with 0 results 27.4%
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 502 22.7%
DISPLAY (excluding automatic displays) 834 37.7%
HELP 168 7.6%
EXPLAIN 73 3.3%
SET/RESET 223 10.1%
SHOW 30 1.4%
ADD ON (AND, OR, AND NOT) 2 0.1%
LOGON or LOGOFF 294 13.3%
COMMENT 0 0.0%
SAVE 4 0.2%
USE 0 0.0%
OTHER 84 3.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:
JOURNAL 310 61.4% 105 33.9% 128 369.7 981.1
EXACT JOURNAL 166 32.9% 32 19.3% 132 244.0 388.2
SUBJECT CAT 9 1.8% 0 0.0% 3,771 3783.2 3138.7
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 3 0.6% 0 0.0% 148 194.7 140.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 17 3.4% 1 5.9% 4 15.2 31.3
By number of indexes:
Multiple 3 0.6% 0 0.0% 148 194.7 140.0
Single 499 99.4% 138 27.7% 125 393.9 1059.2
DISPLAY commands, by type, excluding automatic displays:
REVIEW 6.4%
ISSUES 45.9%
SHORT 25.7%
LONG 16.3%
PERIODICALS 4.5%
COMMENTS 0.0%
Other 1.2%
2.3 Error, EXPLAIN and HELP statistics (CC & CCT)
__________________________________________________
Percent of commands that contained errors 7.1%
Ten most frequent errors:
1. NS command - no next screen 33.1%
2. First word of command is invalid 27.5%
3. FIND command with invalid index name 10.2%
4. Index invalid in current database 4.2%
5. DISPLAY command contains invalid word 2.5%
6. Search term missing from search command 2.2%
7. PS command - no previous screen 1.9%
8. DISPLAY command - no FIND results 1.8%
9. Valid command at an inappropriate time 1.3%
10. Add-on search, no index name after verb 1.3%
11. All others 14.0%
Ten most frequent EXPLAIN requests:
1. CC GUIDE 16.6%
2. FIND (CC DB) 11.7%
3. LOCATE (ARTICLE DBS) 10.8%
4. CC INDEXES 8.0%
5. COMMANDS 5.6%
6. Unrecognized term 4.6%
7. DATABASES 3.7%
8. DISPLAY 2.9%
9. MAIL 2.7%
10. CC DATABASE 2.7%
11. All others 30.7%
Ten most frequent HELP situations:
1. Help requested from START CC command 16.2%
2. First word of command is invalid 12.7%
3. F/BR with index invalid in current DB 9.1%
4. FIND command with invalid index name 8.2%
5. Help requested from SET DB command 7.4%
6. DISPLAY command-first of >1 screen 5.0%
7. FIND command with zero results 4.0%
8. DISPLAY command - middle of >1 screen 3.8%
9. DISPLAY command-complete in one screen 3.4%
10. FIND command retrieves >1 book 2.6%
11. All others 27.6%
Ten most frequent SHOW requests:
1. HISTORY 33.3%
2. SYSTEM NEWS 12.7%
3. SEARCH 10.8%
4. CC NEWS 9.8%
5. MAIL STATUS 7.8%
6. TIME 5.9%
7. SYSTEM1 NEWS 3.9%
8. SC LIST (CC DBS) 3.9%
9. CC SETTINGS 2.9%
10. CC GLOSSARY 2.9%
11. All others 5.9%
Cmm/yy cc MELVYL CURRENT CONTENTS DATABASE TELNET STATISTICS (monthly)