When configuring Universal Cache, you can use the data filtering and transformation features for defining exactly what data to cache.
Universal Cache enables you to, for example:
▪Retain the same relational database schema as the backend database, or have a different schema
▪Load the entire database or select just specific tables, columns, or rows
For example, you can select individual columns to implement vertical partitioning of a database. Similarly, selecting only a subset of rows enables you to implement horizontal partitioning of a database.
▪Extend the cache database schema with additional tables or derived fields
▪Maintain the data format or apply data transformations such as data type conversions or summarizations