MELVYL CURRENT CONTENTS DATABASE TELNET STATISTICS
Time period: 12/01/01 through 12/07/01
1.0 SUMMARY STATISTICS
_______________________
1.1 Total sessions:
____________________
Location Library Remote Total
________ _______ ______ _____
Berkeley 67 550 617
Davis 247 40 287
Irvine 175 0 175
Los Angeles 1 141 142
Riverside 23 65 88
San Diego 30 175 205
San Francisco 147 0 147
Santa Barbara 5 109 114
Santa Cruz 6 48 54
LBL 0 102 102
LLL 0 51 51
Los Alamos n/a 0 0
Other - UC 0 66 66
U.S. Forestry 0
Other-Network UC n/a 457 457
_______ ______ _____
701 1,804 2,505
Per hour usage:
Time Sessions Finds Records Displayed
__________ __________ __________ _________________
12-2 a.m. 23 75 1,027
2-4 a.m. 24 39 7,433
4-6 a.m. 31 135 390
6-8 a.m. 62 160 1,026
8-10 a.m. 331 787 5,498
10-12 a.m. 469 1,127 9,190
12-2 p.m. 437 1,204 10,705
2-4 p.m. 442 1,083 9,165
4-6 p.m. 316 902 12,142
6-8 p.m. 166 519 5,828
8-10 p.m. 120 277 1,629
10-12 p.m. 84 203 1,546
__________ __________ __________ _________________
Total: 2,505 6,511 65,579
1.2 FIND commands
__________________
Number of FIND commands issued by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 135 1,446 1,581
Davis 710 107 817
Irvine 601 0 601
Los Angeles 2 410 412
Riverside 41 202 243
San Diego 104 419 523
San Francisco 396 0 396
Santa Barbara 7 260 267
Santa Cruz 10 100 110
LBL 0 182 182
LLL 0 164 164
Los Alamos n/a 0 0
Other - UC 0 140 140
U.S. Forestry 0
Other-Network UC n/a 1,075 1,075
_______ ______ _____
2,006 4,505 6,511
Number of FIND commands by database
CC database 6,352
CCT database 159
Total number of FIND commands 6,511
1.3 Records displayed
______________________
Number of Records Displayed by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 1,284 14,344 15,628
Davis 5,473 563 6,036
Irvine 11,187 0 11,187
Los Angeles 8 7,574 7,582
Riverside 2,188 1,555 3,743
San Diego 686 3,610 4,296
San Francisco 2,885 0 2,885
Santa Barbara 115 3,019 3,134
Santa Cruz 156 1,188 1,344
LBL 0 1,612 1,612
LLL 0 1,195 1,195
Los Alamos n/a 0 0
Other - UC 0 1,407 1,407
U.S. Forestry 0
Other-Network UC n/a 5,530 5,530
_______ ______ _____
23,982 41,597 65,579
Number of Records Displayed by database:
CC database 60,937
CCT database 4,642
Total number of Records Displayed 65,579
1.4 Relative Use of Databases
______________________________
Relative use of CC vs. CCT databases:
Percent of CC sessions 96.3%
Percent of CCT sessions 3.7%
Percent of searches done in the CC database 97.6%
Percent of searches done in the CCT database 2.4%
1.5 Response time
__________________
Search response time from receipt of command at
DLA until transmission of response:
Average in seconds 1.2
Standard deviation in seconds 4.3
Display response time from receipt of command at
DLA until transmission of a complete screen:
Average in seconds 0.2
Standard deviation in seconds 4.3
2.0 CC Database Statistics
___________________________
Median session length (minutes:seconds) 0:00
Average session length (minutes:seconds) 0:00
Longest session recorded (minutes:seconds) 419:29
Average number of searches completed per session 2.6
Retrievals per search - median 9.0
Retrievals per search - average 738.5
Retrievals per search - standard deviation 8301.2
Percent of searches completed with 0 results 22.9%
Percent of searches entered that are long 0.6%
Percent of long searches completed
(includes partial results) 63.2%
Commands entered, by type, excluding errors:
Total Percentage
__________ __________
FIND 5,688 35.2%
DISPLAY (excluding automatic displays) 4,670 28.9%
HELP 124 0.8%
EXPLAIN 104 0.6%
SET/RESET 1,040 6.4%
SHOW 37 0.2%
ADD ON (AND, OR, AND NOT) 664 4.1%
LOGON or LOGOFF 2,874 17.8%
COMMENT 0 0.0%
SAVE 198 1.2%
USE 1 0.0%
OTHER 768 4.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:
PERSONAL AUTHOR 2,768 44.8% 441 15.9% 32 240.8 1769.8
TITLE WORD 2,063 33.4% 630 30.5% 15 1314.7 10646.0
EXACT TITLE 144 2.3% 54 37.5% 1 24.4 92.4
JOURNAL 308 5.0% 110 35.7% 455 8255.4 33961.3
EXACT JOURNAL 96 1.6% 35 36.5% 733 3268.3 8363.8
SUBJECT CAT 15 0.2% 1 6.7% 23 25.4 24.6
SUBFILE 10 0.2% 1 10.0% 20 134.0 235.2
PUBLICATION TYPE 7 0.1% 0 0.0% 2 3.6 3.0
LANGUAGE 4 0.1% 0 0.0% 132 215.8 261.5
DATE 126 2.0% 21 16.7% 16 157.5 747.5
ADDED 9 0.1% 2 22.2% 17 17.9 13.8
PERIODICAL 339 5.5% 37 10.9% 4 49.3 351.9
EXACT PE 75 1.2% 5 6.7% 3 64.3 256.3
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 221 3.6% 67 30.3% 15 1392.3 8983.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 512 9.1% 158 30.9% 7 66.8 416.4
Single 5,138 90.9% 1,079 21.0% 29 1104.9 10238.9
DISPLAY commands, by type, excluding automatic displays:
REVIEW 4.4%
SHORT 77.2%
LONG 3.7%
FIELDS 2.4%
PERIODICALS 11.0%
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) 36:57
Average number of searches completed per session 1.7
Retrievals per search - median 74.0
Retrievals per search - average 246.0
Retrievals per search - standard deviation 712.4
Percent of searches completed with 0 results 18.9%
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 159 24.1%
DISPLAY (excluding automatic displays) 272 41.2%
HELP 22 3.3%
EXPLAIN 14 2.1%
SET/RESET 63 9.5%
SHOW 12 1.8%
ADD ON (AND, OR, AND NOT) 0 0.0%
LOGON or LOGOFF 89 13.5%
COMMENT 0 0.0%
SAVE 0 0.0%
USE 2 0.3%
OTHER 27 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 101 63.1% 21 20.8% 95 281.9 885.5
EXACT JOURNAL 53 33.1% 7 13.2% 135 359.2 588.3
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 1 0.6% 0 0.0% 1 1.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 5 3.1% 2 40.0% 5 12.3 13.6
By number of indexes:
Multiple 1 0.6% 0 0.0% 1 1.0 0.0
Single 158 99.4% 30 19.0% 107 305.6 783.0
DISPLAY commands, by type, excluding automatic displays:
REVIEW 20.9%
ISSUES 30.1%
SHORT 31.6%
LONG 15.6%
PERIODICALS 1.1%
COMMENTS 0.0%
Other 0.7%
2.3 Error, EXPLAIN and HELP statistics (CC & CCT)
__________________________________________________
Percent of commands that contained errors 7.7%
Ten most frequent errors:
1. First word of command is invalid 32.0%
2. NS command - no next screen 27.1%
3. FIND command with invalid index name 9.2%
4. Index invalid in current database 3.9%
5. Max. # of ports to a Z39 db are in use 3.1%
6. DISPLAY command contains invalid word 2.3%
7. Search term missing from search command 2.0%
8. PS command - no previous screen 1.9%
9. D ABS command in database w/o abstracts 1.9%
10. DISPLAY command - no FIND results 1.7%
11. All others 14.9%
Ten most frequent EXPLAIN requests:
1. CC GUIDE 19.5%
2. FIND (CC DB) 12.7%
3. LOCATE (ARTICLE DBS) 10.2%
4. CC INDEXES 9.3%
5. CC DATABASE 5.1%
6. MAIL 4.2%
7. COMMANDS 4.2%
8. Unrecognized term 3.4%
9. ADD-ON SEARCH 3.4%
10. CCT INDEXES 3.4%
11. All others 24.6%
Ten most frequent HELP situations:
1. Help requested from START CC command 17.8%
2. First word of command is invalid 12.5%
3. Help requested from SET DB command 8.7%
4. FIND command with invalid index name 8.3%
5. F/BR with index invalid in current DB 8.3%
6. FIND command with zero results 6.4%
7. DISPLAY command-complete in one screen 4.5%
8. DISPLAY command - middle of >1 screen 4.2%
9. FIND command retrieves >1 book 3.4%
10. Help requested from FIND PA command 3.0%
11. All others 22.7%
Ten most frequent SHOW requests:
1. HISTORY 34.7%
2. SC LIST (CC DBS) 16.3%
3. UPDATE 8.2%
4. TIME 6.1%
5. SYSTEM NEWS 4.1%
6. STATISTICS 4.1%
7. CC NEWS 4.1%
8. SEARCH 4.1%
9. UCI NEWS 2.0%
10. LIBRARY NEWS 2.0%
11. All others 14.3%
Cmm/yy cc MELVYL CURRENT CONTENTS DATABASE TELNET STATISTICS (monthly)