Skip to main content

This is documentation for Caché & Ensemble. See the InterSystems IRIS version of this content.

For information on migrating to InterSystems IRIS, see Why Migrate to InterSystems IRIS?

Unified Data Architecture

We will also become familiar with the Caché Unified Data Architecture (UDA). The UDA, as we will see, provides both object-oriented and relational representations of data stored in Caché. This means that our application can access stored data both as Caché Objects with properties and methods and as SQL Tables with rows, columns, and stored procedures.

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

Unified Data Architecture
Caché Objects SQL Tables
Package Schema
Class Table
Object Instance Table Row
Property Table Column
Method Stored Procedure
Relationship Foreign Key
Embedded Object Column Subset

This tutorial focuses on using the object-oriented approach to modeling and accessing data. However, we will also see how to access that same data using relational techniques and SQL.

Note:

To learn more about the Caché Unified Data Architecture, read Objects, SQL, and the Unified Data Architecture in Introduction to Caché.

Feedback