MELVYL CURRENT CONTENTS DATABASE TELNET STATISTICS
Time period: 09/15/01 through 09/21/01
1.0 SUMMARY STATISTICS
_______________________
1.1 Total sessions:
____________________
Location Library Remote Total
________ _______ ______ _____
Berkeley 58 532 590
Davis 299 10 309
Irvine 159 0 159
Los Angeles 1 187 188
Riverside 13 43 56
San Diego 22 180 202
San Francisco 124 0 124
Santa Barbara 1 109 110
Santa Cruz 13 27 40
LBL 0 93 93
LLL 0 33 33
Los Alamos n/a 0 0
Other - UC 0 25 25
U.S. Forestry 0
Other-Network UC n/a 559 559
_______ ______ _____
690 1,798 2,488
Per hour usage:
Time Sessions Finds Records Displayed
__________ __________ __________ _________________
12-2 a.m. 42 271 1,495
2-4 a.m. 21 78 1,104
4-6 a.m. 41 103 543
6-8 a.m. 69 213 1,433
8-10 a.m. 320 812 7,867
10-12 a.m. 494 1,348 11,068
12-2 p.m. 387 1,090 8,734
2-4 p.m. 513 1,310 15,190
4-6 p.m. 347 909 7,126
6-8 p.m. 120 352 3,034
8-10 p.m. 76 240 3,370
10-12 p.m. 58 203 1,984
__________ __________ __________ _________________
Total: 2,488 6,929 62,948
1.2 FIND commands
__________________
Number of FIND commands issued by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 145 1,343 1,488
Davis 1,074 25 1,099
Irvine 465 0 465
Los Angeles 0 573 573
Riverside 29 126 155
San Diego 80 567 647
San Francisco 309 0 309
Santa Barbara 2 336 338
Santa Cruz 27 67 94
LBL 0 227 227
LLL 0 118 118
Los Alamos n/a 0 0
Other - UC 1 104 105
U.S. Forestry 0
Other-Network UC n/a 1,311 1,311
_______ ______ _____
2,132 4,797 6,929
Number of FIND commands by database
CC database 6,837
CCT database 92
Total number of FIND commands 6,929
1.3 Records displayed
______________________
Number of Records Displayed by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 1,797 15,667 17,464
Davis 7,023 98 7,121
Irvine 4,094 0 4,094
Los Angeles 0 4,986 4,986
Riverside 582 1,997 2,579
San Diego 601 4,594 5,195
San Francisco 5,641 0 5,641
Santa Barbara 3 3,730 3,733
Santa Cruz 335 807 1,142
LBL 0 2,350 2,350
LLL 0 1,016 1,016
Los Alamos n/a 0 0
Other - UC 7 1,097 1,104
U.S. Forestry 0
Other-Network UC n/a 6,523 6,523
_______ ______ _____
20,083 42,865 62,948
Number of Records Displayed by database:
CC database 58,972
CCT database 3,976
Total number of Records Displayed 62,948
1.4 Relative Use of Databases
______________________________
Relative use of CC vs. CCT databases:
Percent of CC sessions 97.1%
Percent of CCT sessions 2.9%
Percent of searches done in the CC database 98.7%
Percent of searches done in the CCT database 1.3%
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 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) 432:40
Average number of searches completed per session 2.8
Retrievals per search - median 8.0
Retrievals per search - average 493.7
Retrievals per search - standard deviation 3890.5
Percent of searches completed with 0 results 22.9%
Percent of searches entered that are long 0.4%
Percent of long searches completed
(includes partial results) 66.7%
Commands entered, by type, excluding errors:
Total Percentage
__________ __________
FIND 6,186 36.7%
DISPLAY (excluding automatic displays) 4,858 28.8%
HELP 136 0.8%
EXPLAIN 170 1.0%
SET/RESET 1,157 6.9%
SHOW 23 0.1%
ADD ON (AND, OR, AND NOT) 651 3.9%
LOGON or LOGOFF 2,748 16.3%
COMMENT 0 0.0%
SAVE 166 1.0%
USE 3 0.0%
OTHER 746 4.4%
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,793 41.0% 421 15.1% 27 253.0 1923.1
TITLE WORD 2,365 34.7% 701 29.6% 13 796.9 5755.8
EXACT TITLE 103 1.5% 50 48.5% 3 44.4 175.5
JOURNAL 334 4.9% 125 37.4% 1,118 4725.9 11888.0
EXACT JOURNAL 135 2.0% 48 35.6% 1,003 3338.3 5741.3
SUBJECT CAT 17 0.2% 3 17.6% 20 142.7 234.5
SUBFILE 15 0.2% 2 13.3% 58 78.4 66.4
PUBLICATION TYPE 68 1.0% 11 16.2% 8 63.6 212.0
LANGUAGE 0 0.0% 0 0.0% 0 0.0 0.0
DATE 216 3.2% 31 14.4% 11 282.9 777.5
ADDED 23 0.3% 3 13.0% 5 7.5 9.3
PERIODICAL 386 5.7% 52 13.5% 5 26.0 104.1
EXACT PE 92 1.3% 10 10.9% 4 14.3 36.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 271 4.0% 95 35.1% 19 678.6 2962.9
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 638 10.4% 179 28.1% 7 170.7 611.3
Single 5,520 89.6% 1,185 21.5% 25 747.0 4849.0
DISPLAY commands, by type, excluding automatic displays:
REVIEW 5.7%
SHORT 75.9%
LONG 3.9%
FIELDS 1.5%
PERIODICALS 11.7%
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) 42:39
Average number of searches completed per session 1.3
Retrievals per search - median 54.5
Retrievals per search - average 240.9
Retrievals per search - standard deviation 568.2
Percent of searches completed with 0 results 19.6%
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 92 22.0%
DISPLAY (excluding automatic displays) 164 39.1%
HELP 21 5.0%
EXPLAIN 8 1.9%
SET/RESET 43 10.3%
SHOW 4 1.0%
ADD ON (AND, OR, AND NOT) 0 0.0%
LOGON or LOGOFF 70 16.7%
COMMENT 0 0.0%
SAVE 0 0.0%
USE 0 0.0%
OTHER 17 4.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 67 72.8% 16 23.9% 137 366.3 693.8
EXACT JOURNAL 16 17.4% 2 12.5% 66 240.7 479.7
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 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 9 9.8% 0 0.0% 3 12.7 19.2
By number of indexes:
Multiple 0 0.0% 0 0.0% 0 0.0 0.0
Single 92 100% 18 19.6% 103 299.5 620.2
DISPLAY commands, by type, excluding automatic displays:
REVIEW 5.1%
ISSUES 46.1%
SHORT 17.4%
LONG 23.6%
PERIODICALS 6.7%
COMMENTS 0.0%
Other 1.1%
2.3 Error, EXPLAIN and HELP statistics (CC & CCT)
__________________________________________________
Percent of commands that contained errors 7.4%
Ten most frequent errors:
1. NS command - no next screen 33.6%
2. First word of command is invalid 27.3%
3. FIND command with invalid index name 8.9%
4. Index invalid in current database 4.5%
5. DISPLAY command contains invalid word 2.7%
6. Search term missing from search command 2.3%
7. Max. # of ports to a Z39 db are in use 2.1%
8. NS of SHOW/EXP command-no next screen 1.8%
9. PS command - no previous screen 1.6%
10. Valid command at an inappropriate time 1.2%
11. All others 14.1%
Ten most frequent EXPLAIN requests:
1. FIND (CC DB) 15.7%
2. CC GUIDE 11.8%
3. CC INDEXES 11.8%
4. COMMANDS 9.6%
5. LOCATE (ARTICLE DBS) 8.4%
6. Unrecognized term 6.2%
7. CURRENT DATES 3.9%
8. CC DATABASE 3.9%
9. DATABASES 2.8%
10. MAIL 2.2%
11. All others 23.6%
Ten most frequent HELP situations:
1. Help requested from START CC command 13.4%
2. First word of command is invalid 10.7%
3. Help requested from SET DB command 8.7%
4. F/BR with index invalid in current DB 8.4%
5. FIND command with zero results 6.9%
6. DISPLAY command-first of >1 screen 6.3%
7. DISPLAY command - middle of >1 screen 4.5%
8. NS of SHOW/EXP command-no next screen 4.2%
9. FIND command with invalid index name 3.9%
10. DISPLAY command-complete in one screen 3.9%
11. All others 29.3%
Ten most frequent SHOW requests:
1. HISTORY 44.4%
2. SYSTEM NEWS 11.1%
3. MAIL STATUS 11.1%
4. CC SETTINGS 7.4%
5. SEARCH 7.4%
6. Z39.50 NEWS 3.7%
7. GLOSSARY 3.7%
8. LIBRARY NEWS 3.7%
9. CC GLOSSARY 3.7%
10. CC NEWS 3.7%
11. All others 0.0%
Cmm/yy cc MELVYL CURRENT CONTENTS DATABASE TELNET STATISTICS (monthly)