MELVYL CURRENT CONTENTS DATABASE TELNET STATISTICS
Time period: 03/24/01 through 03/30/01
1.0 SUMMARY STATISTICS
_______________________
1.1 Total sessions:
____________________
Location Library Remote Total
________ _______ ______ _____
Berkeley 39 651 690
Davis 249 22 271
Irvine 236 0 236
Los Angeles 2 272 274
Riverside 21 86 107
San Diego 34 241 275
San Francisco 205 0 205
Santa Barbara 2 111 113
Santa Cruz 21 88 109
LBL 0 129 129
LLL 0 44 44
Los Alamos n/a 0 0
Other - UC 0 48 48
U.S. Forestry 0
Other-Network UC n/a 491 491
_______ ______ _____
809 2,183 2,992
Per hour usage:
Time Sessions Finds Records Displayed
__________ __________ __________ _________________
12-2 a.m. 47 194 1,769
2-4 a.m. 39 147 1,278
4-6 a.m. 55 181 1,115
6-8 a.m. 94 238 1,752
8-10 a.m. 356 1,201 14,068
10-12 a.m. 518 1,540 22,582
12-2 p.m. 515 1,375 14,120
2-4 p.m. 578 1,577 14,265
4-6 p.m. 428 1,221 14,087
6-8 p.m. 199 668 6,275
8-10 p.m. 84 345 2,823
10-12 p.m. 79 231 2,852
__________ __________ __________ _________________
Total: 2,992 8,918 96,986
1.2 FIND commands
__________________
Number of FIND commands issued by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 90 1,653 1,743
Davis 656 104 760
Irvine 922 0 922
Los Angeles 22 837 859
Riverside 56 342 398
San Diego 125 768 893
San Francisco 576 0 576
Santa Barbara 3 361 364
Santa Cruz 44 219 263
LBL 0 330 330
LLL 0 703 703
Los Alamos n/a 0 0
Other - UC 0 134 134
U.S. Forestry 0
Other-Network UC n/a 973 973
_______ ______ _____
2,494 6,424 8,918
Number of FIND commands by database
CC database 8,741
CCT database 177
Total number of FIND commands 8,918
1.3 Records displayed
______________________
Number of Records Displayed by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 1,753 16,516 18,269
Davis 7,152 744 7,896
Irvine 6,310 0 6,310
Los Angeles 231 6,107 6,338
Riverside 283 3,544 3,827
San Diego 927 5,582 6,509
San Francisco 21,608 0 21,608
Santa Barbara 77 4,189 4,266
Santa Cruz 257 2,043 2,300
LBL 0 3,500 3,500
LLL 0 7,028 7,028
Los Alamos n/a 0 0
Other - UC 0 2,017 2,017
U.S. Forestry 0
Other-Network UC n/a 7,118 7,118
_______ ______ _____
38,598 58,388 96,986
Number of Records Displayed by database:
CC database 76,419
CCT database 20,567
Total number of Records Displayed 96,986
1.4 Relative Use of Databases
______________________________
Relative use of CC vs. CCT databases:
Percent of CC sessions 95.3%
Percent of CCT sessions 4.7%
Percent of searches done in the CC database 98.0%
Percent of searches done in the CCT database 2.0%
1.5 Response time
__________________
Search response time from receipt of command at
DLA until transmission of response:
Average in seconds 1.1
Standard deviation in seconds 4.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 4.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) 854:43
Average number of searches completed per session 3.1
Retrievals per search - median 8.0
Retrievals per search - average 558.0
Retrievals per search - standard deviation 9168.1
Percent of searches completed with 0 results 25.3%
Percent of searches entered that are long 0.3%
Percent of long searches completed
(includes partial results) 66.7%
Commands entered, by type, excluding errors:
Total Percentage
__________ __________
FIND 8,145 38.7%
DISPLAY (excluding automatic displays) 6,223 29.5%
HELP 131 0.6%
EXPLAIN 159 0.8%
SET/RESET 1,185 5.6%
SHOW 27 0.1%
ADD ON (AND, OR, AND NOT) 596 2.8%
LOGON or LOGOFF 3,552 16.9%
COMMENT 0 0.0%
SAVE 146 0.7%
USE 9 0.0%
OTHER 899 4.3%
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 4,077 42.9% 624 15.3% 31 221.3 1367.1
TITLE WORD 2,805 29.5% 852 30.4% 12 702.3 5551.2
EXACT TITLE 86 0.9% 49 57.0% 1 136.9 726.9
JOURNAL 471 5.0% 223 47.3% 33 6030.0 44145.3
EXACT JOURNAL 469 4.9% 298 63.5% 47 1000.8 4271.7
SUBJECT CAT 46 0.5% 6 13.0% 7 57.5 185.5
SUBFILE 29 0.3% 0 0.0% 51 767.4 2511.7
PUBLICATION TYPE 74 0.8% 12 16.2% 13 13133.0 49974.2
LANGUAGE 4 0.0% 0 0.0% 18 1691.5 3353.0
DATE 124 1.3% 15 12.1% 10 54.7 162.3
ADDED 629 6.6% 438 69.6% 19 30.3 32.6
PERIODICAL 317 3.3% 60 18.9% 4 85.3 821.7
EXACT PE 39 0.4% 2 5.1% 4 13.4 50.2
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 332 3.5% 107 32.2% 15 833.1 6712.7
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 1,364 16.8% 646 47.4% 8 74.2 599.1
Single 6,755 83.2% 1,392 20.6% 29 889.1 11670.8
DISPLAY commands, by type, excluding automatic displays:
REVIEW 4.8%
SHORT 79.6%
LONG 5.1%
FIELDS 2.0%
PERIODICALS 7.4%
COMMENTS 0.0%
Other 1.2%
2.1 CCT Database Statistics
____________________________
Median session length (minutes:seconds) 0:00
Average session length (minutes:seconds) 0:00
Longest session recorded (minutes:seconds) 126:32
Average number of searches completed per session 1.2
Retrievals per search - median 61.0
Retrievals per search - average 504.8
Retrievals per search - standard deviation 1747.3
Percent of searches completed with 0 results 29.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 177 19.1%
DISPLAY (excluding automatic displays) 265 28.6%
HELP 37 4.0%
EXPLAIN 20 2.2%
SET/RESET 85 9.2%
SHOW 8 0.9%
ADD ON (AND, OR, AND NOT) 0 0.0%
LOGON or LOGOFF 121 13.1%
COMMENT 0 0.0%
SAVE 185 20.0%
USE 1 0.1%
OTHER 27 2.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:
JOURNAL 124 69.3% 43 34.7% 119 421.9 993.1
EXACT JOURNAL 36 20.1% 8 22.2% 148 233.8 274.7
SUBJECT CAT 7 3.9% 1 14.3% 7,975 8096.2 4295.7
SUBFILE 0 0.0% 0 0.0% 0 0.0 0.0
DATE 1 0.6% 0 0.0% 115 115.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 11 6.1% 1 9.1% 2 5.7 6.6
By number of indexes:
Multiple 2 1.1% 1 50.0% 115 115.0 0.0
Single 175 98.9% 51 29.1% 137 719.7 2052.6
DISPLAY commands, by type, excluding automatic displays:
REVIEW 1.1%
ISSUES 73.9%
SHORT 6.6%
LONG 11.3%
PERIODICALS 6.0%
COMMENTS 0.0%
Other 1.1%
2.3 Error, EXPLAIN and HELP statistics (CC & CCT)
__________________________________________________
Percent of commands that contained errors 8.4%
Ten most frequent errors:
1. First word of command is invalid 32.7%
2. NS command - no next screen 30.4%
3. FIND command with invalid index name 8.7%
4. Index invalid in current database 3.0%
5. Max. # of ports to a Z39 db are in use 2.7%
6. DISPLAY command - no FIND results 2.2%
7. Search term missing from search command 2.0%
8. DISPLAY command contains invalid word 2.0%
9. NS of SHOW/EXP command-no next screen 1.5%
10. PS command - no previous screen 1.4%
11. All others 13.3%
Ten most frequent EXPLAIN requests:
1. FIND (CC DB) 15.1%
2. CC GUIDE 12.3%
3. CC INDEXES 8.9%
4. Unrecognized term 8.4%
5. COMMANDS 7.8%
6. DISPLAY 5.6%
7. LOCATE (ARTICLE DBS) 4.5%
8. CC DATABASE 4.5%
9. MAIL 3.9%
10. DATABASES 3.9%
11. All others 25.1%
Ten most frequent HELP situations:
1. Help requested from START CC command 17.3%
2. First word of command is invalid 12.4%
3. Help requested from SET DB command 10.1%
4. FIND command with invalid index name 7.5%
5. FIND command with zero results 5.2%
6. F/BR with index invalid in current DB 4.9%
7. DISPLAY command-complete in one screen 3.5%
8. DISPLAY command - middle of >1 screen 2.9%
9. FIND command retrieves 1 book 2.6%
10. DISPLAY command-first of >1 screen 2.6%
11. All others 31.1%
Ten most frequent SHOW requests:
1. HISTORY 37.5%
2. SEARCH 18.8%
3. SYSTEM NEWS 12.5%
4. CC NEWS 12.5%
5. MAIL STATUS 6.3%
6. GLOSSARY 3.1%
7. SYSTEM5 NEWS 3.1%
8. CCT SETTINGS 3.1%
9. SC LIST (CC DBS) 3.1%
11. All others 0.0%
Cmm/yy cc MELVYL CURRENT CONTENTS DATABASE TELNET STATISTICS (monthly)