Caché QuickStart Tutorial
Unified Data Architecture
[Home] [Back] [Next]
InterSystems: The power behind what matters   
Class Reference   
Search:    

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é.