Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
Articles by Anil SAP Gupta
Page 8 of 10
Naming convention for creating a delivery unit in SAP HANA
The name of Delivery Unit must contain only capital letters (A-Z), digits (0-9) and underscores (_). It won’t accept any special characters.
Read MoreLimitations of using SAP HANA 1.0
SAP HANA 1.0 can replicate data only from few of data sources and only in few formats using Sybase Replication. You can perform batch loading using SAP Data Services and it is optimized only for Business Object 4.0 for reporting.
Read MoreUse of Statistics service in SAP HANA
In SAP HANA system, you use statistics serve as a key to internal monitoring infrastructure. You will be notified when a critical alert raised in your HANA environment and you can also get all the historical monitoring data for analysis.Statistical Server is responsible for collecting the data related to system resources, their allocation, and consumption of the resources and overall performance of HANA system.For more details, you can refer our SAP HANA core architecture topichttps://www.tutorialspoint.com/sap_hana/sap_hana_core_architecture.htm
Read MoreGetting data in front-end tools from SAP HANA database
In SAP HANA database, you have different system schema. _SYS_BIC schema in SAP HANA database is used to store column views of all the activated objects in HANA repository. When an object is created and activated (HANA Modeling views, Stored Procedures), run time objects are saved under _SYS_BIC/Column views in database.These column views are used by front-end tools like BusinessObjects to get the data in a query.
Read MoreUpdating configuration property file in SAP HANA Remote source
Note that while modifying or creating the property configuration file, only the property which is different from default value needs to be set. The mistake in property configuration file may result in incorrect action or result of data source.
Read MoreFunctions of Index server in SAP HANA system
Index Server is heart of SAP HANA system and is responsible for processing all SQL statements sent to HANA database. This server contains SQL/MDX Processing engine that is responsible to process and analyze data in HANA db.Index Server also contains Persistence layer for scalability and restoration of the system. In case of system failure, power failure or database corruption, Persistence layer is responsible for the restoration of HANA system to last save point.When you are running complex and large calculations, and there is a system failure Persistence layer is used to ensure that transactions are either fully executed or complete ...
Read MoreUsing different Engine types in SAP HANA
It will use both OLAP and Join engine. The join between the FACT and DIM will be executed in the OLAP engine and joins inside the attribute views will be executed in the JOIN engine so both the engines will be used.
Read MoreHandling failed transactions in SAP HANA system
In SAP HANA system, Session and Transaction Manager is responsible to keep track of all the executed transactions in HANA database. It includes both running transactions and closed transaction. When a transaction in HANA system is failed due to any reason, Transaction Manager informs corresponding engine to handle the error.Session Manager is responsible to manage open and closed sessions and to authorize all the transactions executed in HANA db.
Read MoreHandling user requests for applications based on HANA system
It consists of various components as mentioned above for processing of SQL statements from application users hosted on the top of HANA system.User requests via user interface/web browsers are sent to Web server hosting application which is communicated to SQL/MDX Processor in form of SQL queries. These are further segregated to different data engines in Index server according to query types.Session and Transaction Manager authorize SQL transactions and keep track of all the transactions either completed or running in the system.
Read MorePerforming text data analysis and Search capability in SAP HANA
Preprocessor server provides text data analysis and search capabilities in HANA system. Preprocessor server is used by Index search to analyze the text data and to perform any search on the text data. This server is used to extract the information based on text search capabilities in HANA system.
Read More