SAP HANA - From Relational OLAP Database to Big Data Infrastructure

@inproceedings{May2015SAPH,
  title={SAP HANA - From Relational OLAP Database to Big Data Infrastructure},
  author={Norman May and Wolfgang Lehner and P. ShahulHameed and Nitesh Maheshwari and Carsten M{\"u}ller and Sudipto Chowdhuri and Anil K. Goel},
  booktitle={EDBT},
  year={2015}
}
SAP HANA started as one of the best-performing database engines for OLAP workloads strictly pursuing a main-memory centric ar- chitecture and exploiting hardware developments like large number of cores and main memories in the TByte range. Within this pa- per, we outline the steps from a traditional relational database en- gine to a Big Data infrastructure comprising different methods to handle data of different volume, coming in with different velocity, and showing a fairly large degree of… Expand
SAP HANA - The Evolution of an In-Memory DBMS from Pure OLAP Processing Towards Mixed Workloads
TLDR
The challenges of running mixed workloads with low-latency OLTP queries and complex analytical queries in the context of the same database management system are discussed and an outlook on the future database interaction patterns of modern business applications is given. Expand
Managed Query Processing within the SAP HANA Database Platform
TLDR
This paper describes how these specific capabilities of the HANA platform can be consumed and gives a holistic overview of theHANA platform starting from query modeling, to the deployment, and efficient execution. Expand
Hybrid Transactional and Analytical Processing Databases: A Systematic Literature Review
TLDR
This paper provides a comprehensive summary of these implementations, giving an overview of the last decade of research on the emerging sector of HTAP Processing databases and discussing fundamental involved technologies. Expand
Scalable OLAP-Based Big Data Analytics over Cloud Infrastructures: Models, Issues, Algorithms
TLDR
This paper focuses the attention on so-called scalable OLAP-based big data analytics tools, by providing literature overview and two state-of-the-art research contributions of recent years, which Acting as fundamental components, these solutions are likely to be integrated in larger OLAP/ Cloud infrastructures of the future. Expand
Declarative Recursive Computation on an RDBMS
TLDR
This work considers how to make a very small set of changes to a modern relational database management system (RDBMS) to make it suitable for distributed learning computations. Expand
XNorthwind: Grammar-driven Synthesis of Large Datasets for DB Applications
Relational databases often come with sample databases. One known example is the Northwind database, often used as data repository for software testing and development purposes. The Northwind databaseExpand
ERP Data Analysis and Visualization in High-Performance Computing Environment
TLDR
An approach to extend the ERP integrated analytical tools capabilities by processing ERP data in a multi-tenant GPU-enabled high-performance computing (HPC) environment and sharing the data in GPU memory using open analytic platform along with existed ERP analytical capabilities. Expand
StreamingCube-Based Analytical Framework for Environmental Data Analysis
TLDR
A real-time analytical system based on StreamingCube that can effectively process and analyze city data in real time very effectively, but can also provide analyzed results that are simple and easy to understand by the average citizens. Expand
Datenbanksysteme für Business, Technologie und Web (BTW 2017), 17. Fachtagung des GI-Fachbereichs „Datenbanken und Informationssysteme" (DBIS), 6.-10. März 2017, Stuttgart, Germany, Proceedings
TLDR
Dr. Wolfram Jost, CTO, Software AG stellt vor, wie eine Digitale Business Platform Ihre digitale Transformation zum Erfolg macht. Expand
Managing Urban Resilience
Good governance is necessary to make cities resilient and sustainable. To achieve this, we propose the Responsive City, in which citizens, enabled by technology, take on an active role in urbanExpand
...
1
2
...

References

SHOWING 1-10 OF 28 REFERENCES
The SAP HANA Database -- An Architecture Overview
TLDR
This paper highlights the architectural concepts employed in the SAP HANA database and reports on insights gathered with the SAPHANA database in real-world enterprise application scenarios. Expand
A study of partitioning and parallel UDF execution with the SAP HANA database
TLDR
This paper focuses on optimizations that enable the parallel execution of relational operators and UDFs for a number of typical patterns. Expand
SAP HANA distributed in-memory database system: Transaction, session, and metadata management
TLDR
An overview of the overall functionality with respect to data allocation, metadata caching and query routing in SAP HANA database to achieve scalability to handle large databases and heterogeneous types of workloads is given. Expand
Integrating hadoop and parallel DBMs
TLDR
This paper describes three efforts towards tight and efficient integration of Hadoop and Teradata EDW, where data in both systems are partitioned across multiple nodes for parallel computing, which creates integration optimization opportunities not possible for DBMSs running on a single node. Expand
Scaling Up Mixed Workloads: A Battle of Data Freshness, Flexibility, and Scheduling
TLDR
This paper shares the analysis of the performance of two main-memory databases that support mixed workloads, SAP HANA and HyPer, while evaluating the mixed workload CH-benCHmark and shows that the absence of workload management under cases of high concurrency leads to analytical workloads overwhelming the system and severely hurting theperformance of transactional workloads. Expand
Emerging trends in the enterprise data analytics: connecting Hadoop and DB2 warehouse
TLDR
This use case is outlined and the bidirectional connectors the authors developed between IBM DB2 and IBM InfoSphere BigInsights are discussed, which leverage the wealth of business intelligence tools, which they are accustomed to, that exist for warehouses. Expand
Bridging Two Worlds with RICE Integrating R into the SAP In-Memory Computing Engine
TLDR
This work proposes an alternative data exchange mechanism with R, SQL-SHM, a shared memory-based data exchange to incorporate R’s vertical data structure and extended this approach to R-Op introducing R scripts equivalent to native database operations like join or aggregation within the execution plans. Expand
Oracle in-database hadoop: when mapreduce meets RDBMS
TLDR
A prototype of Oracle In-Database Hadoop that supports the running of native Hadoops applications written in Java, and it is demonstrated how MapReduce functionalities are seamlessly integrated within SQL queries. Expand
Identifying hot and cold data in main-memory databases
TLDR
This work proposes to log record accesses - possibly only a sample to reduce overhead - and performs offline analysis to estimate record access frequencies and finds that exponential smoothing produces very accurate estimates, leading to higher hit rates than the best caching techniques. Expand
The Graph Story of the SAP HANA Database
TLDR
This paper describes the ongoing work to extend the SAP HANA database with built-in graph data support and sees this as a next step on the way to provide an efficient and intuitive data management platform for modern business applications with SAP Hana. Expand
...
1
2
3
...