Day 6 — SAP HANA Schema

What is a Schema in SAP HANA? Why do we use it?

A Schema is a logical container that groups related database objects such as tables, views, procedures, and functions. 1. Purpose of a Schema a. Organizes database objects. b. Makes the database easy to manage. c. Prevents object name conflicts. d. Helps separate different business modules. e. Improves security and user authorization. 2. What Can a Schema Contain? a. Tables b. Views c. Procedures d. Functions e. Sequences 3. Advantages of Using a Schema a. Better database organization. b. Easy maintenance. c. Easy object management. d. Better security. e. Supports multiple applications in one database. 4. Common Examples a. HR Schema b. SALES Schema c. MM Schema d. FINANCE Schema e. SD Schema

• A company has separate departments like HR, Sales, and Finance. • HR tables are stored in the HR Schema. • Customer and Sales Order tables are stored in the SALES Schema. • Accounting tables are stored in the FINANCE Schema. • This keeps the database organized and easy to manage.

1. What is a Schema? 2. Why do we use a Schema? 3. What objects are stored inside a Schema? 4. Can multiple Schemas exist in one database?