MELVYL CURRENT CONTENTS DATABASE TELNET STATISTICS
Time period: 10/27/01 through 11/02/01
1.0 SUMMARY STATISTICS
_______________________
1.1 Total sessions:
____________________
Location Library Remote Total
________ _______ ______ _____
Berkeley 75 559 634
Davis 359 18 377
Irvine 167 0 167
Los Angeles 1 190 191
Riverside 18 33 51
San Diego 20 193 213
San Francisco 119 0 119
Santa Barbara 9 118 127
Santa Cruz 16 65 81
LBL 0 110 110
LLL 0 47 47
Los Alamos n/a 1 1
Other - UC 1 40 41
U.S. Forestry 0
Other-Network UC n/a 508 508
_______ ______ _____
785 1,882 2,667
Per hour usage:
Time Sessions Finds Records Displayed
__________ __________ __________ _________________
12-2 a.m. 19 66 426
2-4 a.m. 38 88 7,917
4-6 a.m. 30 93 611
6-8 a.m. 80 289 2,031
8-10 a.m. 336 777 7,860
10-12 a.m. 546 1,360 19,618
12-2 p.m. 456 1,067 13,294
2-4 p.m. 557 1,404 11,890
4-6 p.m. 310 797 14,742
6-8 p.m. 127 274 2,625
8-10 p.m. 77 210 2,517
10-12 p.m. 91 286 2,647
__________ __________ __________ _________________
Total: 2,667 6,711 86,178
1.2 FIND commands
__________________
Number of FIND commands issued by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 173 1,496 1,669
Davis 969 76 1,045
Irvine 385 0 385
Los Angeles 6 492 498
Riverside 46 68 114
San Diego 73 593 666
San Francisco 314 0 314
Santa Barbara 18 360 378
Santa Cruz 27 148 175
LBL 0 224 224
LLL 0 111 111
Los Alamos n/a 0 0
Other - UC 4 52 56
U.S. Forestry 0
Other-Network UC n/a 1,076 1,076
_______ ______ _____
2,015 4,696 6,711
Number of FIND commands by database
CC database 6,582
CCT database 129
Total number of FIND commands 6,711
1.3 Records displayed
______________________
Number of Records Displayed by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 2,256 22,979 25,235
Davis 14,320 1,118 15,438
Irvine 10,433 0 10,433
Los Angeles 46 3,466 3,512
Riverside 940 804 1,744
San Diego 319 5,511 5,830
San Francisco 2,697 0 2,697
Santa Barbara 110 3,870 3,980
Santa Cruz 228 2,051 2,279
LBL 0 1,817 1,817
LLL 0 703 703
Los Alamos n/a 0 0
Other - UC 4 718 722
U.S. Forestry 0
Other-Network UC n/a 11,788 11,788
_______ ______ _____
31,353 54,825 86,178
Number of Records Displayed by database:
CC database 79,248
CCT database 6,930
Total number of Records Displayed 86,178
1.4 Relative Use of Databases
______________________________
Relative use of CC vs. CCT databases:
Percent of CC sessions 96.3%
Percent of CCT sessions 3.7%
Percent of searches done in the CC database 98.1%
Percent of searches done in the CCT database 1.9%
1.5 Response time
__________________
Search response time from receipt of command at
DLA until transmission of response:
Average in seconds 1.3
Standard deviation in seconds 4.8
Display response time from receipt of command at
DLA until transmission of a complete screen:
Average in seconds 0.2
Standard deviation in seconds 4.8
2.0 CC Database Statistics
___________________________
Median session length (minutes:seconds) 0:00
Average session length (minutes:seconds) 0:00
Longest session recorded (minutes:seconds) 383:57
Average number of searches completed per session 2.6
Retrievals per search - median 9.0
Retrievals per search - average 527.0
Retrievals per search - standard deviation 4379.1
Percent of searches completed with 0 results 21.7%
Percent of searches entered that are long 0.4%
Percent of long searches completed
(includes partial results) 67.9%
Commands entered, by type, excluding errors:
Total Percentage
__________ __________
FIND 6,059 35.5%
DISPLAY (excluding automatic displays) 4,999 29.3%
HELP 148 0.9%
EXPLAIN 198 1.2%
SET/RESET 1,130 6.6%
SHOW 49 0.3%
ADD ON (AND, OR, AND NOT) 523 3.1%
LOGON or LOGOFF 3,029 17.8%
COMMENT 0 0.0%
SAVE 138 0.8%
USE 1 0.0%
OTHER 771 4.5%
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,920 44.3% 413 14.1% 29 197.0 1135.0
TITLE WORD 2,112 32.0% 632 29.9% 17 1225.1 6858.9
EXACT TITLE 95 1.4% 40 42.1% 4 116.4 451.9
JOURNAL 262 4.0% 106 40.5% 210 3516.4 14794.6
EXACT JOURNAL 134 2.0% 47 35.1% 611 4267.7 10751.8
SUBJECT CAT 10 0.2% 1 10.0% 14 34.4 65.7
SUBFILE 10 0.2% 0 0.0% 54 126.8 128.5
PUBLICATION TYPE 27 0.4% 3 11.1% 13 2645.4 11841.0
LANGUAGE 11 0.2% 1 9.1% 37 401.9 1147.1
DATE 127 1.9% 18 14.2% 14 165.2 458.5
ADDED 19 0.3% 1 5.3% 25 26.9 20.6
PERIODICAL 445 6.8% 63 14.2% 4 124.2 1105.4
EXACT PE 118 1.8% 12 10.2% 4 72.8 257.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 300 4.6% 90 30.0% 22 447.1 2191.8
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 534 8.9% 160 30.0% 6 83.5 342.2
Single 5,495 91.1% 1,103 20.1% 26 774.9 5329.8
DISPLAY commands, by type, excluding automatic displays:
REVIEW 5.1%
SHORT 71.8%
LONG 6.1%
FIELDS 2.5%
PERIODICALS 12.7%
COMMENTS 0.0%
Other 1.9%
2.1 CCT Database Statistics
____________________________
Median session length (minutes:seconds) 0:00
Average session length (minutes:seconds) 0:00
Longest session recorded (minutes:seconds) 33:14
Average number of searches completed per session 1.3
Retrievals per search - median 49.0
Retrievals per search - average 318.2
Retrievals per search - standard deviation 1400.9
Percent of searches completed with 0 results 19.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 126 22.3%
DISPLAY (excluding automatic displays) 193 34.1%
HELP 40 7.1%
EXPLAIN 16 2.8%
SET/RESET 78 13.8%
SHOW 9 1.6%
ADD ON (AND, OR, AND NOT) 3 0.5%
LOGON or LOGOFF 81 14.3%
COMMENT 0 0.0%
SAVE 0 0.0%
USE 0 0.0%
OTHER 20 3.5%
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 72 56.3% 20 27.8% 144 600.8 2066.7
EXACT JOURNAL 31 24.2% 5 16.1% 85 126.8 133.8
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 2 1.6% 0 0.0% 27 26.5 36.1
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 23 18.0% 0 0.0% 3 240.8 1067.9
By number of indexes:
Multiple 2 1.6% 0 0.0% 27 26.5 36.1
Single 124 98.4% 25 20.2% 74 404.3 1589.9
DISPLAY commands, by type, excluding automatic displays:
REVIEW 5.2%
ISSUES 52.9%
SHORT 14.8%
LONG 14.8%
PERIODICALS 11.4%
COMMENTS 0.0%
Other 1.0%
2.3 Error, EXPLAIN and HELP statistics (CC & CCT)
__________________________________________________
Percent of commands that contained errors 8.2%
Ten most frequent errors:
1. NS command - no next screen 29.9%
2. First word of command is invalid 28.5%
3. FIND command with invalid index name 10.1%
4. Index invalid in current database 5.0%
5. DISPLAY command contains invalid word 3.0%
6. Valid command at an inappropriate time 2.0%
7. PS command - no previous screen 1.9%
8. D ABS command in database w/o abstracts 1.5%
9. Search term missing from search command 1.4%
10. DISPLAY command - no FIND results 1.3%
11. All others 15.4%
Ten most frequent EXPLAIN requests:
1. CC GUIDE 18.7%
2. LOCATE (ARTICLE DBS) 16.4%
3. FIND (CC DB) 8.9%
4. Unrecognized term 6.5%
5. COMMANDS 6.1%
6. CC INDEXES 5.1%
7. DISPLAY 2.8%
8. ADD-ON SEARCH 2.8%
9. MAIL 2.3%
10. DOWNLOADING 2.3%
11. All others 28.0%
Ten most frequent HELP situations:
1. Help requested from START CC command 16.7%
2. First word of command is invalid 16.4%
3. FIND command with invalid index name 7.2%
4. DISPLAY command-complete in one screen 6.7%
5. F/BR with index invalid in current DB 6.2%
6. DISPLAY command - middle of >1 screen 6.0%
7. Help requested from SET DB command 5.7%
8. FIND command with zero results 4.0%
9. DISPLAY command - last of >1 screen 3.5%
10. FIND command retrieves >1 book 3.0%
11. All others 24.6%
Ten most frequent SHOW requests:
1. HISTORY 35.7%
2. SEARCH 17.9%
3. TIME 10.7%
4. SYSTEM NEWS 8.9%
5. CC SETTINGS 7.1%
6. CC GLOSSARY 5.4%
7. GLOSSARY 3.6%
8. BIBLIOGRAPHIC SOFTWARE 1.8%
9. LIBRARY NEWS 1.8%
10. EXPERIMENTS 1.8%
11. All others 5.4%
Cmm/yy cc MELVYL CURRENT CONTENTS DATABASE TELNET STATISTICS (monthly)