Artículos relacionados a Schema-Free SQL- Providing Freedom from The Schema...

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

Mason, Terrence

 
9783836421393: Schema-Free SQL- Providing Freedom from The Schema Knowledge Required to Formulate SQL Queries
Tapa blanda
ISBN 10: 3836421399 ISBN 13: 9783836421393
Editorial: VDM Verlag Dr. Mueller e.K., 2007

Sinopsis

The current standard query language SQL requires users to know how data isnormalized and stored in a database schema to compose queries. One of themajor challenges in generating these queries is the identification of joins toconnect attributes located in different relations. Constructing these joins inSQL or through a graphical query interface is tedious, error-prone, and notintuitive to casual users. Any new query language should maintain the expressivenessof SQL without requiring schema knowledge or an additionalmodel. A new Schema-Free query system is developed to support theautomatic completion of an SQL query without the full specification of joinsand tables. A new algorithm efficiently constructs all maximal sets of losslessjoins in a schema an order of magnitude faster than previous methods. Thequery system uses a new query language allowing under-specification of SQLqueries to remove the burden of schema knowledge from the user whilecontinuing to support the full range of SQL queries. Queries with multipleinterpretations are disambiguated through three different approaches.

"Sinopsis" puede pertenecer a otra edición de este libro.

Reseña del editor

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.

"Sobre este título" puede pertenecer a otra edición de este libro.

Editorial
VDM Verlag Dr. Mueller e.K.
Año de publicación
2007
Idioma
Inglés
ISBN 10 
3836421399
ISBN 13 
9783836421393
Encuadernación
Tapa blanda
Número de páginas
132
Contacto del fabricante
no disponible
Persona responsable
no disponible