Day 1: Design Metadata Mapping

Outline how data is stored and accessed in your application database by considering: the underlying design philosophy of the database, how the applications access the data, the internal layout of database fields and records, the types of access methods and navigation elements in your database, and the available application programming interface (API) to your database.

Develop a stategy for relational mapping to your proprietary data by defining a set of relational tables and columns that correspond to your proprietary data and a set of relational indexes that correspond to your access methods and navigation elements.

Day 2: Implement Metadata

Implement the metadata by installing the Dharma ODBC SDK components, creating a SQL script that defines mapping and loading the metadata into the Dharma ODBC SDK.

Access your metadata through any ODBC tool.

Day 3: Implement Read Access to User Data

Fill in the storage interface templates to call API routines supported in your database.

Retrieve data in your database using any ODBC tool.

Day 4: Indexed Access to User Data

Increase performance by filling in the templates that define the properties and types of indexes available in your database and access database records based on nindex keys.

You now have optimal read access to your database through any ODBC tool.

Day 5: Implement Write Access to User Data

(optional) Fill in the storage templates that insert, delete, and update table and index records, as well as provide any required transaction behavior.

Functionality & Optimization Highlights

SELECT/INSERT/ UPDATE/DELETE Query rewrite optimization queries Transaction support Static or dynamic metadata management Over 100 scalar functions Interactive SQL utility/LI> CASE expressions Outer Joins	User authentication Derived tables Subqueries View support Metadata caching Data pipelining Dynamic indexing SQL caching for repeated statements 20 SQL data types including LONG and DATE
Client Side Server Side
Dharma ODBC SDK Current Version: 9.0 Latest Release: September, 2004 Supported Operating Systems: Windows XP, Windows 2000, Windows NT, Sun Solaris, IBM AIX, SCO OpenServer, HP-UX, Linux