MELVYL CURRENT CONTENTS DATABASE TELNET STATISTICS
Time period: 12/29/01 through 01/04/02
1.0 SUMMARY STATISTICS
_______________________
1.1 Total sessions:
____________________
Location Library Remote Total
________ _______ ______ _____
Berkeley 22 346 368
Davis 200 16 216
Irvine 98 0 98
Los Angeles 1 163 164
Riverside 27 22 49
San Diego 15 150 165
San Francisco 109 0 109
Santa Barbara 3 24 27
Santa Cruz 5 28 33
LBL 0 51 51
LLL 0 11 11
Los Alamos n/a 0 0
Other - UC 4 35 39
U.S. Forestry 0
Other-Network UC n/a 344 344
_______ ______ _____
484 1,190 1,674
Per hour usage:
Time Sessions Finds Records Displayed
__________ __________ __________ _________________
12-2 a.m. 24 53 2,691
2-4 a.m. 31 105 8,280
4-6 a.m. 33 74 417
6-8 a.m. 72 267 2,466
8-10 a.m. 181 467 5,311
10-12 a.m. 330 910 8,783
12-2 p.m. 245 627 5,223
2-4 p.m. 308 935 6,291
4-6 p.m. 222 566 7,763
6-8 p.m. 81 204 2,376
8-10 p.m. 88 400 2,797
10-12 p.m. 59 211 1,541
__________ __________ __________ _________________
Total: 1,674 4,819 53,939
1.2 FIND commands
__________________
Number of FIND commands issued by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 39 1,000 1,039
Davis 554 30 584
Irvine 315 0 315
Los Angeles 4 466 470
Riverside 42 105 147
San Diego 61 467 528
San Francisco 350 0 350
Santa Barbara 3 106 109
Santa Cruz 10 59 69
LBL 0 187 187
LLL 0 21 21
Los Alamos n/a 0 0
Other - UC 1 84 85
U.S. Forestry 0
Other-Network UC n/a 915 915
_______ ______ _____
1,379 3,440 4,819
Number of FIND commands by database
CC database 4,760
CCT database 59
Total number of FIND commands 4,819
1.3 Records displayed
______________________
Number of Records Displayed by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 349 10,580 10,929
Davis 5,857 1,270 7,127
Irvine 9,383 0 9,383
Los Angeles 218 3,608 3,826
Riverside 458 857 1,315
San Diego 576 5,055 5,631
San Francisco 3,539 0 3,539
Santa Barbara 2 1,188 1,190
Santa Cruz 150 569 719
LBL 0 1,955 1,955
LLL 0 486 486
Los Alamos n/a 0 0
Other - UC 0 1,169 1,169
U.S. Forestry 0
Other-Network UC n/a 6,670 6,670
_______ ______ _____
20,532 33,407 53,939
Number of Records Displayed by database:
CC database 50,802
CCT database 3,137
Total number of Records Displayed 53,939
1.4 Relative Use of Databases
______________________________
Relative use of CC vs. CCT databases:
Percent of CC sessions 96.5%
Percent of CCT sessions 3.5%
Percent of searches done in the CC database 98.8%
Percent of searches done in the CCT database 1.2%
1.5 Response time
__________________
Search response time from receipt of command at
DLA until transmission of response:
Average in seconds 0.9
Standard deviation in seconds 3.9
Display response time from receipt of command at
DLA until transmission of a complete screen:
Average in seconds 0.2
Standard deviation in seconds 3.9
2.0 CC Database Statistics
___________________________
Median session length (minutes:seconds) 0:00
Average session length (minutes:seconds) 0:00
Longest session recorded (minutes:seconds) 833:23
Average number of searches completed per session 2.9
Retrievals per search - median 8.0
Retrievals per search - average 330.0
Retrievals per search - standard deviation 2613.6
Percent of searches completed with 0 results 21.2%
Percent of searches entered that are long 0.5%
Percent of long searches completed
(includes partial results) 88.0%
Commands entered, by type, excluding errors:
Total Percentage
__________ __________
FIND 4,265 36.5%
DISPLAY (excluding automatic displays) 3,335 28.5%
HELP 75 0.6%
EXPLAIN 75 0.6%
SET/RESET 632 5.4%
SHOW 14 0.1%
ADD ON (AND, OR, AND NOT) 495 4.2%
LOGON or LOGOFF 2,069 17.7%
COMMENT 0 0.0%
SAVE 235 2.0%
USE 4 0.0%
OTHER 500 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 2,429 52.2% 356 14.7% 26 151.7 624.3
TITLE WORD 1,302 28.0% 391 30.0% 11 440.7 2851.6
EXACT TITLE 67 1.4% 37 55.2% 2 87.7 336.2
JOURNAL 225 4.8% 85 37.8% 649 3551.4 8967.5
EXACT JOURNAL 65 1.4% 30 46.2% 2,152 4922.1 10273.2
SUBJECT CAT 6 0.1% 0 0.0% 12 30.5 45.2
SUBFILE 4 0.1% 0 0.0% 85 74.5 31.2
PUBLICATION TYPE 18 0.4% 4 22.2% 42 8604.9 21395.0
LANGUAGE 0 0.0% 0 0.0% 0 0.0 0.0
DATE 98 2.1% 20 20.4% 12 67.2 175.4
ADDED 11 0.2% 3 27.3% 9 13.3 12.6
PERIODICAL 217 4.7% 18 8.3% 5 21.2 74.7
EXACT PE 57 1.2% 6 10.5% 3 9.2 23.5
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 154 3.3% 51 33.1% 27 296.0 607.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 399 9.4% 126 31.6% 7 72.1 306.5
Single 3,848 90.6% 748 19.4% 23 487.2 3216.6
DISPLAY commands, by type, excluding automatic displays:
REVIEW 5.9%
SHORT 76.3%
LONG 3.7%
FIELDS 2.0%
PERIODICALS 10.1%
COMMENTS 0.0%
Other 2.0%
2.1 CCT Database Statistics
____________________________
Median session length (minutes:seconds) 0:00
Average session length (minutes:seconds) 0:00
Longest session recorded (minutes:seconds) 28:28
Average number of searches completed per session 1.0
Retrievals per search - median 145.0
Retrievals per search - average 188.9
Retrievals per search - standard deviation 269.4
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 59 18.8%
DISPLAY (excluding automatic displays) 120 38.2%
HELP 23 7.3%
EXPLAIN 10 3.2%
SET/RESET 44 14.0%
SHOW 1 0.3%
ADD ON (AND, OR, AND NOT) 0 0.0%
LOGON or LOGOFF 43 13.7%
COMMENT 0 0.0%
SAVE 2 0.6%
USE 0 0.0%
OTHER 12 3.8%
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 38 64.4% 13 34.2% 265 325.9 306.7
EXACT JOURNAL 19 32.2% 3 15.8% 149 187.2 237.0
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 2 3.4% 1 50.0% 2 2.0 0.0
By number of indexes:
Multiple 0 0.0% 0 0.0% 0 0.0 0.0
Single 59 100% 17 28.8% 171 265.4 286.2
DISPLAY commands, by type, excluding automatic displays:
REVIEW 8.5%
ISSUES 50.8%
SHORT 21.5%
LONG 16.2%
PERIODICALS 0.8%
COMMENTS 0.0%
Other 2.3%
2.3 Error, EXPLAIN and HELP statistics (CC & CCT)
__________________________________________________
Percent of commands that contained errors 6.6%
Ten most frequent errors:
1. NS command - no next screen 34.3%
2. First word of command is invalid 26.2%
3. FIND command with invalid index name 9.7%
4. 1281 5.3%
5. Index invalid in current database 4.5%
6. DISPLAY command contains invalid word 2.0%
7. Search term missing from search command 2.0%
8. PS command - no previous screen 1.6%
9. D ABS command in database w/o abstracts 1.6%
10. DISPLAY command - no FIND results 1.3%
11. All others 11.5%
Ten most frequent EXPLAIN requests:
1. CC GUIDE 12.9%
2. FIND (CC DB) 11.8%
3. CC INDEXES 10.6%
4. LOCATE (ARTICLE DBS) 9.4%
5. CC DATABASE 8.2%
6. DATABASES 7.1%
7. COMMANDS 7.1%
8. Unrecognized term 4.7%
9. CCT INDEXES 4.7%
10. 8400 3.5%
11. All others 20.0%
Ten most frequent HELP situations:
1. Help requested from START CC command 23.0%
2. Help requested from SET DB command 10.4%
3. F/BR with index invalid in current DB 8.7%
4. FIND command with invalid index name 7.7%
5. First word of command is invalid 6.0%
6. DISPLAY command-first of >1 screen 4.9%
7. FIND command with zero results 3.8%
8. Help requested from FIND PA command 3.8%
9. FIND command retrieves >1 book 2.7%
10. DISPLAY command - middle of >1 screen 2.7%
11. All others 26.2%
Ten most frequent SHOW requests:
1. HISTORY 60.0%
2. MAIL STATUS 20.0%
3. SYSTEM NEWS 6.7%
4. CC GLOSSARY 6.7%
11. All others 6.7%
Cmm/yy cc MELVYL CURRENT CONTENTS DATABASE TELNET STATISTICS (monthly)