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 .NET SDK components, creating a SQL script that defines mapping and loading the metadata into the Dharma .NET SDK.

Access your metadata through any .NET interface.

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 .NET interface.

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 .NET interface.

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.

Dharma .NET 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

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