research-article

Schema-free SQL

Authors:

Tianyin Pan, and

Hosagrahar V. JagadishAuthors Info & Claims

SIGMOD '14: Proceedings of the 2014 ACM SIGMOD International Conference on Management of Data

June 2014

Pages 1051 - 1062

https://doi.org/10.1145/2588555.2588571

Published: 18 June 2014 Publication History

Abstract

Querying data in relational databases is often challenging since SQL requires its users to know the exact schema of the database, the roles of various entities in a query, and the precise join paths to be followed. On the other hand, keyword search is unable to express much desired query semantics. In this paper, we propose a query language, Schema-free SQL, which enables its users to query a relational database using whatever partial schema they know. If they know the full schema, they can write full SQL. But, to the extent they do not know the schema, Schema-free SQL is tolerant of unknown or inaccurately specified relation names and attribute names, and it also does not require information regarding which relations are involved and how they are joined. We present techniques to evaluate Schema-free SQL by first converting it to full SQL. We show experimentally that a small amount of schema information, which one can reasonably expect most users to have, is enough to get queries evaluated as if they had been completely and correctly specified.

References

[1]

Active query builder: www.activequerybuilder.com.

[2]

Flyspeed sql query: www.activedbsoft.com.

[3]

Sqleo visual query builder: sqleo.sourceforge.net.

[4]

S. Agrawal, S. Chaudhuri, and G. Das. Dbxplorer: A system for keyword-based search over relational databases. In ICDE, pages 5--16, 2002.

Digital Library

[5]

B. Bercovitz, F. Kaliszan, G. Koutrika, H. Liou, Z. M. Zadeh, and H. Garcia-Molina. Courserank: a social system for course planning. In SIGMOD Conference, pages 1107--1110, 2009.

Digital Library

[6]

G. Bhalotia, A. Hulgeri, C. Nakhe, S. Chakrabarti, and S. Sudarshan. Keyword searching and browsing in databases using banks. In ICDE, pages 431--440, 2002.

Digital Library

[7]

E. Chu, A. Baid, X. Chai, A. Doan, and J. F. Naughton. Combining keyword search and forms for ad hoc querying of databases. In SIGMOD Conference, pages 349--360, 2009.

Digital Library

[8]

V. Hristidis and Y. Papakonstantinou. Discover: Keyword search in relational databases. In VLDB, pages 670--681, 2002.

Digital Library

[9]

H. V. Jagadish, A. Chapman, A. Elkiss, M. Jayapandian, Y. Li, A. Nandi, and C. Yu. Making database systems usable. In SIGMOD Conference, pages 13--24, 2007.

Digital Library

[10]

L. V. S. Lakshmanan, F. Sadri, and S. N. Subramanian. Schemasql: An extension to sql for multidatabase interoperability. ACM Trans. Database Syst., 26(4):476--519, 2001.

Digital Library

[11]

Y. Li, C. Yu, and H. V. Jagadish. Schema-free xquery. In VLDB, pages 72--83, 2004.

Digital Library

[12]

A. Markowetz, Y. Yang, and D. Papadias. Keyword search on relational data streams. In SIGMOD Conference, pages 605--616, 2007.

Digital Library

[13]

A. Nandi and H. V. Jagadish. Qunits: queried units in database search. In CIDR, 2009.

[14]

S. Tata and G. M. Lohman. Sqak: doing more with keywords. In SIGMOD Conference, pages 889--902, 2008.

Digital Library

[15]

J. D. Ullman and J. Widom. A first course in database systems (2. ed.). Prentice Hall, 2002.

Digital Library

[16]

C. Yu and H. V. Jagadish. Querying complex structured databases. In VLDB, pages 1010--1021, 2007.

Digital Library

[17]

J. X. Yu, L. Qin, and L. Chang. Keyword search in relational databases: A survey. IEEE Data Eng. Bull., 33(1):67--78, 2010.

Cited By

Amsterdamer YCallen Y(2021)SPARQLIt: Interactive SPARQL Query Refinement2021 IEEE 37th International Conference on Data Engineering (ICDE)10.1109/ICDE51399.2021.00295(2649-2652)Online publication date: Apr-2021
https://doi.org/10.1109/ICDE51399.2021.00295
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
Sarode RSachdeva SChu WBhalla S(2019)Segment-Search vs Knowledge Graphs: Making a Key-Word Search Engine for Web DocumentsBig Data Analytics10.1007/978-3-030-37188-3_6(88-107)Online publication date: 12-Dec-2019
https://doi.org/10.1007/978-3-030-37188-3_6
Show More Cited By

Index Terms

Schema-free SQL
1. Human-centered computing
  1. Human computer interaction (HCI)
2. Information systems
  1. Data management systems
    1. Query languages

Recommendations

Path Expressions in SQL: A User Study on Query Formulation

This article focuses on testing a path-oriented querying approach to hierarchical data in relational databases. The authors execute a user study to compare the path-oriented approach and traditional SQL from two perspectives: correctness of queries and ...
Read More
Constraint Preserving Transformation from Relational Schema to XML Schema

XML has become the standard for publishing and exchanging data on the Web. However, most business data is managed and will remain to be managed by relational database management systems. As such, there is an increasing need to efficiently and accurately ...
Read More
Schema-free sql: providing freedom from the schema knowledge required for sql querying
Read More

Comments

Information & Contributors

Information

Published In

cover image ACM Conferences

SIGMOD '14: Proceedings of the 2014 ACM SIGMOD International Conference on Management of Data

June 2014

1645 pages

ISBN:9781450323765

DOI:10.1145/2588555

General Chairs:
Curtis Dyreson
Utah State University, USA
,
Feifei Li
University of Utah, USA
,
Program Chair:
M. Tamer Özsu
University of Waterloo, Canada

Copyright © 2014 ACM.

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]

Sponsors

SIGMOD: ACM Special Interest Group on Management of Data

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 18 June 2014

Permissions

Request permissions for this article.

Request Permissions

Check for updates

Author Tags

Qualifiers

Research-article

Conference

SIGMOD/PODS'14

Sponsor:

SIGMOD

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

June 22 - 27, 2014

Utah, Snowbird, USA

Acceptance Rates

SIGMOD '14 Paper Acceptance Rate 107 of 421 submissions, 25%;

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

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

9
Total Citations
View Citations
590
Total Downloads

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

Other Metrics

View Author Metrics

Citations

Cited By

Amsterdamer YCallen Y(2021)SPARQLIt: Interactive SPARQL Query Refinement2021 IEEE 37th International Conference on Data Engineering (ICDE)10.1109/ICDE51399.2021.00295(2649-2652)Online publication date: Apr-2021
https://doi.org/10.1109/ICDE51399.2021.00295
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
Sarode RSachdeva SChu WBhalla S(2019)Segment-Search vs Knowledge Graphs: Making a Key-Word Search Engine for Web DocumentsBig Data Analytics10.1007/978-3-030-37188-3_6(88-107)Online publication date: 12-Dec-2019
https://doi.org/10.1007/978-3-030-37188-3_6
Li YRafiei D(2018)Natural Language Data Management and InterfacesSynthesis Lectures on Data Management10.2200/S00866ED1V01Y201807DTM04910:2(1-156)Online publication date: 13-Aug-2018
https://doi.org/10.2200/S00866ED1V01Y201807DTM049
Jamil HHaspel NCowen LShehu AKahveci TPozzi G(2017)Knowledge Rich Natural Language Queries over Structured Biological DatabasesProceedings of the 8th ACM International Conference on Bioinformatics, Computational Biology,and Health Informatics10.1145/3107411.3107442(352-361)Online publication date: 20-Aug-2017
https://dl.acm.org/doi/10.1145/3107411.3107442
Wahl AEndler GSchwab PHerbst SLenz R(2017)Query-Driven Knowledge-Sharing for Data Integration and Collaborative Data ScienceNew Trends in Databases and Information Systems10.1007/978-3-319-67162-8_8(63-72)Online publication date: 9-Sep-2017
https://doi.org/10.1007/978-3-319-67162-8_8
Kahng MNavathe SStasko JChau D(2016)Interactive browsing and navigation in relational databasesProceedings of the VLDB Endowment10.14778/2994509.29945209:12(1017-1028)Online publication date: 1-Aug-2016
https://dl.acm.org/doi/10.14778/2994509.2994520
Jain SMoritz DHalperin DHowe BLazowska EÖzcan FKoutrika GMadden S(2016)SQLShareProceedings of the 2016 International Conference on Management of Data10.1145/2882903.2882957(281-293)Online publication date: 26-Jun-2016
https://dl.acm.org/doi/10.1145/2882903.2882957
Han LFinin TJoshi ACheng D(2015)Querying RDF data with text annotated graphsProceedings of the 27th International Conference on Scientific and Statistical Database Management10.1145/2791347.2791381(1-12)Online publication date: 29-Jun-2015
https://dl.acm.org/doi/10.1145/2791347.2791381

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.

Full Access

Get this Publication

View options

PDF

View or Download as a PDF file.

eReader

View online with eReader.

Media

Figures

Other

Tables

View Table of Contents