Sap data warehouse concepts pdf
- Comments Off on Sap data warehouse concepts pdf
During the early development of SAP HANA, a number of technologies sap data warehouse concepts pdf developed or acquired by SAP SE. The first product shipped in late November 2010.
By mid-2011, the technology had attracted interest but more experienced business customers considered it to be “in early days”. In 2012, SAP promoted aspects of cloud computing. In May 2013, a managed private cloud offering called the HANA Enterprise Cloud service was announced. In May 2013, Business Suite on HANA became available, enabling customers to run SAP Enterprise Resource Planning functions on the HANA platform. 4HANA, released in 2015, written specifically for the HANA platform, combines functionality for ERP, CRM, SRM and others into a single HANA system. Support Package Stacks are released every 6 months.
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. 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. 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.
Modeling is the methodology to expose operational data to the end user. Data Virtualization is available via a tool named Smart Data Access. In a scale-out environment, HANA can support volumes of up to a petabyte of data in-memory while returning query results in under a second. SAP offers a separate but related product referred to as Vora for tight integration of big data stored in Hadoop with enterprise data in HANA.
Vora leverages some of the same concepts from HANA, namely, in-memory storage, query pushdown, and massive parallelization. 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. HANA incorporates the open source statistical programming language R as a supported language within stored procedures. The column-store database offers graph database capabilities. The graph engine supports the Cypher Query Language as well as a visual graph manipulation via a tool called Graph Viewer. Graph data structures are stored directly in relational tables in HANA’s column store.
HANA also includes a spatial database engine which supports spatial data types and SQL extensions for CRUD operations on spatial data. HANA is certified by the Open Geospatial Consortium. In addition to numerical and statistical algorithms, HANA can perform text analytics and enterprise text search. Results include a statistical measure for how relevant search results are, and search criteria can include a threshold of accuracy for results. HANA can be deployed on-premise or in the cloud from a number of cloud service providers.
HANA can be deployed on-premise as a new appliance from a certified hardware vendor. SAP HANA licensing is primarily divided into two categories. Used to run both SAP and non-SAP applications. This licensing can be used to create custom applications.
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. 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.
This edition is primarily aimed at students, and is free to use for in-memory databases of up to 32GB. SAP’s HANA will speed real-time data analytics”. 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”. SAP’s HANA is hot, but still in early days”. SAP Begins BW on HANA Ramp-Up, First Big Test for the HANA Database”. 71 On Cloud, Mobile And HANA Growth”. SAP Introduces SAP HANA Cloud, an In-Memory Cloud Platform”.