MELVYL CURRENT CONTENTS DATABASE TELNET STATISTICS
Time period: 09/01/01 through 09/30/01
1.0 SUMMARY STATISTICS
_______________________
1.1 Total sessions:
____________________
Location Library Remote Total
________ _______ ______ _____
Berkeley 267 2,282 2,549
Davis 1,105 54 1,159
Irvine 634 0 634
Los Angeles 4 699 703
Riverside 67 207 274
San Diego 85 718 803
San Francisco 551 0 551
Santa Barbara 19 453 472
Santa Cruz 42 145 187
LBL 0 360 360
LLL 0 126 126
Los Alamos n/a 0 0
Other - UC 0 96 96
U.S. Forestry 0
Other-Network UC n/a 2,159 2,159
_______ ______ _____
2,774 7,299 10,073
Per hour usage:
Time Sessions Finds Records Displayed
__________ __________ __________ _________________
12-2 a.m. 223 1,489 12,592
2-4 a.m. 131 518 5,421
4-6 a.m. 148 471 4,427
6-8 a.m. 333 1,450 14,396
8-10 a.m. 1,242 3,541 29,410
10-12 a.m. 1,982 5,195 48,261
12-2 p.m. 1,667 4,262 38,223
2-4 p.m. 1,935 5,067 53,649
4-6 p.m. 1,321 3,473 37,745
6-8 p.m. 495 1,451 12,981
8-10 p.m. 321 1,109 11,908
10-12 p.m. 275 1,102 9,462
__________ __________ __________ _________________
Total: 10,073 29,128 278,475
1.2 FIND commands
__________________
Number of FIND commands issued by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 585 5,958 6,543
Davis 3,647 111 3,758
Irvine 2,179 0 2,179
Los Angeles 4 2,032 2,036
Riverside 133 604 737
San Diego 299 2,093 2,392
San Francisco 1,554 0 1,554
Santa Barbara 33 1,467 1,500
Santa Cruz 82 341 423
LBL 0 827 827
LLL 0 1,463 1,463
Los Alamos n/a 0 0
Other - UC 4 346 350
U.S. Forestry 0
Other-Network UC n/a 5,366 5,366
_______ ______ _____
8,520 20,608 29,128
Number of FIND commands by database
CC database 28,668
CCT database 460
Total number of FIND commands 29,128
1.3 Records displayed
______________________
Number of Records Displayed by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 6,223 68,798 75,021
Davis 26,922 695 27,617
Irvine 16,760 0 16,760
Los Angeles 6 17,026 17,032
Riverside 1,352 7,053 8,405
San Diego 1,921 23,441 25,362
San Francisco 22,196 0 22,196
Santa Barbara 855 17,949 18,804
Santa Cruz 1,035 4,627 5,662
LBL 0 7,750 7,750
LLL 0 14,818 14,818
Los Alamos n/a 0 0
Other - UC 9 2,951 2,960
U.S. Forestry 0
Other-Network UC n/a 36,088 36,088
_______ ______ _____
77,279 201,196 278,475
Number of Records Displayed by database:
CC database 258,626
CCT database 19,849
Total number of Records Displayed 278,475
1.4 Relative Use of Databases
______________________________
Relative use of CC vs. CCT databases:
Percent of CC sessions 96.4%
Percent of CCT sessions 3.6%
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.0
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.0
2.0 CC Database Statistics
___________________________
Median session length (minutes:seconds) 0:00
Average session length (minutes:seconds) 0:00
Longest session recorded (minutes:seconds) 656:25
Average number of searches completed per session 2.9
Retrievals per search - median 8.0
Retrievals per search - average 439.3
Retrievals per search - standard deviation 4302.6
Percent of searches completed with 0 results 24.2%
Percent of searches entered that are long 0.5%
Percent of long searches completed
(includes partial results) 65.1%
Commands entered, by type, excluding errors:
Total Percentage
__________ __________
FIND 26,129 37.5%
DISPLAY (excluding automatic displays) 20,166 29.0%
HELP 492 0.7%
EXPLAIN 544 0.8%
SET/RESET 4,491 6.5%
SHOW 93 0.1%
ADD ON (AND, OR, AND NOT) 2,539 3.6%
LOGON or LOGOFF 11,306 16.2%
COMMENT 0 0.0%
SAVE 753 1.1%
USE 20 0.0%
OTHER 3,064 4.4%
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 12,086 40.5% 1,859 15.4% 28 234.0 1540.5
TITLE WORD 8,630 28.9% 2,624 30.4% 13 729.3 5475.0
EXACT TITLE 460 1.5% 214 46.5% 4 77.6 464.0
JOURNAL 1,480 5.0% 561 37.9% 448 4140.7 16813.3
EXACT JOURNAL 1,216 4.1% 720 59.2% 57 1977.4 6653.2
SUBJECT CAT 163 0.5% 36 22.1% 7 76.7 478.3
SUBFILE 58 0.2% 3 5.2% 56 291.8 1069.9
PUBLICATION TYPE 139 0.5% 36 25.9% 9 57.0 167.4
LANGUAGE 35 0.1% 3 8.6% 7 78.6 257.0
DATE 768 2.6% 112 14.6% 10 169.0 551.6
ADDED 1,190 4.0% 809 68.0% 19 35.3 51.6
PERIODICAL 1,765 5.9% 249 14.1% 4 65.7 629.2
EXACT PE 440 1.5% 52 11.8% 4 35.2 231.2
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,431 4.8% 482 33.7% 16 732.5 5152.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 3,714 14.3% 1,546 41.6% 8 86.6 408.3
Single 22,310 85.7% 4,638 20.8% 25 688.6 5449.0
DISPLAY commands, by type, excluding automatic displays:
REVIEW 5.8%
SHORT 75.3%
LONG 4.5%
FIELDS 1.3%
PERIODICALS 11.6%
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) 110:22
Average number of searches completed per session 1.3
Retrievals per search - median 50.5
Retrievals per search - average 386.8
Retrievals per search - standard deviation 2048.5
Percent of searches completed with 0 results 25.6%
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 457 22.7%
DISPLAY (excluding automatic displays) 713 35.4%
HELP 123 6.1%
EXPLAIN 57 2.8%
SET/RESET 237 11.8%
SHOW 26 1.3%
ADD ON (AND, OR, AND NOT) 3 0.1%
LOGON or LOGOFF 310 15.4%
COMMENT 0 0.0%
SAVE 0 0.0%
USE 0 0.0%
OTHER 88 4.4%
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 284 59.2% 86 30.3% 140 651.5 2802.2
EXACT JOURNAL 152 31.7% 31 20.4% 73 183.7 354.0
SUBJECT CAT 0 0.0% 0 0.0% 0 0.0 0.0
SUBFILE 0 0.0% 0 0.0% 0 0.0 0.0
DATE 23 4.8% 3 13.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 21 4.4% 0 0.0% 4 1272.0 3942.9
By number of indexes:
Multiple 23 5.0% 3 13.0% 1 1.0 0.0
Single 434 95.0% 114 26.3% 128 556.0 2438.0
DISPLAY commands, by type, excluding automatic displays:
REVIEW 4.2%
ISSUES 50.5%
SHORT 16.6%
LONG 22.8%
PERIODICALS 3.7%
COMMENTS 0.0%
Other 2.2%
2.3 Error, EXPLAIN and HELP statistics (CC & CCT)
__________________________________________________
Percent of commands that contained errors 7.4%
Ten most frequent errors:
1. NS command - no next screen 33.9%
2. First word of command is invalid 28.0%
3. FIND command with invalid index name 9.6%
4. Index invalid in current database 4.2%
5. Max. # of ports to a Z39 db are in use 2.2%
6. Search term missing from search command 1.9%
7. DISPLAY command contains invalid word 1.8%
8. D ABS command in database w/o abstracts 1.7%
9. PS command - no previous screen 1.7%
10. Valid command at an inappropriate time 1.4%
11. All others 13.5%
Ten most frequent EXPLAIN requests:
1. CC GUIDE 15.5%
2. FIND (CC DB) 12.5%
3. LOCATE (ARTICLE DBS) 10.6%
4. CC INDEXES 9.5%
5. COMMANDS 7.2%
6. Unrecognized term 4.7%
7. CC DATABASE 4.2%
8. DATABASES 3.7%
9. CURRENT DATES 2.5%
10. ADD-ON SEARCH 2.5%
11. All others 27.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 8.5%
4. Help requested from SET DB command 7.8%
5. FIND command with invalid index name 6.2%
6. DISPLAY command-first of >1 screen 5.5%
7. DISPLAY command - middle of >1 screen 5.4%
8. FIND command with zero results 4.7%
9. FIND command retrieves >1 book 3.5%
10. DISPLAY command-complete in one screen 3.0%
11. All others 26.5%
Ten most frequent SHOW requests:
1. HISTORY 44.1%
2. SYSTEM NEWS 11.0%
3. SEARCH 9.3%
4. TIME 5.1%
5. CC SETTINGS 5.1%
6. MAIL STATUS 4.2%
7. CC NEWS 3.4%
8. SC LIST (CC DBS) 3.4%
9. LIBRARY NEWS 2.5%
10. GLOSSARY 1.7%
11. All others 10.2%
Cmm/yy cc MELVYL CURRENT CONTENTS DATABASE TELNET STATISTICS (monthly)