MELVYL CURRENT CONTENTS DATABASE TELNET STATISTICS
Time period: 03/30/02 through 04/05/02
1.0 SUMMARY STATISTICS
_______________________
1.1 Total sessions:
____________________
Location Library Remote Total
________ _______ ______ _____
Berkeley 65 493 558
Davis 203 12 215
Irvine 95 0 95
Los Angeles 0 134 134
Riverside 11 32 43
San Diego 18 117 135
San Francisco 134 0 134
Santa Barbara 7 61 68
Santa Cruz 45 48 93
LBL 0 52 52
LLL 0 27 27
Los Alamos n/a 0 0
Other - UC 0 34 34
U.S. Forestry 0
Other-Network UC n/a 439 439
_______ ______ _____
578 1,449 2,027
Per hour usage:
Time Sessions Finds Records Displayed
__________ __________ __________ _________________
12-2 a.m. 22 64 788
2-4 a.m. 21 52 7,802
4-6 a.m. 23 51 463
6-8 a.m. 53 174 1,564
8-10 a.m. 289 740 5,286
10-12 a.m. 405 1,101 9,829
12-2 p.m. 313 925 9,038
2-4 p.m. 390 913 8,421
4-6 p.m. 303 682 5,348
6-8 p.m. 104 341 3,036
8-10 p.m. 67 223 2,816
10-12 p.m. 37 115 1,046
__________ __________ __________ _________________
Total: 2,027 5,381 55,437
1.2 FIND commands
__________________
Number of FIND commands issued by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 152 1,469 1,621
Davis 576 21 597
Irvine 225 0 225
Los Angeles 0 369 369
Riverside 18 111 129
San Diego 26 289 315
San Francisco 446 0 446
Santa Barbara 17 161 178
Santa Cruz 92 97 189
LBL 0 86 86
LLL 0 69 69
Los Alamos n/a 0 0
Other - UC 0 132 132
U.S. Forestry 0
Other-Network UC n/a 1,025 1,025
_______ ______ _____
1,552 3,829 5,381
Number of FIND commands by database
CC database 5,238
CCT database 143
Total number of FIND commands 5,381
1.3 Records displayed
______________________
Number of Records Displayed by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 1,547 15,101 16,648
Davis 4,286 163 4,449
Irvine 9,441 0 9,441
Los Angeles 0 3,418 3,418
Riverside 53 486 539
San Diego 250 2,373 2,623
San Francisco 3,890 0 3,890
Santa Barbara 202 1,130 1,332
Santa Cruz 746 1,383 2,129
LBL 0 666 666
LLL 0 824 824
Los Alamos n/a 0 0
Other - UC 0 1,407 1,407
U.S. Forestry 0
Other-Network UC n/a 8,071 8,071
_______ ______ _____
20,415 35,022 55,437
Number of Records Displayed by database:
CC database 51,004
CCT database 4,433
Total number of Records Displayed 55,437
1.4 Relative Use of Databases
______________________________
Relative use of CC vs. CCT databases:
Percent of CC sessions 96.2%
Percent of CCT sessions 3.8%
Percent of searches done in the CC database 97.3%
Percent of searches done in the CCT database 2.7%
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.5
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.5
2.0 CC Database Statistics
___________________________
Median session length (minutes:seconds) 0:00
Average session length (minutes:seconds) 0:00
Longest session recorded (minutes:seconds) 592:51
Average number of searches completed per session 2.7
Retrievals per search - median 9.0
Retrievals per search - average 960.1
Retrievals per search - standard deviation 9651.5
Percent of searches completed with 0 results 21.0%
Percent of searches entered that are long 0.4%
Percent of long searches completed
(includes partial results) 68.2%
Commands entered, by type, excluding errors:
Total Percentage
__________ __________
FIND 4,680 35.7%
DISPLAY (excluding automatic displays) 3,701 28.2%
HELP 108 0.8%
EXPLAIN 104 0.8%
SET/RESET 834 6.4%
SHOW 15 0.1%
ADD ON (AND, OR, AND NOT) 558 4.3%
LOGON or LOGOFF 2,299 17.5%
COMMENT 0 0.0%
SAVE 219 1.7%
USE 1 0.0%
OTHER 583 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,116 41.4% 300 14.2% 27 254.3 2576.2
TITLE WORD 1,591 31.1% 466 29.3% 13 1951.0 10828.7
EXACT TITLE 126 2.5% 46 36.5% 1 27.9 119.9
JOURNAL 307 6.0% 99 32.2% 802 7216.8 38105.0
EXACT JOURNAL 140 2.7% 38 27.1% 1,470 4377.0 12482.8
SUBJECT CAT 39 0.8% 3 7.7% 23 108.2 208.9
SUBFILE 6 0.1% 1 16.7% 64 68.8 84.0
PUBLICATION TYPE 15 0.3% 7 46.7% 120 208.8 279.8
LANGUAGE 2 0.0% 0 0.0% 124 123.5 146.4
DATE 74 1.4% 17 23.0% 7 105.7 273.8
ADDED 9 0.2% 2 22.2% 16 24.4 23.2
PERIODICAL 381 7.4% 56 14.7% 5 194.8 1478.8
EXACT PE 55 1.1% 2 3.6% 4 9.0 16.6
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 253 4.9% 54 21.3% 17 1415.1 7693.8
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 431 9.2% 124 28.8% 6 55.9 197.1
Single 4,230 90.8% 838 19.8% 25 1453.0 11934.6
DISPLAY commands, by type, excluding automatic displays:
REVIEW 5.0%
SHORT 72.7%
LONG 4.5%
FIELDS 2.7%
PERIODICALS 13.5%
COMMENTS 0.0%
Other 1.5%
2.1 CCT Database Statistics
____________________________
Median session length (minutes:seconds) 0:00
Average session length (minutes:seconds) 0:00
Longest session recorded (minutes:seconds) 46:12
Average number of searches completed per session 1.9
Retrievals per search - median 51.0
Retrievals per search - average 577.3
Retrievals per search - standard deviation 3385.7
Percent of searches completed with 0 results 25.2%
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 143 24.4%
DISPLAY (excluding automatic displays) 255 43.4%
HELP 32 5.5%
EXPLAIN 20 3.4%
SET/RESET 53 9.0%
SHOW 1 0.2%
ADD ON (AND, OR, AND NOT) 0 0.0%
LOGON or LOGOFF 64 10.9%
COMMENT 0 0.0%
SAVE 0 0.0%
USE 0 0.0%
OTHER 19 3.2%
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 111 75.5% 28 25.2% 91 942.6 4411.0
EXACT JOURNAL 23 15.6% 7 30.4% 70 247.9 585.6
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 4 2.7% 1 25.0% 13 22.3 17.9
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 6.1% 1 11.1% 8 44.4 88.1
By number of indexes:
Multiple 4 2.8% 1 25.0% 13 22.3 17.9
Single 139 97.2% 35 25.2% 79 793.2 3953.6
DISPLAY commands, by type, excluding automatic displays:
REVIEW 22.2%
ISSUES 26.3%
SHORT 30.7%
LONG 15.4%
PERIODICALS 5.5%
COMMENTS 0.0%
Other 0.0%
2.3 Error, EXPLAIN and HELP statistics (CC & CCT)
__________________________________________________
Percent of commands that contained errors 7.5%
Ten most frequent errors:
1. NS command - no next screen 35.9%
2. First word of command is invalid 28.0%
3. FIND command with invalid index name 9.5%
4. Index invalid in current database 3.6%
5. DISPLAY command contains invalid word 2.3%
6. Search term missing from search command 2.3%
7. PS command - no previous screen 2.1%
8. D ABS command in database w/o abstracts 1.4%
9. Valid command at an inappropriate time 1.2%
10. 422 1.0%
11. All others 12.9%
Ten most frequent EXPLAIN requests:
1. CC GUIDE 16.9%
2. CC INDEXES 12.1%
3. FIND (CC DB) 8.9%
4. Unrecognized term 7.3%
5. COMMANDS 7.3%
6. LOCATE (ARTICLE DBS) 5.6%
7. CCT INDEXES 4.8%
8. DATABASES 4.0%
9. SUBJECT CATEGORY 4.0%
10. CC DATABASE 3.2%
11. All others 25.8%
Ten most frequent HELP situations:
1. Help requested from START CC command 18.9%
2. First word of command is invalid 14.4%
3. F/BR with index invalid in current DB 9.5%
4. FIND command with invalid index name 6.4%
5. DISPLAY command - middle of >1 screen 6.4%
6. FIND command with zero results 4.2%
7. Help requested from SET DB command 4.2%
8. DISPLAY command-first of >1 screen 3.8%
9. DISPLAY command-complete in one screen 3.4%
10. FIND command retrieves >1 book 3.0%
11. All others 25.8%
Ten most frequent SHOW requests:
1. HISTORY 43.8%
2. TIME 25.0%
3. SYSTEM NEWS 6.3%
4. CC GLOSSARY 6.3%
5. SC LIST (CC DBS) 6.3%
6. SEARCH 6.3%
7. DATABASES 6.3%
11. All others 0.0%
Cmm/yy cc MELVYL CURRENT CONTENTS DATABASE TELNET STATISTICS (monthly)