MELVYL CURRENT CONTENTS DATABASE TELNET STATISTICS
Time period: 05/01/01 through 05/31/01
1.0 SUMMARY STATISTICS
_______________________
1.1 Total sessions:
____________________
Location Library Remote Total
________ _______ ______ _____
Berkeley 242 2,670 2,912
Davis 1,692 103 1,795
Irvine 1,105 0 1,105
Los Angeles 8 1,124 1,132
Riverside 161 239 400
San Diego 176 1,023 1,199
San Francisco 712 0 712
Santa Barbara 38 616 654
Santa Cruz 128 406 534
LBL 0 394 394
LLL 0 269 269
Los Alamos n/a 0 0
Other - UC 8 202 210
U.S. Forestry 0
Other-Network UC n/a 2,455 2,455
_______ ______ _____
4,270 9,501 13,771
Per hour usage:
Time Sessions Finds Records Displayed
__________ __________ __________ _________________
12-2 a.m. 226 692 6,980
2-4 a.m. 168 931 5,233
4-6 a.m. 156 480 4,267
6-8 a.m. 389 2,106 22,584
8-10 a.m. 1,492 4,761 44,991
10-12 a.m. 2,478 6,709 67,389
12-2 p.m. 2,356 6,410 108,855
2-4 p.m. 2,578 7,058 66,383
4-6 p.m. 2,046 5,648 63,452
6-8 p.m. 889 2,456 74,142
8-10 p.m. 555 1,757 14,109
10-12 p.m. 438 1,503 10,094
__________ __________ __________ _________________
Total: 13,771 40,511 488,479
1.2 FIND commands
__________________
Number of FIND commands issued by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 532 7,379 7,911
Davis 4,886 284 5,170
Irvine 3,821 0 3,821
Los Angeles 29 3,033 3,062
Riverside 280 795 1,075
San Diego 516 3,000 3,516
San Francisco 1,874 0 1,874
Santa Barbara 78 1,718 1,796
Santa Cruz 307 1,194 1,501
LBL 0 1,236 1,236
LLL 0 2,769 2,769
Los Alamos n/a 0 0
Other - UC 30 617 647
U.S. Forestry 0
Other-Network UC n/a 6,133 6,133
_______ ______ _____
12,353 28,158 40,511
Number of FIND commands by database
CC database 39,643
CCT database 868
Total number of FIND commands 40,511
1.3 Records displayed
______________________
Number of Records Displayed by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 6,697 76,113 82,810
Davis 143,524 1,850 145,374
Irvine 28,170 0 28,170
Los Angeles 250 28,527 28,777
Riverside 2,126 7,748 9,874
San Diego 3,670 24,225 27,895
San Francisco 19,618 0 19,618
Santa Barbara 3,143 21,876 25,019
Santa Cruz 3,198 11,367 14,565
LBL 0 20,998 20,998
LLL 0 34,019 34,019
Los Alamos n/a 0 0
Other - UC 28 8,785 8,813
U.S. Forestry 0
Other-Network UC n/a 42,547 42,547
_______ ______ _____
210,424 278,055 488,479
Number of Records Displayed by database:
CC database 441,854
CCT database 46,625
Total number of Records Displayed 488,479
1.4 Relative Use of Databases
______________________________
Relative use of CC vs. CCT databases:
Percent of CC sessions 95.8%
Percent of CCT sessions 4.2%
Percent of searches done in the CC database 97.9%
Percent of searches done in the CCT database 2.1%
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.4
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.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) 411:23
Average number of searches completed per session 3.0
Retrievals per search - median 9.0
Retrievals per search - average 542.3
Retrievals per search - standard deviation 6487.3
Percent of searches completed with 0 results 25.2%
Percent of searches entered that are long 0.3%
Percent of long searches completed
(includes partial results) 60.1%
Commands entered, by type, excluding errors:
Total Percentage
__________ __________
FIND 36,336 38.0%
DISPLAY (excluding automatic displays) 27,094 28.3%
HELP 735 0.8%
EXPLAIN 839 0.9%
SET/RESET 5,347 5.6%
SHOW 132 0.1%
ADD ON (AND, OR, AND NOT) 3,307 3.5%
LOGON or LOGOFF 16,443 17.2%
COMMENT 0 0.0%
SAVE 1,132 1.2%
USE 38 0.0%
OTHER 4,301 4.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:
PERSONAL AUTHOR 17,729 42.4% 2,916 16.4% 31 254.2 1649.5
TITLE WORD 12,180 29.1% 3,730 30.6% 15 869.6 7116.5
EXACT TITLE 507 1.2% 241 47.5% 2 67.3 555.8
JOURNAL 1,920 4.6% 853 44.4% 229 4191.7 22704.9
EXACT JOURNAL 1,825 4.4% 1,018 55.8% 51 2359.8 8791.9
SUBJECT CAT 295 0.7% 36 12.2% 6 47.5 203.8
SUBFILE 107 0.3% 9 8.4% 41 370.2 1209.6
PUBLICATION TYPE 176 0.4% 40 22.7% 12 15877.5 58234.0
LANGUAGE 34 0.1% 9 26.5% 51 290.6 492.0
DATE 732 1.8% 158 21.6% 10 241.5 1098.5
ADDED 2,345 5.6% 1,465 62.5% 19 35.4 47.1
PERIODICAL 1,481 3.5% 264 17.8% 4 117.4 1727.9
EXACT PE 278 0.7% 18 6.5% 4 36.2 158.7
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,186 5.2% 648 29.6% 17 767.2 6059.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 5,444 15.0% 2,438 44.8% 9 101.6 865.4
Single 30,771 85.0% 6,466 21.0% 30 848.1 8221.2
DISPLAY commands, by type, excluding automatic displays:
REVIEW 5.1%
SHORT 79.3%
LONG 4.6%
FIELDS 2.2%
PERIODICALS 7.6%
COMMENTS 0.0%
Other 1.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) 244:35
Average number of searches completed per session 1.5
Retrievals per search - median 54.5
Retrievals per search - average 481.9
Retrievals per search - standard deviation 2405.4
Percent of searches completed with 0 results 26.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 863 23.7%
DISPLAY (excluding automatic displays) 1,314 36.1%
HELP 214 5.9%
EXPLAIN 125 3.4%
SET/RESET 401 11.0%
SHOW 45 1.2%
ADD ON (AND, OR, AND NOT) 5 0.1%
LOGON or LOGOFF 514 14.1%
COMMENT 0 0.0%
SAVE 43 1.2%
USE 0 0.0%
OTHER 118 3.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 583 67.1% 173 29.7% 130 675.3 3201.2
EXACT JOURNAL 192 22.1% 41 21.4% 119 244.2 394.0
SUBJECT CAT 19 2.2% 0 0.0% 5,150 5438.1 3690.6
SUBFILE 1 0.1% 1 100% 0 0.0 0.0
DATE 2 0.2% 0 0.0% 5 5.0 0.0
ADDED 3 0.3% 0 0.0% 177 202.0 128.3
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 69 7.9% 12 17.4% 4 20.7 46.3
By number of indexes:
Multiple 6 0.7% 1 16.7% 88 123.2 141.0
Single 857 99.3% 225 26.3% 119 660.8 2798.5
DISPLAY commands, by type, excluding automatic displays:
REVIEW 8.3%
ISSUES 52.3%
SHORT 16.1%
LONG 13.9%
PERIODICALS 7.4%
COMMENTS 0.0%
Other 1.9%
2.3 Error, EXPLAIN and HELP statistics (CC & CCT)
__________________________________________________
Percent of commands that contained errors 8.3%
Ten most frequent errors:
1. NS command - no next screen 31.6%
2. First word of command is invalid 27.4%
3. FIND command with invalid index name 9.1%
4. Index invalid in current database 4.7%
5. Max. # of ports to a Z39 db are in use 3.9%
6. DISPLAY command - no FIND results 2.3%
7. Search term missing from search command 2.2%
8. DISPLAY command contains invalid word 2.0%
9. PS command - no previous screen 1.5%
10. D ABS command in database w/o abstracts 1.3%
11. All others 14.0%
Ten most frequent EXPLAIN requests:
1. FIND (CC DB) 13.3%
2. CC GUIDE 13.0%
3. CC INDEXES 12.4%
4. LOCATE (ARTICLE DBS) 6.1%
5. DATABASES 4.6%
6. COMMANDS 4.6%
7. Unrecognized term 4.3%
8. CC DATABASE 4.0%
9. SUBJECT CATEGORY 2.7%
10. CCT INDEXES 2.6%
11. All others 32.5%
Ten most frequent HELP situations:
1. Help requested from START CC command 15.0%
2. First word of command is invalid 14.2%
3. F/BR with index invalid in current DB 9.3%
4. Help requested from SET DB command 6.6%
5. FIND command with invalid index name 6.5%
6. DISPLAY command - middle of >1 screen 6.0%
7. DISPLAY command-first of >1 screen 5.6%
8. FIND command with zero results 3.9%
9. FIND command retrieves >1 book 3.2%
10. DISPLAY command-complete in one screen 2.8%
11. All others 27.0%
Ten most frequent SHOW requests:
1. HISTORY 44.8%
2. SEARCH 11.5%
3. SYSTEM NEWS 8.0%
4. SC LIST (CC DBS) 5.7%
5. CC NEWS 5.2%
6. CC SETTINGS 3.4%
7. MAIL STATUS 3.4%
8. GLOSSARY 2.9%
9. CC GLOSSARY 2.9%
10. LIBRARY NEWS 2.3%
11. All others 9.8%
Cmm/yy cc MELVYL CURRENT CONTENTS DATABASE TELNET STATISTICS (monthly)