MELVYL CURRENT CONTENTS DATABASE TELNET STATISTICS
Time period: 02/01/99 through 02/28/99
1.0 SUMMARY STATISTICS
_______________________
1.1 Total sessions:
____________________
Location Library Remote Total
________ _______ ______ _____
Berkeley 2,017 6,641 8,658
Davis 4,597 369 4,966
Irvine 4,228 0 4,228
Los Angeles 869 3,630 4,499
Riverside 1,203 768 1,971
San Diego 410 2,836 3,246
San Francisco 1,758 17 1,775
Santa Barbara 1,214 1,754 2,968
Santa Cruz 1,293 998 2,291
LBL 0 826 826
LLL 0 1,026 1,026
Los Alamos n/a 63 63
Other - UC 12 475 487
U.S. Forestry 8
Other-Network UC n/a 3,842 3,842
_______ ______ _____
17,601 23,245 40,854
Per hour usage:
Time Sessions Finds Records Displayed
__________ __________ __________ _________________
12-2 a.m. 617 2,239 22,990
2-4 a.m. 386 1,919 15,369
4-6 a.m. 373 1,660 16,433
6-8 a.m. 869 3,659 35,930
8-10 a.m. 3,728 11,868 114,847
10-12 a.m. 6,908 20,590 194,366
12-2 p.m. 7,275 20,589 191,794
2-4 p.m. 8,571 25,037 233,051
4-6 p.m. 6,270 19,061 179,863
6-8 p.m. 2,674 8,744 81,968
8-10 p.m. 1,966 6,059 57,217
10-12 p.m. 1,217 4,530 56,508
__________ __________ __________ _________________
Total: 40,854 125,955 1,200,336
1.2 FIND commands
__________________
Number of FIND commands issued by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 5,590 21,160 26,750
Davis 13,550 960 14,510
Irvine 13,095 0 13,095
Los Angeles 2,582 11,431 14,013
Riverside 3,163 2,251 5,414
San Diego 1,293 8,420 9,713
San Francisco 5,185 44 5,229
Santa Barbara 3,826 5,999 9,825
Santa Cruz 3,505 3,064 6,569
LBL 0 2,944 2,944
LLL 0 5,414 5,414
Los Alamos n/a 181 181
Other - UC 18 1,251 1,269
U.S. Forestry 23
Other-Network UC n/a 11,006 11,006
_______ ______ _____
51,807 74,125 125,955
Number of FIND commands by database
CC database 123,363
CCT database 2,592
Total number of FIND commands 125,955
1.3 Records displayed
______________________
Number of Records Displayed by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 53,992 235,758 289,750
Davis 116,086 7,842 123,928
Irvine 102,288 0 102,288
Los Angeles 20,027 121,518 141,545
Riverside 19,577 36,055 55,632
San Diego 9,690 70,058 79,748
San Francisco 41,150 388 41,538
Santa Barbara 34,997 59,959 94,956
Santa Cruz 28,597 33,045 61,642
LBL 0 34,037 34,037
LLL 0 59,454 59,454
Los Alamos n/a 2,897 2,897
Other - UC 102 11,632 11,734
U.S. Forestry 34
Other-Network UC n/a 100,719 100,719
_______ ______ _____
426,506 773,362 1,199,902
Number of Records Displayed by database:
CC database 1,108,837
CCT database 91,499
Total number of Records Displayed 1,199,902
1.4 Relative Use of Databases
______________________________
Relative use of CC vs. CCT databases:
Percent of CC sessions 94.9%
Percent of CCT sessions 5.1%
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 0.9
Standard deviation in seconds 3.4
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.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) 512:56
Average number of searches completed per session 3.2
Retrievals per search - median 10.0
Retrievals per search - average 558.1
Retrievals per search - standard deviation 5647.4
Percent of searches completed with 0 results 24.2%
Percent of searches entered that are long 0.2%
Percent of long searches completed
(includes partial results) 40.5%
Commands entered, by type, excluding errors:
Total Percentage
__________ __________
FIND 114,537 36.7%
DISPLAY (excluding automatic displays) 89,550 28.7%
HELP 5,853 1.9%
EXPLAIN 5,517 1.8%
SET/RESET 15,228 4.9%
SHOW 894 0.3%
ADD ON (AND, OR, AND NOT) 8,826 2.8%
LOGON or LOGOFF 50,240 16.1%
COMMENT 3 0.0%
SAVE 5,894 1.9%
USE 173 0.1%
OTHER 15,450 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 49,697 39.8% 7,204 14.5% 28 214.9 1278.6
TITLE WORD 43,426 34.8% 12,413 28.6% 19 731.3 5115.3
EXACT TITLE 1,114 0.9% 625 56.1% 2 194.0 1240.7
JOURNAL 5,486 4.4% 2,225 40.6% 621 6486.6 26110.6
EXACT JOURNAL 3,376 2.7% 1,774 52.5% 168 3064.6 8241.4
SUBJECT CAT 474 0.4% 61 12.9% 18 906.4 14915.1
SUBFILE 366 0.3% 29 7.9% 27 176.9 712.7
PUBLICATION TYPE 465 0.4% 97 20.9% 11 2914.0 21465.2
LANGUAGE 374 0.3% 70 18.7% 24 547.6 4266.8
DATE 1,936 1.6% 360 18.6% 11 140.1 571.6
ADDED 2,254 1.8% 1,575 69.9% 16 27.9 38.9
PERIODICAL 3,730 3.0% 792 21.2% 7 380.9 2494.0
EXACT PE 810 0.6% 122 15.1% 3 46.2 340.5
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 11,323 9.1% 3,377 29.8% 22 880.3 5715.5
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,308 9.0% 3,847 37.3% 7 99.0 1022.2
Single 103,802 91.0% 22,905 22.1% 29 824.9 6916.7
DISPLAY commands, by type, excluding automatic displays:
REVIEW 3.3%
SHORT 80.8%
LONG 5.0%
FIELDS 1.4%
PERIODICALS 5.6%
COMMENTS 0.0%
Other 3.9%
2.1 CCT Database Statistics
____________________________
Median session length (minutes:seconds) 0:00
Average session length (minutes:seconds) 0:00
Longest session recorded (minutes:seconds) 175:16
Average number of searches completed per session 1.3
Retrievals per search - median 38.0
Retrievals per search - average 334.3
Retrievals per search - standard deviation 1556.9
Percent of searches completed with 0 results 30.9%
Percent of searches entered that are long 0.2%
Percent of long searches completed
(includes partial results) 0.0%
Commands entered, by type, excluding errors:
Total Percentage
__________ __________
FIND 2,580 20.4%
DISPLAY (excluding automatic displays) 3,973 31.4%
HELP 1,351 10.7%
EXPLAIN 623 4.9%
SET/RESET 1,447 11.4%
SHOW 269 2.1%
ADD ON (AND, OR, AND NOT) 12 0.1%
LOGON or LOGOFF 1,850 14.6%
COMMENT 2 0.0%
SAVE 24 0.2%
USE 23 0.2%
OTHER 512 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,652 63.4% 598 36.2% 84 506.6 1915.3
EXACT JOURNAL 729 28.0% 175 24.0% 58 145.3 248.3
SUBJECT CAT 41 1.6% 9 21.9% 5,994 7029.0 4192.5
SUBFILE 0 0.0% 0 0.0% 0 0.0 0.0
DATE 26 1.0% 4 15.4% 5 860.1 3292.2
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 158 6.1% 22 13.9% 5 45.8 149.1
By number of indexes:
Multiple 33 1.3% 12 36.4% 5 17.2 39.9
Single 2,540 98.7% 784 30.9% 63 491.9 1868.5
DISPLAY commands, by type, excluding automatic displays:
REVIEW 3.0%
ISSUES 46.7%
SHORT 12.1%
LONG 29.4%
PERIODICALS 5.3%
COMMENTS 0.0%
Other 3.5%
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.9%
2. NS command - no next screen 27.1%
3. FIND command with invalid index name 10.2%
4. Index invalid in current database 6.9%
5. DISPLAY command contains invalid word 2.1%
6. Search term missing from search command 1.9%
7. PS command - no previous screen 1.8%
8. D ABS command in database w/o abstracts 1.7%
9. Valid command at an inappropriate time 1.6%
10. F SUB CAT search with invalid SC 1.6%
11. All others 14.1%
Ten most frequent EXPLAIN requests:
1. CC GUIDE 16.1%
2. FIND (CC DB) 13.0%
3. CC INDEXES 11.3%
4. LOCATE (ARTICLE DBS) 9.7%
5. COMMANDS 6.1%
6. Unrecognized term 4.7%
7. CC DATABASE 3.3%
8. DATABASES 2.9%
9. ADD-ON SEARCH 2.8%
10. DISPLAY 2.2%
11. All others 27.9%
Ten most frequent HELP situations:
1. First word of command is invalid 14.2%
2. Help requested from START CC command 14.0%
3. F/BR with index invalid in current DB 11.2%
4. FIND command with invalid index name 7.5%
5. Help requested from SET DB command 6.3%
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.2%
9. FIND command retrieves >1 book 3.6%
10. DISPLAY command-complete in one screen 3.0%
11. All others 25.5%
Ten most frequent SHOW requests:
1. HISTORY 35.4%
2. SEARCH 17.2%
3. DLA NEWS 10.1%
4. MAIL STATUS 8.4%
5. SC LIST (CC DBS) 4.9%
6. CC GLOSSARY 4.7%
7. CC NEWS 4.2%
8. CC SETTINGS 3.2%
9. LIBRARY NEWS 2.0%
10. MAIL SETTINGS 1.7%
11. All others 8.2%