Schema-Free SQL | Providing Freedom from The Schema Knowledge Required to Formulate SQL Queries

Terrence Mason

ISBN 10: 3639449681 / ISBN 13: 9783639449686

Published by AV Akademikerverlag, 2012

About this Item

Schema-Free SQL | Providing Freedom from The Schema Knowledge Required to Formulate SQL Queries | Terrence Mason | Taschenbuch | 132 S. | Englisch | 2012 | AV Akademikerverlag | EAN 9783639449686 | Verantwortliche Person für die EU: preigu GmbH & Co. KG, Lengericher Landstr. 19, 49078 Osnabrück, mail[at]preigu[dot]de | Anbieter: preigu.

Seller Inventory # 106342291

Bibliographic Details

• Title: Schema-Free SQL | Providing Freedom from The Schema Knowledge Required to Formulate SQL Queries
• Publisher: AV Akademikerverlag
• Publication Date: 2012
• Language: English
• ISBN 10: 3639449681
• ISBN 13: 9783639449686
• Binding: Taschenbuch
• Condition: Neu
• Dimensions: 220W x 150H x 9D millimeters 220 millimeters width by 150 millimeters height by 9 millimeters depth
• Weight: 215 grams
• Seller catalogs:
  • Bücher

About this title

Synopsis

The current standard query language SQL requires users to know how data is normalized and stored in a database schema to compose queries. One of the major challenges in generating these queries is the identification of joins to connect attributes located in different relations. Constructing these joins in SQL or through a graphical query interface is tedious, error-prone, and not intuitive to casual users. Any new query language should maintain the expressiveness of SQL without requiring schema knowledge or an additional model. A new Schema-Free query system is developed to support the automatic completion of an SQL query without the full specification of joins and tables. A new algorithm efficiently constructs all maximal sets of lossless joins in a schema an order of magnitude faster than previous methods. The query system uses a new query language allowing under-specification of SQL queries to remove the burden of schema knowledge from the user while continuing to support the full range of SQL queries. Queries with multiple interpretations are disambiguated through three different approaches.

About the Author

Database Systems in Computer Science at University of Iowa. Assistant Professor at University of Wisconsin – Stout, Menomonie, Wisconsin.