MELVYL CURRENT CONTENTS DATABASE TELNET STATISTICS
Time period: 06/01/01 through 06/30/01
1.0 SUMMARY STATISTICS
_______________________
1.1 Total sessions:
____________________
Location Library Remote Total
________ _______ ______ _____
Berkeley 189 2,114 2,303
Davis 1,250 102 1,352
Irvine 831 0 831
Los Angeles 3 1,028 1,031
Riverside 85 206 291
San Diego 158 955 1,113
San Francisco 652 0 652
Santa Barbara 23 496 519
Santa Cruz 70 244 314
LBL 0 370 370
LLL 0 198 198
Los Alamos n/a 0 0
Other - UC 2 148 150
U.S. Forestry 0
Other-Network UC n/a 2,328 2,328
_______ ______ _____
3,263 8,189 11,452
Per hour usage:
Time Sessions Finds Records Displayed
__________ __________ __________ _________________
12-2 a.m. 240 1,069 9,740
2-4 a.m. 131 743 5,427
4-6 a.m. 153 574 4,657
6-8 a.m. 394 2,887 30,827
8-10 a.m. 1,320 4,756 46,197
10-12 a.m. 2,206 6,128 56,449
12-2 p.m. 1,929 5,879 52,891
2-4 p.m. 2,137 5,730 57,380
4-6 p.m. 1,460 4,284 49,005
6-8 p.m. 598 1,909 21,278
8-10 p.m. 445 1,569 20,902
10-12 p.m. 439 1,690 13,309
__________ __________ __________ _________________
Total: 11,452 37,218 368,062
1.2 FIND commands
__________________
Number of FIND commands issued by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 567 6,148 6,715
Davis 4,004 261 4,265
Irvine 2,683 0 2,683
Los Angeles 3 2,883 2,886
Riverside 159 675 834
San Diego 670 2,586 3,256
San Francisco 1,809 0 1,809
Santa Barbara 57 1,367 1,424
Santa Cruz 133 796 929
LBL 0 1,151 1,151
LLL 0 3,519 3,519
Los Alamos n/a 0 0
Other - UC 3 457 460
U.S. Forestry 0
Other-Network UC n/a 7,287 7,287
_______ ______ _____
10,088 27,130 37,218
Number of FIND commands by database
CC database 36,634
CCT database 584
Total number of FIND commands 37,218
1.3 Records displayed
______________________
Number of Records Displayed by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 6,517 61,361 67,878
Davis 34,989 1,730 36,719
Irvine 20,116 0 20,116
Los Angeles 11 27,317 27,328
Riverside 1,136 5,688 6,824
San Diego 5,900 20,791 26,691
San Francisco 49,692 0 49,692
Santa Barbara 599 14,972 15,571
Santa Cruz 2,672 7,269 9,941
LBL 0 11,328 11,328
LLL 0 43,482 43,482
Los Alamos n/a 0 0
Other - UC 15 3,442 3,457
U.S. Forestry 0
Other-Network UC n/a 49,035 49,035
_______ ______ _____
121,647 246,415 368,062
Number of Records Displayed by database:
CC database 314,851
CCT database 53,211
Total number of Records Displayed 368,062
1.4 Relative Use of Databases
______________________________
Relative use of CC vs. CCT databases:
Percent of CC sessions 96.6%
Percent of CCT sessions 3.4%
Percent of searches done in the CC database 98.4%
Percent of searches done in the CCT database 1.6%
1.5 Response time
__________________
Search response time from receipt of command at
DLA until transmission of response:
Average in seconds 0.9
Standard deviation in seconds 4.1
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.1
2.0 CC Database Statistics
___________________________
Median session length (minutes:seconds) 0:00
Average session length (minutes:seconds) 0:00
Longest session recorded (minutes:seconds) 519:51
Average number of searches completed per session 3.3
Retrievals per search - median 8.0
Retrievals per search - average 1412.6
Retrievals per search - standard deviation 16095
Percent of searches completed with 0 results 26.8%
Percent of searches entered that are long 0.4%
Percent of long searches completed
(includes partial results) 65.9%
Commands entered, by type, excluding errors:
Total Percentage
__________ __________
FIND 32,873 38.5%
DISPLAY (excluding automatic displays) 24,320 28.5%
HELP 500 0.6%
EXPLAIN 547 0.6%
SET/RESET 4,571 5.4%
SHOW 118 0.1%
ADD ON (AND, OR, AND NOT) 3,761 4.4%
LOGON or LOGOFF 13,629 16.0%
COMMENT 0 0.0%
SAVE 1,411 1.7%
USE 43 0.1%
OTHER 3,529 4.1%
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 15,160 39.3% 2,472 16.3% 31 290.7 1908.2
TITLE WORD 10,343 26.8% 3,357 32.5% 14 1056.5 9108.2
EXACT TITLE 510 1.3% 246 48.2% 3 519.2 4657.1
JOURNAL 1,797 4.7% 843 46.9% 242 4521.4 20448.7
EXACT JOURNAL 2,579 6.7% 1,504 58.3% 50 1504.4 7038.8
SUBJECT CAT 145 0.4% 19 13.1% 11 86.9 314.0
SUBFILE 85 0.2% 7 8.2% 18 1634.3 4930.8
PUBLICATION TYPE 103 0.3% 15 14.6% 17 3581.8 25747.0
LANGUAGE 17 0.0% 3 17.6% 152 703.4 1249.9
DATE 623 1.6% 107 17.2% 8 119.9 479.1
ADDED 3,123 8.1% 2,138 68.5% 23 39.4 49.4
PERIODICAL 2,029 5.3% 345 17.0% 5 111.8 1168.0
EXACT PE 444 1.2% 53 11.9% 4 22.2 125.4
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 1,636 4.2% 495 30.3% 22 1014.4 6585.5
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,733 17.5% 2,928 51.1% 11 105.4 909.6
Single 27,034 82.5% 5,703 21.1% 30 865.2 7523.2
DISPLAY commands, by type, excluding automatic displays:
REVIEW 5.6%
SHORT 75.4%
LONG 4.1%
FIELDS 2.1%
PERIODICALS 11.2%
COMMENTS 0.0%
Other 1.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) 192:19
Average number of searches completed per session 1.5
Retrievals per search - median 65.5
Retrievals per search - average 534.9
Retrievals per search - standard deviation 2004.2
Percent of searches completed with 0 results 25.0%
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 584 21.3%
DISPLAY (excluding automatic displays) 1,104 40.2%
HELP 158 5.8%
EXPLAIN 81 2.9%
SET/RESET 249 9.1%
SHOW 20 0.7%
ADD ON (AND, OR, AND NOT) 0 0.0%
LOGON or LOGOFF 361 13.1%
COMMENT 1 0.0%
SAVE 123 4.5%
USE 4 0.1%
OTHER 62 2.3%
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 386 66.0% 119 30.8% 132 464.0 1866.6
EXACT JOURNAL 110 18.8% 18 16.4% 128 238.0 351.9
SUBJECT CAT 24 4.1% 0 0.0% 7,019 6788.4 4167.9
SUBFILE 0 0.0% 0 0.0% 0 0.0 0.0
DATE 1 0.2% 0 0.0% 1 1.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 64 10.9% 9 14.1% 8 66.9 211.5
By number of indexes:
Multiple 1 0.2% 0 0.0% 1 1.0 0.0
Single 583 99.8% 146 25.0% 122 714.8 2289.6
DISPLAY commands, by type, excluding automatic displays:
REVIEW 9.1%
ISSUES 43.0%
SHORT 21.3%
LONG 13.9%
PERIODICALS 10.0%
COMMENTS 0.0%
Other 2.8%
2.3 Error, EXPLAIN and HELP statistics (CC & CCT)
__________________________________________________
Percent of commands that contained errors 7.8%
Ten most frequent errors:
1. NS command - no next screen 32.3%
2. First word of command is invalid 26.4%
3. FIND command with invalid index name 8.9%
4. Max. # of ports to a Z39 db are in use 4.3%
5. Index invalid in current database 3.4%
6. DISPLAY command contains invalid word 2.5%
7. Search term missing from search command 2.0%
8. DISPLAY command - no FIND results 1.9%
9. PS command - no previous screen 1.9%
10. D ABS command in database w/o abstracts 1.5%
11. All others 14.9%
Ten most frequent EXPLAIN requests:
1. CC GUIDE 16.1%
2. FIND (CC DB) 12.7%
3. CC INDEXES 10.8%
4. LOCATE (ARTICLE DBS) 6.5%
5. COMMANDS 5.6%
6. DATABASES 4.8%
7. DISPLAY 4.5%
8. Unrecognized term 3.7%
9. CC DATABASE 3.7%
10. CCT INDEXES 2.5%
11. All others 29.1%
Ten most frequent HELP situations:
1. Help requested from START CC command 14.9%
2. First word of command is invalid 12.2%
3. Help requested from SET DB command 8.4%
4. FIND command with invalid index name 8.2%
5. F/BR with index invalid in current DB 7.5%
6. DISPLAY command-first of >1 screen 4.7%
7. FIND command retrieves >1 book 4.4%
8. FIND command with zero results 4.2%
9. DISPLAY command - middle of >1 screen 3.6%
10. DISPLAY command - last of >1 screen 2.6%
11. All others 29.4%
Ten most frequent SHOW requests:
1. HISTORY 45.2%
2. SC LIST (CC DBS) 9.6%
3. SEARCH 7.8%
4. SYSTEM NEWS 4.3%
5. CC NEWS 4.3%
6. MAIL SETTINGS 3.5%
7. CC GLOSSARY 3.5%
8. MAIL STATUS 3.5%
9. CC LOADING STATISTICS 2.6%
10. UPDATE 2.6%
11. All others 13.0%
Cmm/yy cc MELVYL CURRENT CONTENTS DATABASE TELNET STATISTICS (monthly)