Skip to main content

Unified Data Architecture

The Caché multidimensional database engine creates a Unified Data Architecture (UDA). Through the UDA, Caché provides both object-oriented and relational representations of data stored in the database. This means that you can simultaneously treat your data as Caché Objects with properties and methods as well as SQL tables with rows, columns, and stored procedures. Each table in your Caché database corresponds to a Caché class. Each row in a table corresponds to an instance of a class (a Caché Object).

The following table summarizes the mapping between the basic object-oriented features of Caché Objects and the corresponding relational features of SQL Tables.

Object-Oriented and Relational Features
Caché Objects SQL Tables
Package Schema
Class Table
Object Instance Table Row
Property Table Column
Class Method Stored Procedure
Relationship Foreign Key
Embedded Object Column Subset

The Java Binding Mechanism provides Java applications with access to Caché Objects.


To learn more about the Caché Unified Data Architecture, read the discussion of the “Unified Data Dictionary” in the Objects, SQL, and the Unified Data Architecture section of Introduction to Caché.

FeedbackOpens in a new tab