1,126
edits
Difference between revisions of "Content Manager OnDemand Database Tables"
Content Manager OnDemand Database Tables (view source)
Revision as of 15:00, 15 October 2016
, 15:00, 15 October 2016→arsapp - OnDemand Application Definition Table: Initial Edit.
m (Added arsapp.) |
(→arsapp - OnDemand Application Definition Table: Initial Edit.) |
||
| Line 250: | Line 250: | ||
!Value!!Sample Value||Type!!Description | !Value!!Sample Value||Type!!Description | ||
|- | |- | ||
|NAME||System Log, CServPDF||VarChar||Name of the Application | |||
|- | |||
|DESCRIPTION||Customer Service PDFs||VarChar||Description of the Application | |||
|- | |||
|AGID||5158||Integer||Numeric Application Group ID that the Application belongs to | |||
|- | |||
|AID||5821||Integer||Numeric Application ID | |||
|- | |||
|DOC_TYPE||x'42', x'55'||Character||Type of document to store in this Application (see table arsapp.doc_type below) | |||
|- | |||
|DOC_COMP_TYPE||x'44',x'46'||Character||Compression method for the document data | |||
|- | |||
|RES_COMP_TYPE||x'4E',x'4F'||Character||Compression method for the resource data | |||
|- | |||
|IDX_TYPE||x'41',x'47'||Character||The type of indexer to use for this data | |||
|- | |||
|COMP_OBJ_SIZE||100,9999||Integer||Size of the compressed objects that CMOD builds at load time | |||
|- | |||
|PID||Unknown||Integer||Unknown | |||
|- | |||
|ALIAS||Unknown||VarChar||Unknown | |||
|- | |||
|FIXED_VIEW||N/A||Character Large Object (32k)||Contains information about how to view line data | |||
|- | |||
|INDEXER||N/A||Character Large Object (32k)||Stores the indexing parameters for indexing documents with ACIF, ARSPDOCI, or Xenos | |||
|- | |||
|PREPROCESSOR||N/A||Character Large Object (32k)||Stores pre-processing commands for manipulating metadata before loading | |||
|- | |||
|UPD_USERID||ADMIN||VarChar||The User ID of the user that last updated the Application | |||
|- | |||
|UPD_DATE||119287486874||BigInteger||The UNIX-timestamp of the time the Application was last updated. | |||
|- | |||
|DB_EXP_DATE||16494||Integer||It is currently unknown how this date value is used. | |||
|- | |||
|APPL_TYPE||0||Integer||It is currently unknown how this integer value is used. | |||
|} | |||
=== arsapp.doc_type - Type of document to store in the Application === | |||
{|class="wikitable" | |||
|- | |||
!Database Value!!ASCII Character||Document Type!!Description | |||
|- | |||
|x'41'||A||AFP||IBM's Advanced Function Presentation - print output from mainframes | |||
|- | |||
|x'42'||B||BMP||Windows Bitmap Format | |||
|- | |||
|x'47'||G||GIF||Compuserve Graphics Interchange Format | |||
|- | |||
|x'4A'||J||JPEG||Joint Photographic Experts Group | |||
|- | |||
|x'4C'||L||TXT||L for "log" data. ASCII text. | |||
|- | |||
|x'4E'||N||None||There is no document data, just metadata. Primarily used for the System Log. | |||
|- | |||
|x'50'||P||PCX||PC Paintbrush image format | |||
|- | |||
|x'52'||R||PDF||Adobe's Portable Document Format | |||
|- | |||
|x'54'||T||TIFF||Tagged Image File Format | |||
|- | |||
|x'55'||U||User-Defined||A type of data for which OnDemand has no native indexer or viewer. (Word, Excel, Zip, MP3, MP4) | |||
|} | |||
=== arsapp.doc_comp_type and arsapp.res_comp_type - Data compression method to use === | |||
{|class="wikitable" | |||
|- | |||
!Database Value!!ASCII Character||Document Type!!Description | |||
|- | |||
|x'44'||D||Disable||Don't compress data during storage or transport | |||
|- | |||
|x'46'||F||OD77Lite||Faster version of OD77 | |||
|- | |||
|x'4C'||L||LZW12||Lempel-Ziv-Welch compression - use OD77 or OD77Lite instead (deprecated) | |||
|- | |||
|x'4E'||N||None||Don't compress data at load time, compress during retrieval | |||
|- | |||
|x'4F'||O||OD77||Content Manager OnDemand's purpose-built compressor for AFP & Line Data | |||
|- | |||
|x'4C'||L||LZW16||Lempel-Ziv-Welch compression - use OD77 or OD77Lite instead (deprecated) | |||
|} | |||
'''Why would you want to disable compression?''' Some data types stored in OnDemand are already compressed -- JPEG, PDF, GIF, or even user defined data types like MP3 audio or Zip files. Attempting to compress these files usually results in no real savings in storage space (and in some cases, may even make the file bigger) and waste considerable CPU time. | |||
'''What's the difference between 'None' and 'Disable'?''' The 'none' option doesn't compress the file when it's loaded into CMOD, but WILL attempt to compress it before sending it to the end user at the time it's retrieved. There so few examples of why this would be beneficial, that I can't even think of any to tell you. | |||
=== arsapp.idx_type - Selected Indexer for the Application === | |||
{|class="wikitable" | |||
|- | |||
!Database Value!!ASCII Character||Document Type!!Description | |||
|- | |||
|x'41'||A||ACIF||AFP Control and Indexing Facility (AFP & Line Data) | |||
|- | |||
|x'47'||G||Generic||Uses a formatted text file to populate metadata fields | |||
|- | |||
|x'4E'||N||None||No indexer | |||
|- | |||
|x'50'||P||PDF||The built-in PDF indexer, ARSPDOCI. | |||
|- | |||
|x'58'||X||Xenos||The third-party Xenos indexer from OpenText (formerly Actuate) | |||
|} | |} | ||