MELVYL CURRENT CONTENTS DATABASE TELNET STATISTICS
Time period: 09/01/00 through 09/30/00
1.0 SUMMARY STATISTICS
_______________________
1.1 Total sessions:
____________________
Location Library Remote Total
________ _______ ______ _____
Berkeley 444 3,127 3,571
Davis 1,570 161 1,731
Irvine 937 0 937
Los Angeles 322 1,098 1,420
Riverside 114 275 389
San Diego 200 1,120 1,320
San Francisco 1,253 0 1,253
Santa Barbara 116 667 783
Santa Cruz 125 419 544
LBL 0 551 551
LLL 0 280 280
Los Alamos n/a 0 0
Other - UC 1 186 187
U.S. Forestry 0
Other-Network UC n/a 1,459 1,459
_______ ______ _____
5,082 9,343 14,425
Per hour usage:
Time Sessions Finds Records Displayed
__________ __________ __________ _________________
12-2 a.m. 263 1,027 9,095
2-4 a.m. 155 623 4,967
4-6 a.m. 170 512 4,506
6-8 a.m. 371 1,692 18,131
8-10 a.m. 1,544 4,695 17,175
10-12 a.m. 2,574 7,040 70,670
12-2 p.m. 2,536 6,614 64,718
2-4 p.m. 2,956 8,011 104,818
4-6 p.m. 2,213 5,951 81,544
6-8 p.m. 827 2,329 20,788
8-10 p.m. 491 1,643 14,004
10-12 p.m. 325 1,347 10,943
__________ __________ __________ _________________
Total: 14,425 41,484 421,359
1.2 FIND commands
__________________
Number of FIND commands issued by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 983 8,401 9,384
Davis 4,782 429 5,211
Irvine 3,005 0 3,005
Los Angeles 782 3,019 3,801
Riverside 262 1,019 1,281
San Diego 589 3,036 3,625
San Francisco 2,963 0 2,963
Santa Barbara 320 1,937 2,257
Santa Cruz 363 1,193 1,556
LBL 0 1,566 1,566
LLL 0 2,623 2,623
Los Alamos n/a 0 0
Other - UC 3 459 462
U.S. Forestry 0
Other-Network UC n/a 3,750 3,750
_______ ______ _____
14,052 27,432 41,484
Number of FIND commands by database
CC database 40,609
CCT database 875
Total number of FIND commands 41,484
1.3 Records displayed
______________________
Number of Records Displayed by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 10,427 92,898 103,325
Davis 90,479 2,659 93,138
Irvine 21,806 0 21,806
Los Angeles 4,893 33,549 38,442
Riverside 2,664 10,286 12,950
San Diego 4,285 26,838 31,123
San Francisco -5,602 0 -5,602
Santa Barbara 2,390 20,838 23,228
Santa Cruz 2,644 11,392 14,036
LBL 0 21,275 21,275
LLL 0 30,345 30,345
Los Alamos n/a 0 0
Other - UC 3 7,574 7,577
U.S. Forestry 0
Other-Network UC n/a 29,716 29,716
_______ ______ _____
133,989 287,370 421,359
Number of Records Displayed by database:
CC database 390,032
CCT database 31,327
Total number of Records Displayed 421,359
1.4 Relative Use of Databases
______________________________
Relative use of CC vs. CCT databases:
Percent of CC sessions 95.7%
Percent of CCT sessions 4.3%
Percent of searches done in the CC database 97.9%
Percent of searches done in the CCT database 2.1%
1.5 Response time
__________________
Search response time from receipt of command at
DLA until transmission of response:
Average in seconds 0.8
Standard deviation in seconds 3.6
Display response time from receipt of command at
DLA until transmission of a complete screen:
Average in seconds 0.1
Standard deviation in seconds 3.6
2.0 CC Database Statistics
___________________________
Median session length (minutes:seconds) 0:00
Average session length (minutes:seconds) 0:00
Longest session recorded (minutes:seconds) 1209
Average number of searches completed per session 2.9
Retrievals per search - median 11.0
Retrievals per search - average 506.0
Retrievals per search - standard deviation 5679.9
Percent of searches completed with 0 results 23.7%
Percent of searches entered that are long 0.3%
Percent of long searches completed
(includes partial results) 49.3%
Commands entered, by type, excluding errors:
Total Percentage
__________ __________
FIND 37,584 37.2%
DISPLAY (excluding automatic displays) 28,775 28.5%
HELP 1,003 1.0%
EXPLAIN 946 0.9%
SET/RESET 5,235 5.2%
SHOW 139 0.1%
ADD ON (AND, OR, AND NOT) 3,025 3.0%
LOGON or LOGOFF 17,883 17.7%
COMMENT 0 0.0%
SAVE 1,452 1.4%
USE 33 0.0%
OTHER 4,965 4.9%
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 19,149 45.3% 2,653 13.9% 32 201.2 1056.9
TITLE WORD 12,573 29.7% 3,610 28.7% 16 988.8 8830.6
EXACT TITLE 246 0.6% 113 45.9% 4 545.3 3858.1
JOURNAL 1,825 4.3% 796 43.6% 391 4032.1 17743.3
EXACT JOURNAL 1,942 4.6% 1,209 62.3% 40 1631.4 9729.2
SUBJECT CAT 214 0.5% 28 13.1% 17 56.9 147.5
SUBFILE 98 0.2% 4 4.1% 52 352.4 1159.8
PUBLICATION TYPE 204 0.5% 25 12.3% 18 1304.6 7488.7
LANGUAGE 41 0.1% 5 12.2% 38 420.4 1344.1
DATE 496 1.2% 80 16.1% 9 142.7 723.6
ADDED 1,934 4.6% 1,354 70.0% 25 80.7 956.8
PERIODICAL 1,230 2.9% 273 22.2% 6 155.4 1192.0
EXACT PE 287 0.7% 46 16.0% 3 66.2 495.3
RPE 11 0.0% 8 72.7% 735 613.7 514.8
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,062 4.9% 613 29.7% 22 1289.4 8304.1
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 4,758 12.7% 2,183 45.9% 11 87.6 664.9
Single 32,690 87.3% 6,425 19.7% 32 745.2 6866.6
DISPLAY commands, by type, excluding automatic displays:
REVIEW 4.2%
SHORT 81.6%
LONG 4.5%
FIELDS 1.4%
PERIODICALS 6.6%
COMMENTS 0.0%
Other 1.8%
2.1 CCT Database Statistics
____________________________
Median session length (minutes:seconds) 0:00
Average session length (minutes:seconds) 0:00
Longest session recorded (minutes:seconds) 121:53
Average number of searches completed per session 1.4
Retrievals per search - median 52.0
Retrievals per search - average 372.4
Retrievals per search - standard deviation 1938.9
Percent of searches completed with 0 results 28.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 871 23.3%
DISPLAY (excluding automatic displays) 1,358 36.3%
HELP 239 6.4%
EXPLAIN 120 3.2%
SET/RESET 423 11.3%
SHOW 35 0.9%
ADD ON (AND, OR, AND NOT) 4 0.1%
LOGON or LOGOFF 538 14.4%
COMMENT 0 0.0%
SAVE 3 0.1%
USE 4 0.1%
OTHER 148 4.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 527 60.5% 192 36.4% 99 664.3 2958.2
EXACT JOURNAL 295 33.9% 51 17.3% 135 262.0 390.2
SUBJECT CAT 4 0.5% 0 0.0% 8,218 7634.0 3239.3
SUBFILE 0 0.0% 0 0.0% 0 0.0 0.0
DATE 1 0.1% 0 0.0% 3,565 3565.0 0.0
ADDED 1 0.1% 0 0.0% 1,245 1245.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 43 4.9% 7 16.3% 5 110.7 299.2
By number of indexes:
Multiple 0 0.0% 0 0.0% 0 0.0 0.0
Single 871 100% 250 28.7% 111 524.7 2284.6
DISPLAY commands, by type, excluding automatic displays:
REVIEW 6.2%
ISSUES 48.6%
SHORT 15.6%
LONG 22.3%
PERIODICALS 6.1%
COMMENTS 0.0%
Other 1.2%
2.3 Error, EXPLAIN and HELP statistics (CC & CCT)
__________________________________________________
Percent of commands that contained errors 8.3%
Ten most frequent errors:
1. NS command - no next screen 31.5%
2. First word of command is invalid 30.3%
3. FIND command with invalid index name 10.3%
4. Index invalid in current database 4.6%
5. DISPLAY command contains invalid word 2.1%
6. PS command - no previous screen 2.1%
7. D ABS command in database w/o abstracts 1.9%
8. Search term missing from search command 1.8%
9. Valid command at an inappropriate time 1.3%
10. DISPLAY command - no FIND results 1.1%
11. All others 13.0%
Ten most frequent EXPLAIN requests:
1. CC GUIDE 14.7%
2. FIND (CC DB) 12.3%
3. CC INDEXES 9.3%
4. LOCATE (ARTICLE DBS) 8.8%
5. COMMANDS 6.4%
6. DATABASES 4.8%
7. Unrecognized term 4.0%
8. CC DATABASE 3.7%
9. CCT DATABASE 2.6%
10. FIND (CCT DB) 2.3%
11. All others 31.1%
Ten most frequent HELP situations:
1. Help requested from START CC command 15.2%
2. First word of command is invalid 13.7%
3. F/BR with index invalid in current DB 9.6%
4. FIND command with invalid index name 7.8%
5. Help requested from SET DB command 7.5%
6. DISPLAY command - middle of >1 screen 5.8%
7. DISPLAY command-first of >1 screen 5.4%
8. FIND command with zero results 4.5%
9. FIND command retrieves >1 book 3.2%
10. DISPLAY command-complete in one screen 2.2%
11. All others 25.3%
Ten most frequent SHOW requests:
1. HISTORY 38.5%
2. SEARCH 15.4%
3. SYSTEM NEWS 8.9%
4. SC LIST (CC DBS) 8.3%
5. CC NEWS 4.7%
6. DATABASES 4.7%
7. CC SETTINGS 3.6%
8. CC GLOSSARY 3.0%
9. LIBRARY NEWS 2.4%
10. MAIL STATUS 2.4%
11. All others 8.3%
Cmm/yy cc MELVYL CURRENT CONTENTS DATABASE TELNET STATISTICS (monthly)