MELVYL CURRENT CONTENTS DATABASE TELNET STATISTICS
Time period: 01/01/99 through 01/31/99
1.0 SUMMARY STATISTICS
_______________________
1.1 Total sessions:
____________________
Location Library Remote Total
________ _______ ______ _____
Berkeley 1,253 5,814 7,067
Davis 4,532 400 4,932
Irvine 4,600 0 4,600
Los Angeles 839 3,509 4,348
Riverside 1,069 870 1,939
San Diego 341 2,953 3,294
San Francisco 1,935 13 1,948
Santa Barbara 1,095 1,852 2,947
Santa Cruz 1,245 974 2,219
LBL 0 974 974
LLL 0 994 994
Los Alamos n/a 77 77
Other - UC 26 276 302
U.S. Forestry 16
Other-Network UC n/a 3,733 3,733
_______ ______ _____
16,935 22,439 39,390
Per hour usage:
Time Sessions Finds Records Displayed
__________ __________ __________ _________________
12-2 a.m. 602 2,400 23,548
2-4 a.m. 357 1,695 14,131
4-6 a.m. 374 1,392 16,096
6-8 a.m. 961 3,690 37,813
8-10 a.m. 3,461 10,349 96,967
10-12 a.m. 6,799 20,987 205,473
12-2 p.m. 6,739 19,757 185,921
2-4 p.m. 8,575 26,747 252,460
4-6 p.m. 5,966 18,497 193,464
6-8 p.m. 2,603 8,768 88,681
8-10 p.m. 1,768 6,088 66,209
10-12 p.m. 1,185 4,552 43,935
__________ __________ __________ _________________
Total: 39,390 124,922 1,224,698
1.2 FIND commands
__________________
Number of FIND commands issued by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 3,535 18,085 21,620
Davis 14,608 1,155 15,763
Irvine 15,894 0 15,894
Los Angeles 2,424 11,301 13,725
Riverside 3,258 2,928 6,186
San Diego 888 9,191 10,079
San Francisco 5,469 29 5,498
Santa Barbara 3,272 6,121 9,393
Santa Cruz 3,573 3,032 6,605
LBL 0 3,890 3,890
LLL 0 5,018 5,018
Los Alamos n/a 222 222
Other - UC 39 744 783
U.S. Forestry 53
Other-Network UC n/a 10,193 10,193
_______ ______ _____
52,960 71,909 124,922
Number of FIND commands by database
CC database 122,494
CCT database 2,428
Total number of FIND commands 124,922
1.3 Records displayed
______________________
Number of Records Displayed by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 36,442 186,832 223,274
Davis 117,150 15,265 132,415
Irvine 111,215 0 111,215
Los Angeles 19,455 123,658 143,113
Riverside 23,127 38,303 61,430
San Diego 10,169 82,706 92,875
San Francisco 59,176 116 59,292
Santa Barbara 34,605 70,716 105,321
Santa Cruz 28,350 36,603 64,953
LBL 0 40,338 40,338
LLL 0 62,045 62,045
Los Alamos n/a 3,304 3,304
Other - UC 371 7,724 8,095
U.S. Forestry 40
Other-Network UC n/a 116,515 116,515
_______ ______ _____
440,060 784,125 1,224,225
Number of Records Displayed by database:
CC database 1,135,739
CCT database 88,959
Total number of Records Displayed 1,224,225
1.4 Relative Use of Databases
______________________________
Relative use of CC vs. CCT databases:
Percent of CC sessions 95.0%
Percent of CCT sessions 5.0%
Percent of searches done in the CC database 98.1%
Percent of searches done in the CCT database 1.9%
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 3.8
Display response time from receipt of command at
DLA until transmission of a complete screen:
Average in seconds 0.2
Standard deviation in seconds 3.8
2.0 CC Database Statistics
___________________________
Median session length (minutes:seconds) 0:00
Average session length (minutes:seconds) 0:00
Longest session recorded (minutes:seconds) 864:59
Average number of searches completed per session 3.3
Retrievals per search - median 11.0
Retrievals per search - average 600.8
Retrievals per search - standard deviation 5888.0
Percent of searches completed with 0 results 22.8%
Percent of searches entered that are long 0.2%
Percent of long searches completed
(includes partial results) 43.8%
Commands entered, by type, excluding errors:
Total Percentage
__________ __________
FIND 113,247 36.9%
DISPLAY (excluding automatic displays) 88,407 28.8%
HELP 4,990 1.6%
EXPLAIN 4,775 1.6%
SET/RESET 14,517 4.7%
SHOW 820 0.3%
ADD ON (AND, OR, AND NOT) 9,247 3.0%
LOGON or LOGOFF 49,177 16.0%
COMMENT 3 0.0%
SAVE 6,402 2.1%
USE 188 0.1%
OTHER 15,514 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 52,619 42.5% 7,517 14.3% 28 194.9 1114.4
TITLE WORD 42,522 34.3% 11,732 27.6% 22 943.8 5565.9
EXACT TITLE 822 0.7% 475 57.8% 4 202.8 915.9
JOURNAL 5,338 4.3% 2,041 38.2% 692 6471.0 27431.0
EXACT JOURNAL 2,958 2.4% 1,395 47.2% 258 2369.0 7740.3
SUBJECT CAT 618 0.5% 103 16.7% 17 363.1 5398.2
SUBFILE 548 0.4% 98 17.9% 15 488.6 2843.4
PUBLICATION TYPE 614 0.5% 184 30.0% 9 1672.4 16170.7
LANGUAGE 302 0.2% 53 17.5% 30 184.7 823.6
DATE 2,212 1.8% 358 16.2% 12 208.7 1559.0
ADDED 1,850 1.5% 1,037 56.1% 16 31.3 49.1
PERIODICAL 3,278 2.6% 654 19.9% 7 324.3 2056.5
EXACT PE 588 0.5% 103 17.5% 3 50.1 210.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 3 0.0% 1 33.3% 2,038 2037.5 2868.7
Other indexes 9,648 7.8% 2,820 29.2% 28 992.5 6499.7
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 10,609 9.4% 3,618 34.1% 8 123.1 1160.9
Single 102,260 90.6% 21,214 20.7% 33 869.4 7132.5
DISPLAY commands, by type, excluding automatic displays:
REVIEW 3.4%
SHORT 82.5%
LONG 4.1%
FIELDS 1.5%
PERIODICALS 4.8%
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) 273:38
Average number of searches completed per session 1.2
Retrievals per search - median 41.0
Retrievals per search - average 407.3
Retrievals per search - standard deviation 1908.0
Percent of searches completed with 0 results 28.8%
Percent of searches entered that are long 0.1%
Percent of long searches completed
(includes partial results) 50.0%
Commands entered, by type, excluding errors:
Total Percentage
__________ __________
FIND 2,399 19.8%
DISPLAY (excluding automatic displays) 3,943 32.5%
HELP 1,258 10.4%
EXPLAIN 653 5.4%
SET/RESET 1,385 11.4%
SHOW 214 1.8%
ADD ON (AND, OR, AND NOT) 29 0.2%
LOGON or LOGOFF 1,664 13.7%
COMMENT 1 0.0%
SAVE 75 0.6%
USE 22 0.2%
OTHER 480 4.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:
JOURNAL 1,563 63.9% 519 33.2% 110 630.3 2588.5
EXACT JOURNAL 662 27.1% 156 23.6% 58 181.7 314.0
SUBJECT CAT 59 2.4% 15 25.4% 5,543 5110.3 3741.6
SUBFILE 1 0.0% 0 0.0% 746 746.0 0.0
DATE 29 1.2% 10 34.5% 3 81.3 134.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 132 5.4% 17 12.9% 6 39.8 164.7
By number of indexes:
Multiple 41 1.7% 20 48.8% 12 220.6 604.9
Single 2,357 98.3% 674 28.6% 90 577.7 2267.3
DISPLAY commands, by type, excluding automatic displays:
REVIEW 3.9%
ISSUES 47.6%
SHORT 13.1%
LONG 27.4%
PERIODICALS 4.7%
COMMENTS 0.0%
Other 3.3%
2.3 Error, EXPLAIN and HELP statistics (CC & CCT)
__________________________________________________
Percent of commands that contained errors 10.1%
Ten most frequent errors:
1. First word of command is invalid 30.4%
2. NS command - no next screen 28.9%
3. FIND command with invalid index name 10.0%
4. Index invalid in current database 5.8%
5. D ABS command in database w/o abstracts 1.9%
6. Search term missing from search command 1.9%
7. DISPLAY command contains invalid word 1.9%
8. PS command - no previous screen 1.8%
9. Valid command at an inappropriate time 1.5%
10. Add-on search, no index name after verb 1.4%
11. All others 14.5%
Ten most frequent EXPLAIN requests:
1. CC GUIDE 14.8%
2. FIND (CC DB) 12.0%
3. CC INDEXES 11.2%
4. COMMANDS 7.2%
5. LOCATE (ARTICLE DBS) 6.9%
6. Unrecognized term 4.3%
7. DATABASES 3.1%
8. DISPLAY 3.0%
9. CC DATABASE 2.9%
10. MAIL 2.6%
11. All others 31.8%
Ten most frequent HELP situations:
1. Help requested from START CC command 14.9%
2. First word of command is invalid 13.5%
3. F/BR with index invalid in current DB 9.8%
4. FIND command with invalid index name 7.2%
5. Help requested from SET DB command 6.8%
6. DISPLAY command - middle of >1 screen 5.1%
7. FIND command with zero results 4.7%
8. DISPLAY command-first of >1 screen 4.5%
9. FIND command retrieves >1 book 3.5%
10. DISPLAY command-complete in one screen 2.7%
11. All others 27.3%
Ten most frequent SHOW requests:
1. HISTORY 30.7%
2. SEARCH 15.7%
3. DLA NEWS 8.4%
4. MAIL STATUS 8.4%
5. SC LIST (CC DBS) 4.9%
6. MAIL SETTINGS 4.2%
7. CC NEWS 3.7%
8. CC SETTINGS 3.4%
9. CC GLOSSARY 3.3%
10. LIBRARY NEWS 2.4%
11. All others 14.9%