Database management systems (DBMS) typically provide an application programming interface for users to issue queries using query languages such as SQL. Many such languages were originally designed for business data processing applications. While these applications are still relevant, two other classes of applications have become important users of data management systems: (1) web applications that issue queries programmatically to the DBMS, and (2) data analytics involving complex queries that allow data scientists to better understand their datasets.Unfortunately, existing query languages provided by database management systems are often far from ideal for these application domains. Computer-Assisted Query Formulation describes a set of technologies that assist users in specifying database queries for different application domains. The goal of such systems is to bridge the gap between current query interfaces provided by database management systems and the needs of different usage scenarios that are not well served by existing query languages.This monograph discusses the different interaction modes that such systems provide and the algorithms used to infer user queries. In particular, it focuses on a new class of systems built using program synthesis techniques, and furthermore discusses opportunities in combining synthesis and other methods used in prior systems to infer user queries.
Les mer
Describes a set of technologies that assist users in specifying database queries for different application domains. The goal of such systems is to bridge the gap between current query interfaces provided by database management systems and the needs of different usage scenarios that are not well served by existing query languages.
Les mer
1: Introduction2: Query Processing3: Program Synthesis4: Using Verified Lifting to Rewrite Code into SQL5: Assisting Users Specify Database Queries6: Conclusion and Future WorkReferences

Produktdetaljer

ISBN
9781680830361
Publisert
2016-06-14
Utgiver
Vendor
now publishers Inc
Vekt
165 gr
Høyde
234 mm
Bredde
156 mm
Dybde
6 mm
Aldersnivå
UU, 05
Språk
Product language
Engelsk
Format
Product format
Heftet
Antall sider
108