HANA Development is about creating SQL stored procedures and functions, custom tables and views, CDS views and HDI containers to effectively implement and manage customized data models and application logic that support specific business requirements and data processing objectives. This article provides a comprehensive overview of the most important aspects of HANA development. By implementing these comprehensive development approaches, SAP HANA specialists can effectively create and manage customized data models and application logic to support specific business requirements and data processing objectives.
We are happy to support you in the following areas:
| SQL functions | SQL functions are an essential part of the SAP HANA platform and offer a variety of integrated functions for data processing and analysis. Analytical functions are positioned in this guide as aggregate functions and window aggregate functions. Aggregate functions calculate aggregated values based on a group of rows, while array functions take arrays as input. Data type conversion functions convert data from one data type to another, and date and time functions perform operations on date and time data types or return date or time information. Full-text functions perform operations on data with a full-text index, and hierarchy functions allow you to work with hierarchical data such as tables with rows arranged in a tree or directed graph. JSON functions return JSON data or work with JSON data, while numeric functions perform mathematical operations on numeric data types or return numeric information. Security functions provide special functions for security purposes, and serial data functions provide special functions for serial data and serial tables. String functions extract and manipulate strings or return information about strings. Window functions allow analytical operations to be performed on a set of input rows. |
| SQL procedures | SQL in SAP HANA includes extensions for creating procedures that allow data-intensive application logic to be embedded in the database, where it can be optimized for performance by not requiring large data transfers to the application and allowing features such as parallel execution. Procedures are used when other modeling objects, such as analytical or attribute views, are not sufficient. SQL is not designed for complex calculations such as those required in the financial world and does not provide imperative logic. Complex SQL statements can be difficult to understand and maintain. SQL queries return one result set, while procedures can return multiple result sets. Procedures can have local variables, eliminating the need to explicitly create temporary tables for intermediate results. They can be written in the following languages: SQLScript, the language for writing procedures provided by SAP HANA, and R, an open source programming language for statistical calculations and graphics that can be installed and integrated with SAP HANA. There are additional libraries of procedures, such as the Business Function Library and the Predictive Analysis Library, which can be called via SQL or within another procedure. A user-defined function (UDF) allows complex logic to be created in a single database object. A scalar UDF is a user-defined function that can be called in the SELECT and WHERE clauses of an SQL statement. A table UDF makes it possible to create a parameterized, fixed view of the data in the underlying tables. |
| Kundenspezifische Tabellen und Ansichten | A table represents a set of related data represented in columns and rows. The name should make the purpose of the object clear to non-technical users, while the code used to generate code or scripts can be abbreviated and should not normally contain spaces. A column is a series of values of one type in a table. Each row of the table contains one instance of each column. A primary key contains one or more columns whose combined values uniquely identify each row in a table. A table can have only one primary key, but any number of alternate keys that also contain one or more columns whose combined values uniquely identify each row in a table. Foreign keys contain one or more columns whose values correspond to a primary or alternative key in another table. An index is a data structure that is assigned to one or more columns whose order is determined by the column values. Indexes are usually created for columns that you search frequently in order to improve response times. A view is a query that provides access to all or a subset of data in a table or in several tables that are linked to each other via joins. |
| Native SAP HANA development | In SAP HANA verwenden native Anwendungen die Technologie und Dienstleistungen, die von der integrierten SAP HANA XS-Plattform bereitgestellt werden. Der Begriff „native Anwendung“ bezieht sich auf ein Szenario, bei dem Anwendungen in der Designzeit-Umgebung von SAP HANA Extended Application Services (SAP HANA XS) entwickelt werden und die integrierte SAP HANA XS-Plattform verwenden. Der serverzentrierte Ansatz für die native Anwendungsentwicklung, der für SAP HANA vorgesehen ist, umfasst folgendes hochrangiges Szenario: Alle Anwendungsartefakte werden im SAP HANA-Repository gespeichert, die serverseitige prozedurale Logik wird in serverseitigem (XS) JavaScript oder SQLScript definiert, und die UI-Renderung erfolgt vollständig im Client (Browser, mobile Anwendungen). Jede der in der Grafik dargestellten Ebenen manifestiert sich in einer bestimmten Technologie und dedizierten Sprachen, einschließlich SQL / SQLScript, Core Data Services (CDS), DDL, HDBtable für die Datenverarbeitungstechnologie. |
| Function libraries | The Application Function Library (AFL) provides ready-made procedures that can be called directly from SQLScript and executed close to the data within the SAP HANA database to increase performance. The Predictive Analytics Library (PAL) offers more than 20 algorithms that can be embedded in data mining and predictive scenarios for existing applications. The Application Function Modeler (AFM) provides a graphical editor in the SAP HANA platform to connect the BFL and PAL and apply data visualization and drag-and-drop capabilities to achieve results faster. The Business Function Library (BFL) provides information on common business processes, from currency conversion to moving averages and rolling forecasts. |
