MELVYL CURRENT CONTENTS DATABASE TELNET STATISTICS
Time period: 03/01/02 through 03/31/02
1.0 SUMMARY STATISTICS
_______________________
1.1 Total sessions:
____________________
Location Library Remote Total
________ _______ ______ _____
Berkeley 226 2,176 2,402
Davis 944 45 989
Irvine 519 0 519
Los Angeles 7 741 748
Riverside 39 178 217
San Diego 175 586 761
San Francisco 556 0 556
Santa Barbara 21 311 332
Santa Cruz 42 137 179
LBL 0 371 371
LLL 0 175 175
Los Alamos n/a 0 0
Other - UC 3 183 186
U.S. Forestry 0
Other-Network UC n/a 1,684 1,684
_______ ______ _____
2,532 6,587 9,119
Per hour usage:
Time Sessions Finds Records Displayed
__________ __________ __________ _________________
12-2 a.m. 124 350 2,352
2-4 a.m. 106 333 32,348
4-6 a.m. 89 255 2,629
6-8 a.m. 222 500 3,644
8-10 a.m. 1,083 2,864 25,372
10-12 a.m. 1,830 5,508 64,202
12-2 p.m. 1,580 4,518 48,203
2-4 p.m. 1,783 5,012 58,372
4-6 p.m. 1,247 3,701 43,890
6-8 p.m. 504 1,653 26,861
8-10 p.m. 326 1,207 10,918
10-12 p.m. 225 697 6,786
__________ __________ __________ _________________
Total: 9,119 26,598 325,577
1.2 FIND commands
__________________
Number of FIND commands issued by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 540 6,259 6,799
Davis 2,677 95 2,772
Irvine 1,402 0 1,402
Los Angeles 25 2,559 2,584
Riverside 96 652 748
San Diego 425 1,793 2,218
San Francisco 2,636 0 2,636
Santa Barbara 38 970 1,008
Santa Cruz 62 318 380
LBL 0 1,113 1,113
LLL 0 528 528
Los Alamos n/a 0 0
Other - UC 4 474 478
U.S. Forestry 0
Other-Network UC n/a 3,932 3,932
_______ ______ _____
7,905 18,693 26,598
Number of FIND commands by database
CC database 26,006
CCT database 592
Total number of FIND commands 26,598
1.3 Records displayed
______________________
Number of Records Displayed by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 4,584 63,475 68,059
Davis 21,624 680 22,304
Irvine 41,937 0 41,937
Los Angeles 390 22,247 22,637
Riverside 690 7,648 8,338
San Diego 4,679 15,577 20,256
San Francisco 67,508 0 67,508
Santa Barbara 285 10,602 10,887
Santa Cruz 1,834 3,652 5,486
LBL 0 17,715 17,715
LLL 0 4,444 4,444
Los Alamos n/a 0 0
Other - UC 0 4,154 4,154
U.S. Forestry 0
Other-Network UC n/a 31,852 31,852
_______ ______ _____
143,531 182,046 325,577
Number of Records Displayed by database:
CC database 250,332
CCT database 75,245
Total number of Records Displayed 325,577
1.4 Relative Use of Databases
______________________________
Relative use of CC vs. CCT databases:
Percent of CC sessions 95.9%
Percent of CCT sessions 4.1%
Percent of searches done in the CC database 97.8%
Percent of searches done in the CCT database 2.2%
1.5 Response time
__________________
Search response time from receipt of command at
DLA until transmission of response:
Average in seconds 0.7
Standard deviation in seconds 2.7
Display response time from receipt of command at
DLA until transmission of a complete screen:
Average in seconds 0.1
Standard deviation in seconds 2.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) 592:51
Average number of searches completed per session 3.0
Retrievals per search - median 9.0
Retrievals per search - average 578.6
Retrievals per search - standard deviation 4248.2
Percent of searches completed with 0 results 21.9%
Percent of searches entered that are long 0.5%
Percent of long searches completed
(includes partial results) 63.6%
Commands entered, by type, excluding errors:
Total Percentage
__________ __________
FIND 23,569 36.4%
DISPLAY (excluding automatic displays) 19,476 30.0%
HELP 542 0.8%
EXPLAIN 576 0.9%
SET/RESET 3,485 5.4%
SHOW 65 0.1%
ADD ON (AND, OR, AND NOT) 2,437 3.8%
LOGON or LOGOFF 10,991 17.0%
COMMENT 0 0.0%
SAVE 961 1.5%
USE 10 0.0%
OTHER 2,711 4.2%
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 10,687 41.6% 1,582 14.8% 31 234.3 1413.4
TITLE WORD 8,362 32.5% 2,579 30.8% 13 857.9 6687.2
EXACT TITLE 300 1.2% 154 51.3% 2 101.8 740.1
JOURNAL 1,470 5.7% 447 30.4% 1,465 4863.5 9623.9
EXACT JOURNAL 537 2.1% 153 28.5% 1,998 4668.7 9214.7
SUBJECT CAT 96 0.4% 17 17.7% 23 132.2 385.1
SUBFILE 90 0.4% 22 24.4% 15 73.1 123.8
PUBLICATION TYPE 73 0.3% 7 9.6% 9 1898.3 10400.7
LANGUAGE 66 0.3% 5 7.6% 7 25.0 61.7
DATE 520 2.0% 98 18.8% 8 81.8 301.3
ADDED 48 0.2% 6 12.5% 10 14.1 17.6
PERIODICAL 1,745 6.8% 218 12.5% 4 95.6 1532.1
EXACT PE 408 1.6% 29 7.1% 3 14.9 73.7
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,288 5.0% 360 27.9% 24 610.4 3009.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 2,079 8.9% 621 29.9% 6 50.5 229.5
Single 21,412 91.1% 4,406 20.6% 30 859.9 5134.3
DISPLAY commands, by type, excluding automatic displays:
REVIEW 4.2%
SHORT 73.5%
LONG 5.4%
FIELDS 1.2%
PERIODICALS 14.0%
COMMENTS 0.0%
Other 1.7%
2.1 CCT Database Statistics
____________________________
Median session length (minutes:seconds) 0:00
Average session length (minutes:seconds) 0:00
Longest session recorded (minutes:seconds) 117:41
Average number of searches completed per session 1.6
Retrievals per search - median 62.0
Retrievals per search - average 540.7
Retrievals per search - standard deviation 1573.5
Percent of searches completed with 0 results 23.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 547 18.0%
DISPLAY (excluding automatic displays) 944 31.0%
HELP 152 5.0%
EXPLAIN 107 3.5%
SET/RESET 249 8.2%
SHOW 39 1.3%
ADD ON (AND, OR, AND NOT) 45 1.5%
LOGON or LOGOFF 386 12.7%
COMMENT 0 0.0%
SAVE 482 15.8%
USE 0 0.0%
OTHER 93 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 346 63.3% 118 34.1% 116 442.9 1478.2
EXACT JOURNAL 139 25.4% 21 15.1% 100 177.6 321.8
SUBJECT CAT 15 2.7% 0 0.0% 8,275 6932.0 2278.2
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 47 8.6% 1 2.1% 5 9.0 14.9
By number of indexes:
Multiple 0 0.0% 0 0.0% 0 0.0 0.0
Single 547 100% 140 25.6% 99 556.1 1736.5
DISPLAY commands, by type, excluding automatic displays:
REVIEW 4.7%
ISSUES 63.2%
SHORT 10.8%
LONG 13.6%
PERIODICALS 4.9%
COMMENTS 0.0%
Other 2.8%
2.3 Error, EXPLAIN and HELP statistics (CC & CCT)
__________________________________________________
Percent of commands that contained errors 7.3%
Ten most frequent errors:
1. NS command - no next screen 31.0%
2. First word of command is invalid 28.4%
3. FIND command with invalid index name 10.8%
4. Index invalid in current database 4.3%
5. DISPLAY command contains invalid word 2.4%
6. Search term missing from search command 2.0%
7. PS command - no previous screen 2.0%
8. Valid command at an inappropriate time 1.7%
9. DISPLAY command - no FIND results 1.5%
10. D ABS command in database w/o abstracts 1.3%
11. All others 14.5%
Ten most frequent EXPLAIN requests:
1. CC GUIDE 14.6%
2. FIND (CC DB) 13.0%
3. CC INDEXES 11.3%
4. COMMANDS 7.5%
5. LOCATE (ARTICLE DBS) 7.3%
6. CC DATABASE 5.1%
7. DATABASES 4.2%
8. CCT INDEXES 3.5%
9. Unrecognized term 3.1%
10. CCT DATABASE 3.1%
11. All others 27.2%
Ten most frequent HELP situations:
1. Help requested from START CC command 18.7%
2. First word of command is invalid 13.1%
3. FIND command with invalid index name 9.2%
4. F/BR with index invalid in current DB 8.3%
5. Help requested from SET DB command 6.8%
6. DISPLAY command - middle of >1 screen 4.9%
7. FIND command with zero results 4.3%
8. FIND command retrieves >1 book 3.6%
9. DISPLAY command-first of >1 screen 3.1%
10. DISPLAY command-complete in one screen 2.4%
11. All others 25.7%
Ten most frequent SHOW requests:
1. HISTORY 42.4%
2. SYSTEM NEWS 17.2%
3. SC LIST (CC DBS) 9.1%
4. SEARCH 8.1%
5. CC NEWS 6.1%
6. MAIL STATUS 3.0%
7. GLOSSARY 2.0%
8. CC SETTINGS 2.0%
9. CC GLOSSARY 2.0%
10. Invalid term 1.0%
11. All others 7.1%
Cmm/yy cc MELVYL CURRENT CONTENTS DATABASE TELNET STATISTICS (monthly)