1 # ----------------------------------------
2 # LOGGING
3 
4 LOG-FILE: combined-log
5 
6 collection.log_file: @LOG-FILE
7 identifiers.log_file: @LOG-FILE
8 metadata.log_file: @LOG-FILE
9 query.log_file: @LOG-FILE
10 
11 # ----------------------------------------
12 # VALIDATION
13 
14 VALIDATION: off
15 
16 metadata.validation: @VALIDATION
17 query.validation: @VALIDATION
18 
19 # ----------------------------------------
20 # DATABASE
21 
22 DATABASE-DRIVER-CLASS: com.informix.jdbc.IfxDriver
23 DATABASE-URL: jdbc:informix-sqli://db02.alexandria.ucsb.edu:1525/drg_teale:INFORMIXSERVER=adl_db02
24 DATABASE-PROPERTIES: /export/home/gjanee/tomcat/database-props
25 DATABASE-NAME: informix@@db02
26 
27 identifiers.database_driver_class: @DATABASE-DRIVER-CLASS
28 identifiers.database_url: @DATABASE-URL
29 identifiers.database_properties: @DATABASE-PROPERTIES
30 
31 metadata.database_driver_class: @DATABASE-DRIVER-CLASS
32 metadata.database_url: @DATABASE-URL
33 metadata.database_properties: @DATABASE-PROPERTIES
34 
35 query.database_driver_class: @DATABASE-DRIVER-CLASS
36 query.database_url: @DATABASE-URL
37 query.database_properties: @DATABASE-PROPERTIES
38 query.database_name: @DATABASE-NAME
39 
40 # ----------------------------------------
41 # COLLECTION-LEVEL METADATA
42 
43 collection.metadata_url: http://collections.alexandria.ucsb.edu/drg_24k_ca/metadata.xml
44 
45 # ----------------------------------------
46 # IDENTIFIERS
47 
48 metadata.identifier_datatype: string
49 
50 identifiers.query: SELECT ocode FROM ingest
51 
52 # ----------------------------------------
53 # ITEM-LEVEL METADATA
54 
55 metadata.views: BUCKET,BROWSE,ACCESS,FGDC
56 
57 BUCKET.name: adl:bucket
58 BUCKET.class: edu.ucsb.adl.bucket99.GenericQueryMetadataSubdriver
59 BUCKET.template: bucket-report-template.xml
60 BUCKET.queries: BUCKET-MAIN-QUERY
61 BUCKET-MAIN-QUERY.prefix: main
62 BUCKET-MAIN-QUERY.query: SELECT ocode, title, mapname, state, n_b_coord, s_b_coord, e_b_coord, w_b_coord, year FROM ingest WHERE ocode = ?
63 BUCKET-MAIN-QUERY.columns: ocode,title,mapname,state,n_b_coord,s_b_coord,e_b_coord,w_b_coord,year
64 BUCKET-MAIN-QUERY.num_rows_expected: 1
65 
66 BROWSE.name: adl:browse
67 BROWSE.class: edu.ucsb.adl.bucket99.GenericQueryMetadataSubdriver
68 BROWSE.template: browse-report-template.xml
69 BROWSE.queries: BROWSE-MAIN-QUERY
70 BROWSE-MAIN-QUERY.prefix: main
71 BROWSE-MAIN-QUERY.query: SELECT ocode, bytesize_browse, bytesize_thumb FROM ingest WHERE ocode = ?
72 BROWSE-MAIN-QUERY.columns: ocode,bytesize_browse,bytesize_thumb
73 BROWSE-MAIN-QUERY.num_rows_expected: 1
74 
75 ACCESS.name: adl:access
76 ACCESS.class: edu.ucsb.adl.bucket99.GenericQueryMetadataSubdriver
77 ACCESS.template: access-report-template.xml
78 ACCESS.queries: ACCESS-MAIN-QUERY
79 ACCESS-MAIN-QUERY.prefix: main
80 ACCESS-MAIN-QUERY.query: SELECT ocode, ROUND(mbytesize_tif), ROUND(mbytesize_tif*0.4), local_call_num FROM ingest WHERE ocode = ?
81 ACCESS-MAIN-QUERY.columns: ocode,mbytesize_tif_rounded,mrsid_size_approximation,local_call_num
82 ACCESS-MAIN-QUERY.num_rows_expected: 1
83 
84 FGDC.name: FGDC
85 FGDC.class: edu.ucsb.adl.bucket99.GenericQueryMetadataSubdriver
86 FGDC.template: fgdc-report-template.xml
87 FGDC.queries: FGDC-MAIN-QUERY
88 FGDC-MAIN-QUERY.prefix: main
89 FGDC-MAIN-QUERY.query: SELECT title, year, n_b_coord, s_b_coord, e_b_coord, w_b_coord, mapname, state FROM ingest WHERE ocode = ?
90 FGDC-MAIN-QUERY.columns: title,year,n_b_coord,s_b_coord,e_b_coord,w_b_coord,mapname,state
91 FGDC-MAIN-QUERY.num_rows_expected: 1
92 
93 # ----------------------------------------
94 # QUERY PROCESSING
95 
96 query.minimum_connections: 1
97 query.maximum_connections: 2
98 query.connection_lifetime: 1h
99 query.connection_reaper_cycle_time: 10m
100 query.test_query: SELECT COUNT(*) FROM ingest
101 
102 # ----------------------------------------
103 # QUERY TRANSLATION
104 
105 query.translator_class: edu.ucsb.adl.bucket99.PythonQueryTranslator
106 
107 translator.script: query-translator.py
108 translator.python_module_path:
109 translator.python_class_path:
110 translator.python_jar_path:
111 
112 # ----------------------------------------
113 # VOCABULARIES
114 
115 # This collection doesn't require or use
116 # the vocabulary interface, and so the
117 # 'translator.vocabularies' property
118 # should have an empty value. But we
119 # include an example vocabulary here just
120 # to show what's possible.
121 
122 translator.vocabularies: TYPES
123 
124 TYPE-DATABASE-DRIVER-CLASS: com.informix.jdbc.IfxDriver
125 TYPE-DATABASE-URL: jdbc:informix-sqli://db02.alexandria.ucsb.edu:1525/catalog99:INFORMIXSERVER=adl_db02
126 TYPE-DATABASE-PROPERTIES: /export/home/gjanee/tomcat/database-props
127 
128 TYPES.class: edu.ucsb.adl.bucket99.DatabaseCodedVocabulary
129 TYPES.name: ADL Object Type Thesaurus
130 TYPES.bucket: adl:types
131 TYPES.vocabulary_database_driver_class: @TYPE-DATABASE-DRIVER-CLASS
132 TYPES.vocabulary_database_url: @TYPE-DATABASE-URL
133 TYPES.vocabulary_database_properties: @TYPE-DATABASE-PROPERTIES
134 TYPES.term_code_query: SELECT name, type_id FROM j_type
135 TYPES.code_graph_query: SELECT parent_type_id, type_id FROM j_type_parent
136 TYPES.code_usage_query: SELECT DISTINCT type_id FROM j_holding_type
137 TYPES.usage_database_driver_class: @TYPE-DATABASE-DRIVER-CLASS
138 TYPES.usage_database_url: @TYPE-DATABASE-URL
139 TYPES.usage_database_properties: @TYPE-DATABASE-PROPERTIES