MELVYL CURRENT CONTENTS DATABASE TELNET STATISTICS
Time period: 10/01/99 through 10/31/99
1.0 SUMMARY STATISTICS
_______________________
1.1 Total sessions:
____________________
Location Library Remote Total
________ _______ ______ _____
Berkeley 1,433 5,584 7,017
Davis 2,748 247 2,995
Irvine 2,629 0 2,629
Los Angeles 743 2,347 3,090
Riverside 603 526 1,129
San Diego 477 1,669 2,146
San Francisco 1,541 16 1,557
Santa Barbara 517 1,155 1,672
Santa Cruz 823 741 1,564
LBL 0 796 796
LLL 0 883 883
Los Alamos n/a 4 4
Other - UC 14 278 292
U.S. Forestry 0
Other-Network UC n/a 2,660 2,660
_______ ______ _____
11,528 16,906 28,434
Per hour usage:
Time Sessions Finds Records Displayed
__________ __________ __________ _________________
12-2 a.m. 501 1,943 20,014
2-4 a.m. 294 1,237 69,122
4-6 a.m. 318 1,116 37,442
6-8 a.m. 752 2,981 28,201
8-10 a.m. 2,770 8,798 85,012
10-12 a.m. 5,001 14,707 133,779
12-2 p.m. 5,018 14,179 133,182
2-4 p.m. 5,969 16,429 158,742
4-6 p.m. 4,134 11,983 107,864
6-8 p.m. 1,654 5,101 51,968
8-10 p.m. 1,174 3,728 34,541
10-12 p.m. 849 2,973 24,584
__________ __________ __________ _________________
Total: 28,434 85,175 884,451
1.2 FIND commands
__________________
Number of FIND commands issued by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 3,684 16,569 20,253
Davis 8,103 739 8,842
Irvine 8,505 0 8,505
Los Angeles 2,530 6,425 8,955
Riverside 1,594 1,736 3,330
San Diego 1,170 4,907 6,077
San Francisco 4,373 45 4,418
Santa Barbara 1,410 3,517 4,927
Santa Cruz 2,308 2,111 4,419
LBL 0 2,614 2,614
LLL 0 5,118 5,118
Los Alamos n/a 9 9
Other - UC 30 542 572
U.S. Forestry 0
Other-Network UC n/a 7,136 7,136
_______ ______ _____
33,707 51,468 85,175
Number of FIND commands by database
CC database 83,482
CCT database 1,693
Total number of FIND commands 85,175
1.3 Records displayed
______________________
Number of Records Displayed by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 37,315 168,924 206,239
Davis 69,082 5,026 74,108
Irvine 148,363 0 148,363
Los Angeles 19,457 66,950 86,407
Riverside 16,238 17,443 33,681
San Diego 11,385 42,002 53,387
San Francisco 33,636 603 34,239
Santa Barbara 10,493 37,822 48,315
Santa Cruz 19,029 21,300 40,329
LBL 0 27,244 27,244
LLL 0 57,967 57,967
Los Alamos n/a 13 13
Other - UC 239 6,864 7,103
U.S. Forestry 0
Other-Network UC n/a 67,056 67,056
_______ ______ _____
365,237 519,214 884,451
Number of Records Displayed by database:
CC database 822,449
CCT database 62,002
Total number of Records Displayed 884,451
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 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.2
Standard deviation in seconds 5.2
Display response time from receipt of command at
DLA until transmission of a complete screen:
Average in seconds 0.2
Standard deviation in seconds 5.2
2.0 CC Database Statistics
___________________________
Median session length (minutes:seconds) 0:00
Average session length (minutes:seconds) 0:00
Longest session recorded (minutes:seconds) 431:27
Average number of searches completed per session 3.1
Retrievals per search - median 10.0
Retrievals per search - average 559.2
Retrievals per search - standard deviation 5029.8
Percent of searches completed with 0 results 23.5%
Percent of searches entered that are long 0.3%
Percent of long searches completed
(includes partial results) 54.7%
Commands entered, by type, excluding errors:
Total Percentage
__________ __________
FIND 76,915 36.8%
DISPLAY (excluding automatic displays) 58,782 28.1%
HELP 3,510 1.7%
EXPLAIN 3,239 1.5%
SET/RESET 9,514 4.5%
SHOW 523 0.3%
ADD ON (AND, OR, AND NOT) 6,567 3.1%
LOGON or LOGOFF 35,657 17.0%
COMMENT 0 0.0%
SAVE 4,166 2.0%
USE 81 0.0%
OTHER 10,212 4.9%
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 35,370 41.8% 4,932 13.9% 30 224.4 1275.7
TITLE WORD 28,609 33.8% 8,016 28.0% 18 791.3 5435.5
EXACT TITLE 653 0.8% 368 56.4% 3 276.8 2160.0
JOURNAL 4,162 4.9% 1,684 40.5% 530 5157.5 19399.6
EXACT JOURNAL 3,093 3.7% 1,683 54.4% 235 2712.5 7893.2
SUBJECT CAT 329 0.4% 60 18.2% 18 154.8 1018.4
SUBFILE 216 0.3% 26 12.0% 28 278.4 946.5
PUBLICATION TYPE 437 0.5% 104 23.8% 11 2427.7 20408.1
LANGUAGE 58 0.1% 13 22.4% 63 1400.7 7672.0
DATE 1,142 1.4% 170 14.9% 13 148.2 1113.0
ADDED 2,103 2.5% 1,456 69.2% 23 38.3 49.3
PERIODICAL 2,624 3.1% 457 17.4% 5 159.1 1336.4
EXACT PE 585 0.7% 82 14.0% 3 18.0 99.8
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,157 6.1% 1,551 30.1% 24 1028.5 5391.2
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 7,718 10.1% 3,101 40.2% 8 83.2 728.6
Single 68,851 89.9% 14,316 20.8% 31 811.1 6035.1
DISPLAY commands, by type, excluding automatic displays:
REVIEW 3.7%
SHORT 80.9%
LONG 4.6%
FIELDS 1.4%
PERIODICALS 6.4%
COMMENTS 0.0%
Other 3.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) 160:06
Average number of searches completed per session 1.1
Retrievals per search - median 41.0
Retrievals per search - average 411.1
Retrievals per search - standard deviation 1946.4
Percent of searches completed with 0 results 31.8%
Percent of searches entered that are long 0.2%
Percent of long searches completed
(includes partial results) 33.3%
Commands entered, by type, excluding errors:
Total Percentage
__________ __________
FIND 1,678 19.8%
DISPLAY (excluding automatic displays) 2,458 28.9%
HELP 1,024 12.1%
EXPLAIN 417 4.9%
SET/RESET 996 11.7%
SHOW 167 2.0%
ADD ON (AND, OR, AND NOT) 15 0.2%
LOGON or LOGOFF 1,359 16.0%
COMMENT 0 0.0%
SAVE 18 0.2%
USE 6 0.1%
OTHER 355 4.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 1,101 65.4% 391 35.5% 103 512.9 2117.8
EXACT JOURNAL 456 27.1% 129 28.3% 82 177.7 291.6
SUBJECT CAT 36 2.1% 2 5.6% 5,022 5656.4 3276.7
SUBFILE 0 0.0% 0 0.0% 0 0.0 0.0
DATE 8 0.5% 1 12.5% 4 8250.0 14080.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 82 4.9% 15 18.3% 5 291.5 1567.9
By number of indexes:
Multiple 7 0.4% 2 28.6% 1 5.6 8.7
Single 1,669 99.6% 534 32.0% 94 609.5 2349.3
DISPLAY commands, by type, excluding automatic displays:
REVIEW 4.7%
ISSUES 46.6%
SHORT 18.7%
LONG 24.1%
PERIODICALS 4.0%
COMMENTS 0.0%
Other 1.9%
2.3 Error, EXPLAIN and HELP statistics (CC & CCT)
__________________________________________________
Percent of commands that contained errors 9.9%
Ten most frequent errors:
1. First word of command is invalid 31.0%
2. NS command - no next screen 27.9%
3. FIND command with invalid index name 10.8%
4. Index invalid in current database 6.1%
5. DISPLAY command contains invalid word 2.1%
6. PS command - no previous screen 2.0%
7. Search term missing from search command 1.9%
8. D ABS command in database w/o abstracts 1.5%
9. Valid command at an inappropriate time 1.4%
10. F SUB CAT search with invalid SC 1.4%
11. All others 14.0%
Ten most frequent EXPLAIN requests:
1. CC GUIDE 15.9%
2. FIND (CC DB) 12.6%
3. CC INDEXES 12.1%
4. LOCATE (ARTICLE DBS) 8.5%
5. COMMANDS 6.9%
6. Unrecognized term 4.0%
7. CC DATABASE 3.4%
8. DATABASES 3.0%
9. CCT INDEXES 2.2%
10. DISPLAY 2.2%
11. All others 29.3%
Ten most frequent HELP situations:
1. Help requested from START CC command 17.0%
2. First word of command is invalid 14.6%
3. F/BR with index invalid in current DB 9.5%
4. FIND command with invalid index name 7.7%
5. Help requested from SET DB command 7.1%
6. FIND command with zero results 5.0%
7. DISPLAY command - middle of >1 screen 4.6%
8. DISPLAY command-first of >1 screen 4.1%
9. FIND command retrieves >1 book 3.2%
10. DISPLAY command-complete in one screen 2.6%
11. All others 24.7%
Ten most frequent SHOW requests:
1. HISTORY 35.0%
2. SEARCH 15.5%
3. MAIL STATUS 10.3%
4. SYSTEM NEWS 9.6%
5. CC NEWS 5.9%
6. SC LIST (CC DBS) 3.8%
7. CC GLOSSARY 3.5%
8. LIBRARY NEWS 1.9%
9. CC SETTINGS 1.9%
10. MAIL SETTINGS 1.6%
11. All others 10.9%