This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
integration:rawdata:queries [2011/04/04 21:18] deb |
integration:rawdata:queries [2011/04/12 19:57] 127.0.0.1 external edit |
||
---|---|---|---|
Line 11: | Line 11: | ||
[[integration:rawdata:updates|Updates]] | | [[integration:rawdata:updates|Updates]] | | ||
[[integration:rawdata:creation|Generating Data Files]] | | [[integration:rawdata:creation|Generating Data Files]] | | ||
- | [[integration:rawdata:implementation|Implementation Guides]] | + | [[integration:rawdata:integration|Integration Guides]] |
---- | ---- | ||
Line 28: | Line 28: | ||
== Table Joins == | == Table Joins == | ||
- | Omnidex supports standard table joins between raw data files, including inner joins, outer joins and cross joins. Since raw data files do not generally have native indexing capabilities like relational databases, it is important to install Omnidex indexing on the join columns. This will insure the best optimization of table joins. | + | Omnidex supports standard table joins between raw data files, including inner joins, outer joins, and cross joins. Since raw data files do not generally have native indexing capabilities like relational databases, it is important to install Omnidex indexing on the join columns. This will insure the best optimization of table joins. |
== Aggregations == | == Aggregations == | ||
Line 48: | Line 48: | ||
== Datatypes == | == Datatypes == | ||
- | Raw data files can support retrieving data in a wide variety of datatypes. They can store character and binary data, and data can be further converted in SQL statements. Raw data files do not support VARCHAR and CLOB datatypes due to their reliance on length variables; however, CHARACTER and STRING datatypes may be used instead with greater convenience. | + | Raw data files can support retrieving data in a wide variety of datatypes. They can store character and binary data, and data can be further converted using functions in SQL statements. Raw data files do not support VARCHAR and CLOB datatypes due to their reliance on length variables; however, CHARACTER and STRING datatypes may be used instead with greater convenience. |
==== ==== | ==== ==== |