This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
|
integration:rawdata:delimited:limitations [2011/03/14 14:21] 127.0.0.1 external edit |
integration:rawdata:delimited:limitations [2016/06/28 22:38] (current) |
||
|---|---|---|---|
| Line 3: | Line 3: | ||
| {{page>:top_add&nofooter&noeditbtn}} | {{page>:top_add&nofooter&noeditbtn}} | ||
| - | ====== Adminstration: Raw Data Files ====== | + | ====== Integration: Raw Data Files ====== |
| ===== Delimited Files ===== | ===== Delimited Files ===== | ||
| Line 25: | Line 25: | ||
| * **Datatypes** - Delimited files can store nearly every datatype supported by Omnidex, including proprietary datatypes such as ORACLE DATETIME or ODBC DATETIME. An exception to this is the relational datatypes, VARCHAR and CLOB. These datatypes cannot be represented in delimited files because they require separate storage for length and NULL indicators. For delimited files, the STRING and CHARACTER datatypes should be used instead. | * **Datatypes** - Delimited files can store nearly every datatype supported by Omnidex, including proprietary datatypes such as ORACLE DATETIME or ODBC DATETIME. An exception to this is the relational datatypes, VARCHAR and CLOB. These datatypes cannot be represented in delimited files because they require separate storage for length and NULL indicators. For delimited files, the STRING and CHARACTER datatypes should be used instead. | ||
| - | * **NULL's** - Delimited files are not capable of differentiating a NULL column as is done in relational databases. Omnidex will treats empty fields as NULL fields to compensate for this. For character-class datatypes, an IS NULL test will qualify any row containing an empty space in that column. For binary-class datatypes, an IS NULL test will qualify any row containing a zero in that column. | + | * **NULLs** - Delimited files are not capable of differentiating a NULL column as is done in relational databases. Omnidex will treat empty fields as NULL fields to compensate for this. For character-class datatypes, an IS NULL test will qualify any row containing an empty space in that column. For binary-class datatypes, an IS NULL test will qualify any row containing a zero in that column. |
| * **Deletes and Updates** - Omnidex supports INSERT statements against delimited files, but it cannot support the UPDATE or DELETE statement. If UPDATE or DELETE statements are required, consider using [[admin:features:ost:home|Omnidex Standalone Tables]]. | * **Deletes and Updates** - Omnidex supports INSERT statements against delimited files, but it cannot support the UPDATE or DELETE statement. If UPDATE or DELETE statements are required, consider using [[admin:features:ost:home|Omnidex Standalone Tables]]. | ||
| - | * **Data Conversions** - Delimited files store all data in character format, including binary data such as integers, floating point data and dates. These conversions add overhead to the parsing of the data. Files with a large number of binary fields can achieve better performance using fixed-length files or [[admin:features:ost:home|Omnidex Standalone Tables]] | + | * **Data Conversions** - Delimited files store all data in character format, including binary data such as integers, floating point data, and dates. These conversions add overhead to the parsing of the data. Files with a large number of binary fields can achieve better performance using fixed-length files or [[admin:features:ost:home|Omnidex Standalone Tables]] |
| * **Security** - Delimited files are not encrypted as they might be in a relational database. Care should be taken with file system security to properly protect the data. | * **Security** - Delimited files are not encrypted as they might be in a relational database. Care should be taken with file system security to properly protect the data. | ||
| - | Despite these limitations, delimited files provide a fast, flexible and portable solution that brings performance and ease to an application. | + | Despite these limitations, delimited files provide a fast, flexible, and portable solution that brings performance and ease to an application. |
| ===== ===== | ===== ===== | ||