MELVYL CURRENT CONTENTS DATABASE TELNET STATISTICS
Time period: 05/01/00 through 05/31/00
1.0 SUMMARY STATISTICS
_______________________
1.1 Total sessions:
____________________
Location Library Remote Total
________ _______ ______ _____
Berkeley 545 2,821 3,366
Davis 1,862 153 2,015
Irvine 1,463 0 1,463
Los Angeles 400 1,189 1,589
Riverside 436 382 818
San Diego 304 1,197 1,501
San Francisco 1,129 0 1,129
Santa Barbara 327 860 1,187
Santa Cruz 409 429 838
LBL 0 430 430
LLL 0 305 305
Los Alamos n/a 0 0
Other - UC 10 163 173
U.S. Forestry 0
Other-Network UC n/a 1,750 1,750
_______ ______ _____
6,885 9,679 16,564
Per hour usage:
Time Sessions Finds Records Displayed
__________ __________ __________ _________________
12-2 a.m. 301 1,124 10,427
2-4 a.m. 189 843 26,333
4-6 a.m. 224 838 8,503
6-8 a.m. 370 1,695 19,497
8-10 a.m. 1,692 5,165 55,228
10-12 a.m. 2,917 8,462 75,267
12-2 p.m. 2,753 7,878 77,872
2-4 p.m. 3,382 9,173 84,846
4-6 p.m. 2,371 7,004 61,161
6-8 p.m. 1,128 3,406 35,485
8-10 p.m. 729 2,219 22,686
10-12 p.m. 508 1,744 15,026
__________ __________ __________ _________________
Total: 16,564 49,551 492,331
1.2 FIND commands
__________________
Number of FIND commands issued by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 1,544 8,476 10,020
Davis 5,251 399 5,650
Irvine 4,481 0 4,481
Los Angeles 971 3,802 4,773
Riverside 1,326 1,143 2,469
San Diego 754 3,111 3,865
San Francisco 3,131 0 3,131
Santa Barbara 847 2,851 3,698
Santa Cruz 1,173 1,245 2,418
LBL 0 1,312 1,312
LLL 0 2,830 2,830
Los Alamos n/a 0 0
Other - UC 21 481 502
U.S. Forestry 0
Other-Network UC n/a 4,402 4,402
_______ ______ _____
19,499 30,052 49,551
Number of FIND commands by database
CC database 48,640
CCT database 911
Total number of FIND commands 49,551
1.3 Records displayed
______________________
Number of Records Displayed by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 19,242 90,593 109,835
Davis 43,824 2,122 45,946
Irvine 61,858 0 61,858
Los Angeles 6,305 39,344 45,649
Riverside 7,399 13,626 21,025
San Diego 5,127 25,154 30,281
San Francisco 21,568 0 21,568
Santa Barbara 5,790 29,317 35,107
Santa Cruz 8,174 12,490 20,664
LBL 0 19,231 19,231
LLL 0 32,609 32,609
Los Alamos n/a 0 0
Other - UC 760 5,678 6,438
U.S. Forestry 0
Other-Network UC n/a 42,120 42,120
_______ ______ _____
180,047 312,284 492,331
Number of Records Displayed by database:
CC database 460,562
CCT database 31,769
Total number of Records Displayed 492,331
1.4 Relative Use of Databases
______________________________
Relative use of CC vs. CCT databases:
Percent of CC sessions 95.7%
Percent of CCT sessions 4.3%
Percent of searches done in the CC database 98.2%
Percent of searches done in the CCT database 1.8%
1.5 Response time
__________________
Search response time from receipt of command at
DLA until transmission of response:
Average in seconds 1.3
Standard deviation in seconds 6.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 6.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) 685:24
Average number of searches completed per session 3.1
Retrievals per search - median 10.0
Retrievals per search - average 517.0
Retrievals per search - standard deviation 4469.8
Percent of searches completed with 0 results 24.6%
Percent of searches entered that are long 0.3%
Percent of long searches completed
(includes partial results) 43.8%
Commands entered, by type, excluding errors:
Total Percentage
__________ __________
FIND 45,103 37.7%
DISPLAY (excluding automatic displays) 33,234 27.8%
HELP 1,467 1.2%
EXPLAIN 1,426 1.2%
SET/RESET 5,680 4.7%
SHOW 259 0.2%
ADD ON (AND, OR, AND NOT) 3,537 3.0%
LOGON or LOGOFF 21,108 17.6%
COMMENT 0 0.0%
SAVE 1,916 1.6%
USE 37 0.0%
OTHER 5,872 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 20,980 41.7% 2,901 13.8% 30 223.2 1488.4
TITLE WORD 16,220 32.2% 4,776 29.4% 16 987.9 6862.0
EXACT TITLE 364 0.7% 191 52.5% 3 232.4 963.0
JOURNAL 2,332 4.6% 1,034 44.3% 437 4042.6 10950.2
EXACT JOURNAL 2,186 4.3% 1,299 59.4% 64 1486.9 5293.6
SUBJECT CAT 223 0.4% 32 14.3% 11 87.4 770.0
SUBFILE 127 0.3% 13 10.2% 28 338.2 1306.4
PUBLICATION TYPE 153 0.3% 30 19.6% 20 5054.3 31451.5
LANGUAGE 23 0.0% 3 13.0% 79 210.8 420.8
DATE 628 1.2% 99 15.8% 12 105.1 430.9
ADDED 2,043 4.1% 1,416 69.3% 26 50.8 104.8
PERIODICAL 1,409 2.8% 293 20.8% 6 229.5 1487.8
EXACT PE 293 0.6% 41 14.0% 4 86.6 530.9
RPE 0 0.0% 0 0.0% 0 0.0 0.0
XRP 1 0.0% 0 0.0% 1,410 1410.0 0.0
COMMENTS 0 0.0% 0 0.0% 0 0.0 0.0
Other indexes 3,321 6.6% 1,011 30.4% 27 825.1 4857.0
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,330 11.9% 2,370 44.5% 10 64.9 393.3
Single 39,549 88.1% 8,368 21.2% 31 786.2 5541.0
DISPLAY commands, by type, excluding automatic displays:
REVIEW 4.9%
SHORT 81.3%
LONG 4.3%
FIELDS 1.6%
PERIODICALS 5.8%
COMMENTS 0.0%
Other 2.1%
2.1 CCT Database Statistics
____________________________
Median session length (minutes:seconds) 0:00
Average session length (minutes:seconds) 0:00
Longest session recorded (minutes:seconds) 120:49
Average number of searches completed per session 1.3
Retrievals per search - median 33.0
Retrievals per search - average 271.6
Retrievals per search - standard deviation 1698.9
Percent of searches completed with 0 results 34.5%
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 904 21.0%
DISPLAY (excluding automatic displays) 1,406 32.7%
HELP 431 10.0%
EXPLAIN 184 4.3%
SET/RESET 494 11.5%
SHOW 70 1.6%
ADD ON (AND, OR, AND NOT) 7 0.2%
LOGON or LOGOFF 619 14.4%
COMMENT 0 0.0%
SAVE 27 0.6%
USE 5 0.1%
OTHER 154 3.6%
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 630 69.6% 248 39.4% 108 504.1 2442.4
EXACT JOURNAL 198 21.9% 45 22.7% 84 190.3 300.1
SUBJECT CAT 2 0.2% 0 0.0% 10,562 10562.0 8763.9
SUBFILE 0 0.0% 0 0.0% 0 0.0 0.0
DATE 5 0.6% 4 80.0% 11 11.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 70 7.7% 19 27.1% 8 39.9 89.7
By number of indexes:
Multiple 2 0.2% 2 100% 0 0.0 0.0
Single 901 99.8% 312 34.6% 84 415.7 2097.8
DISPLAY commands, by type, excluding automatic displays:
REVIEW 5.9%
ISSUES 45.8%
SHORT 16.0%
LONG 24.3%
PERIODICALS 6.6%
COMMENTS 0.0%
Other 1.4%
2.3 Error, EXPLAIN and HELP statistics (CC & CCT)
__________________________________________________
Percent of commands that contained errors 9.3%
Ten most frequent errors:
1. NS command - no next screen 31.3%
2. First word of command is invalid 29.2%
3. FIND command with invalid index name 10.0%
4. Index invalid in current database 6.4%
5. Search term missing from search command 2.1%
6. PS command - no previous screen 1.9%
7. DISPLAY command contains invalid word 1.9%
8. D ABS command in database w/o abstracts 1.7%
9. Valid command at an inappropriate time 1.5%
10. F SUB CAT search with invalid SC 1.3%
11. All others 12.7%
Ten most frequent EXPLAIN requests:
1. CC GUIDE 16.6%
2. FIND (CC DB) 13.4%
3. CC INDEXES 11.3%
4. LOCATE (ARTICLE DBS) 8.0%
5. COMMANDS 7.3%
6. Unrecognized term 4.2%
7. DATABASES 3.4%
8. CCT INDEXES 3.2%
9. CC DATABASE 2.5%
10. ADD-ON SEARCH 2.4%
11. All others 27.6%
Ten most frequent HELP situations:
1. Help requested from START CC command 14.9%
2. First word of command is invalid 13.4%
3. F/BR with index invalid in current DB 12.0%
4. Help requested from SET DB command 7.6%
5. FIND command with invalid index name 7.4%
6. DISPLAY command - middle of >1 screen 5.1%
7. FIND command with zero results 4.9%
8. DISPLAY command-first of >1 screen 4.0%
9. FIND command retrieves >1 book 3.4%
10. NS command - no next screen 2.7%
11. All others 24.6%
Ten most frequent SHOW requests:
1. HISTORY 31.7%
2. MAIL STATUS 14.1%
3. SYSTEM NEWS 11.3%
4. SEARCH 10.7%
5. CC SETTINGS 5.3%
6. CC GLOSSARY 4.1%
7. SC LIST (CC DBS) 3.8%
8. CC NEWS 3.4%
9. LIBRARY NEWS 2.8%
10. MAIL SETTINGS 1.9%
11. All others 11.0%
Cmm/yy cc MELVYL CURRENT CONTENTS DATABASE TELNET STATISTICS (monthly)