Ingres® 2006 - Object Management Extension User Guide

Peter Kitson

ISBN : -

Order a printed copy of this book from Amazon --UNAVAILABLE--


Cover Design - Ingres® 2006 - Object Management Extension User Guide
  

For your free electronic copy of this book please verify the numbers below. 

(We need to do this to make sure you're a person and not a malicious script)

Numbers

 



Sample Chapter From Ingres® 2006 - Object Management Extension User Guide
     Copyright © Ingres Corporation



Chapter 1: Introduction


This guide provides you with the instructions for using Object Management Extension to add data types and SQL functions to Ingres® and provides the requirements for creating the required source code and procedures for installing your code.

Audience

This guide assumes that you are an experienced programmer, familiar with the C programming language.

In This Guide

This guide introduces Object Management Extension and contains information on the following topics:
  •   Interaction of new data types and SQL functions with the DBMS Server
  •   Requirements for defining a new data type
  •   Requirements for defining a new SQL function
  •   Requirements for defining function instances to support your new data types and functions
  •   Description of the routine used by the DBMS Server to access the code for new data types and functions
  •   Instructions for installing and testing your code
  •   Description of spatial data types

An appendix contains a checklist for defining, installing, and testing a new data type or SQL function.

Object Management Extension is an option that enables you to add data types and SQL functions to the DBMS Server. You can use a user-defined data type in any context in which you can use a standard Ingres data type, including with Ingres Distributed Option. You can use user-defined SQL functions in queries to manipulate both user-defined data types and standard SQL data types. To support your new data types and functions, you can add new capabilities to existing SQL comparison and arithmetic operators. You must write all the code that defines and manipulates your new data types. The header file, IIADD.H, which you can include in your C program, contains the structure and symbol definitions that the DBMS Server requires. IIADD.H is located in the following directories:

Windows
%II_SYSTEM%\ingres\files\iiadd.h

UNIX
/ingres/files/iiadd.h

VMS
II_SYSTEM:[INGRES.FILES]IIADD.H
Object Management Extension includes two demonstration data types:
  •   ord_pair
This demo creates an ordered pair data type, which consists of a simple pair of x and y coordinates. The code is located in the following files:

Windows
%II_SYSTEM%\ingres\demo\udadts\op.c

UNIX
/ingres/demo/udadts/op.c

VMS
II_SYSTEM:[INGRES.DEMO.UDADTS]OP.C
  •   int_list
This demo creates a data type consisting of a variable-length list of 4-byte integers. The code is located in the following files:

Windows
%II_SYSTEM%\ingres\demo\udadts\intlist.c