Db sap



Techopedia Explains SAP DB

Unlike SAP DB, which is open source, MaxDB is closed source, and its source code is not available under the GNU Public License. MAxDB is based on industry standards with interfaces like SQL92, Java Database Connectivity and Open Database Connectivity. MaxDB is also cross-platform based and has been offering releases for HP-UX, IBM AIX, Linux, Solaris, Microsoft Windows 2000, Microsoft Windows Server 2003 and Microsoft Windows XP.

The main features of MaxDB include:
  • Minimal administration is needed to run the database system, which has self-administering features. The system can adjust database size and back up log entries automatically.
  • MaxDB includes self-administration and development tools. Most of the tools provided are GUI-based.
  • Offers built-in hot backup
  • Good online transaction processing (OLTP) performance with fewer hardware requirements
  • High availability mode and fewer fault records
  • Software installations are fully isolated from one another
  • Identifies clients running commands
  • Multiple log partitions allow parallel log writing
  • Default load balancing for CPU

Share this Term

  • Facebook
  • LinkedIn
  • Twitter
Sours: https://www.techopedia.com/definition/3500/sap-db

Get enterprise power at a small price – with our relational database management system

Gain flexibility unmatched by SQL-only databases – with both ISAM and SQL data access

Develop powerful data-driven applications for client-server and mobile environments

Scale from local to peer-to-peer to client-server environments with one set of source code

Install and manage without the need for a database administrator

Extend your existing applications with SAP Advantage Database Server, a full-featured, easily embedded, relational database management system. Use multiple platforms and development languages,SQL or ISAM data access  with native drivers – and manage your database from any location, on any device, even while it’s in use.

Get Started

Jump-start your implementation and drive ROI by collaborating with industry experts, consultants, and support engineers throughout your journey.


Transform your business quickly and effectively by taking advantage of our holistic service and support plans, expert consulting services, custom application development, proven best practices, and deep industry and technical knowledge.


Help keep your SAP solutions running at peak performance with our IT experts and support services, including long-term plans, embedded teams, remote technology support, self-service portal, and innovation strategies.

Security and compliance

Focus on your business and customer relationships, while keeping your data safe and reliable. SAP takes a proactive, predictive approach to maintaining compliance and data security in the cloud and within an on-premise data center.

Cookie Preferences

Back to topSours: https://www.sap.com/products/advantage-database-server.html
  1. Snub nose 357
  2. View usage verizon
  3. Ruger mini14

Unite all the data you have into the answers you need

Database and Data Management solutions power SAP Business Technology Platform, enabling complete control of your data landscape with an end-to-end view of all data through one single gateway.


SAP offers an all-in-one data management solution that delivers advanced transactional and analytical processing with the broadest advanced analytics solutions – securely – across hybrid and multi-cloud environments.


Data Management

SAP solutions for data management give you the tools you need to identify, gather, analyze, and make available the most context-relevant data throughout your enterprise.


Data Management Solution Extensions

Extend your data management products with diverse solutions that help customers transform and enhance their business.


SAP Data and Analytics Virtual Forum

Hear how to drive stronger insights, intelligence, and impact for your business.

Turn your data into business value

Database and data management solutions provide the ability to handle the growing amounts of data stored in multiple locations with controlled access for your entire organization to analyze and act on a single version of the truth.

Business Technology Platform architecture
Run data anywhere

Modernize data stores with flexible deployment options, tailored data centers, or certified appliance configurations from reliable vendors.

Reduce data redundancy

Virtualize data access to reduce the need to replicate data and analyze live data on a single platform for transanalytic applications.

Connect and understand data

Deliver data-driven innovation across distributed landscapes, complex data types, and processing engines.

Govern master data

Build a comprehensive system of master data to streamline business processes and gain a single, trusted view of master data across the value chain.

Database and Data Management Product Overview


SAP HANA is a comprehensive platform that combines a robust database with services for creating innovative applications. It enables real-time business by converging transactions and analytics on one in-memory database. 

  • Advanced in-memory processing to reduce latency to a minimum
  • Real-time insight from Big Data and the Internet of Things
  • Integrated data replication and virtualization that increase scalability and lower complexity
  • Support for modern applications that use multimodel data such as geospatial and streaming data
  • Tools to help keep business secure, minimize downtime, and support compliance with security standards

SAP HANA Cloud is a fully managed in-memory cloud database as a service (DBaaS) that provides one source of streamlined business data.

  • Minimize total cost of ownership with elastic pricing and 10X compression
  • Maximize freedom of choice in storage by virtually moving any data from any source
  • Reduce data duplication by remotely querying data without moving it
  • Work with thousands of partners in implementing, administering monitoring, and optimizing SAP HANA and SAP HANA Cloud
SAP Master Data Governance

Gain a unified, trusted view of your master data and address digital, analytical, and operational challenges head on.

  • Consolidation, central governance and data quality management of master data
  • Automation of the replication and syndication of master data throughout the system landscape
  • Prebuilt data models, business rules, workflow, and user interfaces 
  • Support for all master data domains and implementation styles in a single application
  • On-premise, private, and public cloud deployment
SAP Data Intelligence

Propel your business forward with trusted, data-driven processes, insights, and innovation using data orchestration and scalable machine learning.

  • Connection to data from a single enterprise data fabric
  • Transformation of data across complex data types and curation of a robust, searchable data catalog
  • Orchestration of complex data flows with scalable, repeatable machine learning pipelines
SAP Extended Enterprise Content Management

The SAP Extended Enterprise Content Management application by OpenText connects your structured data and unstructured content, helping you work smarter across processes to improve customer and employee experiences, increase productivity, lower procurement costs, boost asset ROI, and enable automation through machine learning.

  • Personalize customer experiences across channels
  • Improve staff productivity through collaboration
  • Purchase smarter with an enhanced supplier network
  • Digitalize maintenance and repair operations
  • Adapt quickly to future innovative technologies
  • Enhance regulatory compliance

What is Gartner saying about database and data management solutions from SAP?

SAP named a leader in enterprise information management

Find out why the latest Gartner reports ranked SAP as a leader in data quality and integration tools as well as metadata management.

Simplify your move to a cloud database management system

See the Gartner evaluation of cloud DBMS vendors, and learn why Gartner named SAP a Leader in its 2020 Magic Quadrant for Cloud Database Management Systems.

We’re sorry, but your search didn’t return any results. Please try another search.

We’re sorry, but your search didn’t return any results. Please try another search.

We’re sorry, but your search didn’t return any results. Please try another search.

Cookie Preferences

Back to topSours: https://www.sap.com/products/database-data-management.html
SAP HANA tutorial for beginners

SAP customers can rely on the secure global infrastructure of Amazon Web Services (AWS) to easily run SAP database and mobile solutions in the cloud. Without the cost or complexity of purchasing servers or managing data centers, you have more resources to focus on your solution and provide value to your customers.

Amazon Web Services (AWS) and SAP have worked together closely to certify the AWS platform so that companies of all sizes can fully realize all the benefits of the SAP HANA in-memory computing platform on the AWS cloud. Learn more >

AWS supports the SAP Adaptive Server Enterprise (ASE) database using a Bring Your Own License model. SAP ASE combined with the AWS cloud provides a high performance, enterprise-class, relational database management system that is well suited for mission-critical, data-intensive environments. Additional information about running SAP ASE on AWS can be found in SAP Note 2086750 (requires SAP Service Marketplace credentials).

Pre-built images of SAP ASE on Red Hat Enterprise Linux (RHEL) and Microsoft Windows are available in the AWS Marketplace. These enable rapid deployment by eliminating the need to manually install software. Learn more >

SAP IQ is a highly optimized RDBMS built for extreme-scale big data analytics and warehousing. With SAP IQ on AWS, companies can gain an edge in today’s data-intensive world by providing deeper insights across your organization –- insights that were never before practical, or even possible. To learn more about SAP IQ on AWS, see SAP Note 1656099 (requires SAP Service Marketplace credentials).

The SAP Replication Server technology, combined with AWS cloud infrastructures, provides a proven data replication platform to help you satisfy a host of mission-critical needs -– from application high availability and disaster recovery, to seamless, lightning-fast data distribution, to smart decision-making based on up-to-the-second information. To learn more about SAP Replication Server and AWS, read the Real-Time Data Replication for the Cloud blog post on the SAP Community Network website.

SAP Mobile Secure, cloud edition, provides enterprises with complete SaaS-based mobile device management and mobile app management capabilities to secure mobile devices and apps without the complexity and expense of an on-premises installation. Companies can enjoy enterprise mobility through a subscription model with the assurance that all operational aspects -– from app discovery and deployment to device security, upgrades, and disaster recover -– are expertly managed for them.

SAP Mobile Secure provides the lowest per-device, per-month cost possible. It provides a dedicated environment at shared environment cost. Maintenance, upgrades, and support are all included as part of the subscription. It requires no initial investment for licensing, hardware, or equipment. Learn more >

Sours: https://aws.amazon.com/sap/solutions/database/

Sap db


MaxDB is an ANSISQL-92 (entry level) compliant relational database management system (RDBMS) from SAP AG, which was also delivered by MySQL AB from 2003 to 2007. MaxDB is targeted for large SAP environments e.g. mySAP Business Suite and other applications that require enterprise-level database functionality.


The database development started in 1977 as a research project at the Technical University of Berlin headed by Rudolf Munz. In the early 1980s it became a database product that subsequently was owned by Nixdorf Computer, Siemens-Nixdorf, Software AG and today by SAP AG. It has at various times been named VDN, RDS, Reflex, Supra 2, DDB/4, Entire SQL-DB-Server and Adabas D. In 1997 SAP acquired the software from Software AG and developed it as SAP DB, releasing the source code under the GNU General Public License in October 2000.

In 2003 SAP AG and MySQL AB jointly re-branded the database system to MaxDB. In October 2007 this reselling agreement was terminated and sales and support of the database reverted to SAP.[3] SAP AG now manages MaxDB development, distribution, and support. New versions of the source code of MaxDB are no longer available under the GNU General Public License. SAP also stated that "Further commercial support concepts to cover mission critical use requirements outside of SAP scenarios are currently subject to discussion."[4]

MaxDB since version 7.5 is based on the code base of SAP DB 7.4. Therefore, the MaxDB software version 7.5 can be used as a direct upgrade of previous SAP DB versions starting 7.2.04 and higher


MaxDB is delivered with a set of administration and development tools. Most tools are available with both a GUI and command line interface (CLI). It offers bindings for JDBC; ODBC; SQLDBC (native C/C++ interface); precompiler; PHP; Perl; Python; WebDAV; OLE DB, ADO, DAO, RDO and .NET via ODBC; Delphi and Tcl via Third Party Programming Interfaces. MaxDB is cross-platform, offering releases for HP-UX, IBM AIX, Linux, Solaris, Microsoft Windows 2000, Microsoft Windows Server 2003, and up to Microsoft Windows 10.[5]

MaxDB offers built-in hot backup, does not need any online reorganizations and claims to be SQL 92 Entry-Level compatible.

MaxDB since version 7.7.00, uses multiversion concurrency control (MVCC) instead of the previous lock based implementation.


MaxDB was licensed under the GNU General Public License (GPL) from versions 7.2 through 7.6. Programming interfaces were licensed under the GPL with exceptions for projects released under other open source licenses.

SAP DB 7.3 and 7.4 were licensed as GPL but with LGPL drivers. MaxDB 7.5 was offered under dual licensing, i.e. licensed as GPL with GPL drivers or a commercial license.

From version 7.5 through version 7.6 onwards distribution of MaxDB (previously SAP DB) to the open source community was provided by MySQL AB, the same company that develops the open-source software database, MySQL. Development was done by SAP AG, MySQL AB and the open-source software community.

In October 2007 SAP assumed full sales and commercial support for MaxDB. MaxDB 7.6 is now closed source, available free-of-charge (without support, and with usage restrictions) for use with non-SAP applications.

See also[edit]


External links[edit]

Sours: https://en.wikipedia.org/wiki/MaxDB
SAP How to find DB Table for your Module

SAP deployment on Azure using an Oracle DB

SAP systems are used to run mission-critical business applications. Any outage disrupts key processes and can cause increased expenses or lost revenue. Avoiding these outcomes requires an SAP infrastructure that is highly available and resilient when failures occur.

Building a highly available SAP environment requires eliminating single points of failures in your system architecture and processes. Single points of failure can be caused by site failures, errors in system components, or even human error.

This example scenario demonstrates an SAP deployment on Windows or Linux virtual machines (VMs) on Azure, along with a High Availability (HA) Oracle database. For your SAP deployment, you can use VMs of different sizes based on your requirements.

Relevant use cases

Other relevant use cases include:

  • Mission-critical workloads running on SAP.
  • Non-critical SAP workloads.
  • Test environments for SAP that simulate a high-availability environment.


Architecture overview of a production SAP environment in Azure

This example includes a high availability configuration for an Oracle database, SAP central services, and multiple SAP application servers running on different virtual machines. The Azure network uses a hub-and-spoke topology for security purposes. The data flows through the solution as follows:

  1. Users access the SAP system via the SAP user interface, a web browser, or other client tools like Microsoft Excel. An ExpressRoute connection provides access from the organization's on-premises network to resources running in Azure.
  2. The ExpressRoute terminates in Azure at the ExpressRoute virtual network (VNet) gateway. Network traffic is routed to a gateway subnet through the ExpressRoute gateway created in the hub VNet.
  3. The hub VNet is peered to a spoke VNet. The application tier subnet hosts the virtual machines running SAP in an availability set.
  4. The identity management servers provide authentication services for the solution.
  5. The jump box is used by system administrators to securely manage resources deployed in Azure.


  • Virtual Networks are used in this scenario to create a virtual hub-and-spoke topology in Azure.

  • Virtual Machines provide the compute resources for each tier of the solution. Each cluster of virtual machines is configured as an availability set.

  • ExpressRoute extends your on-premises network into the Microsoft cloud through a private connection established by a connectivity provider.

  • Network security groups limit network access to the resources in a virtual network. A network security group contains a list of security rules that allow or deny network traffic based on source or destination IP address, port, and protocol.

  • Resource groups act as logical containers for Azure resources.


SAP provides flexible options for different combinations of operating system, database management system, and VM types in an Azure environment. For more information, see SAP note 1928533, "SAP Applications on Azure: Supported Products and Azure VM Types".


To help you explore the cost of running this scenario, all of the services are pre-configured in the cost calculator examples below. To see how the pricing would change for your particular use case, change the appropriate variables to match your expected traffic.

We have provided four sample cost profiles based on amount of traffic you expect to receive:

SizeSAPsDB VM TypeDB Storage(A)SCS VM(A)SCS StorageApp VM TypeApp StorageAzure Pricing Calculator
Small30000DS13_v24xP20, 1xP20DS11_v21x P10DS13_v21x P10Small
Medium70000DS14_v26xP20, 1xP20DS11_v21x P104x DS13_v21x P10Medium
Large180000E32s_v35xP30, 1xP20DS11_v21x P106x DS14_v21x P10Large
Extra Large250000M64s6xP30, 1xP30DS11_v21x P1010x DS14_v21x P10Extra Large


This pricing is a guide and only indicates the VMs and storage costs. It excludes networking, backup storage, and data ingress/egress charges.

  • Small: A small system consists of VM type DS13_v2 for the database server with 8x vCPUs, 56-GB RAM, and 112 GB of temporary storage, along with five 512-GB premium storage disks; an SAP Central Instance server using a DS11_v2 VM types with 2x vCPUs, 14-GB RAM, and 28 GB of temporary storage; and a single VM type DS13_v2 for the SAP application server with 8x vCPUs, 56-GB RAM, and 400 GB of temporary storage, along with one 128-GB premium storage disk.

  • Medium: A medium system consists of VM type DS14_v2 for the database server with 16x vCPUs, 112 GB RAM, and 800 GB of temporary storage, along with seven 512-GB premium storage disks; an SAP Central Instance server using a DS11_v2 VM types with 2x vCPUs 14-GB RAM and 28 GB of temporary storage; four VM type DS13_v2 for the SAP application server with 8x vCPUs, 56-GB RAM, and 400 GB of temporary storage, along with one 128-GB premium storage disk.

  • Large: A large system consists of VM type E32s_v3 for the database server with 32x vCPUs, 256-GB RAM, and 800 GB of temporary storage, along with three 512 GB and one 128-GB premium storage disk; an SAP Central Instance server using a DS11_v2 VM types with 2x vCPUs, 14-GB RAM, and 28 GB of temporary storage; six VM type DS14_v2 for the SAP application servers with 16x vCPUs, 112 GB RAM, and 224 GB temporary storage, along with six 128-GB premium storage disks.

  • Extra Large: An extra-large system consists of the M64s VM type for the database server with 64x vCPUs, 1024 GB RAM, and 2000 GB of temporary storage, along with seven 1024-GB premium storage disks; an SAP Central Instance server using a DS11_v2 VM types with 2x vCPUs 14-GB RAM and 28 GB of temporary storage; ten VM type DS14_v2 for the SAP application servers with 16x vCPUs, 112 GB RAM, and 224 GB of temporary storage, along with ten 128-GB premium storage disks.


Click the link below to deploy the solution.

Deploy to Azure


SAP and Oracle are not installed during this deployment. You will need to deploy these components separately.

Related resources

For other information about running SAP production workloads in Azure, review the following reference architectures:


View all page feedback

Sours: https://docs.microsoft.com/en-us/azure/architecture/example-scenario/apps/sap-production

Now discussing:


Database management system by SAP

SAP HANA (high-performance analytic appliance) is an in-memory, column-oriented, relational database management system developed and marketed by SAP SE.[2][3] Its primary function as the software running a database server is to store and retrieve data as requested by the applications. In addition, it performs advanced analytics (predictive analytics, spatial data processing, text analytics, text search, streaming analytics, graph data processing) and includes extract, transform, load (ETL) capabilities as well as an application server.


During the early development of SAP HANA, a number of technologies were developed or acquired by SAP SE. These included TREX search engine (in-memorycolumn-oriented search engine), P*TIME (in-memory online transaction processing (OLTP) Platform acquired by SAP in 2005), and MaxDB with its in-memory liveCache engine.[4][5]

The first major demonstration of the platform was in 2008: teams from SAP SE, the Hasso Plattner Institute and Stanford University demonstrated an application architecture for real-time analytics and aggregation called HYRISE.[6] Former SAP SE executive, Vishal Sikka, mentioned this architecture as "Hasso's New Architecture".[7] Before the name "HANA" stabilized, people referred to this product as "New Database".[8] The software was previously called "SAP High-Performance Analytic Appliance".[9]

A first research paper on HYRISE was published in November 2010.[10] The research engine is later released open source in 2013,[11] and was reengineered in 2016 to become HYRISE2 in 2017.[12]

The first product shipped in late November 2010.[5][13] By mid-2011, the technology had attracted interest but more experienced business customers considered it to be "in early days".[14] HANA support for SAP NetWeaver Business Warehouse was announced in September 2011 for availability by November.[15]

In 2012, SAP promoted aspects of cloud computing.[16] In October 2012, SAP announced a platform as a service offering called the SAP HANA Cloud Platform[17][18] and a variant called SAP HANA One that used a smaller amount of memory.[19][20]

In May 2013, a managed private cloud offering called the HANA Enterprise Cloud service was announced.[21][22]

In May 2013, Business Suite on HANA became available, enabling customers to run SAP Enterprise Resource Planning functions on the HANA platform.[23][24]

S/4HANA, released in 2015, written specifically for the HANA platform, combines functionality for ERP, CRM, SRM and others into a single HANA system.[25] S/4HANA is intended to be a simplified business suite, replacing earlier generation ERP systems.[26] While it is likely that SAP will focus its innovations on S/4HANA, some customers using non-HANA systems have raised concerns of being locked into SAP products. Since S/4HANA requires an SAP HANA system to run, customers running SAP business suite applications on hardware not certified by SAP would need to migrate to a SAP-certified HANA database should they choose the features offered by S/4HANA.[27]

Rather than versioning, the software utilizes service packs, referred to as Support Package Stacks (SPS), for updates. Support Package Stacks are released every 6 months.[28]

In November 2016 SAP announced SAP HANA 2, which offers enhancements to multiple areas such as database management and application management and includes two new cloud services: Text Analysis and Earth Observation Analysis.[29] HANA customers can upgrade to HANA 2 from SPS10 and above. Customers running SPS9 and below must first upgrade to SPS12 before upgrading to HANA 2 SPS01.[30]



The key distinctions between HANA and previous generation SAP systems are that it is a column-oriented, in-memory database, that combines OLAP and OLTP operations into a single system; thus in general SAP HANA is an OLTAP system.[31] Storing data in main memory rather than on disk provides faster data access and, by extension, faster querying and processing.[32] While storing data in-memory confers performance advantages, it is a more costly form of data storage. Observing data access patterns, up to 85% of data in an enterprise system may be infrequently accessed[32] therefore it can be cost-effective to store frequently accessed, or "hot", data in-memory while the less frequently accessed "warm" data is stored on disk, an approach SAP have termed "Dynamic tiering".[33]

Column-oriented systems store all data for a single column in the same location, rather than storing all data for a single row in the same location (row-oriented systems). This can enable performance improvements for OLAP queries on large datasets and allows greater vertical compression of similar types of data in a single column. If the read times for column-stored data is fast enough, consolidated views of the data can be performed on the fly, removing the need for maintaining aggregate views and its associated data redundancy.[34]

Although row-oriented systems have traditionally been favored for OLTP, in-memory storage opens techniques to develop hybrid systems suitable for both OLAP and OLTP capabilities,[35] removing the need to maintain separate systems for OLTP and OLAP operations.

The index server performs session management, authorization, transaction management and command processing. The database has both a row store and a columnar store. Users can create tables using either store, but the columnar store has more capabilities and is most frequently used.[citation needed] The index server also manages persistence between cached memory images of database objects, log files and permanent storage files. The XS engine allows web applications to be built.[36]

SAP HANA Information Modeling (also known as SAP HANA Data Modeling) is a part of HANA application development. Modeling is the methodology to expose operational data to the end user. Reusable virtual objects (named calculation views) are used in the modelling process.


SAP HANA manages concurrency through the use of multiversion concurrency control (MVCC), which gives every transaction a snapshot of the database at a point in time. When an MVCC database needs to update an item of data, it will not overwrite the old data with new data, but will instead mark the old data as obsolete and add the newer version.[37][38]

Big data[edit]

In a scale-out environment, HANA can keep volumes of up to a petabyte of data in memory while returning query results in under a second. However, RAM is still much more expensive than disk space, so the scale-out approach is only feasible for certain time critical use cases.[39]


SAP HANA includes a number of analytic engines for various kinds of data processing. The Business Function Library includes a number of algorithms made available to address common business data processing algorithms such as asset depreciation, rolling forecast and moving average.[40] The Predictive Analytics Library includes native algorithms for calculating common statistical measures in areas such as clustering, classification and time series analysis.[41]

HANA incorporates the open source statistical programming language R as a supported language within stored procedures.[42]

The column-store database offers graph database capabilities. The graph engine processes the Cypher Query Language and also has a visual graph manipulation via a tool called Graph Viewer. Graph data structures are stored directly in relational tables in HANA's column store.[43] Pre-built algorithms in the graph engine include pattern matching, neighborhood search, single shortest path, and strongly connected components. Typical usage situations for the Graph Engine include examples like supply chain traceability, fraud detection, and logistics and route planning.[44]

HANA also includes a spatial database engine which implements spatial data types and SQL extensions for CRUD operations on spatial data. HANA is certified by the Open Geospatial Consortium,[45] and it integrates with ESRI'sArcGIS geographic information system.[46]

In addition to numerical and statistical algorithms, HANA can perform text analytics and enterprise text search. HANA's search capability is based on “fuzzy” fault-tolerant search, much like modern web-based search engines. Results include a statistical measure for how relevant search results are, and search criteria can include a threshold of accuracy for results.[47] Analyses available include identifying entities such as people, dates, places, organizations, requests, problems, and more. Such entity extraction can be catered to specific use cases such as Voice of the Customer (customer's preferences and expectations), Enterprise (i.e. mergers and acquisitions, products, organizations), and Public Sector (public persons, events, organizations).[48] Custom extraction and dictionaries can also be implemented.

Application development[edit]

Besides the database and data analytics capabilities, SAP HANA is a web-based application server, hosting user-facing applications tightly integrated with the database and analytics engines of HANA. The "XS Advanced Engine" (XSA) natively works with Node.js and JavaEE languages and runtimes. XSA is based on Cloud Foundry architecture and thus supports the notion of “Bring Your Own Language”, allowing developers to develop and deploy applications written in languages and in runtimes other than those XSA implements natively, as well as deploying applications as microservices. XSA also allows server-sideJavaScript (XSJS).[49]

Supporting the application server is a suite of application lifecycle management tools allowing development deployment and monitoring of user-facing applications.


HANA can be deployed on-premises or in the cloud from a number of cloud service providers.[50]

HANA can be deployed on-premises as a new appliance from a certified hardware vendor.[51] Alternatively, existing hardware components such as storage and network can be used as part of the implementation, an approach which SAP calls "Tailored Data Center Integration (TDI)".[52][53] HANA is certified to run on multiple operating systems[54] including SUSE Linux Enterprise Server[55] and Red Hat Enterprise Linux.[56] Supported hardware platforms for on-premise deployment include Intel 64[57] and POWER Systems.[58] The system is designed to support both horizontal and vertical scaling.

Multiple cloud providers offer SAP HANA on an Infrastructure as a Service basis, including:

SAP also offer their own cloud services in the form of:


SAP HANA licensing is primarily divided into two categories.[67]

Runtime License:

Used to run SAP applications such as SAP Business Warehouse powered by SAP HANA and SAP S/4HANA.

Full Use License:

Used to run both SAP and non-SAP applications. This licensing can be used to create custom applications.[68]

As part of the full use license, features are grouped as editions targeting various use cases.

  • Base Edition: Provides core database features and development tools but does not support SAP applications.
  • Platform Edition: Base edition plus spatial, predictive, R server integration, search, text, analytics, graph engines and additional packaged business libraries.
  • Enterprise Edition: Platform edition plus additional bundled components for some of the data loading capabilities and the rule framework.

In addition, capabilities such as streaming and ETL are licensed as additional options.[69]

As of March 9, 2017, SAP HANA is available in an Express edition; a streamlined version which can run on laptops and other resource-limited environments. The license for SAP HANA, express edition is free of charge, even for productive use up to 32 GB of RAM.[70] Additional capacity increases can be purchased.

See also[edit]


  1. ^"Releases and Updates". Retrieved November 25, 2020.
  2. ^Jeff Kelly (July 12, 2013). "Primer on SAP HANA". Wikibon. Retrieved October 9, 2013.
  3. ^SAP HANA - The Column Oriented (Based) Database on YouTube (December 8, 2012)
  4. ^Vey, Gereon; Krutov, Ilya (January 2012). "SAP In-Memory Computing on IBM eX5 Systems"(PDF). Archived from the original(PDF) on June 7, 2014.
  5. ^ abSAP SE (June 17, 2012). "SAP HANA Timeline". SlideShare. Retrieved October 9, 2013.
  6. ^Plattner, Hasso (2011). In-memory data management : an inflection point for enterprise applications. Zeier, Alexander. Berlin: Springer. ISBN . OCLC 719363183.
  7. ^"Vishal Sikka: Timeless Software". Retrieved March 10, 2017.
  8. ^"What is SAP HANA Database". Gucons web site. 2011. Retrieved October 9, 2013.
  9. ^Jaikumar Vijayan (December 1, 2010). "SAP's HANA will speed real-time data analytics". Computerworld. Retrieved January 4, 2018.
  10. ^Grund, Martin; Krüger, Jens; Plattner, Hasso; Zeier, Alexander; Cudre-Mauroux, Philippe; Madden, Samuel (November 1, 2010). "HYRISE: a main memory hybrid storage engine". Proceedings of the VLDB Endowment. 4 (2): 105–116. doi:10.14778/1921071.1921077.
  11. ^The history of the project on GitHub shows a first commit on 4 February 2013.
  12. ^"HYRISE". hpi.de (in German). Retrieved November 27, 2019.
  13. ^Chris Kanaracus (December 1, 2010). "SAP launches HANA for in-memory analytics: The in-memory analytic appliance will compete with next-generation data-processing platforms such as Oracle's Exadata machines". Info World. Retrieved September 24, 2013.
  14. ^Chris Kanaracus (September 15, 2011). "SAP's HANA is hot, but still in early days". Network World. Archived from the original on October 19, 2011. Retrieved October 15, 2013.
  15. ^Courtney Bjorlin (November 9, 2011). "SAP Begins BW on HANA Ramp-Up, First Big Test for the HANA Database". ASUG News. Archived from the original on November 29, 2013. Retrieved October 15, 2013.
  16. ^Trevis Team (April 30, 2012). "SAP Headed For $71 On Cloud, Mobile And HANA Growth". Forbes. Retrieved October 9, 2013.
  17. ^"SAP Introduces SAP HANA Cloud, an In-Memory Cloud Platform". Database Trends and Applications. October 24, 2012. Retrieved June 18, 2016.
  18. ^"Overview | SAP HANA Cloud Platform". hcp.sap.com. Retrieved June 18, 2016.
  19. ^IBM Cloud AMM for SAP HANA OneArchived November 19, 2015, at the Wayback Machine
  20. ^Doug Henschen (October 17, 2012). "SAP Launches Cloud Platform Built On Hana". InformationWeek. Archived from the original on October 19, 2012. Retrieved October 15, 2013.
  21. ^"SAP unveils HANA Enterprise Cloud service Network World". Retrieved July 13, 2017.
  22. ^"SAP HANA Enterprise Cloud". hana.sap.com. Retrieved June 18, 2016.
  23. ^Brian McKenna (January 11, 2013). "SAP puts Business Suite on HANA, joins transactional to analytical". Computer Weekly. Retrieved October 15, 2013.
  24. ^"Sapphire 2013: Business Suite on HANA goes to general availability". Computer Weekly. May 15, 2013. Retrieved October 15, 2013.
  25. ^"SAP unwraps a new enterprise suite based on Hana PCWorld". Retrieved July 13, 2017.
  26. ^"SAP Business Suite on HANA vs. S/4HANA Symmetry". Retrieved July 13, 2017.
  27. ^"SAP's S4/HANA master plan: The lingering questions ZDNet". Retrieved August 1, 2017.
  28. ^"HANA 2 – What is it? SAP Blogs". Retrieved July 13, 2017.
  29. ^"SAP HANA 2 – Revolution or Evolution? CustomerThink". Retrieved July 13, 2017.
  30. ^"SAP HANA 2 - The Next Generation Platform". Retrieved July 13, 2017.
  31. ^"What is SAP HANA? Expert Insight from Symmetry". Retrieved August 1, 2017.
  32. ^ ab"SAP HANA sales fly but there's more to the in-memory story ZDNet". Retrieved July 28, 2017.
  33. ^"SAP Unleashes Major Hana Upgrade - InformationWeek". Retrieved July 28, 2017.
  34. ^"A Common Database Approach for OLTP and OLAP Using an In-Memory Column Database"(PDF). Retrieved August 1, 2017.
  35. ^"Compacting Transactional Data in Hybrid OLTP&OLAP Databases"(PDF). Retrieved August 1, 2017.
  36. ^"Monthly Archives". SAP Hana Blog. December 2012. Retrieved January 4, 2018.
  37. ^"Multiversion Concurrency Control (MVCC) Issues". SAP Help Portal. Retrieved January 4, 2018.
  38. ^"High-Performance Transaction Processing in SAP HANA"(PDF). Bulletin of the IEEE Computer Society Technical Committee on Data Engineering. n.d. Retrieved January 4, 2018.
  39. ^"SAP HANA and Big Data – Scale-out Options". Felix Weber Research. Retrieved April 7, 2019.
  40. ^"Business Function Library - Real Time Analytics with SAP HANA". Retrieved October 2, 2017.
  41. ^"SAPexperts An Introduction to SAP Predictive Analysis and How It Integrates with SAP HANA". Retrieved October 2, 2017.
  42. ^"When SAP HANA met R – What's new? R-bloggers". Retrieved October 2, 2017.
  43. ^"FOSDEM 2017 - Graph Processing on SAP HANA, express edition". Retrieved October 2, 2017.
  44. ^"The Graph Story of the SAP HANA Database". Retrieved October 2, 2017.
  45. ^"SAP HANA SPS11 tackles analytics, IT and development". Retrieved October 2, 2017.
  46. ^"FAQ: Does the ArcGIS platform support the SAP HANA database?". Retrieved October 2, 2017.
  47. ^"SAP Releases Sentiment Analysis Solution - CRM Magazine". Retrieved October 2, 2017.
  48. ^"SAP HANA TA – Text Analysis". Retrieved October 2, 2017.
  49. ^"A New Development Platform for Native SAP HANA Applications". Retrieved October 2, 2017.
  50. ^"SAP HANA Deployment Options On Premise, Cloud, or Hybrid". Retrieved July 14, 2017.
  51. ^"Certified SAP HANA® Hardware Directory". global.sap.com. Retrieved June 30, 2016.
  52. ^"Datacenter integration is the new 'table stakes' | #SAPPHIRENOW". Retrieved June 30, 2016.
  53. ^"SAP HANA Tailored Data Center Integration - SAP HANA Technical Operations Manual - SAP Library". help.sap.com. Retrieved June 30, 2016.
  54. ^"SAP HANA Hardware and Software Requirements".
  55. ^"SUSE Linux Enterprise Server for SAP Applications". Retrieved July 14, 2017.
  56. ^"Red Hat launches Enterprise Linux for SAP HANA ZDNet". Retrieved July 14, 2017.
  57. ^"SAP HANA Wrings Performance From New Intel Xeons". Retrieved July 14, 2017.
  58. ^"SAP HANA on Power with SUSE Linux Enterprise Server for SAP Applications".
  59. ^"AWS - SAP HANA". Retrieved May 12, 2017.
  60. ^"SAP HANA on Azure Virtual Machines - Microsoft Azure". Retrieved May 12, 2017.
  61. ^"Google Cloud and SAP forge partnership to develop enterprise solutions". Retrieved May 12, 2017.
  62. ^"SAP chooses IBM as a premier strategic provider of Cloud infrastructure services for its business critical applications". IBM.
  63. ^"Huawei Announces Availability of SAP HANA® Running on Huawei FusionSphere-huawei press center". huawei. Retrieved September 8, 2016.
  64. ^"HP News - HP and SAP Accelerate Journey to SAP® S/4HANA on HP Helion Managed Cloud". www8.hp.com. Retrieved September 8, 2016.
  65. ^"SAP unveils HANA Enterprise Cloud service Network World". Retrieved July 14, 2017.
  66. ^"What is SAP Cloud Platform ? - Definition from WhatIs.com". Retrieved July 14, 2017.
  67. ^"Update IV: The SAP HANA FAQ - answering key SAP In-Memory questions". bluefinsolutions.com. Retrieved July 8, 2016.
  68. ^"SAP HANA in-memory DBMS overview". Retrieved July 8, 2016.
  69. ^"SAP HANA Options and Additional Capabilities – SAP Help Portal Page". help.sap.com. Retrieved July 8, 2016.
  70. ^"SAP Developer center - SAP HANA express edition". developers.sap.com. Retrieved January 28, 2019.

External links[edit]

Sours: https://en.wikipedia.org/wiki/SAP_HANA

257 258 259 260 261