Supporting hierarchical data in SAP HANA

Robert Brunel; Jan Finis; Gerald Franz; Norman May; Alfons Kemper; Thomas Neumann; Franz Faerber

doi:10.1109/ICDE.2015.7113376

Supporting hierarchical data in SAP HANA

Robert Brunel, Jan Finis, Gerald Franz, Norman May, Alfons Kemper, Thomas Neumann, Franz Faerber

Research output: Chapter in Book/Report/Conference proceeding › Conference contribution › peer-review

11 Scopus citations

Abstract

Managing hierarchies is an ever-recurring challenge for relational database systems. Through investigations of customer scenarios at SAP we found that today's RDBMSs still leave a lot to be desired in order to meet the requirements of typical applications. Our research puts a new twist on handling hierarchies in SQL-based systems. We present an approach for modeling hierarchical data natively, and we extend the SQL language with expressive constructs for creating, manipulating, and querying a hierarchy. The constructs can be evaluated efficiently by leveraging existing indexing and query processing techniques. We demonstrate the feasibility of our concepts with initial measurements on a HANA-based prototype.

Original language	English
Title of host publication	2015 IEEE 31st International Conference on Data Engineering, ICDE 2015
Publisher	IEEE Computer Society
Pages	1280-1291
Number of pages	12
ISBN (Electronic)	9781479979639
DOIs	https://doi.org/10.1109/ICDE.2015.7113376
State	Published - 26 May 2015
Event	2015 31st IEEE International Conference on Data Engineering, ICDE 2015 - Seoul, Korea, Republic of Duration: 13 Apr 2015 → 17 Apr 2015

Publication series

Name	Proceedings - International Conference on Data Engineering
Volume	2015-May
ISSN (Print)	1084-4627

Conference

Conference	2015 31st IEEE International Conference on Data Engineering, ICDE 2015
Country/Territory	Korea, Republic of
City	Seoul
Period	13/04/15 → 17/04/15

Access to Document

10.1109/ICDE.2015.7113376

Cite this

Brunel, R., Finis, J., Franz, G., May, N., Kemper, A., Neumann, T., & Faerber, F. (2015). Supporting hierarchical data in SAP HANA. In 2015 IEEE 31st International Conference on Data Engineering, ICDE 2015 (pp. 1280-1291). Article 7113376 (Proceedings - International Conference on Data Engineering; Vol. 2015-May). IEEE Computer Society. https://doi.org/10.1109/ICDE.2015.7113376

@inproceedings{cf4d4f5ba3c7493c9fec83f8091ca1e8,

title = "Supporting hierarchical data in SAP HANA",

abstract = "Managing hierarchies is an ever-recurring challenge for relational database systems. Through investigations of customer scenarios at SAP we found that today's RDBMSs still leave a lot to be desired in order to meet the requirements of typical applications. Our research puts a new twist on handling hierarchies in SQL-based systems. We present an approach for modeling hierarchical data natively, and we extend the SQL language with expressive constructs for creating, manipulating, and querying a hierarchy. The constructs can be evaluated efficiently by leveraging existing indexing and query processing techniques. We demonstrate the feasibility of our concepts with initial measurements on a HANA-based prototype.",

author = "Robert Brunel and Jan Finis and Gerald Franz and Norman May and Alfons Kemper and Thomas Neumann and Franz Faerber",

note = "Publisher Copyright: {\textcopyright} 2015 IEEE.; 2015 31st IEEE International Conference on Data Engineering, ICDE 2015 ; Conference date: 13-04-2015 Through 17-04-2015",

year = "2015",

month = may,

day = "26",

doi = "10.1109/ICDE.2015.7113376",

language = "English",

series = "Proceedings - International Conference on Data Engineering",

publisher = "IEEE Computer Society",

pages = "1280--1291",

booktitle = "2015 IEEE 31st International Conference on Data Engineering, ICDE 2015",

}

Brunel, R, Finis, J, Franz, G, May, N, Kemper, A , Neumann, T & Faerber, F 2015, Supporting hierarchical data in SAP HANA. in 2015 IEEE 31st International Conference on Data Engineering, ICDE 2015., 7113376, Proceedings - International Conference on Data Engineering, vol. 2015-May, IEEE Computer Society, pp. 1280-1291, 2015 31st IEEE International Conference on Data Engineering, ICDE 2015, Seoul, Korea, Republic of, 13/04/15. https://doi.org/10.1109/ICDE.2015.7113376

Supporting hierarchical data in SAP HANA. / Brunel, Robert; Finis, Jan; Franz, Gerald et al.
2015 IEEE 31st International Conference on Data Engineering, ICDE 2015. IEEE Computer Society, 2015. p. 1280-1291 7113376 (Proceedings - International Conference on Data Engineering; Vol. 2015-May).

Research output: Chapter in Book/Report/Conference proceeding › Conference contribution › peer-review

TY - GEN

T1 - Supporting hierarchical data in SAP HANA

AU - Brunel, Robert

AU - Finis, Jan

AU - Franz, Gerald

AU - May, Norman

AU - Kemper, Alfons

AU - Neumann, Thomas

AU - Faerber, Franz

PY - 2015/5/26

Y1 - 2015/5/26

N2 - Managing hierarchies is an ever-recurring challenge for relational database systems. Through investigations of customer scenarios at SAP we found that today's RDBMSs still leave a lot to be desired in order to meet the requirements of typical applications. Our research puts a new twist on handling hierarchies in SQL-based systems. We present an approach for modeling hierarchical data natively, and we extend the SQL language with expressive constructs for creating, manipulating, and querying a hierarchy. The constructs can be evaluated efficiently by leveraging existing indexing and query processing techniques. We demonstrate the feasibility of our concepts with initial measurements on a HANA-based prototype.

AB - Managing hierarchies is an ever-recurring challenge for relational database systems. Through investigations of customer scenarios at SAP we found that today's RDBMSs still leave a lot to be desired in order to meet the requirements of typical applications. Our research puts a new twist on handling hierarchies in SQL-based systems. We present an approach for modeling hierarchical data natively, and we extend the SQL language with expressive constructs for creating, manipulating, and querying a hierarchy. The constructs can be evaluated efficiently by leveraging existing indexing and query processing techniques. We demonstrate the feasibility of our concepts with initial measurements on a HANA-based prototype.

UR - http://www.scopus.com/inward/record.url?scp=84940842908&partnerID=8YFLogxK

U2 - 10.1109/ICDE.2015.7113376

DO - 10.1109/ICDE.2015.7113376

M3 - Conference contribution

AN - SCOPUS:84940842908

T3 - Proceedings - International Conference on Data Engineering

SP - 1280

EP - 1291

BT - 2015 IEEE 31st International Conference on Data Engineering, ICDE 2015

PB - IEEE Computer Society

T2 - 2015 31st IEEE International Conference on Data Engineering, ICDE 2015

Y2 - 13 April 2015 through 17 April 2015

ER -

Supporting hierarchical data in SAP HANA

Abstract

Publication series

Conference

Access to Document

Other files and links

Fingerprint

Cite this