short-paper

ProcAnalyzer: Effective Code Analyzer for Tuning Imperative Programs in SAP HANA

Authors:

Young-Koo LeeAuthors Info & Claims

SIGMOD '20: Proceedings of the 2020 ACM SIGMOD International Conference on Management of Data

Pages 2709 - 2712

https://doi.org/10.1145/3318464.3384686

Published: 31 May 2020 Publication History

Get Access

Abstract

Troubleshooting imperative programs at runtime is very challenging because the final optimized plan is quite different from the original design time model. In this demonstration, we present ProcAnalyzer, an expressive and intuitive tool for troubleshooting issues related to performance, code quality, and security. We propose end-to-end graph (E2EGraph) that provides a holistic view of design time, compile time, and runtime behavior so that end users and engine developers easily find the correlations between design time and runtime. ProcAnalyzer provides suggestions and visualization to find problematic statements through the E2EGraph.

References

[1]

C. Binnig, N. May, and T. Mindnich. 2013. SQLScript: Efficiently analyzing big enterprise data in SAP HANA. Datenbank systeme für Business, Technologie und Web (BTW) 2035(2013).

Google Scholar

[2]

T. Grust, F. Kliebhan, J. Rittinger, and T. Schreiber. 2011. True language-level SQL debugging. In EDBT conference. 562--565.

Google Scholar

[3]

J. R. Haritsa. 2010. The Picasso database query optimizer visualizer. In VLDB conference. 1517--1520.

Digital Library

Google Scholar

[4]

H. Herodotou and S. Babu. 2010. Xplus: a SQL-tuning-aware query optimizer. In VLDB conference. 1149--1160.

Google Scholar

[5]

A. Nica, I. Charlesworth, and M. Panju. 2012. Analyzing query optimization process: Portraits of join enumeration algorithms. In ICDE conference. 1301--1304.

Google Scholar

[6]

K. Park, H. Seo, M. Rasel, Y. Lee, C. Jeong, S. Lee, C. Lee, and D. Lee. 2019. Iterative Query Processing based on Unified Optimization Techniques. In SIGMOD conference. 54--68.

Google Scholar

[7]

K. Ramachandra and K. Park. 2019. BlackMagic: Automatic inlining of scalar UDFs into SQL queries with Froid. In VLDB conference. 1810--1813.

Google Scholar

[8]

Y. Sun and J. Han. 2013. Mining heterogeneous information networks: a structural analysis approach. Sigkdd Explorations Newsletter 14, 2(2013), 20--28.

Digital Library

Google Scholar

[9]

A. Treffer, M. Perscheid, and M. Uflacker. 2017. Bringing back-in-time debugging down to the database. In SANER conference. 521--525.

Google Scholar

Cited By

View all

Bach TAndrzejak ASeo CBierstedt CLemke CRitter DHwang DSheshi ESchabernack FRenkes FGaumnitz GMartens JHoemke LFelderer MRudolf MJambigi NMay NJoy RScheja RSchwedes SSeibel SSeifert SHaas SKraft SKroll TScheuer TLehner W(2022)Testing Very Large Database Management Systems: The Case of SAP HANADatenbank-Spektrum10.1007/s13222-022-00426-x22:3(195-215)Online publication date: 24-Nov-2022
https://doi.org/10.1007/s13222-022-00426-x

Index Terms

ProcAnalyzer: Effective Code Analyzer for Tuning Imperative Programs in SAP HANA
1. Information systems
  1. Data management systems
    1. Database administration
      1. Database utilities and tools

Recommendations

Comments

Information & Contributors

Information

Published In

SIGMOD '20: Proceedings of the 2020 ACM SIGMOD International Conference on Management of Data

June 2020

2925 pages

ISBN:9781450367356

DOI:10.1145/3318464

General Chairs:
David Maier
Portland State University, USA
,
Rachel Pottinger
University of British Columbia, Canada
,
Program Chairs:
AnHai Doan
University of Wisconsin, USA
,
Wang-Chiew Tan
Megagon Labs, USA
,
Publications Chairs:
Abdussalam Alawini
University of Illinois at Urbana-Champaign, USA
,
Hung Q. Ngo
RelationalAI, USA

Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 31 May 2020

Permissions

Request permissions for this article.

Request Permissions

Check for updates

Author Tags

Qualifiers

Short-paper

Conference

SIGMOD/PODS '20

Sponsor:

SIGMOD

SIGMOD/PODS '20: International Conference on Management of Data

June 14 - 19, 2020

OR, Portland, USA

Acceptance Rates

Overall Acceptance Rate 785 of 4,003 submissions, 20%

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

1
Total Citations
View Citations
177
Total Downloads

Downloads (Last 12 months)13
Downloads (Last 6 weeks)1

Reflects downloads up to

Other Metrics

View Author Metrics

Citations

Cited By

View all

Bach TAndrzejak ASeo CBierstedt CLemke CRitter DHwang DSheshi ESchabernack FRenkes FGaumnitz GMartens JHoemke LFelderer MRudolf MJambigi NMay NJoy RScheja RSchwedes SSeibel SSeifert SHaas SKraft SKroll TScheuer TLehner W(2022)Testing Very Large Database Management Systems: The Case of SAP HANADatenbank-Spektrum10.1007/s13222-022-00426-x22:3(195-215)Online publication date: 24-Nov-2022
https://doi.org/10.1007/s13222-022-00426-x

View Options

Get Access

Login options

Check if you have access through your login credentials or your institution to get full access on this article.

Cited By

Index Terms

Recommendations

SAP Certified Application Associate - SAP HANA (Edition 2016)

SAP Certified Application Associate - SAP HANA 2.0

SAP Certified Application Associate - SAP HANA - Edition 2014

Comments

Published In

Sponsors

Publisher

Publication History

Permissions

Check for updates

Author Tags

Qualifiers

Conference

Acceptance Rates

Other Metrics

Article Metrics

Other Metrics

Cited By

Login options

Full Access

PDF

eReader

Abstract

References

Cited By

Index Terms

Recommendations

SAP Certified Application Associate - SAP HANA (Edition 2016)

SAP Certified Application Associate - SAP HANA 2.0

SAP Certified Application Associate - SAP HANA - Edition 2014

Comments

Information

Published In

Sponsors

Publisher

Publication History

Permissions

Check for updates

Author Tags

Qualifiers

Conference

Acceptance Rates

Contributors

Other Metrics

Bibliometrics

Article Metrics

Other Metrics

Citations

Cited By

Get Access

Login options

Full Access

View options

PDF

eReader

Figures

Other

Share

Share this Publication link

Share on social media

Affiliations