MELVYL CURRENT CONTENTS DATABASE TELNET STATISTICS
Time period: 04/01/99 through 04/30/99
1.0 SUMMARY STATISTICS
_______________________
1.1 Total sessions:
____________________
Location Library Remote Total
________ _______ ______ _____
Berkeley 2,469 6,601 9,070
Davis 3,709 264 3,973
Irvine 3,513 0 3,513
Los Angeles 804 2,907 3,711
Riverside 912 858 1,770
San Diego 367 2,392 2,759
San Francisco 1,591 8 1,599
Santa Barbara 1,013 1,405 2,418
Santa Cruz 881 836 1,717
LBL 0 871 871
LLL 0 1,007 1,007
Los Alamos n/a 24 24
Other - UC 20 468 488
U.S. Forestry 1
Other-Network UC n/a 3,736 3,736
_______ ______ _____
15,279 21,377 36,657
Per hour usage:
Time Sessions Finds Records Displayed
__________ __________ __________ _________________
12-2 a.m. 511 1,891 17,460
2-4 a.m. 316 1,346 37,856
4-6 a.m. 318 1,097 10,061
6-8 a.m. 865 2,727 23,217
8-10 a.m. 3,392 9,674 95,908
10-12 a.m. 6,252 18,568 173,867
12-2 p.m. 6,555 19,767 191,561
2-4 p.m. 7,935 23,530 218,682
4-6 p.m. 5,441 17,486 166,555
6-8 p.m. 2,311 7,345 70,688
8-10 p.m. 1,670 5,227 57,771
10-12 p.m. 1,091 4,130 44,486
__________ __________ __________ _________________
Total: 36,657 112,788 1,108,112
1.2 FIND commands
__________________
Number of FIND commands issued by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 7,987 20,737 28,724
Davis 11,008 637 11,645
Irvine 10,847 0 10,847
Los Angeles 2,431 9,159 11,590
Riverside 2,377 2,776 5,153
San Diego 1,090 7,746 8,836
San Francisco 5,064 10 5,074
Santa Barbara 2,907 4,880 7,787
Santa Cruz 2,307 2,483 4,790
LBL 0 3,681 3,681
LLL 0 3,118 3,118
Los Alamos n/a 73 73
Other - UC 45 1,416 1,461
U.S. Forestry 0
Other-Network UC n/a 10,009 10,009
_______ ______ _____
46,063 66,725 112,788
Number of FIND commands by database
CC database 110,778
CCT database 2,010
Total number of FIND commands 112,788
1.3 Records displayed
______________________
Number of Records Displayed by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 84,190 231,136 315,326
Davis 96,635 5,713 102,348
Irvine 111,515 0 111,515
Los Angeles 22,922 96,363 119,285
Riverside 19,266 27,797 47,063
San Diego 8,926 66,003 74,929
San Francisco 44,557 67 44,624
Santa Barbara 23,631 50,225 73,856
Santa Cruz 18,159 24,997 43,156
LBL 0 35,844 35,844
LLL 0 32,728 32,728
Los Alamos n/a 411 411
Other - UC 260 14,050 14,310
U.S. Forestry 0
Other-Network UC n/a 92,717 92,717
_______ ______ _____
430,061 678,051 1,108,112
Number of Records Displayed by database:
CC database 1,035,739
CCT database 72,373
Total number of Records Displayed 1,108,112
1.4 Relative Use of Databases
______________________________
Relative use of CC vs. CCT databases:
Percent of CC sessions 95.2%
Percent of CCT sessions 4.8%
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.0
Standard deviation in seconds 4.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 4.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) 406:50
Average number of searches completed per session 3.2
Retrievals per search - median 11.0
Retrievals per search - average 654.2
Retrievals per search - standard deviation 7074.7
Percent of searches completed with 0 results 23.0%
Percent of searches entered that are long 0.2%
Percent of long searches completed
(includes partial results) 45.2%
Commands entered, by type, excluding errors:
Total Percentage
__________ __________
FIND 102,507 36.3%
DISPLAY (excluding automatic displays) 81,124 28.7%
HELP 5,421 1.9%
EXPLAIN 5,071 1.8%
SET/RESET 12,499 4.4%
SHOW 693 0.2%
ADD ON (AND, OR, AND NOT) 8,271 2.9%
LOGON or LOGOFF 46,221 16.3%
COMMENT 0 0.0%
SAVE 6,680 2.4%
USE 185 0.1%
OTHER 14,097 5.0%
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 45,879 41.5% 6,708 14.6% 31 233.6 1306.8
TITLE WORD 40,198 36.4% 11,290 28.1% 17 841.9 6453.8
EXACT TITLE 897 0.8% 537 59.9% 3 159.1 976.3
JOURNAL 5,813 5.3% 2,222 38.2% 637 6971.2 30694.0
EXACT JOURNAL 1,791 1.6% 641 35.8% 568 3672.7 8032.4
SUBJECT CAT 290 0.3% 52 17.9% 10 1976.8 21437.3
SUBFILE 359 0.3% 46 12.8% 28 216.1 1150.0
PUBLICATION TYPE 502 0.5% 119 23.7% 10 1970.5 17706.3
LANGUAGE 162 0.1% 19 11.7% 50 343.8 1121.1
DATE 1,664 1.5% 270 16.2% 15 148.4 501.3
ADDED 445 0.4% 216 48.5% 7 21.4 39.0
PERIODICAL 3,193 2.9% 698 21.9% 6 259.7 2196.2
EXACT PE 594 0.5% 98 16.5% 4 116.3 1089.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 4 0.0% 3 75.0% 4,066 4066.0 0.0
Other indexes 8,646 7.8% 2,496 28.9% 24 1070.9 7619.4
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,066 7.9% 2,461 30.5% 6 96.5 1083.8
Single 94,021 92.1% 20,408 21.7% 33 958.6 8618.9
DISPLAY commands, by type, excluding automatic displays:
REVIEW 3.5%
SHORT 82.1%
LONG 4.2%
FIELDS 1.4%
PERIODICALS 5.3%
COMMENTS 0.0%
Other 3.6%
2.1 CCT Database Statistics
____________________________
Median session length (minutes:seconds) 0:00
Average session length (minutes:seconds) 0:00
Longest session recorded (minutes:seconds) 180:47
Average number of searches completed per session 1.1
Retrievals per search - median 39.0
Retrievals per search - average 502.0
Retrievals per search - standard deviation 2550.7
Percent of searches completed with 0 results 32.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 2,001 18.8%
DISPLAY (excluding automatic displays) 3,187 30.0%
HELP 1,310 12.3%
EXPLAIN 567 5.3%
SET/RESET 1,217 11.5%
SHOW 229 2.2%
ADD ON (AND, OR, AND NOT) 9 0.1%
LOGON or LOGOFF 1,606 15.1%
COMMENT 0 0.0%
SAVE 25 0.2%
USE 12 0.1%
OTHER 460 4.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 1,255 62.6% 471 37.5% 96 798.8 2987.8
EXACT JOURNAL 573 28.6% 135 23.6% 63 163.8 256.0
SUBJECT CAT 37 1.8% 2 5.4% 5,772 6674.4 5115.8
SUBFILE 2 0.1% 2 100% 0 0.0 0.0
DATE 7 0.3% 2 28.6% 46 13983.6 25448.1
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 132 6.6% 31 23.5% 6 51.1 139.7
By number of indexes:
Multiple 9 0.5% 5 55.6% 46 52.0 33.4
Single 1,988 99.5% 633 31.8% 78 742.6 3074.9
DISPLAY commands, by type, excluding automatic displays:
REVIEW 3.5%
ISSUES 47.5%
SHORT 13.3%
LONG 27.5%
PERIODICALS 5.4%
COMMENTS 0.0%
Other 2.8%
2.3 Error, EXPLAIN and HELP statistics (CC & CCT)
__________________________________________________
Percent of commands that contained errors 10.7%
Ten most frequent errors:
1. First word of command is invalid 30.0%
2. NS command - no next screen 27.5%
3. FIND command with invalid index name 10.7%
4. Index invalid in current database 7.0%
5. DISPLAY command contains invalid word 2.1%
6. PS command - no previous screen 2.0%
7. Search term missing from search command 1.8%
8. Valid command at an inappropriate time 1.8%
9. D ABS command in database w/o abstracts 1.7%
10. F SUB CAT search with invalid SC 1.5%
11. All others 14.1%
Ten most frequent EXPLAIN requests:
1. CC GUIDE 17.2%
2. FIND (CC DB) 13.8%
3. CC INDEXES 11.3%
4. LOCATE (ARTICLE DBS) 9.9%
5. COMMANDS 6.6%
6. Unrecognized term 4.4%
7. CC DATABASE 3.1%
8. DATABASES 2.8%
9. ADD-ON SEARCH 2.6%
10. DISPLAY 2.6%
11. All others 25.7%
Ten most frequent HELP situations:
1. Help requested from START CC command 15.6%
2. First word of command is invalid 13.8%
3. F/BR with index invalid in current DB 11.0%
4. FIND command with invalid index name 8.0%
5. Help requested from SET DB command 5.8%
6. DISPLAY command - middle of >1 screen 4.8%
7. FIND command with zero results 4.4%
8. DISPLAY command-first of >1 screen 4.3%
9. FIND command retrieves >1 book 3.5%
10. DISPLAY command-complete in one screen 3.3%
11. All others 25.6%
Ten most frequent SHOW requests:
1. HISTORY 37.2%
2. SEARCH 15.6%
3. SYSTEM NEWS 9.6%
4. CC NEWS 6.5%
5. SC LIST (CC DBS) 5.6%
6. CC GLOSSARY 4.5%
7. MAIL STATUS 4.5%
8. CC SETTINGS 3.0%
9. Invalid term 1.5%
10. LIBRARY NEWS 1.5%
11. All others 10.5%