MELVYL CURRENT CONTENTS DATABASE TELNET STATISTICS
Time period: 11/01/00 through 11/30/00
1.0 SUMMARY STATISTICS
_______________________
1.1 Total sessions:
____________________
Location Library Remote Total
________ _______ ______ _____
Berkeley 594 3,422 4,016
Davis 1,698 156 1,854
Irvine 1,277 0 1,277
Los Angeles 295 1,262 1,557
Riverside 256 278 534
San Diego 227 1,040 1,267
San Francisco 997 0 997
Santa Barbara 228 553 781
Santa Cruz 197 438 635
LBL 0 513 513
LLL 0 296 296
Los Alamos n/a 0 0
Other - UC 3 207 210
U.S. Forestry 0
Other-Network UC n/a 1,716 1,716
_______ ______ _____
5,772 9,881 15,653
Per hour usage:
Time Sessions Finds Records Displayed
__________ __________ __________ _________________
12-2 a.m. 240 781 7,218
2-4 a.m. 211 649 5,704
4-6 a.m. 199 686 5,617
6-8 a.m. 379 2,435 28,655
8-10 a.m. 1,710 5,337 92,587
10-12 a.m. 2,851 7,906 82,614
12-2 p.m. 2,595 7,145 76,403
2-4 p.m. 3,082 8,124 80,998
4-6 p.m. 2,258 5,820 57,622
6-8 p.m. 912 2,615 25,648
8-10 p.m. 741 2,275 32,293
10-12 p.m. 476 1,305 14,336
__________ __________ __________ _________________
Total: 15,654 45,078 509,695
1.2 FIND commands
__________________
Number of FIND commands issued by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 1,864 9,258 11,122
Davis 5,200 335 5,535
Irvine 3,518 0 3,518
Los Angeles 746 3,631 4,377
Riverside 511 740 1,251
San Diego 608 2,885 3,493
San Francisco 3,067 0 3,067
Santa Barbara 488 1,751 2,239
Santa Cruz 373 1,164 1,537
LBL 0 1,388 1,388
LLL 0 2,812 2,812
Los Alamos n/a 0 0
Other - UC 5 431 436
U.S. Forestry 0
Other-Network UC n/a 4,299 4,299
_______ ______ _____
16,380 28,694 45,074
Number of FIND commands by database
CC database 43,962
CCT database 1,116
Total number of FIND commands 45,074
1.3 Records displayed
______________________
Number of Records Displayed by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 19,251 92,165 111,416
Davis 93,417 2,786 96,203
Irvine 40,538 0 40,538
Los Angeles 8,680 36,645 45,325
Riverside 4,277 8,230 12,507
San Diego 6,186 24,628 30,814
San Francisco 39,512 0 39,512
Santa Barbara 4,628 17,731 22,359
Santa Cruz 2,882 12,141 15,023
LBL 0 17,316 17,316
LLL 0 28,171 28,171
Los Alamos n/a 0 0
Other - UC 5 6,150 6,155
U.S. Forestry 0
Other-Network UC n/a 44,288 44,288
_______ ______ _____
219,376 290,251 509,627
Number of Records Displayed by database:
CC database 462,374
CCT database 47,321
Total number of Records Displayed 509,627
1.4 Relative Use of Databases
______________________________
Relative use of CC vs. CCT databases:
Percent of CC sessions 94.8%
Percent of CCT sessions 5.2%
Percent of searches done in the CC database 97.5%
Percent of searches done in the CCT database 2.5%
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.3
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.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) 557:06
Average number of searches completed per session 3.0
Retrievals per search - median 11.0
Retrievals per search - average 625.4
Retrievals per search - standard deviation 6363.5
Percent of searches completed with 0 results 24.3%
Percent of searches entered that are long 0.3%
Percent of long searches completed
(includes partial results) 60.7%
Commands entered, by type, excluding errors:
Total Percentage
__________ __________
FIND 40,912 36.6%
DISPLAY (excluding automatic displays) 31,979 28.6%
HELP 1,569 1.4%
EXPLAIN 1,549 1.4%
SET/RESET 5,300 4.7%
SHOW 259 0.2%
ADD ON (AND, OR, AND NOT) 3,050 2.7%
LOGON or LOGOFF 19,787 17.7%
COMMENT 0 0.0%
SAVE 2,172 1.9%
USE 47 0.0%
OTHER 5,270 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:
PERSONAL AUTHOR 19,406 42.2% 2,721 14.0% 32 238.0 1406.5
TITLE WORD 14,037 30.5% 4,186 29.8% 18 958.5 6438.5
EXACT TITLE 247 0.5% 100 40.5% 2 149.9 700.0
JOURNAL 2,556 5.6% 989 38.7% 568 4776.0 21032.3
EXACT JOURNAL 2,315 5.0% 1,387 59.9% 63 2245.0 6997.7
SUBJECT CAT 200 0.4% 33 16.5% 17 88.0 364.8
SUBFILE 93 0.2% 4 4.3% 38 366.2 1196.5
PUBLICATION TYPE 230 0.5% 40 17.4% 16 7289.2 38417.8
LANGUAGE 60 0.1% 11 18.3% 44 1393.6 6939.5
DATE 541 1.2% 74 13.7% 9 164.7 1095.7
ADDED 2,047 4.5% 1,509 73.7% 25 37.6 39.6
PERIODICAL 1,174 2.6% 220 18.7% 5 177.2 2165.9
EXACT PE 303 0.7% 36 11.9% 3 21.9 106.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 2,753 6.0% 827 30.0% 22 968.2 4830.1
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 5,120 12.6% 2,413 47.1% 10 109.7 1258.6
Single 35,625 87.4% 7,287 20.5% 34 919.0 7373.8
DISPLAY commands, by type, excluding automatic displays:
REVIEW 3.7%
SHORT 81.4%
LONG 5.3%
FIELDS 1.5%
PERIODICALS 5.8%
COMMENTS 0.0%
Other 2.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) 87:58
Average number of searches completed per session 1.4
Retrievals per search - median 39.0
Retrievals per search - average 450.8
Retrievals per search - standard deviation 2097.1
Percent of searches completed with 0 results 32.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 1,105 21.4%
DISPLAY (excluding automatic displays) 1,782 34.5%
HELP 474 9.2%
EXPLAIN 223 4.3%
SET/RESET 600 11.6%
SHOW 86 1.7%
ADD ON (AND, OR, AND NOT) 11 0.2%
LOGON or LOGOFF 701 13.6%
COMMENT 0 0.0%
SAVE 0 0.0%
USE 1 0.0%
OTHER 182 3.5%
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 765 69.0% 294 38.4% 93 507.2 2376.1
EXACT JOURNAL 237 21.4% 52 21.9% 135 265.3 430.9
SUBJECT CAT 21 1.9% 1 4.8% 9,297 8831.6 3939.5
SUBFILE 0 0.0% 0 0.0% 0 0.0 0.0
DATE 4 0.4% 1 25.0% 2 2.7 1.2
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 82 7.4% 11 13.4% 3 277.6 1954.4
By number of indexes:
Multiple 4 0.4% 1 25.0% 2 2.7 1.2
Single 1,101 99.6% 357 32.4% 92 650.9 2497.5
DISPLAY commands, by type, excluding automatic displays:
REVIEW 5.7%
ISSUES 47.7%
SHORT 17.6%
LONG 21.6%
PERIODICALS 6.5%
COMMENTS 0.0%
Other 0.9%
2.3 Error, EXPLAIN and HELP statistics (CC & CCT)
__________________________________________________
Percent of commands that contained errors 9.4%
Ten most frequent errors:
1. First word of command is invalid 30.2%
2. NS command - no next screen 29.1%
3. FIND command with invalid index name 10.1%
4. Index invalid in current database 5.8%
5. DISPLAY command contains invalid word 2.4%
6. PS command - no previous screen 2.0%
7. Search term missing from search command 2.0%
8. D ABS command in database w/o abstracts 1.8%
9. Valid command at an inappropriate time 1.6%
10. F SUB CAT search with invalid SC 1.5%
11. All others 13.5%
Ten most frequent EXPLAIN requests:
1. CC GUIDE 15.7%
2. FIND (CC DB) 11.5%
3. LOCATE (ARTICLE DBS) 10.1%
4. CC INDEXES 10.0%
5. COMMANDS 6.9%
6. Unrecognized term 4.4%
7. DISPLAY 3.2%
8. ADD-ON SEARCH 3.0%
9. CC DATABASE 2.9%
10. DATABASES 2.8%
11. All others 29.4%
Ten most frequent HELP situations:
1. Help requested from START CC command 14.3%
2. First word of command is invalid 13.8%
3. F/BR with index invalid in current DB 11.0%
4. FIND command with invalid index name 8.3%
5. Help requested from SET DB command 7.8%
6. DISPLAY command-first of >1 screen 5.0%
7. DISPLAY command - middle of >1 screen 4.6%
8. FIND command with zero results 3.9%
9. DISPLAY command-complete in one screen 3.1%
10. FIND command retrieves >1 book 2.8%
11. All others 25.3%
Ten most frequent SHOW requests:
1. HISTORY 37.1%
2. SYSTEM NEWS 12.0%
3. SEARCH 8.8%
4. SC LIST (CC DBS) 7.3%
5. CC NEWS 6.1%
6. CC GLOSSARY 5.3%
7. CC SETTINGS 3.8%
8. LIBRARY NEWS 3.5%
9. MAIL STATUS 2.0%
10. UPDATE 1.5%
11. All others 12.6%
Cmm/yy cc MELVYL CURRENT CONTENTS DATABASE TELNET STATISTICS (monthly)