Footprints Data Model

Table
Table Name Configuration File Repository
Table Definition Now during publishing, new dynamic HBM files will be stored in DB and fetched during session restart. Configuration files are also stored here. Design Notes: Identify all configuration files that application (Renoir) need for startup, and running. - Very important that we identify all the files that application is using today. This will help us with #5. a. Examples; Hibernate Configuration Files, and .Properties files. This does not include Spring Specific files. /application/src/main/resources/footprints-email-incoming.properties /business/src/main/resources/ical4j.properties /business/src/main/resources/assetcore-searchdevice-one-result-response.xml /business/src/main/resources/cosmo.version.txt /business/src/main/resources/jeclicense /business/src/main/resources/privkeystore /business/src/main/resources/timezone.alias /core/src/main/resources/mappings/*.* /core/src/main/resources/footprints-external-data.properties /core/src/main/conf/mysql/*.* /core/src/main/conf/oracle/*.* /core/src/main/conf/postgres/*.* /core/src/main/conf/sqlserver/*.* /infrastructure/src/main/resources/dbschema/*.* /infrastructure/src/main/conf/*.properties /web/src/main/conf/footprints-application-key.properties /build/src/main/deployment/log4j.properties 2. Where to store the configuration files (file data store) - This is a. Database of File Storage We plan doing this as more general file Repository interface that will allow us to select any specific implementation. But in our case we decided to use DB. 3. How to retrieve the files from file data store - Store them in blob format of DB and on demand transform into ByteArrayInputStream.

Attribute
Attribute Name Attribute Definition Logical Datatype Is Required
Configuration File Related Path File name and extension, although some names have non-standard extentions. VARCHAR(255) Yes
Configuration File Content The file contents as a binary array. LARGE BINARY Yes