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