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.
| 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.
To learn more about the Caché Unified Data Architecture, read Objects, SQL, and the Unified Data Architecture in Introduction to Caché.
