Home › Categories › Technology› Temporal Query Processing With SAP HANA: Interactive Performance For Real-World Data

Temporal Query Processing With SAP HANA: Interactive Performance For Real-World Data.pdf

p1210-kaufmann.pdf
Preview of Temporal Query Processing with SAP HANA: Interactive Performance for Real-World Data
🔗 Source: vldb.org
📊 Size: 502 KB
👤 Author: kaufmann
⬇️ Downloads: 36

Summary

Despite recent standards like SQL:2011 introducing basic temporal features, few database systems offer robust support due to limited expressiveness and performance issues.

Key Features:

- In-Memory Column Store: Utilizes main memory for data storage, enabling predictable and interactive query response times.
- Timeline Index: A novel, generic temporal index structure designed to process various temporal query types efficiently.
- Use Cases: Demonstrates the prototype's effectiveness on real customer use cases, showcasing its capability to handle time travel, temporal joins, and temporal aggregations interactively for data sets fitting within a single machine's RAM.

Addressing Limitations:

The paper highlights the following shortcomings in existing solutions:

- Limited Expressiveness: Most database systems only provide rudimentary temporal support, lacking advanced expressions for complex temporal queries.
- Performance Issues: Traditional disk-based structures optimize for I/O behavior, not meeting the performance benefits of main memory databases.

Solution Approach:

The prototype combines:

- Historical data stored in a main memory column store.
- A novel Timeline index structure to support temporal operations, offering competitive performance up to several orders of magnitude faster than related work.

Download File

Description

The demo showcases a prototype main memory database system with advanced temporal operator capabilities, addressing the growing need for efficient temporal data handling, despite recent standards advancements in SQL. It combines an in-memory column store and novel temporal query processing techniques for predictable and interactive response times. The system aims to improve upon existing temporal database limitations regarding expressiveness and performance.

Technical Information

  • File Format: PDF
  • File Size: 502 KB
  • Pages: 4
  • Language: EN
  • Author: kaufmann
  • Total Downloads: 36
  • Last Updated: 1 month ago

Document Overview

This PDF document about Temporal Query Processing with SAP HANA: Interactive Performance for Real-World Data provides comprehensive information and guidance. Whether you're a beginner or advanced user, this resource offers valuable insights into Temporal Query Processing with SAP HANA: Interactive Performance for Real-World Data.

Related Topics

If you're interested in Temporal Query Processing with SAP HANA: Interactive Performance for Real-World Data, you might also want to explore:

Temporal guideTemporal tutorialQuery guideQuery tutorialProcessing guideProcessing tutorialwith guidewith tutorialHANA: guideHANA: tutorialInteractive guideInteractive tutorialPerformance guidePerformance tutorialReal-World guideReal-World tutorialData guideData tutorial

Related Categories

Business & Finance
41204 documents
Education & Learning
22711 documents
Health & Wellness
8956 documents

Related Documents

Preview of SLES for SAP HANA
PDF file

SLES for SAP HANA

5.69 MBPowerpointDesignersEN33 pages
SUSE has an 18+ year partnership with SAP, with achievements including firsts in Amazon EC2 OS, open source HA, virtualization, Linux for SAP HANA,...
Download
Preview of SUSE HA for SAP HANA
PDF file

SUSE HA for SAP HANA

4.38 MBPowerpointDesignersEN25 pages
SUSE High Availability for SAP HANA combines in-memory database technology with an industry-leading open source high availability clustering system...
Download
Preview of Download PDF
PDF file

Download PDF

753 KBKatashi Nagao and Jun RekimotoEN8 pages
Agent augmented reality is proposed as a new research area that uses agent technologies to augment the real world environment by integrating...
Download
Preview of Extending Business Processes on SAP Business Technology Platform: Benefits of Event-Driven Architectures and Migration Path to SAP S/4HANA
PDF file

Extending Business Processes on SAP Business Technology Platform: Benefits of Event-Driven Architectures and Migration Path to SAP S/4HANA

464 KBScheer, WolfgangEN8 pages
Sangeetha Jayakumar and Wolfgang Scheer from SAP SE discuss the benefits of extending business processes on the SAP Business Technology Platform,...
Download
Preview of SAP S4 HANA Training
PDF file

SAP S4 HANA Training

851 KBAwais NaeemEN10 pages
3D Educators offers a SAP S4 HANA training program, requiring candidates to have knowledge of Windows, MS Office, or business applications.
Download

Download Temporal Query Processing with SAP HANA: Interactive Performance for Real-World Data eBooks for free and learn more about Temporal Query Processing with SAP HANA: Interactive Performance for Real-World Data. These books contain exercises and tutorials to improve your practical skills, at all levels!

Not satisfied with this document? We have related documents to Temporal Query Processing with SAP HANA: Interactive Performance for Real-World Data, try searching with similar keywords: Temporal Query Processing with SAP HANA: Interactive Performance for Real-World Data, "Hinder och möjliggörare för 1.5°-livsstilar: Ytliga och djupgående strukturella faktorer som påverkar potentialen för hållbar k, Ändring av genomföranderam för en europeisk plattform för utbyte av balansenergi från frekvensåterställn ingsreserver med manuell, Rekommendationer för vaccination mot covid-19 för särskilda grupper av barn -, förstudie för att utvärdera förutsättningarna att genom en innovationsupphandli ng utveckla en drifttjänst för geoenergilager, Självkänsla och KBT ‐ Påverkas självkänslan vid KBT för depression och ångesttillstånd?Se lf‐esteem and CBT ‐ How does CBT for de, Matglädje för alla: en guide till rätt konsistens för olika behov, Soe Vol 814 Hana Haruna Hana Haruna S Cowgirl Posi

You can download PDF versions of the user's guide, manuals and ebooks about Temporal Query Processing with SAP HANA: Interactive Performance for Real-World Data, you can also find and download for free A free online manual (notices) with beginner and intermediate, Downloads Documentation, You can download PDF files (or DOC and PPT) about Temporal Query Processing with SAP HANA: Interactive Performance for Real-World Data for free, but please respect copyrighted ebooks.