Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision
Previous revision
admin:basics:sqlengine:home [2011/01/17 19:54]
els created
admin:basics:sqlengine:home [2011/02/25 16:00]
els
Line 1: Line 1:
 +~~NOTOC~~
 +
 {{page>:​top_add&​nofooter&​noeditbtn}} {{page>:​top_add&​nofooter&​noeditbtn}}
  
Line 9: Line 11:
 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 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.  ​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 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.  ​ 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.  ​
Line 17: Line 19:
 See also: See also:
  
-{{page>:​admin:​see_also&​nofooter&​noeditbtn}}+{{page>:​admin:basics:​see_also&​nofooter&​noeditbtn}}
  
 {{page>:​bottom_add&​nofooter&​noeditbtn}} {{page>:​bottom_add&​nofooter&​noeditbtn}}
 
Back to top
admin/basics/sqlengine/home.txt ยท Last modified: 2016/06/28 22:38 (external edit)