MELVYL CURRENT CONTENTS DATABASE TELNET STATISTICS
Time period: 03/01/00 through 03/31/00
1.0 SUMMARY STATISTICS
_______________________
1.1 Total sessions:
____________________
Location Library Remote Total
________ _______ ______ _____
Berkeley 1,129 4,218 5,347
Davis 2,213 195 2,408
Irvine 1,849 0 1,849
Los Angeles 714 1,721 2,435
Riverside 517 490 1,007
San Diego 317 1,467 1,784
San Francisco 1,307 0 1,307
Santa Barbara 437 1,084 1,521
Santa Cruz 446 575 1,021
LBL 0 591 591
LLL 0 378 378
Los Alamos n/a 1 1
Other - UC 34 213 247
U.S. Forestry 0
Other-Network UC n/a 2,596 2,596
_______ ______ _____
8,963 13,529 22,492
Per hour usage:
Time Sessions Finds Records Displayed
__________ __________ __________ _________________
12-2 a.m. 410 1,279 9,711
2-4 a.m. 287 970 40,204
4-6 a.m. 280 1,005 9,476
6-8 a.m. 619 2,369 24,683
8-10 a.m. 2,366 6,835 63,042
10-12 a.m. 3,860 10,823 100,995
12-2 p.m. 3,888 10,985 97,319
2-4 p.m. 4,546 12,530 107,081
4-6 p.m. 3,258 9,008 84,060
6-8 p.m. 1,430 4,419 42,907
8-10 p.m. 923 2,729 24,855
10-12 p.m. 625 1,970 17,543
__________ __________ __________ _________________
Total: 22,492 64,922 621,876
1.2 FIND commands
__________________
Number of FIND commands issued by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 3,119 11,890 15,009
Davis 7,042 674 7,716
Irvine 5,459 0 5,459
Los Angeles 1,699 5,088 6,787
Riverside 1,191 1,445 2,636
San Diego 929 3,694 4,623
San Francisco 3,499 0 3,499
Santa Barbara 1,283 3,396 4,679
Santa Cruz 1,037 1,595 2,632
LBL 0 1,940 1,940
LLL 0 3,073 3,073
Los Alamos n/a 2 2
Other - UC 66 435 501
U.S. Forestry 0
Other-Network UC n/a 6,366 6,366
_______ ______ _____
25,324 39,598 64,922
Number of FIND commands by database
CC database 63,759
CCT database 1,163
Total number of FIND commands 64,922
1.3 Records displayed
______________________
Number of Records Displayed by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 29,723 119,669 149,392
Davis 56,696 4,031 60,727
Irvine 68,887 0 68,887
Los Angeles 13,872 50,763 64,635
Riverside 9,225 13,715 22,940
San Diego 5,443 31,631 37,074
San Francisco 28,215 0 28,215
Santa Barbara 13,517 32,859 46,376
Santa Cruz 9,239 17,593 26,832
LBL 0 24,286 24,286
LLL 0 36,659 36,659
Los Alamos n/a 9 9
Other - UC 718 3,548 4,266
U.S. Forestry 0
Other-Network UC n/a 51,578 51,578
_______ ______ _____
235,535 386,341 621,876
Number of Records Displayed by database:
CC database 577,819
CCT database 44,057
Total number of Records Displayed 621,876
1.4 Relative Use of Databases
______________________________
Relative use of CC vs. CCT databases:
Percent of CC sessions 95.6%
Percent of CCT sessions 4.4%
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.1
Standard deviation in seconds 5.0
Display response time from receipt of command at
DLA until transmission of a complete screen:
Average in seconds 0.2
Standard deviation in seconds 5.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) 566:49
Average number of searches completed per session 3.0
Retrievals per search - median 10.0
Retrievals per search - average 537.9
Retrievals per search - standard deviation 4853.6
Percent of searches completed with 0 results 24.1%
Percent of searches entered that are long 0.2%
Percent of long searches completed
(includes partial results) 58.6%
Commands entered, by type, excluding errors:
Total Percentage
__________ __________
FIND 59,094 37.1%
DISPLAY (excluding automatic displays) 44,809 28.1%
HELP 2,143 1.3%
EXPLAIN 2,137 1.3%
SET/RESET 8,093 5.1%
SHOW 299 0.2%
ADD ON (AND, OR, AND NOT) 4,665 2.9%
LOGON or LOGOFF 27,713 17.4%
COMMENT 1 0.0%
SAVE 2,584 1.6%
USE 97 0.1%
OTHER 7,798 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 28,292 43.2% 4,071 14.4% 30 217.2 1280.8
TITLE WORD 20,429 31.2% 5,984 29.3% 16 823.6 5209.9
EXACT TITLE 619 0.9% 322 52.0% 2 190.5 1523.0
JOURNAL 3,191 4.9% 1,383 43.3% 466 4903.7 15307.7
EXACT JOURNAL 2,467 3.8% 1,426 57.8% 99 2475.3 8519.6
SUBJECT CAT 244 0.4% 26 10.7% 11 1631.5 22928.7
SUBFILE 214 0.3% 34 15.9% 34 268.7 1016.6
PUBLICATION TYPE 245 0.4% 53 21.6% 15 7477.0 37286.9
LANGUAGE 50 0.1% 12 24.0% 147 422.7 839.6
DATE 888 1.4% 149 16.8% 9 104.9 666.0
ADDED 2,048 3.1% 1,366 66.7% 24 43.9 60.7
PERIODICAL 2,095 3.2% 443 21.1% 6 139.1 1042.8
EXACT PE 476 0.7% 72 15.1% 3 40.6 298.8
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 4,166 6.4% 1,279 30.7% 22 917.8 4650.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 6,436 10.9% 2,739 42.6% 8 77.3 646.1
Single 52,394 89.1% 11,110 21.2% 31 797.9 5866.9
DISPLAY commands, by type, excluding automatic displays:
REVIEW 5.0%
SHORT 80.4%
LONG 4.8%
FIELDS 1.5%
PERIODICALS 6.3%
COMMENTS 0.0%
Other 2.0%
2.1 CCT Database Statistics
____________________________
Median session length (minutes:seconds) 0:00
Average session length (minutes:seconds) 0:00
Longest session recorded (minutes:seconds) 106:04
Average number of searches completed per session 1.2
Retrievals per search - median 42.0
Retrievals per search - average 302.7
Retrievals per search - standard deviation 1350.7
Percent of searches completed with 0 results 31.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 1,159 20.2%
DISPLAY (excluding automatic displays) 1,783 31.0%
HELP 593 10.3%
EXPLAIN 291 5.1%
SET/RESET 683 11.9%
SHOW 98 1.7%
ADD ON (AND, OR, AND NOT) 4 0.1%
LOGON or LOGOFF 892 15.5%
COMMENT 0 0.0%
SAVE 4 0.1%
USE 3 0.1%
OTHER 240 4.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 777 66.8% 276 35.5% 107 411.0 1641.1
EXACT JOURNAL 272 23.4% 74 27.2% 97 166.3 227.0
SUBJECT CAT 22 1.9% 2 9.1% 3,951 5082.0 3302.1
SUBFILE 0 0.0% 0 0.0% 0 0.0 0.0
DATE 5 0.4% 4 80.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 88 7.6% 15 17.0% 4 54.2 157.3
By number of indexes:
Multiple 5 0.4% 4 80.0% 1 1.0 0.0
Single 1,154 99.6% 363 31.5% 98 435.4 1600.1
DISPLAY commands, by type, excluding automatic displays:
REVIEW 4.9%
ISSUES 47.6%
SHORT 17.2%
LONG 22.1%
PERIODICALS 6.2%
COMMENTS 0.0%
Other 1.9%
2.3 Error, EXPLAIN and HELP statistics (CC & CCT)
__________________________________________________
Percent of commands that contained errors 9.2%
Ten most frequent errors:
1. NS command - no next screen 30.6%
2. First word of command is invalid 28.6%
3. FIND command with invalid index name 10.9%
4. Index invalid in current database 6.0%
5. Search term missing from search command 2.1%
6. PS command - no previous screen 2.0%
7. DISPLAY command contains invalid word 1.9%
8. D ABS command in database w/o abstracts 1.6%
9. Valid command at an inappropriate time 1.5%
10. F SUB CAT search with invalid SC 1.4%
11. All others 13.5%
Ten most frequent EXPLAIN requests:
1. CC GUIDE 17.8%
2. FIND (CC DB) 12.6%
3. CC INDEXES 12.0%
4. LOCATE (ARTICLE DBS) 8.6%
5. COMMANDS 5.8%
6. Unrecognized term 4.0%
7. CC DATABASE 3.2%
8. DATABASES 3.0%
9. ADD-ON SEARCH 2.8%
10. CCT INDEXES 2.6%
11. All others 27.7%
Ten most frequent HELP situations:
1. Help requested from START CC command 15.5%
2. First word of command is invalid 13.1%
3. F/BR with index invalid in current DB 11.1%
4. FIND command with invalid index name 8.3%
5. Help requested from SET DB command 6.8%
6. DISPLAY command - middle of >1 screen 5.5%
7. FIND command with zero results 5.0%
8. DISPLAY command-first of >1 screen 4.3%
9. FIND command retrieves >1 book 4.0%
10. DISPLAY command-complete in one screen 2.6%
11. All others 23.8%
Ten most frequent SHOW requests:
1. HISTORY 32.3%
2. SEARCH 16.8%
3. MAIL STATUS 10.9%
4. SYSTEM NEWS 9.2%
5. SC LIST (CC DBS) 5.9%
6. CC NEWS 5.6%
7. CC GLOSSARY 4.1%
8. LIBRARY NEWS 2.0%
9. CC SETTINGS 2.0%
10. MAIL SETTINGS 1.8%
11. All others 9.4%
Cmm/yy cc MELVYL CURRENT CONTENTS DATABASE TELNET STATISTICS (monthly)