This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
integration:rdbms:oracle:home [2011/03/14 14:29] 127.0.0.1 external edit |
integration:rdbms:oracle:home [2016/06/28 22:38] (current) |
||
---|---|---|---|
Line 5: | Line 5: | ||
====== Integration: Relational Databases ====== | ====== Integration: Relational Databases ====== | ||
- | ===== Delimited Files ===== | + | ===== Oracle ===== |
- | **[[integration:rdbms:delimited:home|Overview]]** | | + | **[[integration:rdbms:oracle:home|Overview]]** | |
- | [[integration:rdbms:delimited:environments|Environments]] | | + | [[integration:rdbms:oracle:environments|Environments]] | |
- | [[integration:rdbms:delimited:options|Options]] | | + | [[integration:rdbms:oracle:databases|Databases]] | |
- | [[integration:rdbms:delimited:datatypes|Datatypes]] | | + | [[integration:rdbms:oracle:tables|Tables]] | |
- | [[integration:rdbms:delimited:ofx|Offset Indexes]] | | + | [[integration:rdbms:oracle:constraints|Constraints]] | |
- | [[integration:rdbms:delimited:export|Exporting]] | | + | [[integration:rdbms:oracle:datatypes|Datatypes]] | |
- | [[integration:rdbms:delimited:limitations|Limitations]] | | + | [[integration:rdbms:oracle:queries|Queries]] | |
- | [[integration:rdbms:delimited:example|Example]] | + | [[integration:rdbms:oracle:updates|Updates]] | |
+ | [[integration:rdbms:oracle:example|Example]] | ||
---- | ---- | ||
Line 20: | Line 21: | ||
==== Overview ==== | ==== Overview ==== | ||
- | Delimited files separate the content of columns and rows using special delimiter characters. These are commonly used by relational databases and other data-related tools as a standard, portable data format. Tabs and commas are the most common delimiters between columns, and linefeeds are the most common delimiters between rows. Delimited files always store data in character format, though they can correlate to binary datatypes in a table definition. | + | Omnidex can be deployed directly against an Oracle database. Omnidex retrieves and indexes the Oracle data, and queries read directly from the Oracle database as needed. This approach allows Omnidex to work alongside Oracle, providing a high-performance query environment for applications. |
- | Omnidex supports a wide variety of delimited files. Omnidex supports the standard tab-delimited and comma-delimited formats, but also allows any combination of one or two characters for delimiters. This allows great flexibility when receiving data from other sources, and also allows administrators to create delimited files based on their specific needs. Omnidex also allows configuration options specifying how quotation marks to handled, how escape characters are used and whether header rows are present. | + | An Omnidex Environment File controls how Omnidex connects to the Oracle database and identifies the tables and columns that Omnidex will have access to. Omnidex accesses the Oracle data directly using standard SQL statements issued through the Oracle Call Interface (OCI). During indexing and query processing, Omnidex maintains a connection to the Oracle database and accesses the data as needed. Typically, queries are first routed to the Omnidex indexes where specific rowids or primary keys are identified that meet the criteria. Omnidex then fetches the appropriate rows using these values with standard SQL statements. |
- | === Sample Delimited File === | + | {{:integration:rdbms:oracle:basic_architecture_oracle.png|}} |
- | In the example below, each row consumes a variable amount of space, based on the actual length of the data. Columns are separated by commas and rows are separated by linefeeds, so Omnidex will parse the file to read it as a table. All data is stored in character format, including binary data. | + | Omnidex does not migrate the data out of Oracle, but instead directly references the data in the Oracle database. This is not a requirement, though. Migration of the data into raw data files is an option if that is preferable; in fact, many companies use [[admin:features:snapshots:home|Omnidex Snapshots]] for this very purpose. Omnidex Snapshots are high-performing, highly-portable, heavily-indexed copies of data that can be easily accessed using standard ODBC and JDBC interfaces. |
+ | |||
+ | Omnidex is usually deployed on read-only tables. Most applications require tens to hundreds of Omnidex indexes on a table, making real-time updates impractical. Applications usually set aside certain Oracle tables that are refreshed on a regular basis and Omnidex indexes are completely refreshed. Omnidex does support real-time updates for those situations where there are fewer indexes and lower volume. | ||
- | <code> | ||
- | AK,Alaska,02,PC,US,0.000000 | ||
- | AL,Alabama,01,ES,US,4.000000 | ||
- | AR,Arkansas,05,WS,US,4.625000 | ||
- | AZ,Arizona,04,MT,US,5.000000 | ||
- | CA,California,06,PC,US,6.000000 | ||
- | CO,Colorado,08,MT,US,3.000000 | ||
- | CT,Connecticut,09,NE,US,6.000000 | ||
- | DC,District of Columbia,11,SA,US,5.750000 | ||
- | DE,Delaware,10,SA,US,0.000000 | ||
- | FL,Florida,12,SA,US,6.000000 | ||
- | GA,Georgia,13,SA,US,4.000000 | ||
- | HI,Hawaii,15,PC,US,4.000000 | ||
- | IA,Iowa,19,WN,US,5.000000 | ||
- | ID,Idaho,16,MT,US,5.000000 | ||
- | IL,Illinois,17,EN,US,6.250000 | ||
- | IN,Indiana,18,EN,US,5.000000 | ||
- | KS,Kansas,20,WN,US,4.900000 | ||
- | KY,Kentucky,21,ES,US,6.000000 | ||
- | LA,Louisiana,22,WS,US,4.000000 | ||
- | MA,Massachusetts,25,NE,US,5.000000 | ||
- | MD,Maryland,24,SA,US,5.000000 | ||
- | ME,Maine,23,NE,US,6.000000 | ||
- | MI,Michigan,26,EN,US,6.000000 | ||
- | MN,Minnesota,27,WN,US,6.500000 | ||
- | MO,Missouri,29,WN,US,4.225000 | ||
- | MS,Mississippi,28,ES,US,7.000000 | ||
- | MT,Montana,30,MT,US,0.000000 | ||
- | NC,North Carolina,37,SA,US,4.000000 | ||
- | ND,North Dakota,38,WN,US,5.000000 | ||
- | NE,Nebraska,31,WN,US,5.000000 | ||
- | NH,New Hampshire,33,NE,US,0.000000 | ||
- | NJ,New Jersey,34,MA,US,6.000000 | ||
- | NM,New Mexico,35,MT,US,5.000000 | ||
- | NV,Nevada,32,MT,US,6.500000 | ||
- | NY,New York,36,MA,US,4.000000 | ||
- | OH,Ohio,39,EN,US,5.000000 | ||
- | OK,Oklahoma,40,WS,US,4.500000 | ||
- | OR,Oregon,41,PC,US,0.000000 | ||
- | PA,Pennsylvania,42,MA,US,6.000000 | ||
- | RI,Rhode Island,44,NE,US,7.000000 | ||
- | SC,South Carolina,45,SA,US,5.000000 | ||
- | SD,South Dakota,46,WN,US,4.000000 | ||
- | TN,Tennessee,47,ES,US,6.000000 | ||
- | TX,Texas,48,WS,US,6.250000 | ||
- | UT,Utah,49,MT,US,4.750000 | ||
- | VA,Virginia,51,SA,US,3.500000 | ||
- | VT,Vermont,50,NE,US,5.000000 | ||
- | WA,Washington,53,PC,US,6.500000 | ||
- | WI,Wisconsin,55,EN,US,5.000000 | ||
- | WV,West Virginia,54,SA,US,6.000000 | ||
- | WY,Wyoming,56,MT,US,4.000000 | ||
- | </code> | ||
===== ===== | ===== ===== | ||
- | **[[integration:rdbms:delimited:environments|Next]]** | + | **[[integration:rdbms:oracle:environments|Next]]** |
====== Additional Resources ====== | ====== Additional Resources ====== |