SAP Articles - Page 18 of 104

When a SQL query is executed, you can see the confirmation that the query is executed in time duration and also with server processing time. In this scenario, you can see the time taken by SAP HANA processor to create a new table in the HANA database as below −“Statement 'Create Table Demo_HANA ( ID INTEGER, NAME VARCHAR(10), PRIMARY KEY (ID) )' successfully executed in 3 ms 117 µs  (server processing time − 2 ms 458 µs) - Rows Affected − 0”

To run the query, click on green arrow button on top right corner  or press F8.

In below SQL query, you can see a create table command in SQL editor to create a new table with name-“Demo_HANA” in schema name AA_HANA11 with column names- ID and NAME and corresponding data types. In the below example, we have defined ID as “Primary Key” which means it is unique and not null.Create Table Demo_HANA (    ID INTEGER,    NAME VARCHAR(10),    PRIMARY KEY (ID) );

To change the default schema, you have to select schema name from Catalog folder and click on SQL tab at the top.You can also right click on Schema in which you want to create Relational objects and select Open SQL Console. In below pic, you can see the Schema AA_HANA11 and right click → Open SQL Console.At the top of SQL console, you can see Schema name where the objects will be created using this console.

When you add a new system under HANA Studio, below screen comes where different folders are available to manage HANA system. To open SQL editor, you have to select HANA system and click on SQL button at the top.Once you click on SQL button to open SQL console for selected items, right side you can see a SQL editor where you can run SQL queries in HANA database.You can also open SQL console by right click on HANA system HDB → Open SQL Console. When console is opened, at the top you can see host name and instance number and ... Read More

The cross database container access is managed in Global.ini file in Configuration under System Administration.To access global.ini file you need to navigate to Administration tab in HANA Studio → Configuration and there you can find Global.ini file.

SAP HANA also supports multitenant database container system, along with singe logical database. Using multitenant isolate databases, administration of HANA system becomes easy in a distributed environment.You can also implement cross tenant database structure where one application running on one HANA system can also run on logical database from other container system or two applications can use same single logical database hosted on different HANA systems.

If you open SAP HANA cockpit, you can see different database functions in the HANA system − https://best:4303/sap/hana/admin/cockpit

SAP HANA system combines OLAP and OLTP processing into a single in-memory database and it removes the disk bottlenecks and offering groundbreaking performance. This ACID-compliant, in-memory columnar database stores provides data compression up to 11 times as compared to other conventional database, parallel processing across multiprocessor cores, and supports single instruction multiple data (SIMD) commands.

All the database objects in SAP HANA system are maintained in the CATALOG folder in HANA Studio. Following are the key capabilities of SAP HANA database system −You can use a high-performance in-memory database for processing complex transactions and analytics. You can manage large database volumes in multitenant database containers.Using SAP HANA in-memory database component, you can run advanced analytical queries that are complex in nature that too with high-speed transactions to get the correct, up-to-date responses in a fraction of a second. SAP HANA in-memory db system removes the need of predefined aggregates, materialized views, and removes data duplicity ... Read More