674 DB2 Cube Views: A Primer
API architecture overview
The API is composed of a single stored procedure registered to a DB2 database.
Figure D-1 shows a diagrammatic representation of the DB2 Cube Views API
and how metadata is exchanged through the API.
Figure D-1 API architecture
As described by the diagram, the API is an interface that allows access to
metadata.
This stored procedure accepts input and output parameters in which you can
express complex metadata and metadata operations. Applications A & B push
metadata (by creating and manipulating) to the DB2 catalog and also pull
metadata from the DB2 Catalog. Application C just pulls metadata from DB2
Cube Views. Flow of metadata in all these cases is through the stored procedure
interface.
DB2 Database
DB2 Cube Views
API
(Stored Procedure)
System Catalog
tables
Metadata
Relational tables
& data
Application A
Eg. Olap Center
Application C
Eg. Office Connect,QMF
Client
Server
SQL Queries
Application B
db2mdapiclient
Get DB2 Cube Views: A Primer now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
