This shows you the differences between two versions of the page.
|
dev:home [2010/05/21 07:01] tdo |
dev:home [2016/06/28 22:38] |
||
|---|---|---|---|
| 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 ]] ^ [[ programs:dsedit:home | DSEDIT ]] ^ [[programs:dbinstal:home | DBINSTAL ]] ^ [[ 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 Catalogs ===== | ||
| - | Omnidex Environment Catalogs 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; | ||
| - | |||
| - | create database "SIMPLE" | ||
| - | type FLATFILE | ||
| - | index_directory "idx\SIMPLE_" | ||
| - | in "simple.xml"; | ||
| - | |||
| - | |||
| - | create table "COUNTRIES" | ||
| - | physical "dat\cnt.dat" | ||
| - | ( | ||
| - | "COUNTRY" CHARACTER(2) omnidex, | ||
| - | "DESCRIPTION" C STRING(47) quicktext, | ||
| - | "LATITUDE" FLOAT omnidex usage "LATITUDE", | ||
| - | "LONGITUDE" FLOAT omnidex usage "LONGITUDE", | ||
| - | "CAPITAL" C STRING(31) quicktext, | ||
| - | "CAPITAL_LAT" FLOAT omnidex usage "LATITUDE", | ||
| - | "CAPITAL_LONG" FLOAT omnidex usage "LONGITUDE", | ||
| - | constraint COUNTRIES_COUNTRY_PK primary ("COUNTRY") | ||
| - | ) | ||
| - | in "simple.xml"; | ||
| - | |||
| - | |||
| - | create table "STATES" | ||
| - | 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}} | ||