short-paper

DBridge: Translating Imperative Code to SQL

Authors:

K. Venkatesh Emani,

Tejas Deshpande,

Karthik Ramachandra,

S. SudarshanAuthors Info & Claims

SIGMOD '17: Proceedings of the 2017 ACM International Conference on Management of Data

Pages 1663 - 1666

https://doi.org/10.1145/3035918.3058747

Published: 09 May 2017 Publication History

Get Access

Abstract

Application programs that access data located remotely (such as in a database) often perform poorly due to multiple network round trips and transfer of unused data. This situation is exacerbated in applications that use object-relational mapping (ORM) frameworks such as Hibernate, as developers tend to express complex query logic using imperative code, resulting in poor performance.

DBridge is a system for optimizing data access in database applications by using static program analysis and program transformations. Recently, we incorporated a new suite of optimization techniques into DBridge. These techniques optimize database application programs by identifying relational operations expressed in imperative code, and translating them into SQL. In this demonstration, we showcase these techniques using a plugin for the IntelliJ IDEA Java IDE as the front end. We show the performance gains achieved by employing our system on real world applications that use JDBC or Hibernate.

References

[1]

M. Chavan, R. Guravannavar, K. Ramachandra, and S. Sudarshan. DBridge: A program rewrite tool for set-øriented query execution (demo). In ICDE, 2011.

Digital Library

Google Scholar

[2]

A. Cheung, A. Solar-Lezama, and S. Madden. Optimizing database-backed applications with query synthesis. PLDI, 2013.

Digital Library

Google Scholar

[3]

K. V. Emani, K. Ramachandra, S. Bhattacharya, and S. Sudarshan. Extracting Equivalent SQL from Imperative Code in Database Applications. SIGMOD, 2016.

Digital Library

Google Scholar

[4]

K. Ramachandra, M. Chavan, R. Guravannavar, and S. Sudarshan. Program transformations for asynchronous and batched query submission. TKDE '15, 27(2):531--544.

Google Scholar

[5]

Soot: A Java Optimization Framework http://www.sable.mcgill.ca/soot.

Google Scholar

[6]

Wilos Orchestration Software http://www.ohloh.net/p/6390.

Google Scholar

Cited By

View all

Arch SLiu YMowry TPatel JPavlo A(2024)The Key to Effective UDF Optimization: Before Inlining, First Perform OutliningProceedings of the VLDB Endowment10.14778/3696435.369643618:1(1-13)Online publication date: 1-Sep-2024
https://dl.acm.org/doi/10.14778/3696435.3696436
Zhang CFarouk T(2024)Sharing Queries with Nonequivalent User-defined Aggregate FunctionsACM Transactions on Database Systems10.1145/364913349:2(1-46)Online publication date: 10-Apr-2024
https://dl.acm.org/doi/10.1145/3649133
Zhang GMariano BShen XDillig I(2023)Automated Translation of Functional Big Data Queries to SQLProceedings of the ACM on Programming Languages10.1145/35860477:OOPSLA1(580-608)Online publication date: 6-Apr-2023
https://dl.acm.org/doi/10.1145/3586047
Show More Cited By

Index Terms

DBridge: Translating Imperative Code to SQL
1. Information systems
  1. Data management systems
2. Software and its engineering
  1. Software notations and tools
    1. Compilers
      1. Source code generation

Recommendations

Java and relational databases (tutorial): SQLJ
SIGMOD '98: Proceedings of the 1998 ACM SIGMOD international conference on Management of data

This Tutorial presents the latest developments in the area of Java and Relational Databases. The material is based on the SQLJ consortium effort whose goal is to leverage Java technology for SQL processing. The SQLJ effort is driven by major industry ...
Java and relational databases (tutorial): SQLJ

This Tutorial presents the latest developments in the area of Java and Relational Databases. The material is based on the SQLJ consortium effort whose goal is to leverage Java technology for SQL processing. The SQLJ effort is driven by major industry ...
Research of Structure Integration Based on Struts and Hibernate
CSIE '09: Proceedings of the 2009 WRI World Congress on Computer Science and Information Engineering - Volume 07

Struts framework based on MVC has brought the best code reuse and the legible code structure in entire system by far, but it has some problems such as complicated program, high coupling among layers and hard maintenance because its model part adopts ...

Comments

Information & Contributors

Information

Published In

SIGMOD '17: Proceedings of the 2017 ACM International Conference on Management of Data

May 2017

1810 pages

ISBN:9781450341974

DOI:10.1145/3035918

General Chairs:
Rada Chirkova
North Carolina State University, USA
,
Jun Yang
Duke University, USA
,
Program Chair:
Dan Suciu
University of Washington, 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: 09 May 2017

Permissions

Request permissions for this article.

Request Permissions

Check for updates

Author Tags

Qualifiers

Short-paper

Funding Sources

Tata Consultancy Services

Conference

SIGMOD/PODS'17

Sponsor:

SIGMOD

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

May 14 - 19, 2017

Illinois, Chicago, USA

Acceptance Rates

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

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

14
Total Citations
View Citations
378
Total Downloads

Downloads (Last 12 months)21
Downloads (Last 6 weeks)0

Reflects downloads up to 25 Feb 2025

Other Metrics

View Author Metrics

Citations

Cited By

View all

Arch SLiu YMowry TPatel JPavlo A(2024)The Key to Effective UDF Optimization: Before Inlining, First Perform OutliningProceedings of the VLDB Endowment10.14778/3696435.369643618:1(1-13)Online publication date: 1-Sep-2024
https://dl.acm.org/doi/10.14778/3696435.3696436
Zhang CFarouk T(2024)Sharing Queries with Nonequivalent User-defined Aggregate FunctionsACM Transactions on Database Systems10.1145/364913349:2(1-46)Online publication date: 10-Apr-2024
https://dl.acm.org/doi/10.1145/3649133
Zhang GMariano BShen XDillig I(2023)Automated Translation of Functional Big Data Queries to SQLProceedings of the ACM on Programming Languages10.1145/35860477:OOPSLA1(580-608)Online publication date: 6-Apr-2023
https://dl.acm.org/doi/10.1145/3586047
Grulich PZeuch SMarkl V(2022)BabelfishProceedings of the VLDB Endowment10.14778/3489496.348950115:2(196-210)Online publication date: 4-Feb-2022
https://dl.acm.org/doi/10.14778/3489496.3489501
Gupta SRamachandra K(2021)Procedural extensions of SQLProceedings of the VLDB Endowment10.14778/3457390.345740214:8(1378-1391)Online publication date: 21-Oct-2021
https://dl.acm.org/doi/10.14778/3457390.3457402
Macke SGong HLee DHead AXin DParameswaran A(2021)Fine-grained lineage for safer notebook interactionsProceedings of the VLDB Endowment10.14778/3447689.344771214:6(1093-1101)Online publication date: 12-Apr-2021
https://dl.acm.org/doi/10.14778/3447689.3447712
Zhang GXu YShen XDillig I(2021)UDF to SQL translation through compositional lazy inductive synthesisProceedings of the ACM on Programming Languages10.1145/34854895:OOPSLA(1-26)Online publication date: 15-Oct-2021
https://dl.acm.org/doi/10.1145/3485489
Lyu YVolokh SHalfond WTripp OCadar CZhang X(2021)SAND: a static analysis approach for detecting SQL antipatternsProceedings of the 30th ACM SIGSOFT International Symposium on Software Testing and Analysis10.1145/3460319.3464818(270-282)Online publication date: 11-Jul-2021
https://dl.acm.org/doi/10.1145/3460319.3464818
Gathani SLim PBattle LBernhaupt RMueller FVerweij DAndres JMcGrenere JCockburn AAvellino IGoguey ABjørn PZhao SSamson BKocielnik R(2020)Debugging Database Queries: A Survey of Tools, Techniques, and UsersProceedings of the 2020 CHI Conference on Human Factors in Computing Systems10.1145/3313831.3376485(1-16)Online publication date: 21-Apr-2020
https://dl.acm.org/doi/10.1145/3313831.3376485
Dombrovskaya HCzaplewski JNovikov B(2020)Connecting Galaxies: Bridging the Gap Between Databases and ApplicationsSOFSEM 2020: Theory and Practice of Computer Science10.1007/978-3-030-38919-2_54(648-656)Online publication date: 20-Jan-2020
https://dl.acm.org/doi/10.1007/978-3-030-38919-2_54
Show More Cited By

View Options

Login options

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

Full Access

Get this Publication

View options

PDF

View or Download as a PDF file.

PDF

eReader

View online with eReader.

eReader

Abstract

References

Cited By

Index Terms

Recommendations

Java and relational databases (tutorial): SQLJ

Java and relational databases (tutorial): SQLJ

Research of Structure Integration Based on Struts and Hibernate

Comments

Information

Published In

Sponsors

Publisher

Publication History

Permissions

Check for updates

Author Tags

Qualifiers

Funding Sources

Conference

Acceptance Rates

Contributors

Other Metrics

Bibliometrics

Article Metrics

Other Metrics

Citations

Cited By

Login options

Full Access

View options

PDF

eReader

Share

Share this Publication link

Share on social media

Affiliations