* [[topbar |Table of Contents]] * [[intro:overview:what|Introduction]] * [[install:home|Installation]] * [[install:editions|Product Editions]] * [[install:requirements|System Requirements]] * [[install:platforms|Supported Platforms]] * [[install:guides:home|Installation Guides]] * [[install:licensing:home|Licensing]] * [[install:releases:home|Release Notes]] * [[admin:home|Administration]] * [[admin:admin:home|Administration Basics]] * [[admin:admin:architecture:home|Omnidex Architecture]] * [[admin:admin:applications:home|Building Applications]] * [[admin:basics:home|Omnidex Fundamentals]] * [[admin:basics:environments:home|Omnidex Environments]] * [[admin:basics:sqlengine:home|Omnidex SQL Engine]] * [[admin:basics:updates:home|Omnidex Updates]] * [[admin:basics:network:home|Network Services]] * [[admin:indexing:home|Omnidex Indexing]] * [[admin:indexing:concepts:home|Indexing Concepts]] * [[admin:indexing:indexes:home|Indexing Options]] * [[admin:indexing:creation:home|Index Creation]] * [[admin:indexing:strategies:home|Indexing Strategies]] * [[admin:indexing:activecounts:home|ActiveCounts]] * [[admin:indexing:powersearch:home|PowerSearch]] * [[admin:indexing:autocomplete:home|AutoComplete]] * [[admin:indexing:text:home|Omnidex Text]] * [[admin:features:home|Omnidex Features]] * [[admin:features:snapshots:home|Omnidex Snapshots]] * [[admin:features:grids:home|Omnidex Grids]] * [[admin:features:rollups:home|Rollup Tables]] * [[admin:features:geo:home|Geographic Searches]] * [[admin:features:expressioncols:home|Expression Columns]] * [[admin:features:segments:home|Omnidex Segments]] * [[admin:features:attach:home|Attaching Data]] * [[admin:features:export:home|Exporting Data]] * [[admin:optimization:home|Optimizing Queries]] * [[admin:optimization:plans:home|Query Plans]] * [[admin:optimization:caches:home|Dynamic Caches]] * [[admin:optimization:config:home|Configuring Omnidex]] * [[integration:home|Integration]] * [[integration:rdbms:home|Relational Databases]] * [[integration:rdbms:oracle:home|Oracle]] * [[integration:rdbms:sqlserver:home|SQL Server]] * [[integration:rdbms:mysql:home|MySQL]] * [[integration:rdbms:odbc:home|Generic ODBC]] * [[integration:rawdata:home|Raw Data Files]] * [[integration:rawdata:fixed:home|Fixed-length Files]] * [[integration:rawdata:delimited:home|Delimited Files]] * [[integration:rawdata:ost:home|Standalone Tables]] * [[dev:home|Development]] * [[dev:sql:home|Omnidex SQL]] * [[dev:sql:overview|Overview]] * [[dev:sql:statements:home|Statements]] * [[dev:sql:functions:home|Functions]] * [[dev:sql:examples:home|Examples]] * [[dev:connections:home|Connection Strings]] * [[dev:odbc:home|ODBC Interface]] * [[dev:jdbc:home|JDBC Interface]] * [[dev:debugging:home|Logging/Debugging]] * [[programs:home|Programs]] * [[programs:odxsql:home|OdxSQL]] * [[programs:odxnet:home|OdxNet]] * [[appendix:home|Appendix]] * [[dev:sql:home|Omnidex SQL]] * [[dev:sql:statements:home|Statements]] * [[dev:sql:functions:home|Functions]] * [[dev:sql:examples:home|Examples]] * [[http://www.omnidex.com/download/|Downloads]] * [[support:home|Support]]

**This is an old revision of the document!** ----

A PCRE internal error occured. This might be caused by a faulty plugin

~~NOTOC~~ {{page>:top_add&nofooter&noeditbtn}} ====== Administration: Omnidex Basics ====== ===== Omnidex SQL Engine ===== **[[admin:basics:sqlengine:home|Overview]]** | [[admin:basics:sqlengine:omnidex|Omnidex Extensions]] | [[admin:basics:sqlengine:oracle|Oracle Extensions]] | [[admin:basics:sqlengine:sqlserver|SQL Server Extensions]] | [[admin:basics:sqlengine:mysql|MySQL Extensions]] ---- ==== Overview ==== The Omnidex product is built around a powerful SQL engine that can process statements and take advantage of the Omnidex indexing technology. This SQL engine can process traditional SQL statements, such as SELECT, INSERT, DELETE and UPDATE, and can also process a wide variety of statements to maintain the database and directly access the Omnidex indexes. The Omnidex SQL Engine is based around [[dev:sql:home|Omnidex SQL]], a language that is based on ANSI-standard SQL and includes a number of Omnidex-specific extensions. The Omnidex SQL Engine automatically optimizes statements so that they use the Omnidex indexes as fully as possible. As is true with most relational databases, developers do not need to refer to the indexing strategy in their statements. They simply submit standard SQL statements that reference the tables and columns in the database. This makes it easy to write new applications, and it also means existing applications that call ANSI-standard SQL will quickly receive the benefit of optimization. The major relational databases, such as Oracle, SQL Server and MySQL, support their own proprietary extensions to the SQL language that only work in their respective databases. Omnidex supports a limited number of these proprietary extensions, such as support for some Oracle functions. Generally, though, applications that use these extensions must be changed to submit ANSI-standard SQL or Omnidex extensions to be processed by Omnidex. Similarly, applications that take advantage of Omnidex extensions will only work against the Omnidex SQL Engine. The Omnidex SQL Engine is available through standard [[dev:odbc:home|ODBC]] and [[dev:jdbc:home|JDBC]] interfaces. It can also be accessed interactively in the Omnidex Administrator and in the console program, OdxSQL. ====== Additional Resources ====== See also: {{page>:admin:basics:see_also&nofooter&noeditbtn}} {{page>:bottom_add&nofooter&noeditbtn}}

 
Back to top
admin/basics/sqlengine/home.1298566596.txt.gz ยท Last modified: 2016/06/28 22:38 (external edit)
 
 
chimeric.de = chi`s home Valid CSS Driven by DokuWiki do yourself a favour and use a real browser - get firefox!! Recent changes RSS feed Valid XHTML 1.0