
Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
Found 1039 Articles for SAP

766 Views
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”

9K+ Views
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) );

2K+ Views
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.

4K+ Views
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

453 Views
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.

544 Views
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.

367 Views
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