MELVYL CURRENT CONTENTS DATABASE TELNET STATISTICS
Time period: 04/01/01 through 04/30/01
1.0 SUMMARY STATISTICS
_______________________
1.1 Total sessions:
____________________
Location Library Remote Total
________ _______ ______ _____
Berkeley 475 3,066 3,541
Davis 1,396 115 1,511
Irvine 956 0 956
Los Angeles 21 1,164 1,185
Riverside 153 270 423
San Diego 240 1,123 1,363
San Francisco 694 0 694
Santa Barbara 41 567 608
Santa Cruz 109 392 501
LBL 0 457 457
LLL 0 245 245
Los Alamos n/a 0 0
Other - UC 6 285 291
U.S. Forestry 0
Other-Network UC n/a 2,071 2,071
_______ ______ _____
4,091 9,755 13,846
Per hour usage:
Time Sessions Finds Records Displayed
__________ __________ __________ _________________
12-2 a.m. 241 774 6,293
2-4 a.m. 142 511 6,755
4-6 a.m. 158 725 5,615
6-8 a.m. 340 2,436 26,134
8-10 a.m. 1,497 5,231 48,355
10-12 a.m. 2,461 6,355 54,867
12-2 p.m. 2,381 6,303 64,820
2-4 p.m. 2,724 7,389 65,796
4-6 p.m. 2,054 5,730 61,139
6-8 p.m. 937 2,727 34,029
8-10 p.m. 538 1,496 18,341
10-12 p.m. 373 1,091 11,804
__________ __________ __________ _________________
Total: 13,846 40,768 403,948
1.2 FIND commands
__________________
Number of FIND commands issued by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 1,228 8,087 9,315
Davis 4,368 307 4,675
Irvine 2,985 0 2,985
Los Angeles 49 3,120 3,169
Riverside 292 775 1,067
San Diego 633 3,215 3,848
San Francisco 1,941 0 1,941
Santa Barbara 68 1,852 1,920
Santa Cruz 223 1,073 1,296
LBL 0 1,396 1,396
LLL 0 3,529 3,529
Los Alamos n/a 0 0
Other - UC 11 766 777
U.S. Forestry 0
Other-Network UC n/a 4,850 4,850
_______ ______ _____
11,798 28,970 40,768
Number of FIND commands by database
CC database 39,752
CCT database 1,016
Total number of FIND commands 40,768
1.3 Records displayed
______________________
Number of Records Displayed by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 13,460 85,976 99,436
Davis 45,919 1,791 47,710
Irvine 19,771 0 19,771
Los Angeles 414 27,677 28,091
Riverside 2,298 6,867 9,165
San Diego 4,586 24,839 29,425
San Francisco 19,368 0 19,368
Santa Barbara 1,971 28,899 30,870
Santa Cruz 2,901 10,148 13,049
LBL 0 17,431 17,431
LLL 0 35,574 35,574
Los Alamos n/a 0 0
Other - UC 22 7,587 7,609
U.S. Forestry 0
Other-Network UC n/a 46,449 46,449
_______ ______ _____
110,710 293,238 403,948
Number of Records Displayed by database:
CC database 367,982
CCT database 35,966
Total number of Records Displayed 403,948
1.4 Relative Use of Databases
______________________________
Relative use of CC vs. CCT databases:
Percent of CC sessions 94.6%
Percent of CCT sessions 5.4%
Percent of searches done in the CC database 97.5%
Percent of searches done in the CCT database 2.5%
1.5 Response time
__________________
Search response time from receipt of command at
DLA until transmission of response:
Average in seconds 1.0
Standard deviation in seconds 4.4
Display response time from receipt of command at
DLA until transmission of a complete screen:
Average in seconds 0.1
Standard deviation in seconds 4.4
2.0 CC Database Statistics
___________________________
Median session length (minutes:seconds) 0:00
Average session length (minutes:seconds) 0:00
Longest session recorded (minutes:seconds) 844:55
Average number of searches completed per session 3.0
Retrievals per search - median 9.0
Retrievals per search - average 555.5
Retrievals per search - standard deviation 6319.6
Percent of searches completed with 0 results 25.2%
Percent of searches entered that are long 0.2%
Percent of long searches completed
(includes partial results) 56.8%
Commands entered, by type, excluding errors:
Total Percentage
__________ __________
FIND 37,036 38.2%
DISPLAY (excluding automatic displays) 27,420 28.3%
HELP 973 1.0%
EXPLAIN 1,008 1.0%
SET/RESET 5,193 5.4%
SHOW 176 0.2%
ADD ON (AND, OR, AND NOT) 2,716 2.8%
LOGON or LOGOFF 16,696 17.2%
COMMENT 3 0.0%
SAVE 1,093 1.1%
USE 41 0.0%
OTHER 4,554 4.7%
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 17,435 40.3% 2,687 15.4% 30 236.1 1634.1
TITLE WORD 12,529 29.0% 3,705 29.6% 14 795.9 6185.2
EXACT TITLE 525 1.2% 240 45.7% 3 49.2 314.6
JOURNAL 2,314 5.3% 933 40.3% 247 4751.4 25087.3
EXACT JOURNAL 2,510 5.8% 1,521 60.6% 41 1723.7 6998.0
SUBJECT CAT 166 0.4% 22 13.3% 12 64.2 269.1
SUBFILE 98 0.2% 9 9.2% 40 663.7 2614.2
PUBLICATION TYPE 186 0.4% 34 18.3% 12 5248.9 28055.7
LANGUAGE 43 0.1% 3 7.0% 7 2423.4 6247.6
DATE 621 1.4% 119 19.2% 9 112.9 387.7
ADDED 3,038 7.0% 2,057 67.7% 21 32.8 38.9
PERIODICAL 1,350 3.1% 221 16.4% 4 125.4 1436.1
EXACT PE 315 0.7% 42 13.3% 3 15.4 83.1
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 2,131 4.9% 591 27.7% 21 1251.6 7186.4
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 6,245 16.9% 2,950 47.2% 9 105.7 1088.3
Single 30,660 83.1% 6,246 20.4% 30 868.9 7885.1
DISPLAY commands, by type, excluding automatic displays:
REVIEW 4.0%
SHORT 80.3%
LONG 4.3%
FIELDS 2.6%
PERIODICALS 7.5%
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) 85:33
Average number of searches completed per session 1.4
Retrievals per search - median 55.0
Retrievals per search - average 354.2
Retrievals per search - standard deviation 1738.6
Percent of searches completed with 0 results 26.0%
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 1,011 22.8%
DISPLAY (excluding automatic displays) 1,615 36.4%
HELP 276 6.2%
EXPLAIN 135 3.0%
SET/RESET 470 10.6%
SHOW 60 1.4%
ADD ON (AND, OR, AND NOT) 5 0.1%
LOGON or LOGOFF 713 16.1%
COMMENT 0 0.0%
SAVE 0 0.0%
USE 2 0.0%
OTHER 155 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 651 64.4% 213 32.7% 115 455.7 1994.2
EXACT JOURNAL 270 26.7% 40 14.8% 141 282.0 397.5
SUBJECT CAT 7 0.7% 0 0.0% 16,763 11275.0 7169.5
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 83 8.2% 8 9.6% 2 216.3 1220.9
By number of indexes:
Multiple 0 0.0% 0 0.0% 0 0.0 0.0
Single 1,011 100% 261 25.8% 110 479.5 2009.0
DISPLAY commands, by type, excluding automatic displays:
REVIEW 6.0%
ISSUES 43.0%
SHORT 22.6%
LONG 21.2%
PERIODICALS 6.1%
COMMENTS 0.0%
Other 1.1%
2.3 Error, EXPLAIN and HELP statistics (CC & CCT)
__________________________________________________
Percent of commands that contained errors 8.5%
Ten most frequent errors:
1. NS command - no next screen 31.3%
2. First word of command is invalid 28.6%
3. FIND command with invalid index name 10.0%
4. Index invalid in current database 4.7%
5. DISPLAY command - no FIND results 2.2%
6. DISPLAY command contains invalid word 1.9%
7. Search term missing from search command 1.9%
8. PS command - no previous screen 1.8%
9. Valid command at an inappropriate time 1.7%
10. D ABS command in database w/o abstracts 1.5%
11. All others 14.4%
Ten most frequent EXPLAIN requests:
1. CC GUIDE 17.3%
2. FIND (CC DB) 11.5%
3. LOCATE (ARTICLE DBS) 11.3%
4. CC INDEXES 11.0%
5. COMMANDS 7.3%
6. Unrecognized term 4.5%
7. CC DATABASE 3.8%
8. DATABASES 3.1%
9. CCT INDEXES 2.8%
10. CCT DATABASE 2.8%
11. All others 24.5%
Ten most frequent HELP situations:
1. Help requested from START CC command 16.7%
2. First word of command is invalid 13.0%
3. F/BR with index invalid in current DB 10.8%
4. FIND command with invalid index name 9.3%
5. Help requested from SET DB command 6.0%
6. DISPLAY command - middle of >1 screen 4.8%
7. DISPLAY command-first of >1 screen 4.6%
8. DISPLAY command-complete in one screen 3.6%
9. FIND command with zero results 3.2%
10. FIND command retrieves >1 book 3.0%
11. All others 25.1%
Ten most frequent SHOW requests:
1. HISTORY 49.6%
2. SEARCH 10.3%
3. SYSTEM NEWS 9.5%
4. SC LIST (CC DBS) 3.9%
5. CC NEWS 3.4%
6. MAIL STATUS 3.4%
7. CC GLOSSARY 3.0%
8. GLOSSARY 1.7%
9. LIBRARY NEWS 1.7%
10. CCT SETTINGS 1.7%
11. All others 11.6%
Cmm/yy cc MELVYL CURRENT CONTENTS DATABASE TELNET STATISTICS (monthly)