Differences

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

--- dev:home [2010/05/21 20:20]
tdo
+++ dev:home [2016/06/28 22:38] (current)
@@ Line 1: / Line 1: @@
 {{page>:top_add&nofooter&noeditbtn}}
-<html><div align="center"><span style="color:red">DRAFT</span></div></html>
-====== Omnidex Development Quick Reference ======
-^ Development ^ [[dev:odbc:examples:simpleselect | C++ ]] ^ [[dev:odbc:examples:csharp_simple_select |C# ]] ^ [[dev:jdbc:examples:simpleselect | Java ]] ^ [[dev:odbc:examples:php_select | PHP ]] ^ [[dev:dbprocs:oracle:sample_code | PLSQL ]] ^[[dev:dbprocs:sqlserver:sample_code | TRANSACT ]] ^ [[dev:debug | Debug ]] ^
-^ Programs ^ [[programs:odxadmin:home | OdxAdmin ]] ^ [[programs:odxsql:home | OdxSQL ]] ^ [[programs:odxnet:home | OdxNet ]] ^ [[programs:odxaim:home | OdxAim ]] ^ [[ dev:home | Quick Ref ]] ^
-^ Interfaces ^ [[dev:odbc:home | ODBC ]] ^ [[dev:jdbc:home | JDBC ]] ^ [[dev:dbprocs:home | DB Procs ]] ^
-{{page>:sql_bar&nofooter&noeditbtn}}
-===== Omnidex Environment =====
-Omnidex Environments are used to specify information on the location and layout of the underlying data and how the data is indexed with the Omnidex indexes.
-<code>
-/* Simple Star Schema */
-create environment    "SIMPLE_ENV"
- in                   "simple.xml"
- with                 delete;
+====== Development ======
+===== Introduction =====
-create database       "SIMPLE"
+The section discusses the techniques for developing Omnidex applications.  This is most often read by Omnidex Developers.
-  type                FLATFILE
-  index_directory     "idx\SIMPLE_"
- in                   "simple.xml";
+Choose from these topics:
-create table          "COUNTRIES"
+|< 100% 35% 65% >|
- physical             "dat\cnt.dat"
+| \\ **Omnidex SQL**                                                          ||
- (
+|[[dev:sql:home|Omnidex SQL Quick Reference]]                                 | A quick-reference guide to Omnidex SQL, including statements and functions.            |
-  "COUNTRY"           CHARACTER(2)      omnidex,
+|[[dev:sql:statements:home|Omnidex SQL Statements]]                           | A guide to all Omnidex SQL Statements.                                                 |
-  "DESCRIPTION"       C STRING(47)      quicktext,
+|[[dev:sql:functions:home|Omnidex SQL Functions]]                             | A guide to all Omnidex SQL Functions.                                                  |
-  "LATITUDE"          FLOAT             omnidex      usage "LATITUDE",
+|[[dev:sql:qualify:home|Omnidex SQL Qualification Syntax]]                    | A guide to all Omnidex SQL Qualification Syntax.                                       |
-  "LONGITUDE"         FLOAT             omnidex      usage "LONGITUDE",
+|[[dev:sql:examples:home|Omnidex SQL Examples]]                               | Examples of how to use Omnidex SQL in various situations.                              |
-  "CAPITAL"           C STRING(31)      quicktext,
+| \\ **Connection Strings**                                                   ||
-  "CAPITAL_LAT"       FLOAT             omnidex      usage "LATITUDE",
+|[[dev:connections:home|Connection Strings]]                                  | A guide to Omnidex Connection Strings.                                                 |
-  "CAPITAL_LONG"      FLOAT             omnidex      usage "LONGITUDE",
+| \\ **ODBC Interface**                                                       ||
-  constraint COUNTRIES_COUNTRY_PK primary ("COUNTRY")
+|[[dev:odbc:home|ODBC Interface]]                                             | A guide to using the Omnidex ODBC Interface, including sample programs.                |
- )
+| \\ **JDBC Interface**                                                       ||
- in                   "simple.xml";
+|[[dev:jdbc:home|JDBC Interface]]                                             | A guide to using the Omnidex JDBC Interface, including sample programs.                |
+| \\ **Logging and Debugging**                                                ||
+|[[dev:debug:log|Omnidex Connection and Query Logging]]                       | A guide to logging and monitoring Omnidex connections and queries.                     |
+|[[dev:debug:debug|Omnidex Debugging]]                                        | A guide to debugging Omnidex applications.                                             |
+| \\ **Querying Metadata**                                                    ||
+|[[dev:metadata:home|Querying Metadata]]                                      | A guide to interactively querying metadata from the Omnidex Environment File.          |
-create table          "STATES"
+{{page>:bottom_add&nofooter&noeditbtn}}
- physical             "dat\sta.dat"
- (
-  "STATE"             CHARACTER(2)      omnidex,
-  "DESCRIPTION"       C STRING(31)      quicktext,
-  "STATE_CODE"        CHARACTER(2)      omnidex,
-  "REGION"            CHARACTER(2)      omnidex,
-  "COUNTRY"           CHARACTER(2)      omnidex,
-  "TAX_RATE"          FLOAT             omnidex,
-  constraint STATES_STATE_PK primary ("STATE"),
-  constraint STATES_COUNTRY_FK foreign ("COUNTRY") references "COUNTRIES"
- )
- in                   "simple.xml";
-create table          "GENDERS"
- physical             "dat\gdr.dat"
- (
-  "GENDER"            CHARACTER(1)      omnidex,
-  "DESCRIPTION"       C STRING(31)      quicktext,
-  constraint GENDERS_GENDER_PK primary ("GENDER")
- )
- in                   "simple.xml";
-create table          "HOUSEHOLDS"
- physical             "dat\households.dat"
- (
-  "HOUSEHOLD"         CHARACTER(12)     omnidex,
-  "ADDRESS"           CHARACTER(50)     quicktext,
-  "CITY"              CHARACTER(28)     quicktext,
-  "STATE"             CHARACTER(2)      omnidex,
-  "ZIP"               CHARACTER(5)      omnidex,
-  "COUNTRY"           CHARACTER(2)      omnidex,
-  constraint HOUSEHOLDS_HOUSEHOLD_PK primary ("HOUSEHOLD"),
-  constraint HOUSEHOLDS_STATE_FK foreign ("STATE") references "STATES",
-  constraint HOUSEHOLDS_COUNTRY_FK foreign ("COUNTRY") references "COUNTRIES"
- )
- in                   "simple.xml";
-create table          "INDIVIDUALS"
- physical             "dat\individuals.dat"
- (
-  "INDIVIDUAL"        CHARACTER(12)     omnidex,
-  "HOUSEHOLD"         CHARACTER(12)     omnidex,
-  "NAME"              CHARACTER(50)     quicktext,
-  "GENDER"            CHARACTER(1)      omnidex bitmap,
-  "BIRTHDATE"         ANSI DATE         omnidex,
-  "PHONE"             CHARACTER(14)     omnidex,
-  "EMAIL"             CHARACTER(60)     quicktext,
-  constraint INDIVIDUALS_INDIVIDUAL_PK primary ("INDIVIDUAL"),
-  constraint INDIVIDUALS_HOUSEHOLD_FK foreign ("HOUSEHOLD") references "HOUSEHOLDS",
-  constraint INDIVIDUALS_GENDER_FK foreign ("GENDER") references "GENDERS",
- )
- in                   "simple.xml";
-</code>
-===== Interfaces =====
-  * [[dev:odbc:home | ODBC ]]
-  * [[dev:jdbc:home | JDBC ]]
-  * [[dev:dbprocs:home | RDBMS Stored Procedure Interface ]]
-===== Debugging =====
-  * [[ dev:debug | Debugging ]]
-===== Pre Version 5.1 Environment Catalog Syntax =====
-  * [[ oaenv:home | Environment Catalog Syntax ]]
-===== Tutorials =====
-==== Creating a small Environment on a Flat File ====
-  * [[ dev:tutorials:simple_envrionment_flat | Simple Environment on Flat File ]]
-===== Example Programs =====
-^ Language ^ Example ^
-| Java | [[dev:jdbc:examples:simpleselect | Java JDBC Simple Connection and Select ]] |
-| PHP | [[dev:odbc:examples:php_select | PHP Simple Connection and Select ]] |
-| C++ | [[dev:odbc:examples:simpleselect | Windows C++ Simple Connection and Select ]] |
-| C# | [[dev:odbc:examples:csharp_simple_select | Windows C# Simple Connection and Select ]] |
-| TransactSQL | [[dev:dbprocs:sqlserver:sample_code | SQL Server TransactSQL Stored Procedure Example ]] |
-| PL/SQL | [[dev:dbprocs:oracle:sample_code | Oracle PL/SQL Stored Procedure Example ]] |
-===== Main Development Components =====
-Omnidex Development uses the following main components of the Omnidex Software.
-  * [[ programs:odxadmin:home | Omnidex Administrator ]]
-  * [[ programs:odxsql:home | OdxSQL ]]
-  * [[ programs:odxnet:home | OdxNet ]]
-  * [[ programs:odxaim:home | OdxAim ]]
-  * [[ dev:odbc:home | Omnidex ODBC Driver ]]
-  * [[ dev:jdbc:home | Omnidex JDBC Driver ]]
-  * [[ dev:dbprocs:home | RDBMS Stored Procedure Interface ]]
-===== Java Snapshot Application Steps =====
-  * Install Omnidex on Snapshot data store.
-  * Set up OdxNet Network Services.
-  * Use OdxSQL to test set up, prototype and optimize queries.
-  * Write Java Application.
-===== Windows Snapshot Applications =====
-  * Install Omnidex on Snapshot data store.
-  * Set up OdxNet Network Services.
-  * Use OdxSQL to test set up, prototype and optimize queries.
-  * Write Java Application.
-===== RDBMS Integration =====
-  * Install Omnidex on RDBMS.
-  * Use OdxSQL to test set up, prototype and optimize queries.
-  * Write Stored Procedures using the RDBMS Stored Procedure Interface.
-  * Run OdxAIM to generate Automatic Update Triggers.
-  * Install Triggers.
-  * Run OdxAim to monitor and process the triggered updates.
-Omnidex Development primarily takes the form of developing either an ODBC or JDBC based application or using either SQL Server or Oracle Stored Procedures.
-Applications have also been previously developed using the OmniAccess API (OA) and Client OmniAccess (CLOA) api.  DISC recommends that all future Omnidex development use ODBC, JDBC or the Stored Procedure Interface.
-  * [[dev:odbc:home | ODBC ]]
-  * [[dev:jdbc:home | JDBC ]]
-  * [[dev:dbprocs:home | RDBMS Stored Procedure Interface ]]
-Applications using Omnidex have been developed using:
-^ Language ^ Example ^
-| Java | [[dev:jdbc:examples:simpleselect | Java JDBC Simple Connection and Select ]] |
-| PHP | [[dev:odbc:examples:php_select | PHP Simple Connection and Select ]] |
-| C++ | [[dev:odbc:examples:simpleselect | Windows C++ Simple Connection and Select ]] |
-| C# | [[dev:odbc:examples:csharp_simple_select | Windows C# Simple Connection and Select ]] |
-| TransactSQL | [[dev:dbprocs:sqlserver:sample_code | SQL Server TransactSQL Stored Procedure Example ]] |
-| PL/SQL | [[dev:dbprocs:oracle:sample_code | Oracle PL/SQL Stored Procedure Example ]] |
-| C | |
-| Visual Basic | |
-| Cold Fusion | |
-| Microsoft Access | |
-| Microsoft Excel | |
-| MicroStrategy | |
-| Oracle Business Intelligence | |
-| SAP Business Objects | |
-| Activant Speedware 4th GL | |
-{{page>:bottom_add&nofooter&noeditbtn}}

Back to top

dev/home.1274473258.txt.gz · Last modified: 2016/06/28 22:38 (external edit)

Sitemap Recent Changes