MELVYL CURRENT CONTENTS DATABASE TELNET STATISTICS
Time period: 05/12/01 through 05/18/01
1.0 SUMMARY STATISTICS
_______________________
1.1 Total sessions:
____________________
Location Library Remote Total
________ _______ ______ _____
Berkeley 59 658 717
Davis 325 19 344
Irvine 260 0 260
Los Angeles 6 270 276
Riverside 31 47 78
San Diego 29 222 251
San Francisco 183 0 183
Santa Barbara 14 108 122
Santa Cruz 47 91 138
LBL 0 84 84
LLL 0 49 49
Los Alamos n/a 0 0
Other - UC 1 54 55
U.S. Forestry 0
Other-Network UC n/a 565 565
_______ ______ _____
955 2,167 3,122
Per hour usage:
Time Sessions Finds Records Displayed
__________ __________ __________ _________________
12-2 a.m. 59 176 1,106
2-4 a.m. 52 167 1,552
4-6 a.m. 37 132 1,032
6-8 a.m. 85 583 5,161
8-10 a.m. 339 1,131 10,137
10-12 a.m. 566 1,409 17,151
12-2 p.m. 475 1,215 19,729
2-4 p.m. 586 1,558 14,908
4-6 p.m. 480 1,321 13,408
6-8 p.m. 209 703 5,311
8-10 p.m. 138 478 3,342
10-12 p.m. 96 343 1,902
__________ __________ __________ _________________
Total: 3,122 9,216 94,739
1.2 FIND commands
__________________
Number of FIND commands issued by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 123 1,855 1,978
Davis 855 44 899
Irvine 870 0 870
Los Angeles 28 708 736
Riverside 58 121 179
San Diego 102 643 745
San Francisco 513 0 513
Santa Barbara 21 334 355
Santa Cruz 72 251 323
LBL 0 254 254
LLL 0 678 678
Los Alamos n/a 0 0
Other - UC 3 229 232
U.S. Forestry 0
Other-Network UC n/a 1,454 1,454
_______ ______ _____
2,645 6,571 9,216
Number of FIND commands by database
CC database 9,036
CCT database 180
Total number of FIND commands 9,216
1.3 Records displayed
______________________
Number of Records Displayed by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 1,136 18,922 20,058
Davis 15,915 746 16,661
Irvine 6,500 0 6,500
Los Angeles 245 6,574 6,819
Riverside 402 1,183 1,585
San Diego 487 4,523 5,010
San Francisco 7,470 0 7,470
Santa Barbara 265 5,539 5,804
Santa Cruz 1,368 2,486 3,854
LBL 0 4,023 4,023
LLL 0 6,439 6,439
Los Alamos n/a 0 0
Other - UC 14 1,786 1,800
U.S. Forestry 0
Other-Network UC n/a 8,716 8,716
_______ ______ _____
33,802 60,937 94,739
Number of Records Displayed by database:
CC database 84,212
CCT database 10,527
Total number of Records Displayed 94,739
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.0
Standard deviation in seconds 4.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 4.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) 377:16
Average number of searches completed per session 3.0
Retrievals per search - median 8.0
Retrievals per search - average 656.9
Retrievals per search - standard deviation 7923.9
Percent of searches completed with 0 results 26.5%
Percent of searches entered that are long 0.4%
Percent of long searches completed
(includes partial results) 63.6%
Commands entered, by type, excluding errors:
Total Percentage
__________ __________
FIND 8,208 37.5%
DISPLAY (excluding automatic displays) 6,156 28.1%
HELP 184 0.8%
EXPLAIN 182 0.8%
SET/RESET 1,206 5.5%
SHOW 31 0.1%
ADD ON (AND, OR, AND NOT) 828 3.8%
LOGON or LOGOFF 3,711 17.0%
COMMENT 0 0.0%
SAVE 401 1.8%
USE 5 0.0%
OTHER 965 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 3,859 40.6% 620 16.1% 34 350.0 2630.0
TITLE WORD 2,682 28.2% 821 30.6% 16 731.0 3442.3
EXACT TITLE 109 1.1% 56 51.4% 4 130.3 729.7
JOURNAL 505 5.3% 245 48.5% 391 6037.4 31677.6
EXACT JOURNAL 497 5.2% 318 64.0% 54 2975.3 12603.3
SUBJECT CAT 60 0.6% 5 8.3% 6 50.5 250.8
SUBFILE 36 0.4% 5 13.9% 85 436.6 1275.0
PUBLICATION TYPE 39 0.4% 7 17.9% 28 30937.0 78239.3
LANGUAGE 10 0.1% 2 20.0% 27 280.9 584.7
DATE 152 1.6% 38 25.0% 13 150.1 535.4
ADDED 615 6.5% 429 69.8% 18 31.5 37.2
PERIODICAL 318 3.3% 65 20.4% 4 55.2 418.9
EXACT PE 64 0.7% 3 4.7% 5 46.2 175.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 559 5.9% 147 26.3% 16 639.9 2882.6
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,292 15.8% 628 48.6% 11 148.1 1477.8
Single 6,890 84.2% 1,491 21.6% 33 1059.1 10187.5
DISPLAY commands, by type, excluding automatic displays:
REVIEW 4.8%
SHORT 79.7%
LONG 5.1%
FIELDS 1.9%
PERIODICALS 7.2%
COMMENTS 0.0%
Other 1.3%
2.1 CCT Database Statistics
____________________________
Median session length (minutes:seconds) 0:00
Average session length (minutes:seconds) 0:00
Longest session recorded (minutes:seconds) 55:04
Average number of searches completed per session 1.2
Retrievals per search - median 80.0
Retrievals per search - average 320.8
Retrievals per search - standard deviation 941.5
Percent of searches completed with 0 results 27.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 180 20.6%
DISPLAY (excluding automatic displays) 249 28.5%
HELP 68 7.8%
EXPLAIN 42 4.8%
SET/RESET 105 12.0%
SHOW 15 1.7%
ADD ON (AND, OR, AND NOT) 0 0.0%
LOGON or LOGOFF 130 14.9%
COMMENT 0 0.0%
SAVE 43 4.9%
USE 0 0.0%
OTHER 41 4.7%
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 120 65.2% 41 34.2% 152 284.6 373.1
EXACT JOURNAL 41 22.3% 5 12.2% 143 223.3 296.0
SUBJECT CAT 9 4.9% 0 0.0% 2,056 3000.8 3041.0
SUBFILE 1 0.5% 1 100% 0 0.0 0.0
DATE 0 0.0% 0 0.0% 0 0.0 0.0
ADDED 3 1.6% 0 0.0% 177 202.0 128.3
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 10 5.4% 4 40.0% 2 34.7 78.6
By number of indexes:
Multiple 4 2.2% 1 25.0% 177 202.0 128.3
Single 176 97.8% 49 27.8% 146 449.8 1095.9
DISPLAY commands, by type, excluding automatic displays:
REVIEW 1.9%
ISSUES 62.1%
SHORT 14.3%
LONG 11.8%
PERIODICALS 6.1%
COMMENTS 0.0%
Other 3.8%
2.3 Error, EXPLAIN and HELP statistics (CC & CCT)
__________________________________________________
Percent of commands that contained errors 8.0%
Ten most frequent errors:
1. NS command - no next screen 31.7%
2. First word of command is invalid 25.4%
3. FIND command with invalid index name 9.9%
4. Index invalid in current database 5.1%
5. Max. # of ports to a Z39 db are in use 3.0%
6. DISPLAY command contains invalid word 2.2%
7. D ABS command in database w/o abstracts 2.0%
8. DISPLAY command - no FIND results 1.7%
9. Search term missing from search command 1.7%
10. PS command - no previous screen 1.5%
11. All others 15.9%
Ten most frequent EXPLAIN requests:
1. FIND (CC DB) 15.6%
2. CC INDEXES 14.3%
3. CC GUIDE 13.8%
4. DATABASES 5.4%
5. LOCATE (ARTICLE DBS) 4.5%
6. CCT INDEXES 4.5%
7. DISPLAY 4.0%
8. COMMANDS 4.0%
9. SUBJECT CATEGORY 3.1%
10. CCT DATABASE 3.1%
11. All others 27.7%
Ten most frequent HELP situations:
1. Help requested from START CC command 14.9%
2. First word of command is invalid 13.0%
3. F/BR with index invalid in current DB 10.3%
4. Help requested from SET DB command 6.3%
5. DISPLAY command-first of >1 screen 5.9%
6. FIND command with invalid index name 5.5%
7. DISPLAY command - middle of >1 screen 5.0%
8. FIND command retrieves >1 book 3.6%
9. DISPLAY command-complete in one screen 3.6%
10. FIND command with zero results 2.9%
11. All others 29.0%
Ten most frequent SHOW requests:
1. HISTORY 35.6%
2. SEARCH 15.6%
3. CC SETTINGS 6.7%
4. CC GLOSSARY 6.7%
5. CC NEWS 6.7%
6. GLOSSARY 4.4%
7. SYSTEM NEWS 4.4%
8. 0628 4.4%
9. LIBRARY NEWS 2.2%
10. MAIL SETTINGS 2.2%
11. All others 11.1%
Cmm/yy cc MELVYL CURRENT CONTENTS DATABASE TELNET STATISTICS (monthly)