What is hana database

Flexible: Deploys in a public or private cloud, in multiple clouds, on premise, or in a hybrid scenario. Intelligent: Augments applications and analytics with built-in machine learning ML.

Secure: Offers comprehensive data and application security, secure setup, and more. In-memory, columnar, massively parallel processing database: SAP HANA runs transactional and analytical workloads using a single instance of the data on a single platform.

It stores data in high-speed memory, organises it in columns, and partitions and distributes it among multiple servers. This delivers faster queries more efficiently than aggregate data and avoids costly full-table scans. Multi-tenancy: Allows multiple tenant databases to run in one system, sharing the same memory and processors.

Each tenant database is fully isolated with its own database users, catalog, repository, data files, and log files for maximum security and control. Multi-tier storage and persistent memory support: Various software solutions manage multi-temperature data hot, warm, and cold to optimise performance and cost of storage. Scaling: Supports terabytes of data in a single server and scales further by implementing a shared-nothing architecture across multiple servers in a cluster.

Distributes large tables across these servers automatically based on rules. Graphical modelling tools enable easy collaboration between stakeholders and creation of models to execute complex business logic and data transformation that can be processed in real-time.

Stored procedures: SAP HANA has a native language to build stored procedures and uses advanced capabilities to create complex logic that runs inside the database. Administration: Provides comprehensive administration tools for various platform lifecycle, performance, and management operations and automation, such as start, stop, restart, back up, and recover.

Security: Unique real-time data anonymization capabilities to extract value from data while protecting privacy. Robust authentication, user management, and authorisation protocols help ensure that users access only the data they have permission to see and handle. High availability and disaster recovery: SAP HANA supports high availability and disaster recovery to meet a broad range of service levels through an array of techniques — such as backup, storage mirroring, synchronous, asynchronous, and multitarget system replication, hot standby, auto restart, and auto failover.

These applications run on any device and adapt automatically to screen size, delivering a consistent look and feel across all touch points. Client access: Provides many client libraries for accessing SAP HANA from other application platforms and languages such as JavaScript, Python, R, Java and Go to name a few Application lifecycle management: Helps build and package applications, transport them from development to test to production, and deploy and upgrade them. Application development tools: Offers lightweight development tools for data modelling and app development on-premises and in the Cloud.

Search: Use SQL to locate text quickly across multiple columns and textual content. Run both full-text and advanced fuzzy searches for numerous languages. Spatial processing is supported by SQL through open standards to store, query, and access location-enabled content.

Graph: Store and process highly connected data using a property graph. Streaming analytics: Store, query, and apply machine learning ML to streaming data to discover trends over a period. These data sources include sensors, plant equipment, and Internet of Things IoT devices that arrive in a time-series format.

These include ETL extract, transform, load and ELT as well as real-time data replication, bulk-load processing, data transformation, and built-in data quality and enrichment services. The memory pool is used to store all the in-memory data and system tables, thread stack, temporary computations and all other data structure required for managing the database. This is Modelling environment for non-technical people like an end user.

SQL Expressions is a clause that can be used for return values. There are 4 types of SQL Expressions-. A trigger is also a stored procedure that automatically executes when an event happens on a given table or view. It can be deployed on-premises or in the cloud. In , SAP also began offering a hybrid HANA platform that allows administrators in large enterprises to integrate and orchestrate premise-to-premise, premise-to-cloud and cloud-to-cloud processes.

Applications that use HANA can access and process data in real time or near real-time. Hybrid Processing — HANA can act as both a transactional and an analytical database at the same time, processing both types of requests on a single data set simultaneously. Administrators can simplify their custom application's architecture by working with coding languages that best suits their needs and goals. Supply chain optimization. It is known for being one of the few database systems that can be trusted when networks are at peak performance.

It is also one of the few database platforms certified for the Linux operating system OS. It is generally affordable for small teams and individuals. Some things to consider when exploring whether or not to implement SAP HANA include performance needs, scalability, adaptability, and whether or not there needs to be full control over the instance or just want to take advantage of in-memory computing.

In an on-premise implementation, customers obtain a simple signature file by purchasing a key from the SAP Support website. Those who are bringing their own license to the public cloud would follow the same steps as those performing an on-premise installation. There are myriad reasons why this may be desirable, such as a desire to explore the option of a future full-cloud deployment while currently running an on-premise deployment.

Major revisions were released every six months. As the platform matured, updates for the on-premise version were delivered annually. For the cloud version, however, releases are more frequent, with new features being delivered whenever possible, typically quarterly. General information about software maintenance can be found on the SAP Support Portal, while detailed information on maintenance can be found on the Product Availability Matrix.

Here are they are in list form:.