MELVYL CURRENT CONTENTS DATABASE TELNET STATISTICS
Time period: 06/01/99 through 06/30/99
1.0 SUMMARY STATISTICS
_______________________
1.1 Total sessions:
____________________
Location Library Remote Total
________ _______ ______ _____
Berkeley 896 5,061 5,957
Davis 3,382 390 3,772
Irvine 3,115 0 3,115
Los Angeles 788 2,726 3,514
Riverside 724 582 1,306
San Diego 375 2,228 2,603
San Francisco 1,645 12 1,657
Santa Barbara 741 1,277 2,018
Santa Cruz 650 779 1,429
LBL 0 826 826
LLL 0 862 862
Los Alamos n/a 30 30
Other - UC 21 199 220
U.S. Forestry 5
Other-Network UC n/a 3,053 3,053
_______ ______ _____
12,337 18,025 30,367
Per hour usage:
Time Sessions Finds Records Displayed
__________ __________ __________ _________________
12-2 a.m. 589 2,388 28,344
2-4 a.m. 408 1,379 63,000
4-6 a.m. 392 1,418 12,448
6-8 a.m. 878 3,552 36,324
8-10 a.m. 3,000 9,399 88,776
10-12 a.m. 5,343 16,127 145,476
12-2 p.m. 5,486 16,427 147,580
2-4 p.m. 6,238 18,449 171,683
4-6 p.m. 4,221 13,091 128,528
6-8 p.m. 1,689 5,886 59,037
8-10 p.m. 1,224 3,932 39,242
10-12 p.m. 899 3,351 36,796
__________ __________ __________ _________________
Total: 30,367 95,399 957,234
1.2 FIND commands
__________________
Number of FIND commands issued by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 2,378 16,259 18,637
Davis 10,236 1,022 11,258
Irvine 9,770 0 9,770
Los Angeles 2,183 8,638 10,821
Riverside 1,988 1,851 3,839
San Diego 1,092 6,590 7,682
San Francisco 4,634 26 4,660
Santa Barbara 2,320 4,498 6,818
Santa Cruz 2,221 2,351 4,572
LBL 0 3,087 3,087
LLL 0 4,715 4,715
Los Alamos n/a 72 72
Other - UC 34 469 503
U.S. Forestry 26
Other-Network UC n/a 8,939 8,939
_______ ______ _____
36,856 58,517 95,399
Number of FIND commands by database
CC database 93,489
CCT database 1,910
Total number of FIND commands 95,399
1.3 Records displayed
______________________
Number of Records Displayed by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 28,390 182,983 211,373
Davis 88,650 8,682 97,332
Irvine 120,158 0 120,158
Los Angeles 13,608 90,015 103,623
Riverside 14,777 21,025 35,802
San Diego 7,056 58,329 65,385
San Francisco 42,850 139 42,989
Santa Barbara 22,226 43,412 65,638
Santa Cruz 12,555 23,812 36,367
LBL 0 34,157 34,157
LLL 0 50,367 50,367
Los Alamos n/a 8,723 8,723
Other - UC 220 4,300 4,520
U.S. Forestry 18
Other-Network UC n/a 80,615 80,615
_______ ______ _____
350,490 606,559 957,067
Number of Records Displayed by database:
CC database 887,142
CCT database 70,092
Total number of Records Displayed 957,067
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 0.8
Standard deviation in seconds 3.4
Display response time from receipt of command at
DLA until transmission of a complete screen:
Average in seconds 0.2
Standard deviation in seconds 3.4
2.0 CC Database Statistics
___________________________
Median session length (minutes:seconds) 0:00
Average session length (minutes:seconds) 0:00
Longest session recorded (minutes:seconds) 598:44
Average number of searches completed per session 3.2
Retrievals per search - median 11.0
Retrievals per search - average 562.8
Retrievals per search - standard deviation 5834.6
Percent of searches completed with 0 results 23.1%
Percent of searches entered that are long 0.2%
Percent of long searches completed
(includes partial results) 51.8%
Commands entered, by type, excluding errors:
Total Percentage
__________ __________
FIND 86,694 36.8%
DISPLAY (excluding automatic displays) 68,247 29.0%
HELP 3,223 1.4%
EXPLAIN 3,372 1.4%
SET/RESET 9,946 4.2%
SHOW 504 0.2%
ADD ON (AND, OR, AND NOT) 6,795 2.9%
LOGON or LOGOFF 39,131 16.6%
COMMENT 3 0.0%
SAVE 5,876 2.5%
USE 143 0.1%
OTHER 11,548 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 40,335 42.5% 5,562 13.8% 30 204.9 1189.8
TITLE WORD 31,529 33.2% 8,676 27.5% 18 806.3 6587.6
EXACT TITLE 757 0.8% 453 59.8% 2 162.7 873.2
JOURNAL 4,258 4.5% 1,704 40.0% 791 6300.0 24977.0
EXACT JOURNAL 2,999 3.2% 1,542 51.4% 187 2692.7 7585.2
SUBJECT CAT 379 0.4% 65 17.1% 14 180.2 883.0
SUBFILE 365 0.4% 47 12.9% 27 235.8 1191.9
PUBLICATION TYPE 449 0.5% 88 19.6% 11 2068.5 18599.0
LANGUAGE 120 0.1% 22 18.3% 32 1630.7 7843.3
DATE 1,306 1.4% 202 15.5% 12 132.6 450.9
ADDED 1,933 2.0% 1,272 65.8% 24 40.3 48.6
PERIODICAL 2,575 2.7% 505 19.6% 6 225.1 1845.1
EXACT PE 684 0.7% 142 20.8% 4 99.3 1194.5
RPE 3 0.0% 3 100% 0 0.0 0.0
XRP 0 0.0% 0 0.0% 0 0.0 0.0
COMMENTS 2 0.0% 0 0.0% 4,066 4066.0 0.0
Other indexes 7,220 7.6% 2,284 31.6% 24 965.6 6331.3
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 8,248 9.5% 3,160 38.3% 8 88.5 692.6
Single 78,171 90.5% 16,177 20.7% 32 826.2 7119.5
DISPLAY commands, by type, excluding automatic displays:
REVIEW 3.9%
SHORT 80.8%
LONG 4.8%
FIELDS 1.5%
PERIODICALS 5.5%
COMMENTS 0.0%
Other 3.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) 119:54
Average number of searches completed per session 1.3
Retrievals per search - median 36.0
Retrievals per search - average 356.2
Retrievals per search - standard deviation 2189.8
Percent of searches completed with 0 results 33.7%
Percent of searches entered that are long 0.1%
Percent of long searches completed
(includes partial results) 50.0%
Commands entered, by type, excluding errors:
Total Percentage
__________ __________
FIND 1,903 21.3%
DISPLAY (excluding automatic displays) 3,142 35.2%
HELP 762 8.5%
EXPLAIN 425 4.8%
SET/RESET 971 10.9%
SHOW 110 1.2%
ADD ON (AND, OR, AND NOT) 7 0.1%
LOGON or LOGOFF 1,251 14.0%
COMMENT 0 0.0%
SAVE 21 0.2%
USE 7 0.1%
OTHER 325 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 1,166 61.1% 435 37.3% 102 539.4 2206.9
EXACT JOURNAL 566 29.6% 180 31.8% 83 162.8 252.8
SUBJECT CAT 18 0.9% 3 16.7% 6,242 7860.8 4144.7
SUBFILE 0 0.0% 0 0.0% 0 0.0 0.0
DATE 5 0.3% 1 20.0% 23,453 23451.5 27076.0
ADDED 1 0.1% 1 100% 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 153 8.0% 28 18.3% 5 87.5 412.2
By number of indexes:
Multiple 7 0.4% 5 71.4% 3 3.0 2.8
Single 1,895 99.6% 638 33.7% 81 540.8 2680.4
DISPLAY commands, by type, excluding automatic displays:
REVIEW 3.3%
ISSUES 45.3%
SHORT 11.7%
LONG 29.3%
PERIODICALS 7.9%
COMMENTS 0.0%
Other 2.5%
2.3 Error, EXPLAIN and HELP statistics (CC & CCT)
__________________________________________________
Percent of commands that contained errors 9.4%
Ten most frequent errors:
1. NS command - no next screen 30.6%
2. First word of command is invalid 29.9%
3. FIND command with invalid index name 10.1%
4. Index invalid in current database 5.9%
5. DISPLAY command contains invalid word 2.2%
6. Search term missing from search command 2.0%
7. PS command - no previous screen 1.8%
8. D ABS command in database w/o abstracts 1.7%
9. Valid command at an inappropriate time 1.4%
10. F SUB CAT search with invalid SC 1.1%
11. All others 13.4%
Ten most frequent EXPLAIN requests:
1. CC GUIDE 16.4%
2. FIND (CC DB) 13.9%
3. CC INDEXES 11.2%
4. LOCATE (ARTICLE DBS) 7.3%
5. COMMANDS 6.8%
6. Unrecognized term 4.4%
7. CC DATABASE 2.9%
8. DISPLAY 2.7%
9. CCT INDEXES 2.5%
10. DATABASES 2.5%
11. All others 29.3%
Ten most frequent HELP situations:
1. Help requested from START CC command 15.8%
2. First word of command is invalid 13.1%
3. F/BR with index invalid in current DB 9.9%
4. FIND command with invalid index name 7.4%
5. Help requested from SET DB command 6.5%
6. DISPLAY command - middle of >1 screen 5.4%
7. DISPLAY command-first of >1 screen 5.1%
8. FIND command with zero results 5.0%
9. FIND command retrieves >1 book 3.4%
10. DISPLAY command-complete in one screen 2.8%
11. All others 25.7%
Ten most frequent SHOW requests:
1. HISTORY 47.1%
2. SEARCH 14.5%
3. MAIL STATUS 6.8%
4. SYSTEM NEWS 5.8%
5. SC LIST (CC DBS) 5.6%
6. CC SETTINGS 4.3%
7. CC NEWS 3.8%
8. CC GLOSSARY 2.8%
9. MAIL SETTINGS 2.0%
10. DATABASES 1.0%
11. All others 6.4%