Authoring schema vs Physical schema in SAP HANA


In SAP HANA system, schema is used to group logical objects tables, Stored procedures and database views. When objects are moved from one system to other, you can consider involvement of following schema types −

Authoring Schema

This schema is used in design time views. This schema is used in creating objects in content development system. Let us say you are developing some objects in development system and schema used is Dev_schema that contains all the required tables. Dev_schema is authoring schema to create modeling views.

Physical Schema

Let us say you move objects from development system to other system. In target system you have a schema that contains required tables. This schema is called Physical schema.

Published on 25-Apr-2018 23:29:17